Login Issue

Posted by satish on Nov 06, 2023; 2:21am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Login-Issue-tp12162.html

Dear Erman,

We are on R12.2.5 and database version 19.17. We need your expertise on below issue. Our configuration is as below:

We have 2 application servers and 2 node RAC database servers.

On app node 1 : we have 2 oacores and 2 forms
On app node 2 : we have 2 oacores and 2 forms

Using shared appl top

We have 64GB ram on each app nodes and CPU's are as below on each node.

CPU(s):                8
On-line CPU(s) list:   0-7
Thread(s) per core:    2
Core(s) per socket:    4
Socket(s):             1

Recently number of concurrent users increased from 250 to 390. We faced below error in logs.


<4 Nov, 2023 3:53:27 PM IST> <Error> <ServletContext-/OA_HTML> <BEA-000000> <oracle.apps.fnd.login.LoginHelper.getConnection
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 weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:506)
        Truncated. see log file for complete stacktrace

Thanks,
SG