Login issues R12.2.5

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Login issues R12.2.5

satish
Hi Erman,

We are on R12.2.5 and 19c database. We have 2 app node and 2 node RAC.
os redhat 7.9
We have defined 2 oacores on each apps server. We observed below errors in logfiles. We have 500 concurrent users peak.

Caused By: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool EBSDataSource to allocate to applications, please increase the size of the pool and retry..
        at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:252)
        at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:471)
        at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:553)
        at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:513)
        at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)
        Truncated. see log file for complete stacktrace

Please advice.

Thanks,
SG
Reply | Threaded
Open this post in threaded view
|

Re: Login issues R12.2.5

ErmanArslansOracleBlog
Administrator
Please go through -> Oracle E-Business Suite 12.2 Data Source Connection Pool Diagnostics (Doc ID 1940996.1).. You may consider enabling ICT.. But first go through the document and do your diag..