Root cause for connection leaks
Hi,
My customer having connection leak issue in EBS R12.2.6 instance,
/test/oracle/NDO1/applmgr/fs2/FMW_Home/user_projects/domains/EBS_domain_NDO1/servers/oacore_server1/logs/oacore_server1.log
####<Mar 22, 2017 11:46:44 AM JST> <Error> <ServletContext-/OA_HTML> <isy9g101> <oacore_server1> <pool-3-thread-1> <<anonymous>> <> <005In^iDxh^AxGTtQ8YBTd0000sR000008> <1490150804764> <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..
This problem resolved by adjusting Inactive Connection Timeout.
(It is just temporary setting as workaround and customer wants to identify the root cause for permanent fix.)