1、 前端登录界面
2、 后台应用日志
报错信息一致为:
$$callid= $$thread=[Service Monitor and Runtime Enroment] $$host= $$userid= $$ts=2017-05-23 09:18:13 $$remotecall=[nc.bs.mw.ejbsql.IerpXADataSource] $$debuglevel=ERROR $$msg=initializing the connection pool failed,can't open database connection
java.sql.SQLException: Io 异常: Got minus one from a read call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
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:802)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at nc.bs.mw.ejb.xares.IerpDataSource.getConnection(IerpDataSource.java:38)
at nc.bs.mw.ejbsql.IerpXADataSource.createNoXaConnection(IerpXADataSource.java:601)
at nc.bs.mw.ejbsql.IerpXADataSource.init(IerpXADataSource.java:212)
at nc.bs.mw.ejbsql.IerpXADataSource.init(IerpXADataSource.java:859)
at nc.bs.mw.naming.EJBContainerService.initDataSource(EJBContainerService.java:72)
at nc.bs.mw.naming.EJBContainerService.startServer(EJBContainerService.java:196)
at nc.bs.mw.fm.ServiceManager.startBaseService(ServiceManager.java:348)
at nc.bs.mw.fm.ServiceManager.run(ServiceManager.java:236)
二、问题分析
1.查看数据库服务器信息
经过DBA排查初步断定为数据服务器出了问题,接下来由DBA协助问题处理解决。
三、问题解决
1、 经过DBA的协助下,NC恢复正常访问