9 Replies Latest reply: Sep 26, 2012 6:44 AM by EdStevens RSS

    ERROR: ORA-12560: TNS:protocol adapter error

    953769
      OS: Windows 7 64-bit
      Oracle 11g installed

      Error Message:

      SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012

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

      Enter user-name: Ajinkya
      Enter password:
      ERROR:
      ORA-12560: TNS:protocol adapter error


      Please Help!!
        • 1. Re: ERROR: ORA-12560: TNS:protocol adapter error
          sb92075
          950766 wrote:
          OS: Windows 7 64-bit
          Oracle 11g installed

          Error Message:

          SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012

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

          Enter user-name: Ajinkya
          Enter password:
          ERROR:
          ORA-12560: TNS:protocol adapter error


          Please Help!!
          FAQ!

          are both OS Services for the listener & database started & running?
          • 2. Re: ERROR: ORA-12560: TNS:protocol adapter error
            EdStevens
            950766 wrote:
            OS: Windows 7 64-bit
            Oracle 11g installed

            Error Message:

            SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012

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

            Enter user-name: Ajinkya
            Enter password:
            ERROR:
            ORA-12560: TNS:protocol adapter error


            Please Help!!
            Too bad you didn't show the command that generated this ... where you actuall invoked sqlplus at the command line.... That has a bearing on this error.

            Typically this will result from
            1) not having ORACLE_SID properly set. Especially so on Windows.
            2) not having the db service started. See the windows services applet, services.msc
            • 3. Re: ERROR: ORA-12560: TNS:protocol adapter error
              953769
              hw do u do that? m totally new to dis.
              • 4. Re: ERROR: ORA-12560: TNS:protocol adapter error
                953769
                wn i start sql plus, it asks 4 login name and password.. after entering the password.. dis error is shown
                • 5. Re: ERROR: ORA-12560: TNS:protocol adapter error
                  EdStevens
                  950766 wrote:
                  hw do u do that? m totally new to dis.
                  Sigh ...

                  Ok, step by step.

                  In the lower left corner of your computer screen, you should see an icon that looks suspiciously like the Windows logo. This is common referred to as the Windows "start button".

                  Click on it.

                  That should result in a pop-up, commonly referred to as the Windows "Start Menu". At the bottom of that menu there should be an input field with the text "search programs and files". Click in that field to position your input cursor there.

                  Enter the text "services.msc"

                  This should result in one program listed, named "services.msc".

                  Click on the icon for that program.

                  That should result in the opening of the "services" applet. This lists all of the service programs that are running in windows.

                  Scroll down the list, looking for anything that starts with "Oracle".

                  Tell us the name of every service you see whose name starts with "Oracle"
                  • 6. Re: ERROR: ORA-12560: TNS:protocol adapter error
                    Osama_Mustafa
                    if you check this forum i think you find more than 2000 thread talking about this error , i think we must create new topics for this error please search in forum before you post new topics.

                    and what version of windows 7 you run ?
                    • 7. Re: ERROR: ORA-12560: TNS:protocol adapter error
                      ShankarViji
                      Hi User,

                      Welcome to Forum !!!

                      Please check that the Connection String for the database exists in the TNSNAMES.ora File. Usually,
                      it is located $ORACLE_HOME\ora81\network\ADMIN.

                      Regarding ORACLE_HOME,

                      Please read the Link below:

                      ORACLE_HOME

                      The Connection String for the database need to be added in the TNSNAMES.ORA.

                      And, once done. You can check it by issuing the following command from Command Prompt.
                      D:\>tnsping orcd
                      
                      TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 04-AUG-20
                      12 14:35:19
                      
                      Copyright (c) 1997 Oracle Corporation.  All rights reserved.
                      
                      Used parameter files:
                      C:\OraDevSuite\network\admin\sqlnet.ora
                      C:\OraDevSuite\network\admin\tnsnames.ora
                      
                      Used TNSNAMES adapter to resolve the alias
                      Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
                      (HOST = 12.77.1.19)(PORT = 1521))) (CONNECT_DATA = (SID = orcd)))
                      OK (0 msec)
                      
                      D:\>
                      Here, the orcd is the connection string we have added in the TNSNAMES.ora file.
                      SID is used to uniquely identify a database on a system.

                      Thanks,
                      Shankar
                      • 8. Re: ERROR: ORA-12560: TNS:protocol adapter error
                        964419
                        please check out login by using host name

                        Example:

                        c:\>sqlplus

                        User: scott/tiger@orcl

                        SQL>

                        It worked for me. If i give it in this way it returns the error

                        c:\>sqlplus

                        User: scott/tiger

                        ORA-12560: TNS: protocol adapter error

                        Hope that would help you to solve the problem. I have check your thread today

                        Thank You
                        Shreyas
                        • 9. Re: ERROR: ORA-12560: TNS:protocol adapter error
                          EdStevens
                          961416 wrote:
                          please check out login by using host name

                          Example:

                          c:\>sqlplus

                          User: scott/tiger@orcl

                          SQL>

                          It worked for me. If i give it in this way it returns the error

                          c:\>sqlplus

                          User: scott/tiger

                          ORA-12560: TNS: protocol adapter error

                          Hope that would help you to solve the problem.
                          I doubt it, since you give no explanation of why it worked one way and not the other.
                          I have check your thread today
                          The thread you checked is nearly two-months old. Nearly two months without the OP responding with any of the already requested information. I seriously doubt he is watching this thread any more.

                          >
                          Thank You
                          Shreyas
                          Edited by: EdStevens on Sep 26, 2012 6:43 AM