1 2 3 Previous Next 34 Replies Latest reply: Mar 5, 2013 11:57 PM by sb92075 Go to original post RSS
      • 15. Re: TNS-12535: TNS:operation timed out
        EdStevens
        moslee wrote:
        Hi yoonus

        1. Firewall is not running...
        Just because the server itself isn't running a firewall doesn't mean there is no firewall issue. Unless the client and serve are the same machine and you are doing an IPC connection, then your connection is going over a network and one could assume that network is controlled with one or more firewalls at the routers.
        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>
        • 16. Re: TNS-12535: TNS:operation timed out
          moslee
          Hi sb92075

          My apologies... The followings are the CORRECT information for ATDMPQA (138.141.10.5, linux). And JohnWatson is still right, it is on Port 1521. But other DBs are still able to connect successfully to ATDMPQA via Port 1531. Any idea why? Thanks guys for your great investigation..


          [atdmp@ATDMP1 ~]$ lsnrctl stat
          LSNRCTL for Linux: Version 9.2.0.7.0 - Production on 08-FEB-2013 08:03:19
          Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
          Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
          STATUS of the LISTENER
          ------------------------
          Alias LISTENER
          Version TNSLSNR for Linux: Version 9.2.0.7.0 - Production
          Start Date 04-FEB-2013 15:22:32
          Uptime 3 days 16 hr. 40 min. 47 sec
          Trace Level off
          Security OFF
          SNMP OFF
          Listener Parameter File /etc/listener.ora
          Listener Log File /home/oracle/product/9.2.0/network/log/listener.log
          Listening Endpoints Summary...
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=atdmp1.ssg.renesas.com)(PORT=1521)))
          Services Summary...
          Service "ATDMP" has 1 instance(s).
          Instance "ATDMP", status READY, has 1 handler(s) for this service...
          The command completed successfully
          [atdmp@ATDMP1 ~]$


          [atdmp@ATDMP1 ~]$ lsnrctl services
          LSNRCTL for Linux: Version 9.2.0.7.0 - Production on 08-FEB-2013 08:03:46
          Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
          Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
          Services Summary...
          Service "ATDMP" has 1 instance(s).
          Instance "ATDMP", status READY, has 1 handler(s) for this service...
          Handler(s):
          "DEDICATED" established:1 refused:0 state:ready
          LOCAL SERVER
          The command completed successfully
          [atdmp@ATDMP1 ~]$



          [atdmp@ATDMP1 log]$ cat listener.log
          TNSLSNR for Linux: Version 9.2.0.7.0 - Production on 04-FEB-2013 15:22:32
          Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
          System parameter file is /etc/listener.ora
          Log messages written to /home/oracle/product/9.2.0/network/log/listener.log
          Trace information written to /home/oracle/product/9.2.0/network/trace/listener.trc
          Trace level is currently 0
          Started with pid=13954
          Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=atdmp1.ssg.renesas.com)(PORT=1521)))
          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
          04-FEB-2013 15:22:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          04-FEB-2013 15:22:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          04-FEB-2013 15:23:14 * service_register * ATDMP * 0
          04-FEB-2013 15:29:45 * service_update * ATDMP * 0
          04-FEB-2013 15:30:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          04-FEB-2013 15:34:42 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          04-FEB-2013 15:39:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          04-FEB-2013 15:39:46 * service_update * ATDMP * 0
          04-FEB-2013 15:46:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          04-FEB-2013 15:49:46 * service_update * ATDMP * 0
          .
          .
          05-FEB-2013 13:30:13 * service_update * ATDMP * 0
          05-FEB-2013 13:35:33 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          05-FEB-2013 13:40:13 * service_update * ATDMP * 0
          .
          .
          08-FEB-2013 07:50:55 * (CONNECT_DATA=(SID=ATDMP)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=LAN-1880)(USER=amosleeyp))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.168.5.61)(PORT=50578)) * establish * ATDMP * 0
          08-FEB-2013 07:56:31 * service_update * ATDMP * 0
          08-FEB-2013 07:58:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          08-FEB-2013 08:01:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          08-FEB-2013 08:02:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * services * 0
          08-FEB-2013 08:03:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
          08-FEB-2013 08:03:46 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * services * 0
          [atdmp@ATDMP1 log]$

          Edited by: moslee on Feb 7, 2013 5:15 PM
          • 17. Re: TNS-12535: TNS:operation timed out
            moslee
            Hi JohnWatson

            I am puzzled... On my current working desktop, the Port in tnsnames.ora is 1531 and I can connect to ATDMPQA. When I change to Port 1521, I can connect as well..

            ATDMPQA.SSG.RENESAS.COM =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(Host = 138.141.10.5)(Port = 1531))
            )
            (CONNECT_DATA =
            (SID = ATDMP)
            )
            )


            Query result:

            SQL> conn atdmp/<password>@atdmpqa
            Connected.
            SQL> select * from v$version;
            BANNER
            ----------------------------------------------------------------
            Oracle9i Release 9.2.0.7.0 - Production
            PL/SQL Release 9.2.0.7.0 - Production
            CORE 9.2.0.7.0 Production
            TNS for Linux: Version 9.2.0.7.0 - Production
            NLSRTL Version 9.2.0.7.0 - Production

            SQL> select count(*) from ATDMP.ALLOWEDDIE_TESTSTREAMS;
            COUNT(*)
            ----------
            7595
            • 18. Re: TNS-12535: TNS:operation timed out
              sb92075
              moslee wrote:
              Hi sb92075

              My apologies... The followings are the CORRECT information for ATDMPQA (138.141.10.5, linux). And JohnWatson is still right, it is on Port 1521. But other DBs are still able to connect successfully to ATDMPQA via Port 1531.
              I don't believe you
              Any idea why? Thanks guys for your great investigation..
              post COPY & PASTE proof above is correct

              >
              [atdmp@ATDMP1 ~]$ lsnrctl stat
              LSNRCTL for Linux: Version 9.2.0.7.0 - Production on 08-FEB-2013 08:03:19
              Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
              Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
              STATUS of the LISTENER
              ------------------------
              Alias LISTENER
              Version TNSLSNR for Linux: Version 9.2.0.7.0 - Production
              Start Date 04-FEB-2013 15:22:32
              Uptime 3 days 16 hr. 40 min. 47 sec
              Trace Level off
              Security OFF
              SNMP OFF
              Listener Parameter File /etc/listener.ora
              Listener Log File /home/oracle/product/9.2.0/network/log/listener.log
              Listening Endpoints Summary...
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=atdmp1.ssg.renesas.com)(PORT=1521)))
              Services Summary...
              Service "ATDMP" has 1 instance(s).
              Instance "ATDMP", status READY, has 1 handler(s) for this service...
              The command completed successfully
              [atdmp@ATDMP1 ~]$


              [atdmp@ATDMP1 ~]$ lsnrctl services
              LSNRCTL for Linux: Version 9.2.0.7.0 - Production on 08-FEB-2013 08:03:46
              Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
              Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
              Services Summary...
              Service "ATDMP" has 1 instance(s).
              Instance "ATDMP", status READY, has 1 handler(s) for this service...
              Handler(s):
              "DEDICATED" established:1 refused:0 state:ready
              LOCAL SERVER
              The command completed successfully
              [atdmp@ATDMP1 ~]$



              [atdmp@ATDMP1 log]$ cat listener.log
              TNSLSNR for Linux: Version 9.2.0.7.0 - Production on 04-FEB-2013 15:22:32
              Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
              System parameter file is /etc/listener.ora
              Log messages written to /home/oracle/product/9.2.0/network/log/listener.log
              Trace information written to /home/oracle/product/9.2.0/network/trace/listener.trc
              Trace level is currently 0
              Started with pid=13954
              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=atdmp1.ssg.renesas.com)(PORT=1521)))
              TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
              04-FEB-2013 15:22:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              04-FEB-2013 15:22:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              04-FEB-2013 15:23:14 * service_register * ATDMP * 0
              04-FEB-2013 15:29:45 * service_update * ATDMP * 0
              04-FEB-2013 15:30:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              04-FEB-2013 15:34:42 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              04-FEB-2013 15:39:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              04-FEB-2013 15:39:46 * service_update * ATDMP * 0
              04-FEB-2013 15:46:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              04-FEB-2013 15:49:46 * service_update * ATDMP * 0
              .
              .
              05-FEB-2013 13:30:13 * service_update * ATDMP * 0
              05-FEB-2013 13:35:33 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              05-FEB-2013 13:40:13 * service_update * ATDMP * 0
              .
              .
              08-FEB-2013 07:50:55 * (CONNECT_DATA=(SID=ATDMP)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=LAN-1880)(USER=amosleeyp))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.168.5.61)(PORT=50578)) * establish * ATDMP * 0
              08-FEB-2013 07:56:31 * service_update * ATDMP * 0
              08-FEB-2013 07:58:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              08-FEB-2013 08:01:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              08-FEB-2013 08:02:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * services * 0
              08-FEB-2013 08:03:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * status * 0
              08-FEB-2013 08:03:46 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ATDMP1)(USER=atdmp))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093888)) * services * 0
              [atdmp@ATDMP1 log]$

              Edited by: moslee on Feb 7, 2013 5:15 PM
              EVERY connection request that gets to the listener is logged into listener.log file;
              which will contain status code 12535 for the timed out request.

              posted excerpt doe NOT contain 12535 value!
              why not?
              • 19. Re: TNS-12535: TNS:operation timed out
                moslee
                Hi sb92075

                I cannot explain why excerpt does not contain 12535 as well. Here's the proof:

                (Tnsnames.ora)
                ATDMPQA.SSG.RENESAS.COM =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(Host = 138.141.10.5)(Port = 1531))
                )
                (CONNECT_DATA =
                (SID = ATDMP)
                )
                )



                On My Desktop PC - [Port 1531]
                C:\Windows\System32>tnsping atdmpqa
                TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 08-FEB-2013 09:46:18

                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>sqlplus /nolog

                SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 8 09:46:22 2013

                Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

                SQL> set time on
                09:46:24 SQL> set timing on
                09:46:28 SQL> conn atdmp/<password>@atdmpqa
                Connected.
                09:46:34 SQL> select * from global_name;

                GLOBAL_NAME
                --------------------------------------------------------------------------------

                ATDMP

                Elapsed: 00:00:00.00
                09:46:41 SQL> select * from v$version;

                BANNER
                ----------------------------------------------------------------
                Oracle9i Release 9.2.0.7.0 - Production
                PL/SQL Release 9.2.0.7.0 - Production
                CORE 9.2.0.7.0 Production
                TNS for Linux: Version 9.2.0.7.0 - Production
                NLSRTL Version 9.2.0.7.0 - Production

                Elapsed: 00:00:00.00
                09:46:48 SQL> select count(*) from atdmp.alloweddie_teststreams;

                COUNT(*)
                ----------
                7595

                Elapsed: 00:00:00.00
                09:46:56 SQL>




                On My Desktop PC - [Change to Port 1521]
                Microsoft Windows [Version 6.1.7601]
                Copyright (c) 2009 Microsoft Corporation. All rights reserved.

                C:\Windows\System32>tnsping atdmpqa

                TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 08-FEB-2013 09:48:50

                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 = 1521))) (CONNECT_DATA = (SID = ATDMP)))
                OK (10 msec)

                C:\Windows\System32>sqlplus /nolog

                SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 8 09:48:59 2013

                Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

                SQL> set time on
                09:49:02 SQL> set timing on
                09:49:04 SQL> conn atdmp/<password>@atdmpqa
                Connected.
                09:49:10 SQL> select * from global_name;

                GLOBAL_NAME
                --------------------------------------------------------------------------------

                ATDMP

                Elapsed: 00:00:00.00
                09:49:15 SQL> select * from v$version;

                BANNER
                ----------------------------------------------------------------
                Oracle9i Release 9.2.0.7.0 - Production
                PL/SQL Release 9.2.0.7.0 - Production
                CORE 9.2.0.7.0 Production
                TNS for Linux: Version 9.2.0.7.0 - Production
                NLSRTL Version 9.2.0.7.0 - Production

                Elapsed: 00:00:00.00
                09:49:21 SQL> select count(*) from atdmp.alloweddie_teststreams;

                COUNT(*)
                ----------
                7595

                Elapsed: 00:00:00.00
                09:49:27 SQL>

                Edited by: moslee on Feb 7, 2013 5:53 PM

                Edited by: moslee on Feb 7, 2013 5:54 PM
                • 20. Re: TNS-12535: TNS:operation timed out
                  moslee
                  Hi to all

                  Erm... any idea why this is so? Thanks for your sharing..
                  • 21. Re: TNS-12535: TNS:operation timed out
                    yoonas
                    >
                    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 ~]$
                    >

                    This is the result from your linux server, so there is a listener running listening on 1531. You may be having two listeners running listening on 1521 and 1531

                    Post the output of below command and listener.ora from your database server host(linux).
                    ps -ef | grep tns
                    • 22. Re: TNS-12535: TNS:operation timed out
                      moslee
                      Hi yoonus

                      Yes, you're right...

                      Last login: Fri Feb 8 08:37:09 2013 from 168.168.5.61
                      [atdmp@ATDMP1 ~]$ ps -ef|grep tns
                      oracle 13954 1 0 Feb04 ? 00:00:00 /home/oracle/product/9.2.0/bin/tnslsnr LISTENER -inherit
                      atdmp 16755 1 0 2012 ? 00:00:02 /home/oracle/product/9.2.0/bin/tnslsnr lsn_ATDMP -inherit
                      atdmp 21417 21402 0 14:18 pts/3 00:00:00 grep tns
                      [atdmp@ATDMP1 ~]$




                      #
                      # Filename: Listener.ora
                      #

                      #
                      # ATDMP(SS)
                      #
                      lsn_ATDMP = (ADDRESS_LIST=
                      (ADDRESS=
                      (PROTOCOL=tcp)
                      (HOST=138.141.10.5) # Package IP address
                      (PORT=1531) # listening port
                      )
                      # (ADDRESS=
                      # (PROTOCOL=ipc)
                      # (KEY=ATDMP) # used for local connections
                      # )
                      )

                      # This tells the listener the services to which it can connect incoming
                      # requests

                      SID_LIST_lsn_ATDMP= # for connect requests
                      (SID_LIST= # list all databases
                      (SID_DESC=
                      (SID_NAME=ATDMP) # ORACLE_SID
                      (ORACLE_HOME=/home/oracle/product/9.2.0) # ORACLE_HOME
                      )
                      )

                      # Parameters to control TRACE and LOG output

                      TRACE_LEVEL_lsn_ATDMP = OFF # OFF/ADMIN
                      TRACE_DIRECTORY_lsn_ATDMP = /calc/atdmp/atdmp/network/trace # trace output
                      TRACE_FILE_lsn_ATDMP = "lsn_atdmp"
                      LOG_DIRECTORY_lsn_ATDMP = /calc/atdmp/atdmp/network/log

                      # Miscellaneous parameters

                      CONNECT_TIMEOUT_lsn_ATDMP = 10 # allow 10 secs for connects
                      STOP_lsn_ATDMP = YES
                      DBA_GROUP = dba
                      #PASSWORDS_LISTENER = manager # uncomment for a password

                      ##
                      ## ATDMP(SS) for OA segment
                      ##
                      #lsn_ATDMPOA = (ADDRESS_LIST=
                      # (ADDRESS=
                      # (PROTOCOL=tcp)
                      # (HOST=138.140.0.11) # Package IP address
                      # (PORT=1532) # listening port
                      # )
                      # )
                      #
                      ## This tells the listener the services to which it can connect incoming
                      ## requests
                      #
                      #SID_LIST_lsn_ATDMPOA= # for connect requests
                      # (SID_LIST= # list all databases
                      # (SID_DESC=
                      # (SID_NAME=ATDMP) # ORACLE_SID
                      # (ORACLE_HOME=/home/oracle/product/9.2.0) # ORACLE_HOME
                      # )
                      # )
                      #
                      ## Parameters to control TRACE and LOG output
                      #
                      #TRACE_LEVEL_lsn_ATDMPOA = OFF # OFF/ADMIN
                      #TRACE_DIRECTORY_lsn_ATDMPOA = /calc/atdmp/atdmp/network/trace # trace output
                      #TRACE_FILE_lsn_ATDMPOA = "listener"
                      #LOG_DIRECTORY_lsn_ATDMPOA = /calc/atdmp/atdmp/network/log
                      #
                      ## Miscellaneous parameters
                      #
                      #CONNECT_TIMEOUT_lsn_ATDMPOA = 10 # allow 10 secs for connects
                      #STOP_lsn_ATDMPOA = YES
                      #DBA_GROUP = dba
                      ##PASSWORDS_LISTENER = manager # uncomment for a password
                      #

                      Edited by: moslee on Feb 12, 2013 11:31 PM
                      • 23. Re: TNS-12535: TNS:operation timed out
                        EdStevens
                        moslee wrote:
                        Hi yoonus

                        Yes, you're right...

                        Last login: Fri Feb 8 08:37:09 2013 from 168.168.5.61
                        [atdmp@ATDMP1 ~]$ ps -ef|grep tns
                        oracle 13954 1 0 Feb04 ? 00:00:00 /home/oracle/product/9.2.0/bin/tnslsnr LISTENER -inherit
                        atdmp 16755 1 0 2012 ? 00:00:02 /home/oracle/product/9.2.0/bin/tnslsnr lsn_ATDMP -inherit
                        atdmp 21417 21402 0 14:18 pts/3 00:00:00 grep tns
                        [atdmp@ATDMP1 ~]$

                        <snip>

                        And once again we see some of the unnecessary complexity that results from unnecessarily running multiple listeners. You need to loose the listener named 'lsn_ATDMP'.
                        • 24. Re: TNS-12535: TNS:operation timed out
                          moslee
                          Hi, lsn_ATDMP is the correct listener that I need to use. This DB is a development set. Both productions DB are having lsn_ATDMP. I have stop the listener LISTENER.


                          [atdmp@ATDMP1 ~]$ lsnrctl status lsn_ATDMP
                          LSNRCTL for Linux: Version 9.2.0.7.0 - Production on 14-FEB-2013 08:35:37
                          Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
                          Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=138.141.10.5)(PORT=1531))
                          STATUS of the LISTENER
                          ------------------------
                          Alias lsn_ATDMP
                          Version TNSLSNR for Linux: Version 9.2.0.7.0 - Production
                          Start Date 12-NOV-2012 16:20:17
                          Uptime 93 days 16 hr. 15 min. 20 sec
                          Trace Level off
                          Security OFF
                          SNMP OFF
                          Listener Parameter File /etc/listener.ora
                          Listener Log File /calc/atdmp/atdmp/network/log/lsn_atdmp.log
                          Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=138.141.10.5)(PORT=1531)))
                          Services Summary...
                          Service "ATDMP" has 1 instance(s).
                          Instance "ATDMP", status UNKNOWN, has 1 handler(s) for this service...
                          The command completed successfully



                          [atdmp@ATDMP1 ~]$ ps -ef | grep tns
                          atdmp 16755 1 0 2012 ? 00:00:02 /home/oracle/product/9.2.0/bin/tnslsnr lsn_ATDMP -inherit
                          atdmp 22342 22297 0 08:38 pts/3 00:00:00 grep tns

                          Edited by: moslee on Feb 13, 2013 5:48 PM
                          • 25. Re: TNS-12535: TNS:operation timed out
                            moslee
                            Still getting error...

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



                            C:\>tnsping atdmpqa
                            TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 14-FEB-2
                            013 12:37:59
                            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
                            • 26. Re: TNS-12535: TNS:operation timed out
                              asahide
                              Hi,

                              Put output from follow command on server.
                              $ netstat -na | grep ":1531 "
                              And on client.
                              $ telnet 138.141.10.5 1531
                              Regards,
                              • 27. Re: TNS-12535: TNS:operation timed out
                                sb92075
                                moslee wrote:
                                Still getting error...

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



                                C:\>tnsping atdmpqa
                                TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 14-FEB-2
                                013 12:37:59
                                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
                                post excerpt from listener.log that contains status=12535 & surrounding lines.
                                • 28. Re: TNS-12535: TNS:operation timed out
                                  EdStevens
                                  moslee wrote:
                                  Hi, lsn_ATDMP is the correct listener that I need to use. This DB is a development set. Both productions DB are having lsn_ATDMP. I have stop the listener LISTENER.
                                  Except for the lsnrctl command, I can think of absolutely NOTHING that cares about the name of the listener. Everything thing else that needs to contact the listener (client requesting a connection and database doing self-registration) does it via server/ip and port. So even with only one listener (which is all you need), it is an unnecessary complexity to name that listener anything other than the default of LISTENER.


                                  >
                                  [atdmp@ATDMP1 ~]$ lsnrctl status lsn_ATDMP
                                  LSNRCTL for Linux: Version 9.2.0.7.0 - Production on 14-FEB-2013 08:35:37
                                  Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
                                  Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=138.141.10.5)(PORT=1531))
                                  STATUS of the LISTENER
                                  ------------------------
                                  Alias lsn_ATDMP
                                  Version TNSLSNR for Linux: Version 9.2.0.7.0 - Production
                                  Start Date 12-NOV-2012 16:20:17
                                  Uptime 93 days 16 hr. 15 min. 20 sec
                                  Trace Level off
                                  Security OFF
                                  SNMP OFF
                                  Listener Parameter File /etc/listener.ora
                                  Listener Log File /calc/atdmp/atdmp/network/log/lsn_atdmp.log
                                  Listening Endpoints Summary...
                                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=138.141.10.5)(PORT=1531)))
                                  Services Summary...
                                  Service "ATDMP" has 1 instance(s).
                                  Instance "ATDMP", status UNKNOWN, has 1 handler(s) for this service...
                                  The command completed successfully



                                  [atdmp@ATDMP1 ~]$ ps -ef | grep tns
                                  atdmp 16755 1 0 2012 ? 00:00:02 /home/oracle/product/9.2.0/bin/tnslsnr lsn_ATDMP -inherit
                                  atdmp 22342 22297 0 08:38 pts/3 00:00:00 grep tns

                                  Edited by: moslee on Feb 13, 2013 5:48 PM
                                  • 29. Re: TNS-12535: TNS:operation timed out
                                    moslee
                                    Hi

                                    [On server]

                                    [atdmp@ATDMP1 ~]$ netstat -na | grep ":1531 "
                                    tcp 0 0 138.141.10.5:1531 0.0.0.0:* LISTEN
                                    tcp 0 0 138.141.10.5:1531 138.141.10.4:2536 ESTABLISHED
                                    [atdmp@ATDMP1 ~]$



                                    [On another client]

                                    [scmdm@ISD37 scmdm]$ telnet 138.141.10.5 1531
                                    Trying 138.141.10.5...
                                    Connected to 138.141.10.5.
                                    Escape character is '^]'.



                                    [On server again]

                                    [atdmp@ATDMP1 ~]$ netstat -na | grep ":1531 "
                                    tcp 0 0 138.141.10.5:1531 0.0.0.0:* LISTEN
                                    tcp 0 0 138.141.10.5:1531 168.169.1.37:34164 ESTABLISHED
                                    tcp 0 0 138.141.10.5:1531 138.141.10.4:2536 ESTABLISHED
                                    [atdmp@ATDMP1 ~]$

                                    Edited by: moslee on Feb 14, 2013 6:42 PM

                                    Edited by: moslee on Feb 14, 2013 6:43 PM