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
uj5u.com熱心網友回復：
自己頂………………uj5u.com熱心網友回復：
樓主12170、超時連接錯誤，曾經在實施現場遇到過，排查了很久，當時是因為分配給oracle的記憶體過大造成的，記得當時分配的memory_target=50多個G，在降低記憶體分配后解決。uj5u.com熱心網友回復：
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))
最近一直出現這個問題不知道怎么解決
uj5u.com熱心網友回復：
求大神指導。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/82484.html
標籤：高級技術
上一篇：親們，誰能幫我解釋一下這個問題：navicat能通過sql陳述句查詢到資料表，但是在表里面找不到這張表，這是怎么回事