1. Home
  2. Support
Article - CS155173

Oracle 11g R2 database connection issues in Windchill on Linux

Modified: 06-Jan-2017   


Applies To

  • Windchill PDMLink 9.1 to 11.0
  • FlexPLM 9.1 to 11.0

Description

  • Database connection issues on Linux and Oracle 11g
  • Example of error messages in MethodServer log file:
Nested exception is: wt.pom.ConnectionException: A SQL error has occurred. Database system message follows:
Nested exception is: java.sql.SQLRecoverableException: IO Error: Connection reset
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:421)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:154)
    at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:216)
    at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:78)
    at wt.pds.oracle81.OracleDataSource.getConnection(OracleDataSource.java:59)
    at wt.pom.WTConnection.connect(WTConnection.java:254)
    at wt.pom.WTConnection.<init>(WTConnection.java:238)

Caused by: java.net.SocketException: Connection reset
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
    at oracle.net.ns.DataPacket.send(DataPacket.java:199)
    at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:211)
    at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:227)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)

ERROR [main] wt.method.server.startup.services  - Failure to start manager wt.audit.StandardAuditService
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: Connection reset
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: Connection reset
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:467)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:154)
    at wt.pds.StandardDataSource$2.getConnection(StandardDataSource.java:235)
    at wt.pds.StandardDataSource$ConnectionRetry.execute(StandardDataSource.java:367)
    at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:238)
    at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:80)
    at wt.pds.oracle81.OracleDataSource.getConnection(OracleDataSource.java:64)
    at wt.pom.WTConnection.connect(WTConnection.java:291)
    at wt.pom.WTConnection.<init>(WTConnection.java:275)
    at wt.pom.PersistentObjectManager.connect(PersistentObjectManager.java:313)
    at wt.pom.POMHandler.getConnection(POMHandler.java:133)
    at wt.method.MethodContext.getConnection(MethodContext.java:2058)
    at wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:322)
    at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1099)
    at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1015)
    at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1829)
    at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:1858)
    at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:675)
    at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:427)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
    at $Proxy10.find(Unknown Source)
    at wt.ufid.FederatableServerHelper.getRepositoryFromDB(FederatableServerHelper.java:1854)
    at wt.ufid.FederatableServerHelper.getRepository(FederatableServerHelper.java:228)
    at wt.org.StandardOrganizationServicesManager._getRepositoryForService(StandardOrganizationServicesManager.java:9398)
    at wt.org.StandardOrganizationServicesManager._getDomainsForPrincipals(StandardOrganizationServicesManager.java:9511)
    at wt.org.StandardOrganizationServicesManager.getDomainsForPrincipals(StandardOrganizationServicesManager.java:9428)
    at wt.org.StandardOrganizationServicesManager._queryPrincipals(StandardOrganizationServicesManager.java:7418)
    at wt.org.StandardOrganizationServicesManager._queryPrincipals(StandardOrganizationServicesManager.java:7245)
    at wt.org.StandardOrganizationServicesManager._queryPrincipals(StandardOrganizationServicesManager.java:7221)
    at wt.org.StandardOrganizationServicesManager._queryPrincipal(StandardOrganizationServicesManager.java:7166)
    at wt.org.StandardOrganizationServicesManager.getAuthenticatedUser(StandardOrganizationServicesManager.java:2213)
    at wt.org.StandardOrganizationServicesManager.getUser(StandardOrganizationServicesManager.java:2358)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
    at $Proxy20.getUser(Unknown Source)
    at wt.session.StandardSessionManager.getUser(StandardSessionManager.java:390)
    at wt.session.StandardSessionManager.getAdministrator(StandardSessionManager.java:272)
    at wt.session.StandardSessionManager.setAdministrator(StandardSessionManager.java:250)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
    at $Proxy19.setAdministrator(Unknown Source)
    at wt.audit.StandardAuditService.performStartupProcess(StandardAuditService.java:297)
    at wt.services.StandardManager.startup(StandardManager.java:459)
    at wt.services.ManagerImplementation.startup(ManagerImplementation.java:356)
    at wt.services.DefaultStartupHandler.startup(DefaultStartupHandler.java:112)
    at wt.services.StandardManagerService.performStartupProcess(StandardManagerService.java:166)
    at wt.services.StandardManager.startup(StandardManager.java:459)
    at wt.services.StandardServicesHandler.start(StandardServicesHandler.java:44)
    at wt.method.MethodServerMain.run(MethodServerMain.java:410)
    at wt.method.MethodServerMain.main(MethodServerMain.java:257)
This is a printer-friendly version of Article 155173 and may be out of date. For the latest version click CS155173