Issue:
In a 12.2.6 EBS environment, Login fails with below error
Unable to create anonymous session. ICX_SESSION_CREATION_FAILED (userid=6) exception oracle.apps.fnd.common.PoolException: Exception creating new Poolable object. Encountered a java exception with the message Exception creating new Poolable object. Cause:java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: java.lang.reflect.InvocationTargetException.
Analysis:
The error indicates that there are not enough resources to create a new JDBC session. oacore_server.log has the below error messages
####<Aug 08, 2017 3:43:05 PM EST> <Info> <Common> <test.domain.com> <oacore_server1> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005dy^V9G5e9xW6RJMU4TB0000xv001lSB> <1591994585553> <BEA-000627> <Reached maximum capacity of pool "EBSDataSource", making "0" new resource instances instead of "1".>
####<Aug 08, 2017 3:43:07 PM EST> <Info> <Common> <test.domain.com> <oacore_server1> <pool-2-thread-1> <<anonymous>> <> <*******************> <887561> <BEA-000627> <Reached maximum capacity of pool "EBSDataSource", making "0" new resource instances instead of "1".>
####<Aug 08, 2017 3:43:15 PM EST> <Info> <Common> <test.domain.com> <oacore_server1> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005dy^V9G5e9xW6RJMU4TB0000xv001lSB> <1591994595562> <BEA-000627> <Reached maximum capacity of pool "EBSDataSource", making "0" new resource instances instead of "1".>
####<Aug 08, 2017 3:43:15 PM EST> <Info> <Common> <test.domain.com> <oacore_server1> <pool-2-thread-1> <<anonymous>> <> <*******************> <955123> <BEA-000627> <Reached maximum capacity of pool "EBSDataSource", making "0" new resource instances instead of "1".>
Number of processes capacity for the Datasource "EBSDatasource" is exhausted.
Solution:
1. Increase the number of sessions in EBSDatasource
Login to weblogic Console, Navigate to Datasource, click on EBSDatasource.
Click on Lock and Edit, Go to Connection Pool Tab, Increase the value in Number of sessions field.
Click on Activate Changes.
This change does not require any restart of services.
(or)
Alternate Solution:
2. Bounce oacore_server to release any inactive sessions and free up the resources
cd $ADMIN_SCRIPTS_HOME
admanagedsrvctl.sh stop oacore_server
admanagedsrvctl.sh start oacore_server
In a 12.2.6 EBS environment, Login fails with below error
Unable to create anonymous session. ICX_SESSION_CREATION_FAILED (userid=6) exception oracle.apps.fnd.common.PoolException: Exception creating new Poolable object. Encountered a java exception with the message Exception creating new Poolable object. Cause:java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: java.lang.reflect.InvocationTargetException.
Analysis:
The error indicates that there are not enough resources to create a new JDBC session. oacore_server.log has the below error messages
####<Aug 08, 2017 3:43:05 PM EST> <Info> <Common> <test.domain.com> <oacore_server1> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005dy^V9G5e9xW6RJMU4TB0000xv001lSB> <1591994585553> <BEA-000627> <Reached maximum capacity of pool "EBSDataSource", making "0" new resource instances instead of "1".>
####<Aug 08, 2017 3:43:07 PM EST> <Info> <Common> <test.domain.com> <oacore_server1> <pool-2-thread-1> <<anonymous>> <> <*******************> <887561> <BEA-000627> <Reached maximum capacity of pool "EBSDataSource", making "0" new resource instances instead of "1".>
####<Aug 08, 2017 3:43:15 PM EST> <Info> <Common> <test.domain.com> <oacore_server1> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005dy^V9G5e9xW6RJMU4TB0000xv001lSB> <1591994595562> <BEA-000627> <Reached maximum capacity of pool "EBSDataSource", making "0" new resource instances instead of "1".>
####<Aug 08, 2017 3:43:15 PM EST> <Info> <Common> <test.domain.com> <oacore_server1> <pool-2-thread-1> <<anonymous>> <> <*******************> <955123> <BEA-000627> <Reached maximum capacity of pool "EBSDataSource", making "0" new resource instances instead of "1".>
Number of processes capacity for the Datasource "EBSDatasource" is exhausted.
Solution:
1. Increase the number of sessions in EBSDatasource
Login to weblogic Console, Navigate to Datasource, click on EBSDatasource.
Click on Lock and Edit, Go to Connection Pool Tab, Increase the value in Number of sessions field.
Click on Activate Changes.
This change does not require any restart of services.
(or)
Alternate Solution:
2. Bounce oacore_server to release any inactive sessions and free up the resources
cd $ADMIN_SCRIPTS_HOME
admanagedsrvctl.sh stop oacore_server
admanagedsrvctl.sh start oacore_server
I can not find Number of sessions field.
ReplyDeleteWhere is Number of sessions field location?
Graton Casino - Mapyro
ReplyDeleteThe Graton Casino is a gambling 나주 출장마사지 venue 군포 출장샵 in 속초 출장샵 Northern Kentucky. The venue offers 부산광역 출장마사지 over 4,000 태백 출장안마 slot and video poker games, including progressive jackpots