Article - CS212465

Rehost Utility failed with "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"

Modified: 30-Apr-2025   


Applies To

  • Windchill Rehosting Utility 11.1 to 12.1

Description

  • Rehost failed to connect to Oracle Database
  • Rehost Utility failed with following error:
BUILD FAILED
/opt/ptc/Exchange/RehostUtility/conf/rehost.xml:63: com.ptc.wc.rehost.exception.RehostException: Failed to validate db connection
Nested exception is: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
    at java.sql.DriverManager.getConnection(DriverManager.java:571)
    at java.sql.DriverManager.getConnection(DriverManager.java:215)
    at com.ptc.wc.rehost.validate.DBConnectionValidator.validateOracle(DBConnectionValidator.java:274)
    at com.ptc.wc.rehost.validate.DBConnectionValidator.validate(DBConnectionValidator.java:232)
    at com.ptc.wc.rehost.validate.Validator.execute(Validator.java:35)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

ERROR [DBConnectionValidator]: com.ptc.wc.rehost.exception.RehostException: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Nested exception is: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
This is a printer-friendly version of Article 212465 and may be out of date. For the latest version click CS212465