Ora-12560: Tns:Protocol Adaptor Error

ORA-12560: TNS:protocol adaptor error

1. Go to the windows machine that hosts the Oracle database server

2. Go to Start -> Run -> Services.msc in Windows.
   Locate OracleService < SID > (here OracleServiceORCL) and click on Start to start the oracle database service (if not already running)
   

3. Once it is up and running, from the command prompt run the following:

   tnsping < tnsalias > 
   

   (tnsalias entry you can find it in tnsnames.ora file)

ORA-12560: TNS: Error protocol Adapter

I think I know the problem. You said that you did the same steps in the tutorial.

In the tutorial, he did this step C:>set oracle_sid=db.

Did you have the same name of the Oracle SID ? If you did a default installation, by the default the Oracle SID is orcl .

In your case, do this C:>set oracle_sid=ORCL. To verify the Oracle SID, go to this path C:\oracle\app\oracle\product\11.2.0\server\network\ADMIN and open the listener.ora and check the host name.

LISTENER =
     (DESCRIPTION_LIST =
         (DESCRIPTION =
             (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
             (ADDRESS = (PROTOCOL = TCP)(HOST =ORCL)(PORT = 1521)
         )
     )
)

If you have HOST=ORCL, then you must do this C:>set oracle_sid=ORCL. If you have another name, do this C:>set oracle_sid=NAME_OF_YOUR_HOST

Related Topics