weblogic.jdbc.extensions.PoolDisabledSQLException:
weblogic.common.resourcepool.ResourceDisabledException: Pool AgileContentPool is
Suspended, cannot allocate resources to applications..
at
weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:265)
at
weblogic.jdbc.jts.Driver.newConnection(Driver.java:900)
at
weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:220)
at
weblogic.jdbc.jts.Driver.connect(Driver.java:170)
at
weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:523)
at
weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:516)
at
weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:512)
<2019-09-10 10:38:56,366>
<PCMHelperSessionBean_9xz6y2_Impl:ERROR> Session terminated...
If there are long running queries find out what it is running and users may see ORA-00020: Maximum number of processes reached.
Possible reasons :
1. Database running some custom or un-optimized long running queries
2. Application forgot to release the connection back to pool due to recent config changes, which can result connection leak.
3. Inactive connection timeout value may need to change to support system growth/load.
We have verified at DB level and everything working fine except more connections hanging around and not releasing. After investigation we found that most of the connections going though one server due to recent patch and didn’t update the Pcclient.jnlp, Jndiurl.properties..etc
After updating the config we see that user connections going trough all servers and connection load balance happening as expected and issue has been resolved.
Hope this post helps to resolve Agile Content pool suspended issue.
Thanks,
Satishbabu Gunukula, Oracle ACE
