No se puede iniciar el servidor con el error "ORA-12518, TNS: el oyente no pudo transferir la conexión del cliente" en Windchill PDMLink
Se aplica a
- Windchill PDMLink 9.1 to 12.1
Descripción
- No se puede conectar a la base de datos Oracle al instalar Windchill
- Windchill no se inicia y muestra el siguiente mensaje en los registros de MethodServer:
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)
- El servicio o receptor de Oracle no responde a las solicitudes
- La cola dejó de funcionar y todas las entradas muestran el estado Ejecutando
- La instalación de Windchill falla al cargar el módulo de esquema de la base de datos. Mensaje de error en PTC\Windchill_12.0\Windchill\installer\logs\xxx_WindchillDDL.log y 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************