Fatal NI connect error 12537和ORA-609问题, 如何排查

2021-03-30

数据库的alter日志中经常出现
Fatal NI connect error 12537,和ora-609的错误。
之前排查发现是tnsname.ora中有主机名设置错误并进行修改。
今天在看还是存在Fatal NI connect error 12537错误提示

数据库版本是11。2.0.4，Centos linux 6.10,单机
详细错误摘录如下：

Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
Tue Mar 30 15:02:02 2021

Fatal NI connect error 12537, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
opiodr aborting process unknown ospid (175623) as a result of ORA-609
Time: 30-MAR-2021 15:02:03

VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Tns error struct:
Tracing not turned on.
Tracing not turned on.
Tracing not turned on.
Time: 30-MAR-2021 15:02:03
Time: 30-MAR-2021 15:02:03
Time: 30-MAR-2021 15:02:03
ns main err code: 12537
Tns error struct:
Tns error struct:
ns main err code: 12537

Tns error struct:
Tracing not turned on.
Tracing not turned on.
ns main err code: 12537
Tracing not turned on.
opiodr aborting process unknown ospid (175613) as a result of ORA-609

ns main err code: 12537

Tns error struct:
Tns error struct:
Tns error struct:
ns main err code: 12537
ns main err code: 12537

ns main err code: 12537

opiodr aborting process unknown ospid (175581) as a result of ORA-609

opiodr aborting process unknown ospid (175478) as a result of ORA-609

TNS-12537: TNS:connection closed
TNS-12537: TNS:connection closed
TNS-12537: TNS:connection closed
TNS-12537: TNS:connection closed
TNS-12537: TNS:connection closed
TNS-12537: TNS:connection closed
TNS-12537: TNS:connection closed
ns secondary err code: 12560
ns secondary err code: 12560
ns secondary err code: 12560
ns secondary err code: 12560
ns secondary err code: 12560
nt main err code: 0
nt main err code: 0
nt main err code: 0
ns secondary err code: 12560
nt main err code: 0
ns secondary err code: 12560
nt secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt secondary err code: 0
nt secondary err code: 0
nt main err code: 0
nt main err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt secondary err code: 0
nt secondary err code: 0
nt secondary err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (175767) as a result of ORA-609
opiodr aborting process unknown ospid (175726) as a result of ORA-609
opiodr aborting process unknown ospid (175736) as a result of ORA-609opiodr aborting process unknown ospid (175649) as a result of ORA-609

opiodr aborting process unknown ospid (175690) as a result of ORA-609
opiodr aborting process unknown ospid (175763) as a result of ORA-609
opiodr aborting process unknown ospid (175712) as a result of ORA-609
Tue Mar 30 15:02:07 2021

3条回答

默认