暂无图片
12cr2 rac ora-29740 ora-3136
我来答
分享
Squidward Tentacles
2021-08-11
12cr2 rac ora-29740 ora-3136

一个月rac出现两次问题,都是重启服务器解决,4个节点报错ORA-29740,ORA-3136,12.2.0.1,4节点rac,centos7.4,大神帮忙看下,以下是各节点报错信息
image.png
image.png
image.png
image.png

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
Uncopyrightable

有个项目也遇到类似的问题,也是12C环境
Oracle Linux 7.9 RAC 12.2.0.1版本的
提示连接超时,网上只能找到10g出现类似问题解决办法,10g主要是长连接没有释放,最终没有找到解决办法。是不是连接请求太多太频繁了?

2019-12-19T11:48:17.333690+08:00


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for Linux: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
Time: 19-DEC-2019 11:48:17
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.104.17)(PORT=54024))
2019-12-19T11:48:17.345482+08:00
WARNING: inbound connection timed out (ORA-3136)
2019-12-19T11:55:13.095233+08:00


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for Linux: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
Time: 19-DEC-2019 11:55:13
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.104.17)(PORT=54118))
2019-12-19T11:55:13.096457+08:00
WARNING: inbound connection timed out (ORA-3136)
2019-12-19T11:58:37.831017+08:00


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for Linux: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
Time: 19-DEC-2019 11:58:37
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.13.206)(PORT=4750))
2019-12-19T11:58:37.831955+08:00
WARNING: inbound connection timed out (ORA-3136)

暂无图片 评论
暂无图片 有用 0
Squidward Tentacles
题主
2021-08-11
和我这个报错很像,出这个报错后来你们数据库down了没
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