Fatal NI connect error [message #647784] |
Mon, 08 February 2016 01:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ashishkumarmahanta80
Messages: 231 Registered: October 2006 Location: kolkatta
|
Senior Member |
|
|
Dear All,
Now a days, I am getting below error at production database's alert. Please let me know, whether it is purely related to networking issue?
Though, In awr report, it come at last Top 10 Foreground Events by Total Wait Time.
Mon Feb 08 12:40:03 2016
Thread 1 cannot allocate new log, sequence 67751
Checkpoint not complete
Current log# 2 seq# 67750 mem# 0: /database/oracle/app/oracle/oradata/XYZDB/XYZDB/redo02a.log
Current log# 2 seq# 67750 mem# 1: /database/oracle/app/oracle/oradata/XYZDB/XYZDB/redo02b.log
Mon Feb 08 12:40:08 2016
***********************************************************************
Fatal NI connect error 12170.
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
Time: 08-FEB-2016 12:40: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=192.168.16.102)(PORT=63557))
Mon Feb 08 12:40:14 2016
Thread 1 advanced to log sequence 67751 (LGWR switch)
Current log# 5 seq# 67751 mem# 0: /database/oracle/app/oracle/oradata/XYZDB/XYZDB/redo05a.log
Current log# 5 seq# 67751 mem# 1: /database/oracle/app/oracle/oradata/XYZDB/XYZDB/redo05b.log
Mon Feb 08 12:40:14 2016
Archived Log entry 68360 added for thread 1 sequence 67750 ID 0xf94a7787 dest 1:
Thread 1 cannot allocate new log, sequence 67752
Checkpoint not complete
Current log# 5 seq# 67751 mem# 0: /database/oracle/app/oracle/oradata/XYZDB/XYZDB/redo05a.log
Current log# 5 seq# 67751 mem# 1: /database/oracle/app/oracle/oradata/XYZDB/XYZDB/redo05b.log
Waiting for your valuable inputs...
Regards,
Ashish Kumar Mahanta
|
|
|
Re: Fatal NI connect error [message #647785 is a reply to message #647784] |
Mon, 08 February 2016 01:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
That Fatal NI message is not a problem, ignore it.
The checkpointing issue is because your logfile groups are too small and you do not have enough of them..
|
|
|
Re: Fatal NI connect error [message #647787 is a reply to message #647785] |
Mon, 08 February 2016 01:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ashishkumarmahanta80
Messages: 231 Registered: October 2006 Location: kolkatta
|
Senior Member |
|
|
Dear John,
I know about the checkpoint issue. Some urgent work is going on during office hour instead on off-office hour. Only concerned is about
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
If it's not having problem, then I can ignore it....right??
Regards,
Ashish Kumar Mahanta
|
|
|
|
|
|