5 Replies Latest reply: Jan 17, 2013 5:26 PM by 982153 RSS

    ORA-12560: TNS Protocol Adapter Error(ORACLE 11g)

    846418
      i installed 11g on my laptop yesterday and it was working perfectly but today it keeps writing:(AS SHOWN BELOW)



      ========================================================================
      SQL*Plus: Release 11.2.0.1.0 Production on Fri May 20 12:26:48 2011

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

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


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


      Enter user-name:
      ===============================================================================

      I checked the listener status and it seems to be working quite well as shown below...i don't understand!

      ================================================================================


      Microsoft Windows [Version 6.1.7600]
      Copyright (c) 2009 Microsoft Corporation. All rights reserved.


      C:\Users\Bryan>lsnrctl status

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-MAY-2011 12:31
      :07

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
      ction
      Start Date 20-MAY-2011 09:30:43
      Uptime 0 days 3 hr. 0 min. 24 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File C:\app\Bryan\product\11.2.0\dbhome_2\network\admin\lis
      tener.ora
      Listener Log File c:\app\bryan\diag\tnslsnr\Bryan-PC\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
      ===========================================================================


      i dont know wat happened PLEASE ASSIST
        • 1. Re: ORA-12560: TNS Protocol Adapter Error(ORACLE 11g)
          Aman....
          Did you check that the service of the db is started from the Services ?

          Aman....
          • 2. Re: ORA-12560: TNS Protocol Adapter Error(ORACLE 11g)
            Thierry H.
            Hi,

            What is the SID of your database?
            I do not see any handler for a database instance running.... Please post your listener.ora

            Can you also post the results of "lsnrctl services"?

            As mentioned above, also check if the Windows servies for your database instance is running.

            Also try to login to your database with SYS as SYSDBA from where you'll be able to do a startup if needed.

            HTH,
            Thierry
            • 3. Re: ORA-12560: TNS Protocol Adapter Error(ORACLE 11g)
              DBA Learner
              Hi,

              Am also facing the same issue, please help me

              Thanks in advance.
              • 4. Re: ORA-12560: TNS Protocol Adapter Error(ORACLE 11g)
                Aman....
                DBA Learner wrote:
                Hi,

                Am also facing the same issue, please help me

                Thanks in advance.
                Don't you think that rather than hijacking an year old thread and that too without posting any details of your version and o/s, you could have searched for the same error on Google or within this forum as this error is a fairly popular one?

                http://www.lmgtfy.com/?q=tns+protocol+adaptor+error#

                Aman....
                • 5. Re: ORA-12560: TNS Protocol Adapter Error(ORACLE 11g)
                  982153
                  Hello,

                  I am having the same problem, my step son touched the computer and have no idea what he did.
                  here are my results

                  lsnrctl services

                  Microsoft Windows [Version 6.1.7601]
                  Copyright (c) 2009 Microsoft Corporation. All rights reserved.

                  C:\Users\Rami>lsnrctl services

                  LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 17-JAN-2013 23:22
                  :23

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

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                  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 "PLSExtProc" has 1 instance(s).
                  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                  Handler(s):
                  "DEDICATED" established:0 refused:0
                  LOCAL SERVER
                  The command completed successfully

                  C:\Users\Rami>