现象如下:
java.sql.SQLRecoverableException: IO 错误: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
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 com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1572)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1636)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:898)
at io.renren.datasource.config.DynamicDataSourceFactory.buildDruidDataSource(DynamicDataSourceFactory.java:48)
at io.renren.datasource.config.DynamicDataSourceConfig.lambda$getDynamicDataSource$0(DynamicDataSourceConfig.java:56)
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
at io.renren.datasource.config.DynamicDataSourceConfig.getDynamicDataSource(DynamicDataSourceConfig.java:55)
at io.renren.datasource.config.DynamicDataSourceConfig.dynamicDataSource(DynamicDataSourceConfig.java:43)
at io.renren.datasource.config.DynamicDataSourceConfig$$EnhancerBySpringCGLIB$$9bbf5379.CGLIB$dynamicDataSource$1(<generated>)
无法登录oracle
异常上报时间非常接近
Oracle数据库1521端口时断时续/TNS超时/服务器无响应排错(TNS-12541/TNS-12560/TNS-00511/TNS-12535)
排查oracle日志以及oracle相关服务。
排查oracle日志,进入上图目录下查看监听日志listener.log,发现此文件大小为4G,感觉有点不对劲,将后缀改为bak,然后重启oracle监听服务
oracle的一个bug,bug号是9879101
参考:https://programming.vip/docs/oracle-monitoring-failure-in-windows.html