环境:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
告警文件内容:
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 09-10月-2016 14:20:11
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS: 连接关闭
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (9052) as a result of ORA-609
Sun Oct 09 14:20:21 2016
分析步骤:
1、由于ora-609错误导致会话连接失败,由于会话连接超时,造成会话中断。
2、tnsping检测监听是否正常,正常的话,可适当修改可会客户端的超时时间
3、tnsping不正常,检测自己的监听状态
4、监听不正常,可重建或者找到原因,解决问题
解决方法:
最终发现数据库的监听日志文件太大,导致监听起不来,重建监听日志文件,关闭监听日志
位置:Oracle的基目录/diag/主机名/listener/trace/listener