1 2 3 Previous Next 34 Replies Latest reply: Mar 5, 2013 11:57 PM by sb92075 RSS

    TNS-12535: TNS:operation timed out

    moslee
      Hi to all

      I have been trying to connect a db(ATDMPQA Oracle 9i) from this current 10g db but I encounter TNS-12535: TNS:operation timed out. Please help as I really cannot figure where the mistake was... Thanks.

      C:\Documents and Settings\Administrator>tnsping atdmpqa
      TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 04-FEB-2
      013 17:18:10
      Copyright (c) 1997, 2003, Oracle. All rights reserved.
      Used parameter files:
      D:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = o3_
      ora.NECSS.NEC.COM.SG) (PROTOCOL = TCP) (Host = 138.141.10.5) (Port = 1531))) (CO
      NNECT_DATA = (SID = ATDMP) (GLOBAL_NAME = ATDMP.NECSS.NEC.COM.SG)))
      TNS-12535: TNS:operation timed out


      In Tnsnames.ora, i stated
      -----------------------------------
      ATDMPQA.NECSS.NEC.COM.SG =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS =
      (COMMUNITY = o3_ora.NECSS.NEC.COM.SG)
      (PROTOCOL = TCP)
      (Host = 138.141.10.5)
      (Port = 1531)
      )
      )
      (CONNECT_DATA =
      (SID = ATDMP)
      (GLOBAL_NAME = ATDMP.NECSS.NEC.COM.SG)
      )
      )


      In Sqlnet.ora, i stated
      ------------------------------
      AUTOMATIC_IPC = OFF
      TRACE_LEVEL_CLIENT = OFF
      SQLNET.EXPIRE_TIME = 0
      NAMES.DEFAULT_DOMAIN = NECSS.NEC.COM.SG
      NAME.DEFAULT_ZONE = NECSS.NEC.COM.SG
      SQLNET.CRYPTO_SEED = "-1617985050-1384208265"
      NAMES.DIRECTORY_PATH = (TNSNAMES)

      Edited by: moslee on Feb 4, 2013 1:22 AM
        • 1. Re: TNS-12535: TNS:operation timed out
          asahide
          Hi,

          TNS-12535 is network issue.
          Can you reach "138.141.10.5:1531" via any protocol?

          This error is often caused by Firewall..

          Regards,
          • 2. Re: TNS-12535: TNS:operation timed out
            JohnWatson
            Just one possibility - should this
            (Port = 1531)
            actually be this
            (Port = 1521)
            • 3. Re: TNS-12535: TNS:operation timed out
              yoonas
              Hi,

              Can you ping to 138.141.10.5 (ping 138.141.10.5)

              Check if fire wall is blocking your connection on the server

              Please open sqlplus , try connecting with service name and post the ouput here.(sqlplus <usename>/<passowrd>@service

              Regards
              Yoonas
              • 4. Re: TNS-12535: TNS:operation timed out
                Osama_Mustafa
                Refer to
                TNS-12535 / ORA-12535 on Connection to Database [ID 214122.1]
                TNS-12535 While Connecting Via Shared Servers [ID 823274.1]
                ORA-12535 or TNS-12535 'Connection timed out' [ID 1504201.1]
                • 5. Re: TNS-12535: TNS:operation timed out
                  moslee
                  To asahideO
                  -----------
                  I can reach via ftp.

                  C:\>ftp 138.141.10.5
                  Connected to 138.141.10.5.
                  220 (vsFTPd 2.0.1)
                  User (138.141.10.5:(none)): atdmp
                  331 Please specify the password.
                  Password:
                  230 Login successful.
                  ftp> bye
                  221 Goodbye.
                  • 6. Re: TNS-12535: TNS:operation timed out
                    moslee
                    To JohnWatson
                    -------------
                    1531 is the port number.
                    I have other DBs successfully connected to 138.141.10.5 (ATDMPQA)
                    • 7. Re: TNS-12535: TNS:operation timed out
                      moslee
                      To yoonus
                      ---------
                      I can ping 138.141.10.5.

                      C:\Documents and Settings\Administrator>ping 138.141.10.5

                      Pinging 138.141.10.5 with 32 bytes of data:

                      Reply from 138.141.10.5: bytes=32 time=2ms TTL=63
                      Reply from 138.141.10.5: bytes=32 time=2ms TTL=63
                      Reply from 138.141.10.5: bytes=32 time=2ms TTL=63
                      Reply from 138.141.10.5: bytes=32 time=2ms TTL=63

                      Ping statistics for 138.141.10.5:
                      Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
                      Approximate round trip times in milli-seconds:
                      Minimum = 2ms, Maximum = 2ms, Average = 2ms

                      C:\Documents and Settings\Administrator>


                      I have no Windows Firewall because the Windows Firewall/Internet Connection Sharing (ICS) service is not running.


                      SQL> conn <usename>/<passowrd>@atdmpqa
                      ERROR:
                      ORA-12170: TNS:Connect timeout occurred

                      I suspect the entry in the tnsnames wasn't correct. But I just cannot figure out what was the issue.
                      • 8. Re: TNS-12535: TNS:operation timed out
                        sb92075
                        moslee wrote:
                        To yoonus
                        ---------
                        I can ping 138.141.10.5.

                        C:\Documents and Settings\Administrator>ping 138.141.10.5

                        Pinging 138.141.10.5 with 32 bytes of data:

                        Reply from 138.141.10.5: bytes=32 time=2ms TTL=63
                        Reply from 138.141.10.5: bytes=32 time=2ms TTL=63
                        Reply from 138.141.10.5: bytes=32 time=2ms TTL=63
                        Reply from 138.141.10.5: bytes=32 time=2ms TTL=63

                        Ping statistics for 138.141.10.5:
                        Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
                        Approximate round trip times in milli-seconds:
                        Minimum = 2ms, Maximum = 2ms, Average = 2ms

                        C:\Documents and Settings\Administrator>


                        I have no Windows Firewall because the Windows Firewall/Internet Connection Sharing (ICS) service is not running.


                        SQL> conn <usename>/<passowrd>@atdmpqa
                        ERROR:
                        ORA-12170: TNS:Connect timeout occurred

                        I suspect the entry in the tnsnames wasn't correct. But I just cannot figure out what was the issue.
                        The most common cause for TIMEOUT is due to FireWall on or between Client & DB Server
                        • 9. Re: TNS-12535: TNS:operation timed out
                          yoonas
                          Can you check on the server (where your database is running) if firewall is enabled or antivirus sometimes

                          What happens when you connect(with service name) from the database server with the same tns entry

                          Are you able to connect to the database from any other machines?
                          • 10. Re: TNS-12535: TNS:operation timed out
                            moslee
                            Hi yoonus

                            1. Firewall is not running... Guess there is no antivirus (cannot confirm now)
                            [root@ATDMP1 ~]# service iptables status
                            Firewall is stopped.
                            [root@ATDMP1 ~]#


                            2. This is the tns entry in the linux server(where ATDMPQA database is running)
                            [atdmp@ATDMP1 /etc]$ cat tnsnames.ora
                            ATDMP1 =
                            (DESCRIPTION =
                            (ADDRESS =
                            (PROTOCOL= TCP)
                            (HOST= 138.141.10.5)
                            (Port= 1531)
                            )
                            (CONNECT_DATA =
                            (SID = ATDMP)
                            )
                            )

                            [atdmp@ATDMP1 ~]$ tnsping atdmp1

                            TNS Ping Utility for Linux: Version 9.2.0.7.0 - Production on 05-FEB-2013 13:51:46
                            Copyright (c) 1997 Oracle Corporation. All rights reserved.
                            Used parameter files:
                            Used TNSNAMES adapter to resolve the alias
                            Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP) (HOST= 138.141.10.5) (Port= 1531)) (CONNECT_DATA = (SID = ATDMP)))
                            OK (0 msec)
                            [atdmp@ATDMP1 ~]$


                            3. Yes, actually I can connect from other machines except that 10g DB.

                            This is from my client terminal..
                            C:\Windows\System32>tnsping atdmpqa

                            TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-FEB-20
                            13 14:55:17
                            Copyright (c) 1997 Oracle Corporation. All rights reserved.
                            Used parameter files:
                            C:\oracle\ora92\network\ADMIN\sqlnet.ora

                            Used TNSNAMES adapter to resolve the alias
                            Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
                            (Host = 138.141.10.5)(Port = 1531))) (CONNECT_DATA = (SID = ATDMP)))
                            OK (0 msec)
                            C:\Windows\System32>
                            • 11. Re: TNS-12535: TNS:operation timed out
                              yoonas
                              Can you check this document
                              Troubleshooting Guide TNS-12535 or ORA-12535 or ORA-12170 Errors [ID 119706.1]
                              • 12. Re: TNS-12535: TNS:operation timed out
                                sb92075
                                moslee wrote:
                                Hi yoonus

                                1. Firewall is not running... Guess there is no antivirus (cannot confirm now)
                                [root@ATDMP1 ~]# service iptables status
                                Firewall is stopped.
                                [root@ATDMP1 ~]#


                                2. This is the tns entry in the linux server(where ATDMPQA database is running)
                                [atdmp@ATDMP1 /etc]$ cat tnsnames.ora
                                ATDMP1 =
                                (DESCRIPTION =
                                (ADDRESS =
                                (PROTOCOL= TCP)
                                (HOST= 138.141.10.5)
                                (Port= 1531)
                                )
                                (CONNECT_DATA =
                                (SID = ATDMP)
                                )
                                )
                                while logged on to DB Server issue the following OS commands

                                lsnrctl status
                                lsnrctl service

                                post excerpt from listener.log file that shows record containing 12535 status code & surrounding lines
                                • 13. Re: TNS-12535: TNS:operation timed out
                                  moslee
                                  Hi sb92075

                                  C:\Documents and Settings\Administrator>lsnrctl status

                                  LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 07-FEB-2013 15:44
                                  :03

                                  Copyright (c) 1991, 2004, Oracle. All rights reserved.

                                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                                  STATUS of the LISTENER
                                  ------------------------
                                  Alias LISTENER
                                  Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
                                  ction
                                  Start Date 09-JUL-2012 12:43:05
                                  Uptime 213 days 3 hr. 0 min. 58 sec
                                  Trace Level off
                                  Security ON: Local OS Authentication
                                  SNMP OFF
                                  Listener Parameter File D:\oracle\product\10.1.0\Db_1\network\admin\listener.o
                                  ra
                                  Listener Log File D:\oracle\product\10.1.0\Db_1\network\log\listener.log

                                  Listening Endpoints Summary...
                                  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
                                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isd15.ssg.necel.com)(PORT=1521)))
                                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isd15.ssg.necel.com)(PORT=8080))(Pre
                                  sentation=HTTP)(Session=RAW))
                                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isd15.ssg.necel.com)(PORT=2100))(Pre
                                  sentation=FTP)(Session=RAW))
                                  Services Summary...
                                  Service "WebfocusXDB" has 1 instance(s).
                                  Instance "webfocus", status READY, has 1 handler(s) for this service...
                                  Service "webfocus" has 1 instance(s).
                                  Instance "webfocus", status READY, has 1 handler(s) for this service...
                                  The command completed successfully

                                  C:\Documents and Settings\Administrator>lsnrctl service

                                  LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 07-FEB-2013 15:44
                                  :34

                                  Copyright (c) 1991, 2004, Oracle. All rights reserved.

                                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                                  Services Summary...
                                  Service "WebfocusXDB" has 1 instance(s).
                                  Instance "webfocus", status READY, has 1 handler(s) for this service...
                                  Handler(s):
                                  "D000" established:0 refused:0 current:0 max:1002 state:ready
                                  DISPATCHER <machine: ISD15, pid: 4108>
                                  (ADDRESS=(PROTOCOL=tcp)(HOST=isd15.ssg.necel.com)(PORT=3407))
                                  Service "webfocus" has 1 instance(s).
                                  Instance "webfocus", status READY, has 1 handler(s) for this service...
                                  Handler(s):
                                  "DEDICATED" established:798976 refused:0 state:ready
                                  LOCAL SERVER
                                  The command completed successfully


                                  From listener.log (but no record containing 12535 status code )
                                  -----------------------
                                  07-FEB-2013 15:48:26 * service_update * webfocus * 0
                                  07-FEB-2013 15:49:14 * (CONNECT_DATA=(SID=WEBFOCUS)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.169.1.17)(PORT=2808)) * establish * WEBFOCUS * 0
                                  07-FEB-2013 15:49:14 * (CONNECT_DATA=(SID=webfocus)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.169.1.17)(PORT=2810)) * establish * webfocus * 0
                                  07-FEB-2013 15:49:15 * (CONNECT_DATA=(SID=WEBFOCUS)(GLOBAL_NAME=WEBFOCUS.NECSS.NEC.COM.SG)(CID=(PROGRAM=C:\WFProd\ibi\srv71\home\bin\tscom3.exe)(HOST=ISD15)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.169.1.16)(PORT=3172)) * establish * WEBFOCUS * 0
                                  07-FEB-2013 15:50:03 * (CONNECT_DATA=(SID=Webfocus)(CID=(PROGRAM=D:\oracle\product\10.1.0\Db_1\perl\5.6.1\bin\MSWin32-x86\perl.exe)(HOST=ISD15)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.169.1.16)(PORT=3183)) * establish * Webfocus * 0
                                  07-FEB-2013 15:50:05 * service_update * webfocus * 0
                                  07-FEB-2013 15:50:14 * (CONNECT_DATA=(SID=WEBFOCUS)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.169.1.17)(PORT=2813)) * establish * WEBFOCUS * 0
                                  07-FEB-2013 15:50:14 * (CONNECT_DATA=(SID=webfocus)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.169.1.17)(PORT=2815)) * establish * webfocus * 0
                                  07-FEB-2013 15:51:13 * (CONNECT_DATA=(SID=webfocus)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.169.1.17)(PORT=2820)) * establish * webfocus * 0
                                  07-FEB-2013 15:51:14 * (CONNECT_DATA=(SID=WEBFOCUS)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.169.1.17)(PORT=2822)) * establish * WEBFOCUS * 0
                                  • 14. Re: TNS-12535: TNS:operation timed out
                                    JohnWatson
                                    moslee wrote:
                                    LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 07-FEB-2013 15:44
                                    :03

                                    Copyright (c) 1991, 2004, Oracle. All rights reserved.

                                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                                    STATUS of the LISTENER
                                    ------------------------
                                    Alias LISTENER
                                    Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
                                    ction
                                    Start Date 09-JUL-2012 12:43:05
                                    Uptime 213 days 3 hr. 0 min. 58 sec
                                    Trace Level off
                                    Security ON: Local OS Authentication
                                    SNMP OFF
                                    Listener Parameter File D:\oracle\product\10.1.0\Db_1\network\admin\listener.o
                                    ra
                                    Listener Log File D:\oracle\product\10.1.0\Db_1\network\log\listener.log

                                    Listening Endpoints Summary...
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isd15.ssg.necel.com)(PORT=1521)))
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isd15.ssg.necel.com)(PORT=8080))(Pre
                                    sentation=HTTP)(Session=RAW))
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isd15.ssg.necel.com)(PORT=2100))(Pre
                                    sentation=FTP)(Session=RAW))
                                    Services Summary...
                                    Service "WebfocusXDB" has 1 instance(s).
                                    Instance "webfocus", status READY, has 1 handler(s) for this service...
                                    Service "webfocus" has 1 instance(s).
                                    Instance "webfocus", status READY, has 1 handler(s) for this service...
                                    The command completed successfully
                                    This shows that your listener is listening on port 1521, but your tns entry at the top of the thread is going to port 1531. I did raise this possibility back on Tuesday :)
                                    1 2 3 Previous Next