This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Aug 14, 2013 9:39 PM by sb92075 RSS

Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.

user8860348 Explorer
Currently Being Moderated

Folks,

 

Hello. Initially, my Windows XP host name is "localhost" and IP address 127.0.0.1.

I installed Oracle Database 11g with Windows XP successfully and all Database clients work with Database instance correctly.

 

For some reasons, I uninstalled the entire Database Server and delete the entire installation directory /oracle.

 

I configured Windows XP IP address into 192.168.196.101 in order to ping other machines.

 

For my need, I installed Oracle Database 11g with Windows XP again. On step 7 of 8: Oracle Database Configuration Assistant, I got this error:

ORA-12560:TNS: protocol adapter error.

I click "Password Management" button, there are no rows in this Windows (no username, no lock accounts).

 

I check listener as below:

C:\>lsnrctl
LSNRCTL>start
Its output: listener name LISTENER has already been started.
LSNRCTL>status
Its output: ......Service DB1 has 1 instance. Instance DB1 status ready. The command completed successfully.

 

I check \Oracle\cfgtoollogs\dbca\DB1\trace file, the entry is :

listen[0]=LISTENER address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(port=1522))

 

I also check \oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\SAMPLE\tnsnames.ora file and listener.ora file, the entries are the same as below

HOST=localhost  port=1522

 

I think HOST=localhost and port=1522 is the cause of the error ORA-12560 because Windows XP has been configured into HOST=192.168.196.101.

 

But I don't understand how to solve this issue.

Can any folk tell me how to solve this issue ? need to cancel the installation on step 7 of 8 and install it again ?


