1. Home
  2. Support
Article - CS196921

Oracle listener not starting on Unix/Linux

Modified: 20-Jun-2017   


Applies To

  • Pro/INTRALINK 8.x + 9.1 M010
Oracle all versions on Unix

Description

  • MethodServer not starting due to connection error to Oracle database due to Oracle listener not starting on Unix/Linux.
  • Error in MethodServer log file:
wt.ufid.UfidException: wt.pom.DatastoreException: A persistence error occurred. System message follows:
    wt.pom.ConnectionException: A SQL error has occurred. Database system message follows:
    java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Nested exception is: wt.pom.DatastoreException: A persistence error occurred. System message follows:
Nested exception is: wt.pom.ConnectionException: A SQL error has occurred. Database system message follows:
Nested exception is: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:143)
    at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:111)
    at wt.pds.oracle81.OracleDataSource.getConnection(OracleDataSource.java:93)
    at wt.pom.WTConnection.connect(WTConnection.java:145)
    at wt.pom.WTConnection.<init>(WTConnection.java:129)
    at wt.pom.PersistentObjectManager.connect(PersistentObjectManager.java:325)
    at wt.pom.POMHandler.getConnection(POMHandler.java:110)
    at wt.method.MethodContext.getConnection(MethodContext.java:1879)
    at wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:358)
    at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1141)
    at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1051)
    at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:4474)
    at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:4529)
    at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:1559)
    at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:614)
    at wt.fc.PersistenceManagerFwd.find(PersistenceManagerFwd.java:212)
    at wt.ufid.FederatableServerHelper.getRepositoryFromDB(FederatableServerHelper.java:1183)
    at wt.ufid.FederatableServerHelper.getRepository(FederatableServerHelper.java:237)
    at wt.org.StandardOrganizationServicesManager._getRepositoryForService(StandardOrganizationServicesManager.java:11447)
    at wt.org.StandardOrganizationServicesManager._getDomainsForPrincipals(StandardOrganizationServicesManager.java:11550)
    at wt.org.StandardOrganizationServicesManager._queryPrincipals(StandardOrganizationServicesManager.java:8695)
    at wt.org.StandardOrganizationServicesManager._queryPrincipal(StandardOrganizationServicesManager.java:8618)
    at wt.org.StandardOrganizationServicesManager.getAuthenticatedUser(StandardOrganizationServicesManager.java:2578)
    at wt.org.StandardOrganizationServicesManager.getUser(StandardOrganizationServicesManager.java:2760)
    at wt.org.OrganizationServicesManagerFwd.getUser(OrganizationServicesManagerFwd.java:1322)
    at wt.session.StandardSessionManager.getUser(StandardSessionManager.java:607)
    at wt.session.StandardSessionManager.getAdministrator(StandardSessionManager.java:381)
    at wt.session.StandardSessionManager.setAdministrator(StandardSessionManager.java:342)
    at wt.session.SessionManagerFwd.setAdministrator(SessionManagerFwd.java:193)
    at wt.audit.StandardAuditService.performStartupProcess(StandardAuditService.java:350)
    at wt.services.StandardManager.startup(StandardManager.java:631)
    at wt.services.ManagerImplementation.startup(ManagerImplementation.java:479)
    at wt.services.DefaultStartupHandler.startup(DefaultStartupHandler.java:206)
    at wt.services.StandardManagerService.performStartupProcess(StandardManagerService.java:216)
    at wt.services.StandardManager.startup(StandardManager.java:631)
    at wt.services.StandardServicesHandler.start(StandardServicesHandler.java:43)
    at wt.method.MethodServerMain.run(MethodServerMain.java:376)
    at wt.method.MethodServerMain.start(MethodServerMain.java:263)
    at wt.method.MethodServerMain.main(MethodServerMain.java:207)
  • Caused by Oracle listener not running:
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 05-JAN-2015 22:56:25

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /usr2/ptc/Windchill_9.1/osa/oraprod/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /usr2/ptc/Windchill_9.1/osa/oraprod/network/admin/listener.ora
Log messages written to /usr2/ptc/Windchill_9.1/osa/oraprod/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12557: TNS:protocol adapter not loadable
TNS-12560: TNS:protocol adapter error
TNS-00527: Protocol Adapter not loadable

 
This is a printer-friendly version of Article 196921 and may be out of date. For the latest version click CS196921