Fixed – ORA-12560: TNS: protocol adapter error

When you login into Oracle Database and it throws an error message:

Ora-12560: TNS: protocol adapter error

Then follow the below mentioned steps to solve this issue.

Ora-12560 Error

First of all, make sure that you have set the correct ORACLE_SID:


C:\>sqlplus system/manager@xe
SQL*Plus: Release 11.2.0.2.0 Production
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
C:\>set ORACLE_SID=xe
C:\>sqlplus system/manager@xe
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> startup
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size                  1388352 bytes
Variable Size             620757184 bytes
Database Buffers          444596224 bytes
Redo Buffers                4591616 bytes
Database mounted.
Database opened.

SQL>

If the above method doesn’t work, may be the OracleService for the database is not running. Check for the service, if it is not running then starts the service. If it is running then restart the service.

C:\>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:34:24 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Enter user-name:  / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

Now restart the service using below method.


Start > Run > Type Services.msc

Start/Restart both Oracle service & listener service- OracleServiceXE & OracleXETNSListener

C:\>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:41:30 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size                  1388352 bytes
Variable Size             620757184 bytes
Database Buffers          444596224 bytes
Redo Buffers                4591616 bytes
Database mounted.
Database opened.

SQL>

If you are still unable to resolve the issue, write below in comment section. We will try to solve your problem.

SiteGround Black Friday Sale Below Banner

Get Free Blogging Tips & Technology updates in your Email !!!

Subscribe via RSS feed

The following two tabs change content below.
Anil Kumar
IT Blogger Tips focus on Blogging Tips, SEO Tips, Social Media, SQL Tips, PL/SQL Tips, Oracle DBA, Linux/Unix, Latest Technology, How Tos and Technical Solutions. You can find us on Facebook | Twitter |
Find on Google+

  • prateek aggarwal

    As i have tried all the options still facing the same problem. Please hep me out.

    • Hi Prateek,

      This is the proven solution but still you are getting the same problem, then clear all the event log files and try to do the same thing again.
      It is surprising to clear the event logs but this is also one of the step of this solution.

  • rama

    I had oracle 11g installed on Win 7 64 and i want to connect from client (11g instant client)and i am getting tns protocol adapter error in the client side but where as from the server i am able to connect. So could you please let me know where would be the problem

  • Md Faruque Islam

    I got this error when i install “ODTwithODAC112030” tools for visual studio.net 10.0
    ORA-12560: TNS:protocol adapter error
    it is solved as the examples given above:
    for oracle 11g r2
    C:\>set ORACLE_SID=orcl
    C:\>sqlplus system/oracle@orcl[press enter]
    it works for my case. Thank you for the information.

Siteground SALE
70% OFF SiteGround WordPress Hosting – $2.95/month (Exclusive Offer !!!)