Article - CS419742

Windchill exits prematurely with the error "Failed to acquire JDBC connection java.sql.SQLException: Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off client connection"

Modified: 07-Jun-2024   


Applies To

  • Windchill PDMLink 12.1

Description

  • Windchill exits prematurely with the error Failed to acquire JDBC connection java.sql.SQLException: Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off client connection
  • ServerManager reports the following error:
ERROR [MasterLeaseMaintainer] wt.manager.CacheMasterNegotiator - Failed to acquire JDBC connection java.sql.SQLException: Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection
 
                at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:862)
                at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
                at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
                at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
                at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
                at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
                at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
                at wt.pds.StandardDataSource$2.getConnection(StandardDataSource.java:157)
                at wt.pds.StandardDataSource$ConnectionRetry.execute(StandardDataSource.java:411)
                at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:160)
                at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:87)
                at wt.manager.CacheMasterNegotiator.getNewConnection(CacheMasterNegotiator.java:875)
                at wt.manager.CacheMasterNegotiator.refreshConnection(CacheMasterNegotiator.java:852)
                at wt.manager.CacheMasterNegotiator.refreshConnection(CacheMasterNegotiator.java:844)
                at wt.manager.CacheMasterNegotiator.resetAndRefreshConnections(CacheMasterNegotiator.java:1778)
                at wt.manager.CacheMasterNegotiator$MasterLeaseMaintainer.run(CacheMasterNegotiator.java:1987)
                at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection
 
                at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
                at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
                at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1604)
                at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:595)
                ... 18 more
 
ERROR [MasterLeaseMaintainer] wt.manager.CacheMasterNegotiator - isValid() returned false for oracle.jdbc.driver.T4CConnection@54d0578 [id=20]; took 7.29E-5 seconds java.lang.IllegalStateException: Invalid JDBC connection
                at wt.manager.CacheMasterNegotiator.isConnectionValid(CacheMasterNegotiator.java:1350)
                at wt.manager.CacheMasterNegotiator.isConnectionValid(CacheMasterNegotiator.java:1317)
                at wt.manager.CacheMasterNegotiator.refreshConnection(CacheMasterNegotiator.java:850)
                at wt.manager.CacheMasterNegotiator.refreshConnection(CacheMasterNegotiator.java:844)
                at wt.manager.CacheMasterNegotiator.resetAndRefreshConnections(CacheMasterNegotiator.java:1778)
                at wt.manager.CacheMasterNegotiator$MasterLeaseMaintainer.run(CacheMasterNegotiator.java:1987)
                at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.base/java.lang.Thread.run(Thread.java:829)
  • MethodServer reports the following error:
ERROR [ajp-nio-127.0.0.1-8011-exec-363] wt.licenseusage.licensing.StandardLicenseManagerService xxxxx - A persistence error occurred.
ERROR [ajp-nio-127.0.0.1-8011-exec-363] wt.pds.exception xxxxx - Suppressing internal message wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
Nested exception is: wt.pom.ConnectionException
                at wt.pom.POMHandler.getConnection(POMHandler.java:88)
                at wt.method.MethodContext.getConnection(MethodContext.java:2436)


 
This is a printer-friendly version of Article 419742 and may be out of date. For the latest version click CS419742