1 2 Previous Next 15 Replies Latest reply: Feb 5, 2012 9:44 AM by sb92075 RSS

    ora-12170 TNS:connect time out occured

    914219
      Hello everyone;

      Environment: windows 2003 server

      I have installed Toad 9.5 for login to oracle ..I have given user name :scott & password :tiger

      tns:oracle (that I have defined)

      "ora-12170 TNS:connect time out occured "

      Please let me know steps to trouble shoot this issue

      thank you
        • 1. Re: ora-12170 TNS:connect time out occured
          908002
          Your connection is timing out. Check if your destination host is reachable. It has happened to me sometimes that if the ping to the server times out, then this error is shown as a time out in tns connections. Please verify your network configuration.
          • 2. Re: ora-12170 TNS:connect time out occured
            Ramio
            See

            ERROR ORA-12170: TNS:Connect timeout occurred

            Edited by: Ramio on Jan 30, 2012 11:22 PM
            • 3. Re: ora-12170 TNS:connect time out occured
              914219
              Hi,

              I have installed oracle 10g ..It worked pretty well before

              Now also I am able to login using" sql plus "..(.Working fine)

              The problem with login using TOAD
              • 4. Re: ora-12170 TNS:connect time out occured
                914219
                Hi ,

                Thanks ..

                Here is the error message :sqlnet.log


                Fatal NI connect error 12541, connecting to:

                VERSION INFORMATION:
                     TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.3.0 - Production
                Time:
                Tracing not turned on.
                Tns error struct:
                ns main err code: 12541
                TNS-12541: TNS:no listener
                ns secondary err code: 12560
                nt main err code: 511
                TNS-00511: No listener
                nt secondary err code: 61
                nt OS err code: 0



                I will try to fix this issue "TNS-12541: TNS:no listener"

                Edited by: 911216 on Jan 31, 2012 12:05 AM
                • 5. Re: ora-12170 TNS:connect time out occured
                  914219
                  Hi,

                  I tried this forum..it didn't give solution to issue..

                  I am not connecting through any network...I have installed oracle 10g on my Virtual machine workstation (windows server 2003)

                  please let me any input to resolve this issue

                  Thank you !!
                  • 6. Re: ora-12170 TNS:connect time out occured
                    sb92075
                    911216 wrote:
                    Hi,

                    I tried this forum..it didn't give solution to issue..

                    I am not connecting through any network...I have installed oracle 10g on my Virtual machine workstation (windows server 2003)

                    please let me any input to resolve this issue

                    Thank you !!
                    from DB Server issue following OS commands

                    lsnrctl status
                    lsnrctl service

                    COPY commands & results then PASTE all back here
                    • 7. Re: ora-12170 TNS:connect time out occured
                      914219
                      Hi,

                      This is the message :


                      C:\Documents and Settings\Administrator>lsnrctl status

                      LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 -
                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                      TNS-12541: TNS:no listener
                      TNS-12560: TNS:protocol adapter error
                      TNS-00511: No listener
                      32-bit Windows Error: 2: No such file or directory
                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.186.128)(PORT=15
                      21)))
                      TNS-12535: TNS:operation timed out
                      TNS-12560: TNS:protocol adapter error
                      TNS-00505: Operation timed out
                      32-bit Windows Error: 60: Unknown error


                      2)C:\Documents and Settings\Administrator>lsnrctl service

                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                      TNS-12541: TNS:no listener
                      TNS-12560: TNS:protocol adapter error
                      TNS-00511: No listener
                      32-bit Windows Error: 2: No such file or directory
                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.186.128)(PORT=15
                      21)))
                      TNS-12535: TNS:operation timed out
                      TNS-12560: TNS:protocol adapter error
                      TNS-00505: Operation timed out
                      32-bit Windows Error: 60: Unknown error

                      3)message in the log :listner.log

                      System parameter file is C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
                      Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listener.log
                      Trace information written to C:\oracle\product\10.2.0\db_1\network\trace\listener.trc
                      Trace level is currently 0

                      Started with pid=1480
                      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                      Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.186.128)(PORT=1521)))
                      TNS-12545: Connect failed because target host or object does not exist
                      TNS-12560: TNS:protocol adapter error
                      TNS-00515: Connect failed because target host or object does not exist
                      32-bit Windows Error: 49: Unknown error
                      No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))


                      Here the thing is recently last month ..I had formatted my windows operating system (windows7)and restore the virtual machine(windows server 2003...oracle installed here ) ..This
                      issue occuring from then..earlier it worked pretty well..


                      Unfortunately I am not an admin (I am an application developer) it seems entries are missing in listener file ..please guide me accordingly

                      Thanks for the time..really appreciate it !!!
                      • 8. Re: ora-12170 TNS:connect time out occured
                        sb92075
                        rename, remove or delete listener.ora file
                        NO listener.ora file is required to start listener.

                        then issue following OS command

                        lsnrctl start

                        COPY command & results then PASTE all back here
                        • 9. Re: ora-12170 TNS:connect time out occured
                          914219
                          Hi,


                          C:\Documents and Settings\Administrator>lsnrctl start

                          LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on
                          Starting tnslsnr: please wait...

                          TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production
                          Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listener.log
                          Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxx-93fa1abb)(PORT=15
                          21)))

                          Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                          STATUS of the LISTENER
                          ------------------------
                          Alias LISTENER
                          Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
                          ction
                          Start Date 04-FEB-2012 23:00:42
                          Uptime 0 days 0 hr. 0 min. 4 sec
                          Trace Level off
                          Security ON: Local OS Authentication
                          SNMP OFF
                          Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

                          Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXX-93fa1abb)(PORT=1521)))
                          The listener supports no services
                          The command completed successfully


                          thank you !!!
                          • 10. Re: ora-12170 TNS:connect time out occured
                            sb92075
                            911216 wrote:

                            thank you !!!
                            if problem has been solved, then mark thread as answered.
                            • 11. Re: ora-12170 TNS:connect time out occured
                              914219
                              Hi,

                              I couldn't figure out ..its the same error message "ora-12170 TNS:connect time out occured"

                              C:\Documents and Settings\Administrator>lsnrctl start ORCL

                              LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 04-FEB-2012 23:16
                              :49

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

                              Starting tnslsnr: please wait...

                              TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production
                              Log messages written to C:\oracle\product\10.2.0\db_1\network\log\orcl.log


                              TNS-01151: Missing listener name, ORCL, in LISTENER.ORA

                              Listener failed to start. See the error message(s) above...

                              how to add listener name, ORCL in LISTENER.ORA

                              thank you
                              • 12. Re: ora-12170 TNS:connect time out occured
                                914219
                                Hi,

                                Listener log message:


                                TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production on 04-FEB-2012 23:00:40

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

                                Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listener.log
                                Trace information written to C:\oracle\product\10.2.0\db_1\network\trace\listener.trc
                                Trace level is currently 0

                                Started with pid=876
                                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXXX-93fa1abb)(PORT=1521)))
                                Listener completed notification to CRS on start

                                TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                                04-FEB-2012 23:00:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870080)) * status * 0
                                04-FEB-2012 23:00:46 * service_register * orcl * 0
                                04-FEB-2012 23:01:37 * service_update * orcl * 0
                                04-FEB-2012 23:02:10 * service_update * orcl * 0
                                04-FEB-2012 23:03:49 * service_update * orcl * 0
                                04-FEB-2012 23:04:22 * service_update * orcl * 0
                                04-FEB-2012 23:04:55 * service_update * orcl * 0
                                04-FEB-2012 23:09:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870080)) * status * 0
                                *04-FEB-2012 23:10:20 * service_died * orcl * 12547*
                                TNS-12547: TNS:lost contact


                                Thank you
                                • 13. Re: ora-12170 TNS:connect time out occured
                                  sb92075
                                  911216 wrote:
                                  Hi,

                                  I couldn't figure out ..its the same error message "ora-12170 TNS:connect time out occured"
                                  what command do you issue that throws error above?


                                  How many different system are involved?


                                  from DB Server issue following OS commands

                                  lsnrctl status
                                  lsnrctl service

                                  COPY commands & results then PASTE all back here
                                  • 14. Re: ora-12170 TNS:connect time out occured
                                    914219
                                    Hi,


                                    what command do you issue that throws error above?

                                    re:I am getting this error when connecting using "TOAD"options :

                                    user :scott
                                    password:tiger
                                    tns:orcl


                                    How many different system are involved?

                                    re:I am not sure I Understood correctly..my environment is as below:

                                    Virtual Machine O/S:Windows 2003 server

                                    Oracle 10g

                                    tool:TOAD (Connection)

                                    sql plus:able to connect to orcl ..because its is connecting as local

                                    4)
                                    from DB Server issue following OS commands

                                    lsnrctl status
                                    lsnrctl service



                                    C:\Documents and Settings\Administrator>lsnrctl status

                                    LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 04-FEB-2012 23:47
                                    :41

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

                                    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                                    STATUS of the LISTENER
                                    ------------------------
                                    Alias LISTENER
                                    Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
                                    ction
                                    Start Date 04-FEB-2012 23:11:58
                                    Uptime 0 days 0 hr. 35 min. 43 sec
                                    Trace Level off
                                    Security ON: Local OS Authentication
                                    SNMP OFF
                                    Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

                                    Listening Endpoints Summary...
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXXX-93fa1abb)(PORT=1521)))
                                    Services Summary...
                                    Service "orcl" has 1 instance(s).
                                    Instance "orcl", status READY, has 1 handler(s) for this service...
                                    Service "orclXDB" has 1 instance(s).
                                    Instance "orcl", status READY, has 1 handler(s) for this service...
                                    Service "orcl_XPT" has 1 instance(s).
                                    Instance "orcl", 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.2.0.3.0 - Production on 04-FEB-2012 23:47
                                    :27

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

                                    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                                    Services Summary...
                                    Service "orcl" has 1 instance(s).
                                    Instance "orcl", status READY, has 1 handler(s) for this service...
                                    Handler(s):
                                    "DEDICATED" established:0 refused:0 state:ready
                                    LOCAL SERVER
                                    Service "orclXDB" has 1 instance(s).
                                    Instance "orcl", status READY, has 1 handler(s) for this service...
                                    Handler(s):
                                    "D000" established:0 refused:0 current:0 max:1002 state:ready
                                    DISPATCHER <machine: XXXXXX-93FA1ABB, pid: 2324>
                                    (ADDRESS=(PROTOCOL=tcp)(HOST=XXXXXX-93fa1abb)(PORT=1029))
                                    Service "orcl_XPT" has 1 instance(s).
                                    Instance "orcl", status READY, has 1 handler(s) for this service...
                                    Handler(s):
                                    "DEDICATED" established:0 refused:0 state:ready
                                    LOCAL SERVER
                                    The command completed successfully

                                    I guess from above messages ..it seems the problem is with the entries in the

                                    listener.ora


                                    # listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
                                    # Generated by Oracle configuration tools.

                                    SID_LIST_LISTENER =
                                    (SID_LIST =
                                    (SID_DESC =
                                    (SID_NAME = PLSExtProc)
                                    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.186.128)(PORT = 1522))
                                    (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
                                    (PROGRAM = extproc)
                                    )
                                    )

                                    LISTENER =
                                    (DESCRIPTION_LIST =
                                    (DESCRIPTION =
                                    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.186.128)(PORT = 1521))
                                    )
                                    )

                                    No entry for ORCL here ..this is could be the possible error ???


                                    Thank you
                                    1 2 Previous Next