数据库alter日志报TNS-12537和ORA-609错误
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 -
Production
Oracle Bequeath NT Protocol Adapter for Linux:
Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version
11.2.0.1.0 - Production
Time: 30-MAR-2015 17:38:22
Tracing not turned on.
Tns error struct:
ns main err
code: 12537
TNS-12537: TNS:connection closed
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 (10140) as a result of
ORA-609
Mon Mar 30 17:38:22 2015
***********************************************************************
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 -
Production
Oracle Bequeath NT Protocol Adapter for Linux:
Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version
11.2.0.1.0 - Production
Time: 30-MAR-2015 17:38:22
Tracing not turned on.
Tns error struct:
ns main err
code: 12537
TNS-12537: TNS:connection closed
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 (10136) as a result of
ORA-609
------------------------------------
开发人员反映说连接非常慢,会报连接不够用的错误。检查之后后process的值为1000,而目前的连接只有90多个,完全够用。初步怀疑是监听出现问题,查询监听日志,正常没有报错。lsnrctl
status发现响应时间非常慢,tnsping监听响应也非常慢,需要40多秒,但是ping
ip的时候速度很快,查找相关资料,最后注释掉 /etc/resolve.conf 中无法解析的ip,解决问题。