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

  • Saba

    Sir,
    I tried the above steps. none of them worked for me. I even tried to Start/Restart both Oracle service & listener service. But when I try to start OracleServiceORCL then it shows “Error 1067: the process terminated unexpectedly.”

    I have the GlobalDatabaseName and SID set as orcl during installation.

    I have installed Oracle 10g on my Windows 7 32-bit OS, and not even had a single successfull login since then.
    Please help. Thanks in advance.

  • Ramandeep

    Facing the same problem. Please hep me out.I am unable to Connect as sysdba.I can only connect using SQLPLUS /nolog option.Oracle Listner and Oracle Service is running.I have checked using tnsping command.In Bdump folder i checked the trace file which is showing problem with REDOLOG02 file.How to recover this file as I am not able to connect as sysdba.

  • $uPPu

    I dont find these services OracleServiceXE & OracleXETNSListener

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