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.



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

Subscribe via RSS feed

The following two tabs change content below.
Anil Verma
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+

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