4 Replies Latest reply: Apr 30, 2013 12:07 AM by Mahir M. Quluzade RSS

    TNS-12535: TNS:operation timed out

    user13584223
      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
          Mahir M. Quluzade
          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
            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
              =======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
                Mahir M. Quluzade
                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