1 2 Previous Next 15 Replies Latest reply: Aug 14, 2013 11:39 PM by sb92075 RSS

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

    user8860348

      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

          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

            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

              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

                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

                  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

                    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

                      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

                        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

                          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

                            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

                              >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

                                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

                                  >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

                                    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