Thanks.

  • 1. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    sb92075 Guru
    Currently Being Moderated

    ORA-12560 occurs for a myriad of different reasons; one of which is when IP# does not match hostname.

     

    any system which identifies itself as "localhost" can never be contacted by any remote system.

    It would help debugging efforts if you completely show the whole results from

     

    lsnrctl status

     

    no listener.ora is not required to start or use the Oracle listener.

     

    do as below

     

    lsnrctl stop

    rename, remove or otherwise make the listener.ora file unavailable

    lsnrctl start

    # wait 60+ seconds before proceeding

    lsnrctl service

     

     

    COPY the results from above then  PASTE  all back here

  • 2. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    user8860348 Explorer
    Currently Being Moderated

    Folks,

    Hello. The result is below:

    LSNRCTL>
    LSNRCTL>
    LSNRCTL> stop
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    The command completed successfully

    LSNRCTL> start
    Starting tnslsnr: please wait...

    TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    System parameter file is C:\SecondTime_OracleDatabase_Install_Directory\product\
    11.2.0\dbhome_1\network\admin\listener.ora

    Log messages written to c:\secondtime_oracledatabase_install_directory\diag\tnsl
    snr\user-19yyar8x0d\listener\alert\log.xml

    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522
    ipc)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))

    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
    ction
    Start Date                14-AUG-2013 18:53:32
    Uptime                    0 days 0 hr. 0 min. 2 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   C:\SecondTime_OracleDatabase_Install_Directory\product
    \11.2.0\dbhome_1\network\admin\listener.ora

    Listener Log File         c:\secondtime_oracledatabase_install_directory\diag\tn
    slsnr\user-19yyar8x0d\listener\alert\log.xml

    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully


    LSNRCTL>

    LSNRCTL> service
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:0 refused:0
             LOCAL SERVER
    Service "DB1XDB" has 1 instance(s).
      Instance "DB1", status READY, has 1 handler(s) for this service...
        Handler(s):
          "D000" established:0 refused:0 current:0 max:1022 state:ready
             DISPATCHER <machine: user-19YYAR8X0D, pid: 120>
             (ADDRESS=(PROTOCOL=tcp)(HOST=user-19yyar8x0d)(PORT=1051))
    Service "DB1" has 1 instance(s).
      Instance "DB1", status READY, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:6 refused:0 state:ready
             LOCAL SERVER
    The command completed successfully
    LSNRCTL>

     

     

     

     

    Very grateful in advance.

  • 3. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    sb92075 Guru
    Currently Being Moderated

    Please try again, again

    But this time between the lsnrctl stop & lsnrctl start actually RENAME or DELETE the listener.ora file which still exists as shown above & below!

     

    >System parameter file is C:\SecondTime_OracleDatabase_Install_Directory\product\11.2.0\dbhome_1\network\admin\listener.ora

  • 4. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    user8860348 Explorer
    Currently Being Moderated

    Folks,

    Hello. Oracle Database 11g Installation Wizard is on step 7 of 8. I don't cancel the Wizard. I am not sure whether there is effect or not. listener.ora is not removed. I have been waiting for a while after stop listener.  I run the 3 commands again and copy the result as below:

     

    C:\>lsnrctl stop

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-AUG-2013 19:32
    :14

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       64-bit Windows Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       64-bit Windows Error: 61: Unknown error

    C:\>
    C:\>
    C:\>
    C:\>
    C:\>
    C:\>lsnrctl start

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-AUG-2013 19:33
    :04

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

    Starting tnslsnr: please wait...

    TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

    System parameter file is C:\SecondTime_OracleDatabase_Install_Directory\product\
    11.2.0\dbhome_1\network\admin\listener.ora

    Log messages written to c:\secondtime_oracledatabase_install_directory\diag\tnsl
    snr\user-19yyar8x0d\listener\alert\log.xml

    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522
    ipc)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
    ction
    Start Date                14-AUG-2013 19:33:07
    Uptime                    0 days 0 hr. 0 min. 3 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF

    Listener Parameter File   C:\SecondTime_OracleDatabase_Install_Directory\product
    \11.2.0\dbhome_1\network\admin\listener.ora

    Listener Log File         c:\secondtime_oracledatabase_install_directory\diag\tn
    slsnr\user-19yyar8x0d\listener\alert\log.xml

    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    C:\>
    C:\>
    C:\>
    C:\>
    C:\>lsnrctl service

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-AUG-2013 19:36
    :37

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:0 refused:0
             LOCAL SERVER
    Service "DB1XDB" has 1 instance(s).
      Instance "DB1", status READY, has 1 handler(s) for this service...
        Handler(s):
          "D000" established:0 refused:0 current:0 max:1022 state:ready
             DISPATCHER <machine: user-19YYAR8X0D, pid: 120>
             (ADDRESS=(PROTOCOL=tcp)(HOST=user-19yyar8x0d)(PORT=1051))
    Service "DB1" has 1 instance(s).
      Instance "DB1", status READY, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:19 refused:0 state:ready
             LOCAL SERVER
    The command completed successfully

    C:\>

     

     

    As we see, listener.ora file is not removed by Stop command. I am on the installation Wizard. How to solve this issue ?

     

     

    Thanks.

  • 5. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    sb92075 Guru
    Currently Being Moderated

    You choose to not do what I say needs to be done.

    I choose to nor waste any more time on this thread.


    You're On Your Own (YOYO)!

  • 6. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    user8860348 Explorer
    Currently Being Moderated

    Folks,

     

    Hello. I absolutely listen to you and do what you tell me to do. I might not understand what you say correctly.

    I did the 3 commands in order and copy the result to you.

     

    C:\>lsnrctl stop

    C:\>lsnrctl start

    C:\>lsnrctl service

     

    If it's not what you say, what you exactly want me to do ?

     

     

    Very grateful in advance.

  • 7. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    sb92075 Guru
    Currently Being Moderated

    NOTE #2 below

     

    do as below

     

    1) lsnrctl stop

    2) rename, delete or otherwise make the listener.ora file unavailable

    3) lsnrctl start

    4) # wait 60+ seconds before proceeding

    5) lsnrctl service

     

     

    COPY the results from above then  PASTE  all back here

  • 8. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    user8860348 Explorer
    Currently Being Moderated

    Folks,

    Hello. Very grateful to your help. The result is below:


    C:\>lsnrctl stop

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-AUG-2013 20:14
    :26

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    The command completed successfully

    C:\>

     

    Then I rename listener.ora as listener2.ora. 


    C:\>
    C:\>lsnrctl start

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-AUG-2013 20:16
    :01

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

    Starting tnslsnr: please wait...

    TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    Log messages written to c:\secondtime_oracledatabase_install_directory\diag\tnsl
    snr\user-19yyar8x0d\listener\alert\log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=user-19yyar8x0d)(PORT=15
    21)))

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
    ction
    Start Date                14-AUG-2013 20:16:04
    Uptime                    0 days 0 hr. 0 min. 3 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Log File         c:\secondtime_oracledatabase_install_directory\diag\tn
    slsnr\user-19yyar8x0d\listener\alert\log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=user-19yyar8x0d)(PORT=1521)))
    The listener supports no services
    The command completed successfully

    C:\>
    C:\>
    C:\>
    C:\>lsnrctl service

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-AUG-2013 20:16
    :25

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

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    The listener supports no services
    The command completed successfully

    C:\>
    C:\>
    C:\>

     

    I think the reason is that I change localhost  127.0.0.1 into IP address 192.168.196.101.

    Colud you please help to solve the issue ?

     

    Thanks.

  • 9. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    sb92075 Guru
    Currently Being Moderated

    Is English your primary language?

     

    what part of below do you NOT understand?

    4) # wait 60+ seconds before proceeding


    are my directions too complicated?


    lsnrctl start was issued at  14-AUG-2013 20:16:01

    lsnrctl service was issued at 14-AUG-2013 20:16:25


    which less than 30 seconds after the start!


    >Colud you please help to solve the issue ?

    ISSUE? What issue? I don't see any issue.



  • 10. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    user8860348 Explorer
    Currently Being Moderated

    Folks,

    Hello. I am very sorry and very grateful to you. The result is below:

     

    C:\>lsnrctl stop

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-AUG-2013 20:45
    :34

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

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    The command completed successfully

    C:\>
    C:\>

    Then I rename listener2.ora as listener3.ora.


    C:\>
    C:\>lsnrctl start

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-AUG-2013 20:47
    :18

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

    Starting tnslsnr: please wait...

    TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    Log messages written to c:\secondtime_oracledatabase_install_directory\diag\tnsl
    snr\user-19yyar8x0d\listener\alert\log.xml

    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=user-19yyar8x0d)(PORT=15
    21)))

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
    ction
    Start Date                14-AUG-2013 20:47:21
    Uptime                    0 days 0 hr. 0 min. 3 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF

    Listener Log File         c:\secondtime_oracledatabase_install_directory\diag\tn
    slsnr\user-19yyar8x0d\listener\alert\log.xml

    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=user-19yyar8x0d)(PORT=1521)))
    The listener supports no services
    The command completed successfully

    C:\>
    C:\>
    C:\>
    C:\>
    C:\>lsnrctl service

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-AUG-2013 20:49
    :49

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

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    The listener supports no services
    The command completed successfully

    C:\>
    C:\>
    C:\>


    I assume that I configure Windows XP localhost 127.0.0.1 as IP # 192.168.196.101 in order to ping other machine cause this LISTENER problem.
    Could you please help to solve the issue ?


    Thanks.

  • 11. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    sb92075 Guru
    Currently Being Moderated

    >Colud you please help to solve the issue ?

    ISSUE? What issue? I don't see any issue.


    post command & resultant error that needs to be resolved.


    It does not appear that any database is currently up, online & available on the system where the listener is now running.


    what IP# is associated with (HOST=user-19yyar8x0d)


    what results from doing OS  command below


    ping user-19yyar8x0d


  • 12. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    user8860348 Explorer
    Currently Being Moderated

    Folks,

     

    Hello.

    C:\>ping user-19yyar8x0d

    Pinging user-19yyar8x0d [192.168.196.101] with 32 bytes of data:

    Reply from 192.168.196.101: bytes=32 time=3ms TTL=128
    Reply from 192.168.196.101: bytes=32 time<1ms TTL=128
    Reply from 192.168.196.101: bytes=32 time<1ms TTL=128
    Reply from 192.168.196.101: bytes=32 time<1ms TTL=128

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

    C:\>

     

    The issue is that I am installing Oracle Database 11g with Windows XP. The wizard is  On step 7 of 8: Oracle Database Configuration Assistant, I got this error: ORA-12560:TNS: protocol adapter error.

    I click "Password Management" button, there are no rows in this Windows (no username, no lock accounts). It's supposed to have some user names.


    My question is:

    How to solve this error and continue to install it ?

  • 13. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    sb92075 Guru
    Currently Being Moderated

    >The issue is that I am installing Oracle Database 11g with Windows XP

    Why? above is NOT a supported combination.

    what makes you think that it should work without error?

  • 14. Re: Oracle Database 11g Installation Issue: ORA-12560:TNS: protocol adapter error.
    user8860348 Explorer
    Currently Being Moderated

    Folks,

     

    Oracle Database 11g install wizard is  On step 7 of 8: Oracle Database Configuration Assistant, I got this error:

     

    ORA-12560:TNS: protocol adapter error.

     

    I click OK button and this error windows disappear. Then in install Wizard window, there is still Step 8 to get to finish stage. But the Wizard cannot proceed any more. What to do ? Click CANCEL button ? or other ?

     

    Thanks.

1 2 Previous Next

Legend

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