The 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
NT Windows NT TCP/IP Protocol Adapter for 64 - bit Windows: Version 11.2.0.1.0 - Production
Time: August - 2017-08-08:36:50
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: 60
Nt OS err code: 0
The Client address: (address=(TCP) PROTOCOL=(HOST=124.236.237.17) (49358) PORT=)
Tue Aug 08 08:37:21 2017
Thread 1 always the allocate new log, a sequence of 340646
Private strand flush the not complete
Current log# 4 seq# 340645 mem# 0: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO04 LOG
Thread 1 advanced to log sequence 340646 (LGWR switch)
Current log# 5 seq# 340646 mem# 0: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO05 LOG
Tue Aug 08 08:42:40 2017
Thread 1 always the allocate new log, a sequence of 340647
Private strand flush the not complete
Current log# 5 seq# 340646 mem# 0: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO05 LOG
Thread 1 advanced to log sequence 340647 (LGWR switch)
Current log# 6 seq# 340647 mem# 0: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO06 LOG
Tue Aug 08 08:45:22 2017
Thread 1 always the allocate new log, a sequence of 340648
Private strand flush the not complete
Current log# 6 seq# 340647 mem# 0: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO06 LOG
Thread 1 advanced to log sequence 340648 (LGWR switch)
Current log# seq# 340648 mem# 0 1: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO01 LOG
Tue Aug 08 08:45:52 2017
Thread 1 advanced to log sequence 340649 (LGWR switch)
Current log# seq# 340649 mem# 0 2: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO02 LOG
Tue Aug 08 08:46:25 2017
Thread 1 always the allocate new log, a sequence of 340650
Private strand flush the not complete
Current log# seq# 340649 mem# 0 2: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO02 LOG
Thread 1 advanced to log sequence 340650 (LGWR switch)
Current log# 3 seq# 340650 mem# 0: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO03 LOG
CodePudding user response:
Their top...CodePudding user response:
The building Lord 12170, timeout connection error, once met, at the scene of the implementation of screening for a long time, because at that time allocated to oracle's memory is too large, remember distribution memory_target=50 G, solve after reducing memory allocation,CodePudding user response:
Fatal NI connect error 12170.The 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
NT Windows NT TCP/IP Protocol Adapter for 64 - bit Windows: Version 11.2.0.4.0 - Production
Time: 12 - September - 2017 18:43:34
Tracing not turned on.
Tns error struct:
Ns main err code: 12535
TNS - 12535: TNS: operation timed out
Ns secondary err code: 12606
Nt main err code: 0
Nt secondary err code: 0
Nt OS err code: 0
The Client address: (address=(TCP) PROTOCOL=(HOST=10.77.76.20) (56154) PORT=)
Tue Sep 12 18:43:35 2017
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Tue Sep 12 18:43:35 2017
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fatal NI connect error 12170.
The 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
NT Windows NT TCP/IP Protocol Adapter for 64 - bit Windows: Version 11.2.0.4.0 - Production
Time: 12 - September - 2017 18:43:35
Tracing not turned on.
Tns error struct:
Ns main err code: 12535
TNS - 12535: TNS: operation timed out
Ns secondary err code: 12606
Nt main err code: 0
Nt secondary err code: 0
Nt OS err code: 0
The Client address: (address=(TCP) PROTOCOL=(HOST=10.77.76.20) (56162) PORT=)
Tue Sep 12 18:43:32 2017
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fatal NI connect error 12170.
The 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
NT Windows NT TCP/IP Protocol Adapter for 64 - bit Windows: Version 11.2.0.4.0 - Production
Time: 12 - September - 2017 18:43:35
Tracing not turned on.
Tns error struct:
Ns main err code: 12535
TNS - 12535: TNS: operation timed out
Ns secondary err code: 12606
Nt main err code: 0
Nt secondary err code: 0
Nt OS err code: 0
The Client address: (address=(TCP) PROTOCOL=(HOST=10.77.76.20) (56160) PORT=)
Fatal NI connect error 12170.
The VERSION INFORMATION:
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull