Fixed – ORA-12560: TNS: protocol adapter error

This article will explain you how to resolve ORA-12560: TNS: protocol adapter error.

Error Message:

ORA-12560: TNS: protocol adapter error

Resolution:

Method-1:

To resolve this issue, you need to make sure that you have set the correct oracle SID. Lets take the following example.

C:\>sqlplus system/manager@xe

SQL*Plus: Release 11.2.0.2.0 Production
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:

I got the error "ORA-12560: TNS:protocol adapter error"

Now what I did to resolve this issue. I set the Oracle SID on command prompt and tried to STARTUP again. Now this time my startup was successful.

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, might be service of Oracle 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.

Method-2:

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

How to restart the Oracle Service?

Go to Start > Run > Type Services.msc

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

Once both the services are started, try to start your database.

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 getting the same issue, write us in comment section. We will try to solve your problem.

Subscribe to get free tech advice, tips and in-depth articles.


Start Your Dream Website Today & Earn Money Online

To Start a dream website, choose a Domain Name & Reliable Hosting Provider, Self-hosted Blogging Platform, WordPress Theme, Email Marketing and SEO Tool for traffic.

SiteGround Hosting Discount - 60% OFF
ConvertKit The Best Email Marketing Software
Free SEMRush SEM and SEO Tool
Get Your Hosting Package with SiteGround, Increase new email subscribers with ConvertKit and Research Keywords with SEMRush to Boost Organic Traffic.





4 Responses to Fixed – ORA-12560: TNS: protocol adapter error

  1. Avatar for Techies Digest Poonam says:

    All above methods are not working for me.I tried to restart service from command prompt but it is still showing error as access denied.

  2. Avatar for Techies Digest Amit Kumar says:

    hi i tired with all of the above methods but my issue is not solved soo pls give a solution to fix this up

  3. Avatar for Techies Digest Cam says:

    Just an FYI… make sure you’re relaunching cmd prompt after fixing your environment variables. I’ve made this mistake with 3 or 4 DB’s I’ve loaded and wasted a good amount of time staring at correct variables.

Leave a Reply

Your email address will not be published. Required fields are marked *