sql - ORA-12560: TNS:protocol adaptor error

Question

I Google[d] for this error ORA-12560: TNS:protocol adaptor error but not able to find the actual reason and how to solve this error ?

Can anyone tell me a perfect solution to solve login problem.

Answer 1

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)