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.

17 thoughts on “Fixed – ORA-12560: TNS: protocol adapter error”

  1. Reddy A

    Hi
    I tried logging with command prompt with above procedure its working,, like C:sqlplus XXXXX/XXXXX@orcl
    but i can’t logging through SQLPLUS , i checked back again all services are up and running ,tried restarting those, but its still same issue,
    only with command prompt its working
    I have windows 10/ 64bit OS with Oracle 11g

  2. clickpulsa.com

    not work in my case..,

    C:UsersAdministrator>lsnrctl start

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 – Production on 25-JAN-2017 07:54
    :54

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Starting tnslsnr: please wait…

    TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 – Production
    System parameter file is D:oracleappAdministratorproduct11.2.0dbhome_1net
    workadminlistener.ora
    Log messages written to d:appadministratordiagtnslsnrWIN-JPJLOMNGCPSlisten
    eralertlog.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1521
    ipc)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-JPJLOMNGCPS)(PORT=15
    21)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    STATUS of the LISTENER
    ————————
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 – Produ
    ction
    Start Date 25-JAN-2017 07:54:59
    Uptime 0 days 0 hr. 0 min. 7 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File D:oracleappAdministratorproduct11.2.0dbhome_1ne
    tworkadminlistener.ora
    Listener Log File d:appadministratordiagtnslsnrWIN-JPJLOMNGCPSlist
    eneralertlog.xml
    Listening Endpoints Summary…
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1521ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-JPJLOMNGCPS)(PORT=1521)))
    Services Summary…
    Service “CLRExtProc” has 1 instance(s).
    Instance “CLRExtProc”, status UNKNOWN, has 1 handler(s) for this service…
    The command completed successfully

    ———————————————————————————————————-
    C:UsersAdministrator>sqlplus “/as sysdba”

    SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 25 08:06:31 2017

    Copyright (c) 1982, 2011, Oracle. All rights reserved.

    ERROR:
    ORA-12560: TNS:protocol adapter error

    Enter user-name:

  3. phani kiran gurudatta

    Thanx a lot, starting both the services thru services.msc had helped me resolve the tns error..

  4. D Suresh

    hi i have upgraded from window7 to windows10 after the am facing

    Oracle service & listener service- OracleXETNSListener are not staring in services.msc even after restart the servicce many times and its not starting..Pls help me on this

    how to resolve this problem ?

    Thanks Advance.

  5. Brent

    I had this issue with Oracle 12c Standard Edition installing on WIndows 10 Pro.
    I tried multiple, multiple work arounds.
    Turning off UAC, turning off firewall, running setup.exe as admin, various tns, sqlnet and listener config edits.
    Finally I tried installing Oracle 11, it worked first time, without any issues what-so-ever.

  6. harry

    i tried this aproach but its not working in my case

  7. sachin

    I have restart the service and also restart the listener but till I am getting same error.
    This is happend after applying Opatch.

  8. Mehmet Celikel

    If hostname or IP of Oracle server has been changed, then this may cause the problem. In this case, you need to update listener.ora file with valid values (hostname or IP).

    1. Yes, you are right. If you have changed the name of host or IP, its better to reconfigure listener.

  9. $uPPu

    I dont find these services OracleServiceXE & OracleXETNSListener

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

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

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

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

  14. prateek aggarwal

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

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

Leave a Comment

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

shares
Scroll to Top