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