java.sql.SQLException: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dd.testdb.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MCTS3DB)))

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 790852, 1 year ago
Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dd.testdb.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MCTS3DB)))
via Oracle Community by 843859, 3 months ago
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: //localhost:1521/orcl
via Stack Overflow by Priyan RockZ
, 2 years ago
Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: //10.2.5.21:9001/XE
via adempiere by sergeyv
, 1 year ago
Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: //hobbit:1521/xe
via adempiere by puwadej
, 1 year ago
Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: //nvb-1.nvb.co.th:1521/dev.nvb.co.th
via Atlassian JIRA by Jozef Babjak, 1 year ago
Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: localhost:1521:PDB
java.sql.SQLException: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dd.testdb.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MCTS3DB)))
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:390)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:519)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:167)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:816)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:325)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:235)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:157)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:94)
at oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:1702)
at oracle.jdbc.pool.OracleImplicitConnectionCache.getCacheConnection(OracleImplicitConnectionCache.java:575)
at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:435)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:432)
at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:336)
at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:322)
at oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:575)
at oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:207)
at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1059)
at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1093)
at oracle.sysman.eml.app.SessionObjectManager.sessionDestroyed(SessionObjectManager.java:116)
at oracle.sysman.eml.app.SessionListener.sessionDestroyed(SessionListener.java:112)
at com.evermind.server.http.HttpApplication.invalidateSession(HttpApplication.java:785)
at com.evermind.server.http.EvermindHttpSession.invalidate(EvermindHttpSession.java:399)
at com.evermind.server.http.EvermindHttpSession.isInvalid(EvermindHttpSession.java:308)
at com.evermind.server.http.EvermindHttpSession.getServletContext(EvermindHttpSession.java:960)
at oracle.sysman.eml.app.SessionListener.sessionDestroyed(SessionListener.java:88)
at com.evermind.server.http.HttpApplication.invalidateLocalSession(HttpApplication.java:813)
at com.evermind.server.http.EvermindHttpSession.invalidateLocal(EvermindHttpSession.java:349)
at com.evermind.server.http.HttpApplication.destroySessions(HttpApplication.java:5674)
at com.evermind.server.http.HttpApplication.destroy(HttpApplication.java:5617)
at com.evermind.server.http.HttpSite.destroy(HttpSite.java:865)
at com.evermind.server.http.HttpServer.destroy(HttpServer.java:549)
at com.evermind.server.ApplicationServer.destroy(ApplicationServer.java:1937)
at com.evermind.server.ApplicationServerShutdownHandler.run(ApplicationServerShutdownHandler.java:94)
at java.lang.Thread.run(Thread.java:595)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 3 weeks ago
Samebug visitor profile picture
Unknown user
Once, 3 weeks ago
Samebug visitor profile picture
Unknown user
Once, 3 weeks ago
Samebug visitor profile picture
Unknown user
Once, 3 weeks ago
Samebug visitor profile picture
Unknown user
Once, 3 weeks ago
136 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.