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.
First of all, make sure that you have set the correct ORACLE_SID:
C:\>sqlplus system/manager@xeSQL*Plus: Release 11.2.0.2.0 ProductionERROR:ORA-12560: TNS:protocol adapter errorEnter user-name:C:\>set ORACLE_SID=xeC:\>sqlplus system/manager@xeConnected to:Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> startupORACLE instance started.Total System Global Area 1071333376 bytesFixed Size 1388352 bytesVariable Size 620757184 bytesDatabase Buffers 444596224 bytesRedo Buffers 4591616 bytesDatabase 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:\>sqlplusSQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:34:24 2013Copyright (c) 1982, 2010, Oracle. All rights reserved.Enter user-name: / as sysdbaERROR: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:\>sqlplusSQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:41:30 2013Copyright (c) 1982, 2010, Oracle. All rights reserved.Enter user-name: / as sysdbaConnected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 1071333376 bytesFixed Size 1388352 bytesVariable Size 620757184 bytesDatabase Buffers 444596224 bytesRedo Buffers 4591616 bytesDatabase 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.
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:
Thanx a lot, starting both the services thru services.msc had helped me resolve the tns error..
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.
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.
i tried this aproach but its not working in my case
I have restart the service and also restart the listener but till I am getting same error.
This is happend after applying Opatch.
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).
Yes, you are right. If you have changed the name of host or IP, its better to reconfigure listener.
I dont find these services OracleServiceXE & OracleXETNSListener
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.
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.
It should work..
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.
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
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.