Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

TNS-00505: Operation timed out error..

rsar001Mar 15 2010 — edited Mar 22 2010
Hi Experts,
We were in the middle of remote transactions today and all of a sudden our process stopped.. I checked out the alert log and I saw the following:
Mon Mar 15 13:48:12 2010
Thread 1 advanced to log sequence 9831 (LGWR switch)
  Current log# 2 seq# 9831 mem# 0: D:\ORACLE\ORADATA\ONLINELOG\RNET\REDO02.LOG
  Current log# 2 seq# 9831 mem# 1: C:\ORACLE\ORADATA\ONLINELOG\RNET\REDO02.LOG
Mon Mar 15 13:48:12 2010
Archived Log entry 24 added for thread 1 sequence 9830 ID 0x27020ba0 dest 10:
Mon Mar 15 13:50:33 2010
Thread 1 advanced to log sequence 9832 (LGWR switch)
  Current log# 3 seq# 9832 mem# 0: D:\ORACLE\ORADATA\ONLINELOG\RNET\REDO03.LOG
  Current log# 3 seq# 9832 mem# 1: C:\ORACLE\ORADATA\ONLINELOG\RNET\REDO03.LOG
Mon Mar 15 13:50:33 2010
Archived Log entry 25 added for thread 1 sequence 9831 ID 0x27020ba0 dest 10:
Mon Mar 15 13:51:16 2010


***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.1.0.7.0 - Production
	Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.7.0 - Production
  Time: 15-MAR-2010 13:51:16
  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
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=142.32.186.111)(PORT=1521))
Mon Mar 15 13:54:06 2010
Thread 1 advanced to log sequence 9833 (LGWR switch)
  Current log# 1 seq# 9833 mem# 0: D:\ORACLE\ORADATA\ONLINELOG\RNET\REDO01.LOG
  Current log# 1 seq# 9833 mem# 1: C:\ORACLE\ORADATA\ONLINELOG\RNET\REDO01.LOG
Mon Mar 15 13:54:06 2010
Archived Log entry 26 added for thread 1 sequence 9832 ID 0x27020ba0 dest 10:
Mon Mar 15 13:54:53 2010
Thread 1 advanced to log sequence 9834 (LGWR switch)
  Current log# 2 seq# 9834 mem# 0: D:\ORACLE\ORADATA\ONLINELOG\RNET\REDO02.LOG
  Current log# 2 seq# 9834 mem# 1: C:\ORACLE\ORADATA\ONLINELOG\RNET\REDO02.LOG
Mon Mar 15 13:54:53 2010
We've been running our process for years and never had such a problem with it.. I'm guessing this is listener/network related.. Do we need to set any listener specific parameter to prevent this from happening? Anyone can shed some light on what the error might be and how to prevent this from happening in the future please.


Thanks

Edited by: rsar001 on Mar 15, 2010 4:24 PM

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 19 2010
Added on Mar 15 2010
#general-database-discussions
6 comments
18,850 views