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)))

Oracle Community | 790852 | 6 years ago
  1. 0

    Erros while installing FailSafe for oracle

    Oracle Community | 6 years ago | 790852
    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)))
  2. 0

    Enterprise Manager Not Working

    Oracle Community | 4 years ago | 897568
    java.sql.SQLException: User credentials doesn't match the existing ones * at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:77)
  3. 0

    "503 Service Unavailable" error for EM10g grid console

    Oracle Community | 1 decade ago | 446155
    java.sql.SQLException: ORA-28000: the account is locked
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SYSMAN Locked(Timed)

    Oracle Community | 8 years ago | 699072
    java.sql.SQLException: ORA-01017: invalid username/password; logon denied
  6. 0

    grid control error

    Oracle Community | 7 years ago | user11974259
    java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed.

  1. wendellpereira 2 times, last 3 months ago
6 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Oracle jdbc
    OracleDataSource.getConnection
    1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
    3. oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:390)
    4. oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:519)
    5. oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:167)
    6. oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    7. oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:816)
    8. oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:325)
    9. oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:235)
    10. oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:157)
    11. oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:94)
    12. oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:1702)
    13. oracle.jdbc.pool.OracleImplicitConnectionCache.getCacheConnection(OracleImplicitConnectionCache.java:575)
    14. oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:435)
    15. oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:432)
    16. oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:397)
    16 frames
  3. oracle.sysman.util
    ConnectionCache.getUnwrappedConnection
    1. oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:336)
    2. oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:322)
    3. oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:575)
    3 frames
  4. oracle.sysman.emSDK
    ConnectionService.getPrivateConnection
    1. oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:207)
    2. oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1059)
    3. oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1093)
    3 frames
  5. oracle.sysman.eml
    SessionListener.sessionDestroyed
    1. oracle.sysman.eml.app.SessionObjectManager.sessionDestroyed(SessionObjectManager.java:116)
    2. oracle.sysman.eml.app.SessionListener.sessionDestroyed(SessionListener.java:112)
    2 frames
  6. com.evermind.server
    EvermindHttpSession.getServletContext
    1. com.evermind.server.http.HttpApplication.invalidateSession(HttpApplication.java:785)
    2. com.evermind.server.http.EvermindHttpSession.invalidate(EvermindHttpSession.java:399)
    3. com.evermind.server.http.EvermindHttpSession.isInvalid(EvermindHttpSession.java:308)
    4. com.evermind.server.http.EvermindHttpSession.getServletContext(EvermindHttpSession.java:960)
    4 frames
  7. oracle.sysman.eml
    SessionListener.sessionDestroyed
    1. oracle.sysman.eml.app.SessionListener.sessionDestroyed(SessionListener.java:88)
    1 frame
  8. com.evermind.server
    ApplicationServerShutdownHandler.run
    1. com.evermind.server.http.HttpApplication.invalidateLocalSession(HttpApplication.java:813)
    2. com.evermind.server.http.EvermindHttpSession.invalidateLocal(EvermindHttpSession.java:349)
    3. com.evermind.server.http.HttpApplication.destroySessions(HttpApplication.java:5674)
    4. com.evermind.server.http.HttpApplication.destroy(HttpApplication.java:5617)
    5. com.evermind.server.http.HttpSite.destroy(HttpSite.java:865)
    6. com.evermind.server.http.HttpServer.destroy(HttpServer.java:549)
    7. com.evermind.server.ApplicationServer.destroy(ApplicationServer.java:1937)
    8. com.evermind.server.ApplicationServerShutdownHandler.run(ApplicationServerShutdownHandler.java:94)
    8 frames
  9. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:595)
    1 frame