ORA-12560: TNS:protocol adaptor error
- Go to the windows machine that hosts the Oracle database server
Go to Start -> Run -> Services.msc in Windows.Locate OracleService < SID > (here
OracleServiceORCL) and click onStartto start the oracle database service (if not already running)
Once it is up and running, from the command prompt run the following:
tnsping < tnsalias >(tnsalias entry you can find it in
tnsnames.orafile)
In my case I didn't have an OracleService (OracleServiceORCL) in Windows Services.msc as described in Bharathi's answer.
I executed this command:
C:\> ORADIM -NEW -SID ORCLand 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
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
Set Oracle SIDC:>set oracle_sid=ORCL
Now run Net start command.C:>net start oracleserviceORCL