This discussion is archived
4 Replies Latest reply: Apr 29, 2013 10:07 PM by MahirM.Quluzade RSS

TNS-12535: TNS:operation timed out

user13584223 Newbie
Currently Being Moderated
TNS-12535: TNS:operation timed out

Frequently getting below error in alert log file. Please help me to sort out this issue.
Database: Active standby database
OS: Windows Server
Db Version: 11.2.0.2
Error:
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 26-APR-2013 01:02:43
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
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.47.111.12)(PORT=49753))
WARNING: inbound connection timed out (ORA-3136)
Tns error struct:
Time: 26-APR-2013 01:02:43
ns main err code: 12535
Tracing not turned on.

Tns error struct:
TNS-12535: TNS:operation timed out
ns main err code: 12535
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.47.111.12)(PORT=49765))
WARNING: inbound connection timed out (ORA-3136)
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.47.111.12)(PORT=49776))
WARNING: inbound connection timed out (ORA-3136)
  • 1. Re: TNS-12535: TNS:operation timed out
    MahirM.Quluzade Guru
    Currently Being Moderated
    Hi,

    Can you paste result of following script?

    On both server.
    tnsping <primary net servicename> 
    tnsping <standby net servicename>
    Can you paste here SQLNET.log content ?


    Mahir
  • 2. Re: TNS-12535: TNS:operation timed out
    Mihael Pro
    Currently Being Moderated
    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
    Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.47.111.12)(PORT=49753))
    WARNING: inbound connection timed out (ORA-3136)
    This indicates unsuccessful connections from 10.47.111.12. May be due to heavy network load. If happens no often than 1-2 times per hour, can be ignored.
  • 3. Re: TNS-12535: TNS:operation timed out
    user13584223 Newbie
    Currently Being Moderated
    =======Primary========
    C:\Windows\system32>tnsping ORCLDB
    TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 30-APR-2013 05:48:00
    Copyright (c) 1997, 2010, Oracle. All rights reserved.
    Used parameter files:
    C:\app\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WPODB01A.co.uk)(PORT = 1521)) (CONNECT_DATA = (SERVER =
    DEDICATED) (SERVICE_NAME = ORCLDB.CO.UK)))
    OK (0 msec)

    =======standby========
    C:\app\oracle\grid\agent11g\bin>tnsping ORCLDBSTBY
    TNS Ping Utility for 64-bit Windows: Version 11.1.0.7.0 - Production on 30-APR-2013 05:46:01
    Copyright (c) 1997, 2008, Oracle. All rights reserved.
    Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-03505: Message 3505 not found; No message file for product=NETW
    ORK, facility=TNS
  • 4. Re: TNS-12535: TNS:operation timed out
    MahirM.Quluzade Guru
    Currently Being Moderated
    user13584223 wrote:
    =======Primary========
    C:\Windows\system32>tnsping ORCLDB
    TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 30-APR-2013 05:48:00
    Copyright (c) 1997, 2010, Oracle. All rights reserved.
    Used parameter files:
    C:\app\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WPODB01A.co.uk)(PORT = 1521)) (CONNECT_DATA = (SERVER =
    DEDICATED) (SERVICE_NAME = ORCLDB.CO.UK)))
    OK (0 msec)

    =======standby========
    C:\app\oracle\grid\agent11g\bin>tnsping ORCLDBSTBY
    TNS Ping Utility for 64-bit Windows: Version 11.1.0.7.0 - Production on 30-APR-2013 05:46:01
    Copyright (c) 1997, 2008, Oracle. All rights reserved.
    Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-03505: Message 3505 not found; No message file for product=NETW
    ORK, facility=TNS
    Hi,

    Did you sure contains primary and standby network service name in TNSNAMES.ora both side?

    Can you paste here tnsnames.ora file from both side?


    Regards
    Mahir M. Quluzade

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points