数据库告警日志报错:
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Time: 22-NOV-2012 16:16:20
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.1.4)(PORT=17911))
WARNING: inbound connection timed out (ORA-3136)
可能的原因有:
网络方面的问题,恶意的客户端访问、验证60秒超时、数据库负载过重无法在默认时间内完成客户端登陆等(具体参见文档Troubleshooting ORA-3136 WARNING Inbound Connection Timed Out [ID 465043.1])
建议:
1)编辑文件sqlnet.ora,添加参数:
SQLNET.INBOUND_CONNECT_TIMEOUT = 120
2)编辑文件listener.ora,添加参数:
INBOUND_CONNECT_TIMEOUT_ = 110
<或者将上述两个参数都设置为0>
3)重启或重新加载监听:
lsnrctl
Lsnrctl > restart
Lsnrctl > reload
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21256317/viewspace-1062801/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21256317/viewspace-1062801/