Oracle 19.21 rac alert大量报错日志：
Fatal NI connect error 12170.
Fatal NI connect error 12170.
Fatal NI connect error 12170.
Fatal NI connect error 12170.
Fatal NI connect error 12170.
Fatal NI connect error 12170.
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
Version 19.21.0.0.0
Version 19.21.0.0.0
Version 19.21.0.0.0
Version 19.21.0.0.0
Version 19.21.0.0.0
Version 19.21.0.0.0
Version 19.21.0.0.0
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
Time: 07-MAR-2024 12:25:02
Time: 07-MAR-2024 12:25:02
Time: 07-MAR-2024 12:25:02
Time: 07-MAR-2024 12:25:02
Time: 07-MAR-2024 12:25:02
Time: 07-MAR-2024 12:25:02
Time: 07-MAR-2024 12:25:02
Tracing not turned on.
Tracing not turned on.
Tracing not turned on.
Tracing not turned on.
Tracing not turned on.
Version 19.21.0.0.0
Tracing not turned on.
Tracing not turned on.
Tns error struct:
Tns error struct:
Tns error struct:
Tns error struct:
Tns error struct:
Tns error struct:
Tns error struct:
ns main err code: 12535
ns main err code: 12535
Time: 07-MAR-2024 12:25:02
ns main err code: 12535
ns main err code: 12535
ns main err code: 12535
ns main err code: 12535
ns main err code: 12535
Tracing not turned on.
TNS-12535: TNS:operation timed out
TNS-12535: TNS:operation timed out
TNS-12535: TNS:operation timed out
TNS-12535: TNS:operation timed out
TNS-12535: TNS:operation timed out
TNS-12535: TNS:operation timed out
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
Tns error struct:
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
ns secondary err code: 12560
nt main err code: 505
nt main err code: 505
nt main err code: 505
nt main err code: 505
ns main err code: 12535
nt main err code: 505
nt main err code: 505
nt main err code: 505
TNS-00505: Operation timed out
TNS-00505: Operation timed out
TNS-00505: Operation timed out
TNS-00505: Operation timed out
TNS-00505: Operation timed out
TNS-00505: Operation timed out
TNS-00505: Operation timed out
nt secondary err code: 110
nt secondary err code: 110
nt secondary err code: 110
nt secondary err code: 110
nt secondary err code: 110
nt secondary err code: 110
nt secondary err code: 110
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
TNS-12535: TNS:operation timed out
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.26.62.126)(PORT=56135))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.36.64.12)(PORT=63348))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.18.1.85)(PORT=64977))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.36.64.41)(PORT=63286))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.90.11.24)(PORT=50963))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.19.11.1)(PORT=52525))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.90.11.24)(PORT=50982))
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.36.64.12)(PORT=49747))
2024-03-07T12:26:08.118754+08:00
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
Version 19.21.0.0.0
Time: 07-MAR-2024 12:26:08
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.33.61.68)(PORT=50833))
2024-03-07T12:26:36.790759+08:00
***********************************************************************
处理办法：
1.sqlnet.ora在oracle用户下：
The following parameter, set at the **RDBMS_HOME/network/admin/sqlnet.ora, can resolve this kind of problem.
DCD or SQLNET.EXPIRE_TIME can mimic data transmission between the server and the client during long periods of idle time.
SQLNET.EXPIRE_TIME=2
DIAG_ADR_ENABLED = OFF
2.listener.ora:在grid用户下
if the listener name is ‘LISTENER’, the parameter would read:
DIAG_ADR_ENABLED_LISTENER = OFF
-Reload or restart the TNS Listener for the parameter change to take effect.
相关参考：
Resolving Problems with Connection Idle Timeout With Firewall (Doc ID 257650.1)
Alert Log Errors: 12170 TNS-12535/TNS-00505: Operation Timed Out (Doc ID 1628949.1)
Versions 11, 12 and Newer Databases: Fatal NI Connect Error 12170, ‘TNS-12535: TNS:operation timed out’ Reported in Alert Log (Doc ID 1286376.1)
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
