Connection test failed with the following exception: weblogic.common.resourcepool.ResourceDisabledException: Pool mds-SpacesDS is Suspended, cannot allocate resources to applications..

Connection test failed with the following exception: weblogic.common.resourcepool.ResourceDisabledException: Pool mds-SpacesDS is Suspended, cannot allocate resources to applications..

You may observe datasources going into suspended state. When you try to test the datasource connection, it throws error as above (with the problem datasource name)

Try checking the DB parameters:

SQL> select name, value from v$parameter where name in ('processes', 'sessions', 'transactions');

If the parameters are set to low values, you may want to increase the value of these parameters & restart the database. Often the case may be Processes parameter may have maxed out & increasing it should resolve the issue of datasources going into suspended state.


SQL> alter system set processes = <value> scope = spfile;

System altered.

SQL> alter system set sessions = <value> scope = spfile;

System altered.

SQL> alter system set transactions = <value> scope = spfile;

System altered.

Restart the database


You may also want to increase Max Capacity of problem datasources.

Also consider increasing the timeout value under Domain -> JTA -> Configuration