Oracle日志中alert_orcl.log出现Fatal NI connect error 12170，如何破？

[zkcharge]

Fatal NI connect error 12170.

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: 08-8月 -2017 08:36:50
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS: 操作超时
ns secondary err code: 12560
nt main err code: 505

TNS-00505: 操作超时
nt secondary err code: 60
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=124.236.237.17)(PORT=49358))
Tue Aug 08 08:37:21 2017
Thread 1 cannot allocate new log, sequence 340646
Private strand flush not complete
Current log# 4 seq# 340645 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG
Thread 1 advanced to log sequence 340646 (LGWR switch)
Current log# 5 seq# 340646 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOG
Tue Aug 08 08:42:40 2017
Thread 1 cannot allocate new log, sequence 340647
Private strand flush not complete
Current log# 5 seq# 340646 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOG
Thread 1 advanced to log sequence 340647 (LGWR switch)
Current log# 6 seq# 340647 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO06.LOG
Tue Aug 08 08:45:22 2017
Thread 1 cannot allocate new log, sequence 340648
Private strand flush not complete
Current log# 6 seq# 340647 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO06.LOG
Thread 1 advanced to log sequence 340648 (LGWR switch)
Current log# 1 seq# 340648 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Tue Aug 08 08:45:52 2017
Thread 1 advanced to log sequence 340649 (LGWR switch)
Current log# 2 seq# 340649 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Tue Aug 08 08:46:25 2017
Thread 1 cannot allocate new log, sequence 340650
Private strand flush not complete
Current log# 2 seq# 340649 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Thread 1 advanced to log sequence 340650 (LGWR switch)
Current log# 3 seq# 340650 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG

[zkcharge]

自己顶………………

[MOUSE20051316025]

楼主12170、超时连接错误，曾经在实施现场遇到过，排查了很久，当时是因为分配给oracle的内存过大造成的，记得当时分配的memory_target=50多个G，在降低内存分配后解决。

[私念醉美]

Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Time: 12-9月 -2017 18:43:34 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS: 操作超时 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.77.76.20)(PORT=56154)) Tue Sep 12 18:43:35 2017 *********************************************************************** Tue Sep 12 18:43:35 2017 *********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Time: 12-9月 -2017 18:43:35 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS: 操作超时 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.77.76.20)(PORT=56162)) Tue Sep 12 18:43:32 2017 *********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Time: 12-9月 -2017 18:43:35 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS: 操作超时 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.77.76.20)(PORT=56160)) Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Time: 12-9月 -2017 18:43:36 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS: 操作超时 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.77.76.20)(PORT=56153)) Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production Time: 12-9月 -2017 18:43:36 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS: 操作超时 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.77.76.20)(PORT=56152)) 最近一直出现这个问题不知道怎么解决

[私念醉美]

引用 3 楼 MOUSE20051316025 的回复:

楼主12170、超时连接错误，曾经在实施现场遇到过，排查了很久，当时是因为分配给oracle的内存过大造成的，记得当时分配的memory_target=50多个G，在降低内存分配后解决。

求大神指导。