Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12516, TNS:listener could not find available handler with matching protocol stack

Srinanda DasSep 4 2019 — edited Sep 13 2019

Please suggest. I'm getting this error from log.

Error:

<Sep 3, 2019 11:04:02 AM MDT> <Error> <oracle.soa.bpel.engine.dispatch> <BEA-000000> <Failed to handle message class com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessage, Error message : weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Listener refused the connection with the following error:

ORA-12516, TNS:listener could not find available handler with matching protocol stack

<Sep 3, 2019 11:04:02 AM MDT> <Warning> <oracle.soa.bpel.engine> <BEA-000000> <Attempt (1/2): caught GLOBAL_RETRY exception. Retry after 3 seconds.>

<Sep 3, 2019 11:07:00 AM MDT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "OraSDPMDataSource": Listener refused the connection with the following error:

ORA-12516, TNS:listener could not find available handler with matching protocol stack

.>

<Sep 3, 2019 11:07:00 AM MDT> <Warning> <oracle.soa.healthcheck> <BEA-000000> <Periodic run 'frequently' did not pass for id 193085, category 'Quick'. Ran 3 checks. Number of failures=0, errors=1, warnings=0.>

<Sep 3, 2019 11:07:00 AM MDT> <Warning> <oracle.soa.healthcheck> <BEA-000000> <Health check 'JDBCPoolsCheck' for id 193085 did not pass.

Unable to get connection for datasource OraSDPMDataSource. java.sql.SQLException: Cannot obtain XAConnection

SOA server 2:

<Sep 3, 2019 11:03:36 AM MDT> <Error> <org.quartz.core.ErrorLogger> <BEA-000000> <An error occured while scanning for the next trigger to fire.

org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'soaNonManagedDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection for datasource 'SOALocalTxDataSource'. The DBMS driver exception was: Listener refused the connection with the following error:

ORA-12516, TNS:listener could not find available handler with matching protocol stack

Comments
Post Details
Added on Sep 4 2019
3 comments
2,070 views