Article - CS214170

Oracle Listener does not start successfully

Modified: 06-Jun-2017   


Applies To

  • Windchill PDMLink 9.1 to 11.0
  • Oracle 11g

Description

Oracle Listener status errors:

  • TNS-12541: TNS:no listener
  • Oracle listener simply doesn't start.
  • In Method Server log during Windchill startup: Failure to start manager wt.audit.StandardAuditService wt.services.ManagerException: Could not initialize Auditing service
Windchill not starting because of Oracle errors in the Method Server log:
  • Nested exception is: wt.services.ManagerException: Could not initialize Auditing service.
    Nested exception is: wt.ufid.UfidException: wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
        wt.pom.ConnectionException: A SQL error has occurred. Database system message follows:
        java.sql.SQLRecoverableException: IO Error: Socket read timed out
    Nested exception is: wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
    Nested exception is: wt.pom.ConnectionException: A SQL error has occurred. Database system message follows:
    Nested exception is: java.sql.SQLRecoverableException: IO Error: Socket read timed out
  • Caused by: oracle.net.ns.NetException: Socket read timed out
Oracle alert log:
  • TNS-12537: TNS:connection closed
        ns secondary err code: 12560
        nt main err code: 0
        nt secondary err code: 0
        nt OS err code: 0
    opiodr aborting process unknown ospid (8008) as a result of ORA-609
This is a printer-friendly version of Article 214170 and may be out of date. For the latest version click CS214170