sql – ORA-12560: TNS:protocol adaptor error

sql – 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)

In my case I didnt have an OracleService (OracleServiceORCL) in Windows Services.msc as described in Bharathis answer.

I executed this command:

C:> ORADIM -NEW -SID ORCL

and then the OracleService called OracleServiceORCL just showed up and got started in Services.msc. Really nice.

---

Source: https://forums.oracle.com/forums/message.jspa?messageID=4044655#4044655

sql – ORA-12560: TNS:protocol adaptor error

Seems like database is not up. It might be due to restarting machine and the instance is not set to autostart and it so not started munually after starting from services Screen.

Just goto Command prompt

1. Set Oracle SID
   C:>set oracle_sid=ORCL

2. Now run Net start command.
   C:>net start oracleserviceORCL