My Oracle Support Banner

Custom Code Receives ORA-12516, TNS:Listener Could Not Find Available Handler With Matching Protocol Stack (Doc ID 2781864.1)

Last updated on JUNE 03, 2021

Applies to:

Oracle Agile Product Portfolio Management - Version 9.3.6.0 and later
Information in this document applies to any platform.

Goal

Custom Code Receives ORA-12516, TNS:Listener Could Not Find Available Handler With Matching Protocol Stack

Listener could not find available handler with matching protocol stack but the session and processes was not full at the time when Listener was disconnected.
Any other reason that could cause Listener disconnected other than processes and session being full?

Error Log

2021-04-07 00:00:14.749 [pool-4-thread-1] ERROR <Custom Code> Error!
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.ctfe.idbs.agile.JDBCUtils.getConnection(JDBCUtils.java:42)
.

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.