java.sql.SQLException: 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

Atlassian JIRA | Jozef Babjak | 1 decade ago
  1. 0

    I'm installing new instance of Confluence. I'm migrating data from previous instance which used HSQL database. The both instances are in verson 2.1.5a. Now, I will use Oracle 10g database. Installation procedure is as follows: 1) Extract Confluence Standalone. 2) Copy Oracle JDBC driver 10.2.0.1 to common/lib directory. 3) Set up confluence.home in file conluence-init.properties appropriatelly. 4) Start confluence via ./startup.sh; JAVA_HOME points to JDK 1.5.0_04-b05. 5) Insert licence key on first page of installer, select Oracle10g as external DB. 6) Select connection directly via JDBC driver and set up connection parameters appropriatelly. 7) Select installation with restoring data from backup. Things go OK while restoring is in progress. When progress bar reach 100%, many of the same exceptions are starting to be written into catalina.out: java.sql.SQLException: 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 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:387) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83) at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884) at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601) at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354) Data seems to be loaded into new instance of Confluence correctly. The same exceptions repeat while rebuilding search index. I snipped some another exception while index rebuilding; see attached log for details.

    Atlassian JIRA | 1 decade ago | Jozef Babjak
    java.sql.SQLException: 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
  2. 0

    I'm installing new instance of Confluence. I'm migrating data from previous instance which used HSQL database. The both instances are in verson 2.1.5a. Now, I will use Oracle 10g database. Installation procedure is as follows: 1) Extract Confluence Standalone. 2) Copy Oracle JDBC driver 10.2.0.1 to common/lib directory. 3) Set up confluence.home in file conluence-init.properties appropriatelly. 4) Start confluence via ./startup.sh; JAVA_HOME points to JDK 1.5.0_04-b05. 5) Insert licence key on first page of installer, select Oracle10g as external DB. 6) Select connection directly via JDBC driver and set up connection parameters appropriatelly. 7) Select installation with restoring data from backup. Things go OK while restoring is in progress. When progress bar reach 100%, many of the same exceptions are starting to be written into catalina.out: java.sql.SQLException: 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 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:387) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83) at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884) at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601) at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354) Data seems to be loaded into new instance of Confluence correctly. The same exceptions repeat while rebuilding search index. I snipped some another exception while index rebuilding; see attached log for details.

    Atlassian JIRA | 1 decade ago | Jozef Babjak
    java.sql.SQLException: 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
  3. 0

    Error Acquisition Attempt Failed!!! exceeded simultaneous SESSIONS_PER_US - Forums | Liferay

    liferay.com | 2 years ago
    java.sql.SQLException: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [LPS-28489] Setup Wizard - Configuring from HSQL to Oracle 10 causes java.sql.SQLException - Liferay Issues

    liferay.com | 1 year ago
    java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  6. 0

    Could not open connection after migration from Oracle 10g to 11g driver

    Stack Overflow | 1 year ago | divanov
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

  1. Michael 1 times, last 4 months ago
  2. Jeremy 1 times, last 4 months ago
  3. qavid 2 times, last 5 months ago
  4. Kawada 4 times, last 6 months ago
45 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-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: localhost:1521:PDB

    at oracle.jdbc.driver.DatabaseError.throwSqlException()
  2. Oracle jdbc
    OracleDriver.connect
    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:387)
    4. oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
    5. oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    6. oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    7. oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    7 frames
  3. c3p0:JDBC DataSources/Resource Pools
    ThreadPoolAsynchronousRunner$PoolThread.run
    1. com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
    2. com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
    3. com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
    4. com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
    5. com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
    6. com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
    7. com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
    8. com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)
    8 frames