Article - CS48982
Cannot start server with error "ORA-12518, TNS:listener could not hand off client connection" in Windchill PDMLink
Modified: 09-Jun-2024
Applies To
- Windchill PDMLink 9.1 to 12.1
Description
- Unable to connect to oracle database when installing Windchill
- Windchill does not start and displays following message is MethodServer logs:
Nested exception is: java.sql.SQLException: Listener refused the connection with the following error:ORA-12518, TNS:listener could not hand off client connection main: at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:119) main: at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:134) main: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:247) main: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:694)
- Oracle Service or Listener not responding to requests
- The Queue stop working, and all the entries show Executing status
- Windchill installation fails with loading database schema module. Error message in PTC\Windchill_12.0\Windchill\installer\logs\xxx_WindchillDDL.log and xx_ WindchillDDL_errors.log:
************ Starting to log at Wed Mar 03 22:54:04 CST 2021************ 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:228) at wt.pds.StandardDataSource$1.getConnection(StandardDataSource.java:115) at wt.pds.StandardDataSource$ConnectionRetry.execute(StandardDataSource.java:411) at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:118) at wt.tools.sql.SQLCommandTool.getConnection(SQLCommandTool.java:216) at wt.tools.sql.SQLCommandTool.getConnection(SQLCommandTool.java:193) at wt.tools.sql.SQLCommandConfiguration.getConnection(SQLCommandConfiguration.java:324) at wt.tools.sql.SQLCommandTool.main(SQLCommandTool.java:103) 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) ... 13 more ************ Ending log at Wed Mar 03 23:00:44 CST 2021************
This is a printer-friendly version of Article 48982 and may be out of date. For the latest version click CS48982