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.

Solution 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)

Solution 2

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 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

Solution 3

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

Solution 4

Add to the enviroment vars the following varibale and value to identify the place of the tnsnames.ora file:

TNS_ADMIN

C:\oracle\product\10.2.0\client_1\network\admin

Solution 5

from command console, if you get this error you can avoid it by typing

c:\> sqlplus /nolog

then you can connect

SQL> conn user/pass @host:port/service

View more solutions