技术文章 - CS155173
Linux 上的 Windchill 与 Oracle 11g R2 数据库的连接问题
已修改: 06-Jan-2017
适用于
- Oracle11g R2
- Windchill family 10.0, 10.1 所有日期代码
- Red Hat Enterprise Linux 5, 6
说明
- Linux 上的 Windchill 与 Oracle 11g R2 数据库的连接问题
- 方法服务器日志报告的错误样例如下：
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)
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)
这是文章 155173 的 PDF 版本，可能已过期。最新版本 CS155173