技术文章 - CS48982
在 Windchill PDMLink 中无法启动服务器并出现错误“ORA-12518，TNS：侦听器无法切换客户端连接”
已修改: 10-Jun-2024
适用于
- Windchill PDMLink 9.1 to 12.1
说明
- 安装 Windchill 时无法连接到 Oracle 数据库
- Windchill 无法启动并在方法服务器日志中显示以下消息：
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 服务或监听器未响应请求
- 队列停止工作，所有条目显示正在执行状态
- Windchill 安装因加载数据库架构模块而失败。PTC \Windchill_12.0\Windchill\installer\logs\xxx_WindchillDDL.log 和 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************
这是文章 48982 的 PDF 版本，可能已过期。最新版本 CS48982