Oracle 1521端口无法访问 IO 错误: The Network Adapter could not establish the connection

现象如下:

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

sunywz

~

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值