Skip to Main Content
  • Questions
  • ORA-12560: TNS:protocol adapter error

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, deepan.

Asked: September 04, 2007 - 10:27 am UTC

Last updated: November 04, 2019 - 1:22 pm UTC

Version: 9.2.0

Viewed 100K+ times! This question is

You Asked

i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error "
what should i do?
please help..
(scott/tiger)

and we said...

sounds like the database is not up. you probably restarted your machine and the instance is not set to autostart

C:\Documents and Settings\tkyte>sqlplus scott/tiger

SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

scott%ORA10GR1> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

C:\Documents and Settings\tkyte><b>net stop oracleserviceora10gr1
The OracleServiceORA10GR1 service is stopping.........
The OracleServiceORA10GR1 service was stopped successfully.
</b>

C:\Documents and Settings\tkyte>sqlplus scott/tiger

SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.
<b>
ERROR:
ORA-12560: TNS:protocol adapter error

</b>
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
<b>
C:\Documents and Settings\tkyte>net start oracleserviceora10gr1
The OracleServiceORA10GR1 service is starting..........
The OracleServiceORA10GR1 service was started successfully.
</b>

C:\Documents and Settings\tkyte>sqlplus scott/tiger

SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

scott%ORA10GR1>


in the above ora10gr1 is my oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle.

Rating

  (126 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Another method

Arangaperumal G, September 10, 2007 - 3:15 am UTC

Start --> Run--> type " services.msc"

Select the OracleService name, Right Click, Start.


ora-12560

Jain M., August 27, 2008 - 8:20 am UTC

hi, i am using oracle 8.1.7 on windows with 2GB RAM while connecting to svrmgrl it is giving ora-12560..though XXX database is there and working last day...

H:\oracle\ora81>set ORACLE_SID=XXX

H:\oracle\ora81>svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-12560: TNS:protocol adapter error
Tom Kyte
August 28, 2008 - 8:52 am UTC

sounds like the database service is not started. is it.

ora-12560

Jain M., August 28, 2008 - 10:01 am UTC

it was started
==================================
Memory status
Physical Memory
Total 2096524 K
available 160312 K
sysem cache 330992 K
==================================
C:\>net stop OracleServiceXXX
The OracleServiceXXX service is stopping.
The OracleServiceXXX service was stopped successfully.


C:\>net start OracleServiceXXX
The OracleServiceXXX service is starting.
The OracleServiceXXX service was started successfully.


C:\>Set ORACLE_SID=XXX

C:\>svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-12560: TNS:protocol adapter error
SVRMGR>

Tom Kyte
August 29, 2008 - 10:31 pm UTC

oracle_home set properly?

B.VO, August 29, 2008 - 9:38 am UTC

Hi,

Did you use Terminal Server ? Terminal Server is not compatible with Oracle 8i, you'll hit ORA-12560.

Best regards,
B.VO

TNS Protocol Adapter Error

Marichele, September 10, 2008 - 9:29 pm UTC

B.Vo of France

Terminal Service interferes with database creation creating the TNS:Protocol Adapter Error. Using Remote Control on the virtual server worked where the Remote Desktop didn't.

Thank you B. Vo of France

Thanks, Marichele

ora-12560

Arvind, July 11, 2009 - 6:54 pm UTC

Hi,

I am installing Oracle 11.1.0 on windows xp. I am getting error ora-12560 when configuration assistant part of installation starting. I have installed loopback adapter and tested it by ping command. Please help me.

Thanks,

Arvind
Tom Kyte
July 14, 2009 - 5:23 pm UTC

the database service is not started - peek into your services with control panel

ora-12560

Arvind Mishra, July 18, 2009 - 5:53 am UTC

Hello Tom,

When we install Oracle on windows it automatically start the windows services. After your suggestion I checked the services and tried to start it manually also but it is not starting.

I also goolged for this error and found that a lot of other people are also getting same error but unfortunately no one has any solution.

Thanks,

Arvind


Tom Kyte
July 24, 2009 - 9:23 am UTC

review your alert log, your service is not starting.

ORA-12560

Arvind Mishra, July 26, 2009 - 12:09 am UTC

Hi Tom,

I manually uninstalled the Oracle and then reinstalled it and then it is installed successfully (in third trial). I do not know the reason why it was not installed during first and second try.

Thanks,

Arvind


Tania, August 07, 2009 - 6:06 am UTC

Tom,
I am opening oracle first time and whenever i try to login
Username:/nolog
sql>connect/as Sysdba
i get the below response:
Error:
ORA 12560:TNS:Protocol adapter error

hey pls help me out as i am new to this and want to learn it.
Tom Kyte
August 07, 2009 - 10:12 am UTC

see the original answer above, you are on windows undoubtedly - and the service is not running.

ORA-12560

ali, August 23, 2009 - 4:07 am UTC

DEAR tom

while starting up database, i am grtting following error

ERROR:
Error while trying to retrieve text for error ORA-12560

version : 9i
OS : Linux

i verified home , path variables .. they have been set properly and listenr is up

could you please help me to resolve the issue

Thanks
Ali

12560 TNS protocol Error

Yasir, December 04, 2009 - 6:47 am UTC

hey Tom,
when i get enter user name scott and pass tiger to Oracle 9i

i get the ORA - 12560 TNS protocol error.

Please tell me how to correct it in easy way. i couldnt find any Solution. please help me.

external table

MAHESWARI, March 17, 2010 - 6:01 am UTC

when try to create the external table using the oracle_loader getting error "ORA-25153:TEMPORARY TABLESPACE IS EMPTY"
Tom Kyte
March 17, 2010 - 8:41 am UTC

[tkyte@dellpe ~]$ oerr ora 25153
25153, 00000, "Temporary Tablespace is Empty"
// *Cause: An attempt was made to use space in a temporary tablespace with
//         no files.
// *Action: Add files to the tablespace using ADD TEMPFILE command.



did you look up the error message to see what the likely action should be?

apparently your query needs some temporary sort space and you have a temporary tablespace without any tempfiles.

12560 TNS protocol adaptor Error

Manoj Chaudhary, March 22, 2010 - 3:45 am UTC

I Installed 8iEE but after starting it ,it gives the error
12560: TNS: protocol adaptor Error
Tom Kyte
March 22, 2010 - 9:30 am UTC

hopefully you installed it on an operating system at least as old.

but you don't say anything about that. that is a very generic error meaning 'you didn't set it up'.

if this is windows, sounds like you did not start the database service at all.

All answers seem to be Services not running

Edward, March 25, 2010 - 10:28 am UTC

You seem to be saying that services not running is the reason for this error on the server. And you suggested setting oracle_sid manually. However, the oracle service is running as evidenced by the ability to connect to it in SQL developer using the sys login. Setting Oracle_Sid manually makes no difference, nor does explicitly indicating the name of the sid in the login attempt. I am at a loss to resolve this.
Tom Kyte
March 26, 2010 - 1:45 pm UTC

edward,

you give me nothing to work with and you expect perfect answers.

You write:

... I Installed 8iEE but after starting it ,it gives the error
12560: TNS: protocol adaptor Error ...


hmmm, you still haven't told me anything about the OS or anything (and hopefully it is an OS that existed when 8i was production - last century - and if it isn't don't bother asking).

Also, sql developer? use sqlplus please.

and - where did I tell you to set anything like the oracle_sid????


A reader, March 28, 2010 - 4:45 am UTC


Ora-12560 TNS Adapter error

Dhiraj, April 12, 2010 - 10:44 pm UTC

Dear Tom,
i installed Oracle10g on my PC at home.During the login i m getting Ora-12560 Tns Adapter error.

i checked my services.msc also but there was no entry for the oracleservicename10g in that....so what should i do?????

Kindly please help me!!!

solved n running listener

vroom, April 23, 2010 - 4:49 am UTC

@ Arangaperumal G from Chennai,India


ur method works n we hv to push start every oracle services to overcome this error n keep listener running in no time


(in mycomputer-manage -services
Tom Kyte
April 23, 2010 - 9:13 am UTC

Your keyboard is apparently near total failure. It is dropping vowels left and right - you should get that fixed because otherwise it makes you look like a 12 year old kid trying to be cool on the internet.



"ORA-12560: TNS:protocol adapter error "

srikanth M, August 30, 2010 - 2:02 am UTC

Hi,
I installed Oracle 10g Database on My laptop. O.S is Windows XP SP3 and I downloaded Oracle software from OTN. It worked fine without any errors. Now I am getting ""ORA-12560: TNS:protocol adapter error ". I tried all the steps which you mentioned. Nothing went right. It seems that Again I need to reinstall Oracle 10G. I got few errors in some other systems
OS Windows XP.
Errors are as follows:
Problem 1: TNSLSNR.exe has encountered a problem and nees to close
Problem 2: The Oracle<Home>Agent could not be started
Parameter "orahome"=c:\oracle\ora92
Parameter "nodeinfo"=NO_VALUE

Please do the needful.

"ORA-12560: TNS:protocol adapter error " November 20 from India, Bangalore

jaganath panda, November 18, 2010 - 9:15 pm UTC

Hi,
I installed Oracle 10g Database on My laptop. O.S is Windows XP SP2 and I downloaded Oracle
software from OTN. It worked fine without any errors. i take enjoy about this database.One day when i login sql*plus at that time error can occur.The type of error is "ORA-12560: TNS:protocol adapter error". I had getting ""ORA-12560: TNS:protoco.But ur 2nd-guide line more help me. ur 2nd guide line is Start --> Run--> type " services.msc"

Select the OracleService name, Right Click, Start.
So i never forget u.If i face for there any problem u most be help me
Thank's
jaganath

ORA-12560 : TNS:Protocol Adapter Error

A reader, December 13, 2010 - 2:43 am UTC

Hi Tom,

I am accessing the oracle using Command Prompt.

c:\>set oracle_sid = orcl
c:\> sqplus / as sysdba

If i tried to connect in command prompt using above commands then its working fine.I am able to work perfectly.

But when i try to login into SQL*PLUS,i am getting the error like ORA_12560 TNS:protocol Adapter Error.

How to resolve this error..
Kindly advise me.

Regards,
Sakthi.

Tom Kyte
December 14, 2010 - 2:39 am UTC

but


c:\> sqplus / as sysdba


is sql*plus?

sounds like your oracle_sid isn't set somewhere in your environment. Put it into your environment using control panel

Oracle TNS Protocol Adopter error

Amal Kant Chaudhary, December 30, 2010 - 6:12 am UTC

when i installed oracle 10g in my pc(windows 7) then oracle is working properly. After that when i restarted my pc and again login in oracle then message is coming" TNS Protocol Adopter Error" then what we should be do?

Please help me amalkantchaudhary@gmail.com
Tom Kyte
December 30, 2010 - 4:45 pm UTC

you should start the database.

You could start just by reading the original answer I gave years ago which basically says "your database is not started"


ORA-12560 on WIndows 2008 Server Standard

Danilo, January 14, 2011 - 10:42 am UTC

Hi,

I'm having the same problem on my server. The instance of oracle was running well, but I have to change the archive's directory, affter that, my oracle starts to show this "Ora-12560. TNS: Protocol adapter error".
I reinstall the oracle and reinstall the OS. Nothing work. What i can do to fix that?
Please send me an answer to danilo@newtasks.com.br.

Thank you a lot.
Danilo

Where for art thou server

Annoyed, January 15, 2011 - 12:47 pm UTC

Oracle must be the worst database. If the installer actually succeeds then there are these issues with setup, the bottom of the protocol stack and a host of others. I am an architect and have spent hours completely wasted on this ridiculous product. As a comparison, install DB2 and everything will work, a sample database, a tool to manage databases, a logical hierarchy of items. Even H2 is preferable to Oracle. Written by one man, download and double click the bat and off you go. Please tell me why people still use this product?


Alexey, January 18, 2011 - 9:50 am UTC

Hello, Tom
I need to check if instance is up from a script, but I don't want to get error message in console. I will check result from %errorlevel% variable after command is executed.
How can I disable ORA-... messages? Cause "set termout off" is useless in that case.

ERROR:
ORA-12541: TNS:no listener
Tom Kyte
January 23, 2011 - 3:34 pm UTC

use pipes? redirect stdout and stderr to grep and filter out what you want to see and lose the rest.

or sqlplus /nolog - set termout off - spool - and then connect

Fine.

shubhangi, January 23, 2011 - 12:41 am UTC

it is so much helpful
on oracle 10g TNS protocol error is comming
than i used services.msc commang
and i enable that service
oracle get started

Tns:Listener

Arul Ananth, January 24, 2011 - 4:52 pm UTC

Thanks Arangapermual.i eat 4 houre.this very use ful.

ORA-12560 error

Bose, January 26, 2011 - 9:59 am UTC

I am using Redhat linux As4 with oracle 10g. Now am enterd into the database. Now am using
conn username/password@netservice
that time i got ORA-12560 error. What s the problem

Check your firewalls

Woody Kellum, January 27, 2011 - 2:16 pm UTC

I just got this error with 11g running on Redhad SELinux.
It was a firewall issue - we had to open up access specifically to our client host on port 1521.

error in username and paaword

sadhiq basha, February 02, 2011 - 12:21 am UTC

when am installed the oracle 9i,i show the 12560 protocol adapter error msg..how can i resolve that one.. i want to be work,pls give the suggestion
regards
sadhiq

thank

pavi, February 02, 2011 - 7:32 am UTC

thank u so much for your help

TNS Protocol Error

John Kayode-Abusi, February 09, 2011 - 9:55 am UTC

I understand what you guys are passing through as regard TNS error. you can avoid this by:
1. install on Linux with firewall/SElinux disabled
2. install on windows server with firewall disabled
*don't allow other services on the machine to share port with it.
3.On 11g, run the installer first without creating a starter database, run NETCA and finally DBCA.
4 if you are using client OS like XP/VISTA/WIN7,follow case 3 and immediately go to services before you turn off your computer after installation and change all oracle services to start manually. from there, you will always start manually.
5. also, always start listener immediately after setting SID before other things.

I hope it will help!

sql+

anu, February 24, 2011 - 8:51 am UTC

i cannot login to sql + because of some protocol adapter error.W hat should i do for this problem?

Oracle-12560 error

gaurav, March 10, 2011 - 12:42 pm UTC

Thank you so much . i find information very useful & relevent.
thanks

still facing problems in connecting

A reader, March 24, 2011 - 11:50 pm UTC

Hi tom, when i connect to oracle 11g R2 on windows server 2003
as
c:>sqlplus scott/tiger
i got following errors

errors: The procedure entry point longjmp couldnot be located in the dynamic link library orauts.dll
ORA-12560: TNS:protocol adapter error

even after restarting pc, stoping and restarting OracleServiceORCL
even every service which start with Oracle
plz help me in this regard

Tom Kyte
March 25, 2011 - 11:00 am UTC

please contact support, there is something botched in your installation

oracle9i tns error..

abc, March 30, 2011 - 8:57 am UTC

i m getting error wen i start sqlplus..
username=scott
password=tiger
ora-12560:TNS protocol adaptor error..
plzz help me how to fix this..

TNS protocol adapter Error

Md. Mosarraf Hossen, April 11, 2011 - 5:03 am UTC

Your service name (oracle) is not started properly. If you properly restart your service, then problem will be solved. You may do as follows
1. Go to services.msc
2. Start oracleServiceDBTEST

my service name is dbtest.

Thanks

moorthy, May 10, 2011 - 5:11 am UTC

its moorthy,
I am opening oracle first time in windows 7 and whenever i try to login
Username:/scott
sql>connect/as tiger
i get the below response:
Error:
ORA 12560:TNS:Protocol adapter error

hey pls help me out as i am new to this and want to learn it.

Pfeiffer, May 22, 2011 - 4:47 am UTC

check if db listener is running; seems like database is up but listener is not.

go to services and look for a service OracleOraXYZTNSListener and start it.
OR
go to command prompt and run lsnrctl, then enter 'start' to start the listener


Thanx alot

A reader, May 25, 2011 - 1:30 pm UTC

Thanx Arangaperumal G i got my problem solved through ur solution.

chetali, June 20, 2011 - 11:18 am UTC

I am opening oracle first time in windows 7 and whenever i try to login
Username:/chetalii
sql>connect/ niit
i get the below response:
Error:
ORA 12560:TNS:Protocol adapter error

hey pls help me out as i am new to this and want to learn it.



ORA-12560 TNS:protocol adapter error

A reader, June 21, 2011 - 9:26 am UTC

Hi Tom,

I have a linux 32 bit database server. I have installed 10.2.0.1 and then upgraded it to 10.2.0.4. Now I have restored and recovered my database with help of RMAN utility. I have no problem in connecting my database using "@" string in the server itself.
But whenever I am trying to connect the Linux database server from any Windows client I am getting this error "ORA-12560 TNS:protocol adapter error" (my Linux server and database is up and running fine).
Can you please help me regarding this?
Tom Kyte
June 21, 2011 - 9:52 am UTC

verify your client configuration files are set up in the same fashion as your linux ones (sqlnet.ora's, tnsnames.ora)

can you tnsping it from the client.

TNS-12560: TNS:protocol adapter error

A reader, June 22, 2011 - 1:59 am UTC

Hi Tom,

I cannot do the tnsping from the windows client (getting the same error) but I am able to do it in the server itself.
The server TNS:
HMSTMS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.33.87)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hmstms)
)
)

The server SQLNET.ORA:
# sqlnet.ora Network Configuration File: /data/app/oracle/product/10204/db/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)


My windows client TNS is same and SQLNET.ORA conf is as follows:

# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)


But still I am getting the TNS protocol adapter error. Please help me.
Tom Kyte
June 22, 2011 - 10:26 am UTC

can you ping the machine, just ping it.

TNS-12560: TNS:protocol adapter error

A reader, June 22, 2011 - 1:09 pm UTC

Hi Tom,

Yes I can ping the server IP from the windows client command prompt successfully but couldn't able to tnsping it as the commands end with the error TNS-12560: TNS:protocol adapter error.
Please advise.
Tom Kyte
June 22, 2011 - 1:20 pm UTC

I would think that either

a) the configuration is not what you think it is (there is a TNS_ADMIN environment variable set or something that is pointing to a different location or the files you are looking at are not in the right location)

b) the software installation is incorrect on the client. Can you use this software to connect to *anything*



do the tnsping like this, put the TNS entry (*your tns entry, not mine!) right on the command line - and cut and paste the exact results back here:

$ tnsping '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ora10gr2)))'

TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 22-JUN-2011 14:19:01

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

Attempting to contact (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ora10gr2)))
OK (0 msec)

TNS-12560: TNS:protocol adapter error

A reader, June 23, 2011 - 2:59 am UTC

Hi Tom,

I am able to connect any other server from the same windows clients but not this particular server. Please check the below output as you have asked:

C:\Documents and Settings\Administrator>tnsping '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.33.87)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = XXXXX)))'

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 23-JUN-2
011 13:24:42

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

Tom Kyte
June 23, 2011 - 8:08 am UTC

see, that shows your tnsnames file is mucked up somehow - the error is no longer 12560. If you do not use the tnsnames.ora file, something else becomes wrong.

ops$tkyte%ORA11GR2> !oerr tns 3505
03505, 00000, "Failed to resolve name"
// *Cause:  The service name you provided could not be found in TNSNAMES.ORA,
//          an Oracle Names server, or a native naming service.
// *Action: Verify that you entered the service name correctly.  You may need
//          to ensure that the name was entered correctly into the network
//          configuration.


is your service name XXXXX?


TNS-12560: TNS:protocol adapter error

A reader, June 24, 2011 - 2:28 am UTC

Hi Tom,

My mistake. I had written the SID wrong. The tnsping is not working. giving the error "TNS-12560: TNS:protocol adapter error."

C:\Documents and Settings\Administrator>tnsping '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.33.87)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = hmstms)))'

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 23-JUN-2
011 13:24:42

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora

TNS-12560: TNS:protocol adapter error.


Also I am finding the trace in the database server sqlnet.trc in $ORACLE_HOME/network/trace:

[23-JUN-2011 14:35:26:776] nsevwait: waiting for transport event (0 thru 0)...
[23-JUN-2011 14:35:28:596] nsevwait: 1 newly-posted event(s)
[23-JUN-2011 14:35:28:597] nsevfnt: cxd: 0xe6092b0 stage 0: NT events set:
READ
[23-JUN-2011 14:35:28:597] nsevfnt: cxd: 0xe6092b0 stage 0: NS events set:
INCOMING SEND
[23-JUN-2011 14:35:28:597] nsevwait: event is 0x2, on 0
[23-JUN-2011 14:35:28:597] nsevwait: 1 posted event(s)
[23-JUN-2011 14:35:28:598] nsgrhe_HandleEvents: entry
[23-JUN-2011 14:35:28:598] nsdo: cid=0, opcode=68, *bl=1, *what=0, uflgs=0x0, cflgs=0x3
[23-JUN-2011 14:35:28:598] nsdo: rank=64, nsctxrnk=0
[23-JUN-2011 14:35:28:598] nsdo: nsctx: state=8, flg=0x400d, mvd=0
[23-JUN-2011 14:35:28:598] nsdo: gtn=334, gtc=334, ptn=10, ptc=8155
[23-JUN-2011 14:35:28:598] nsrdr: recving a packet
[23-JUN-2011 14:35:28:598] nsprecv: reading from transport...
[23-JUN-2011 14:35:28:598] nttmrd: entry
[23-JUN-2011 14:35:28:598] ntt2err: entry
[23-JUN-2011 14:35:28:598] ntt2err: Read unexpected EOF ERROR on 18
[23-JUN-2011 14:35:28:598] ntt2err: exit
[23-JUN-2011 14:35:28:598] nttmrd: socket 18 had bytes read=8208
[23-JUN-2011 14:35:28:598] nttmrd: exit
[23-JUN-2011 14:35:28:598] nserror: nsres: id=0, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[23-JUN-2011 14:35:28:598] nsdo: nsctxrnk=0
[23-JUN-2011 14:35:28:598] nsgrError: entry
[23-JUN-2011 14:35:28:598] nsgrcClose: entry
[23-JUN-2011 14:35:28:598] nstimarmed: no timer allocated



Please advise.
Tom Kyte
June 24, 2011 - 8:55 am UTC

please utilize support - give them this information to get started. If it is working for other sites - using the same software - I don't see anything obvious from here.

Appreciatio

pavan, July 23, 2011 - 12:47 pm UTC

the info is very helpful and knowledgable.

Kevin, July 26, 2011 - 12:21 pm UTC

You should add the file: tnsnames.ora in the following directory:
C:\oracle\product\11.2.0\client_2\network\admin

The file should contain:

serviceID(SID) =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 12.34.56.78)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = serviceID)
)
)

Best Suggestion and advice

Ashok M Prajapati, August 17, 2011 - 7:32 am UTC

It is very useful for me and very likely advisable plz send suggestion on my mail id:- amprajapati95@gmail.com

Rajesh, September 16, 2011 - 12:35 pm UTC

\Oracle\ora81\BIN\SQLPLUSW.EXE

Windows - ORA-12560: TNS:protocol adapter error

Garry, October 17, 2011 - 11:02 am UTC

On Windows, if you're using SQL*Plus to connect to a local database
and getting an "ORA-12560", then

1) Check the Oracle service is running (as described by others)
2) Ensure ORACLE_SID is defined in the Windows registry.

Under Oracle 10.2 the registry path is:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_Oracle

You need a string named ORACLE_SID, with the value of your database sid.

ora 12560: TNS: Protocol adapter error for 11g

CHAKRI, November 05, 2011 - 4:32 am UTC

pls any one can give me the answer ........

oracle 11g error

shakthi, November 08, 2011 - 9:15 am UTC

hi sir....
iam install oracle 11g in windows7 ultimate(64) i open the sqlplus but sql is not open. i enter the username and password is not correct and
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Nov 8 20:43:16 2011

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

Enter user-name: sys
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:



and the oracle service is not their windows service option also...
plz i needs ur help.....


Arangaperumal G from Chennai,India

Shekar, November 10, 2011 - 4:08 am UTC

thankQ (Arangaperumal G from Chennai,India)

Re: Trouble with ORACLE DB Installation

JCY, November 29, 2011 - 1:49 pm UTC

I was getting the same ora-12560 after Installed Oracle 11g Release 2 Client (32-bit) on window system 7 had installed win64_11gR2_database. I switched the order (client\bin path follows server\bin path) in the PATH and that fixes the error.

A.D Glogo, December 07, 2011 - 9:38 am UTC

I am experiencing something similar The computer hosting my oracle 10g XE database developed an OS error (system32 file missing or corrupt) so I repaired the os using a windows setup disc and recovered my system with all programs and files. When I tried to start an application I developed using odp.net, I got the following error message: "Could not load file or assembly 'system.EnterpriseServices,Version=2.0.0.0, Culture=neutral, PublicKeyToken=bo3f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified".
I also tried connecting from sqlplus and got ORA-12560: TNS Protocol adapter error. I also tried accessing the database homepage from a browser to no avail. PLS HELP!

sqlplus / as sysdba

avyakt Kumar, January 20, 2012 - 3:36 am UTC

I installed Oracle 11gR2 on windows 7 professional. No database was created. I want to create database manually. so I try to login to SqlPlus with the following command.

D:\app\username>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 20 15:00:15 2012

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:

I checked the DBA_ORA group. My user is there. Why is this coming? Of course there is no oracle service is running although listner is running.
Tom Kyte
January 20, 2012 - 9:54 am UTC

you need to use oradim to create a service - because windows is "special" and not like a normal OS (like unix ;) )

did you read the install/admin guides for windows at all?

http://docs.oracle.com/cd/E11882_01/win.112/e10845/create.htm#i1005959


Of course
there is no oracle service is running although listner is running.


therein lies your problem... the step by steps are fully documented in the linked to manual...

DHCP install oracle 11g

RMckendree, January 20, 2012 - 12:06 pm UTC

you may need to install the MS loopback adapter and review the DHCP installtion guide accessible from this link:

http://docs.oracle.com/cd/B19306_01/install.102/b14316/reqs.htm#BABBDGBI

Im very new to this but hope it helps.
Tom Kyte
January 20, 2012 - 12:08 pm UTC



better link (for my site anyway :) )

http://docs.oracle.com/cd/B19306_01/install.102/b14316/reqs.htm#sthref254


it won't help them with where they are at at all - they haven't even gotten to that point. networking doesn't come into play during a database create from the command line really.

12560: tns protocol adapter Error

Tapan, January 28, 2012 - 2:28 am UTC

hi,
M using o/s Vista and while intalling oracle 10g, i am getting error "12560: TNS Protocol Adapter Error" i tried all the things but i unable to resolve it.. plz help me.

A reader, February 01, 2012 - 10:02 pm UTC


azhar, February 13, 2012 - 7:49 am UTC

Hello Tom,

I have installed oracle 11gR2 client on windows server 2008, i have added tns entry for BAST database in tnsnames.ora file..also added entry in sqlnet.ora file as tnsnames.

tnsnames.ora file entry:

BAST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 195.169.239.167)(PORT = 1522)
)
)
(CONNECT_DATA =
(ORACLE_SID = BAST)
)
)

Sqlnet.ora file entry:

SQLNET.AUTHENTICATION_SERVICES= (NTS,TNSNAMES)

NAMES.DIRECTORY_PATH= (TNSNAMES)

But when doing tnsping BAST i received below error:

C:\Users\sa_oracle>tnsping BAST

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-FEB-2
012 14:40:44

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

Used parameter files:
G:\oracle\tns_admin\sqlnet.ora

TNS-03505: Failed to resolve name

C:\Users\sa_oracle>

But when i did below it work:

C:\Users\sa_oracle>tnsping "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL =
TCP)(HOST = 195.169.239.167)(PORT = 1522)))(CONNECT_DATA =(ORACLE_SID = BAST)))"


TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-FEB-2
012 14:46:36

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

Attempting to contact (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(H
OST = 195.169.239.167)(PORT = 1522)))(CONNECT_DATA =(ORACLE_SID = BAST)))
OK (0 msec)

C:\Users\sa_oracle>


My question that why it is not working with tnsping BAST?
instead of having correct entries in tnsnames.ora and sqlnet.ora files.

Regards,
Azhar


Tom Kyte
February 13, 2012 - 9:02 am UTC

is your tnsnames.ora in c:\oracle\tns_admin


SQLNET.AUTHENTICATION_SERVICES= (NTS,TNSNAMES)

tnsnames is not an authentication service. did you use the network configuration assistant to set things up? It'll generate well formed files. I'm guessing either your file is not in the right location or is not in the right format (it is pretty picky about things)

Azhar, February 14, 2012 - 5:26 am UTC

Hi Tom,

Thanks it worked well after configuring tnsnames.ora file using net manager.

Regards,
Azhar

Re:

Gurleen, February 27, 2012 - 3:16 am UTC

i got "ORA-12560:TNS:protocol adapter error" fixed by starting all oracle services manually of my computer.
Start>Control Panel>Performance and Maintenance>Administrative Tools>Services.
this basically happened because of less RAM,therefore taking long time to start services.

IT WORKED

harsha, March 11, 2012 - 6:22 am UTC

start->run->services.msg right click on Oracle system service and select start.... it worked for me

Oracle installation error

jahangeer, April 01, 2012 - 1:13 am UTC

Hello sir
i am getting an error while installing the oracle software ie.. ORA-12546 TNS permission denied.
How to solve this error

Dependency on listener?

Dhruva, April 23, 2012 - 10:43 am UTC

Hi Tom, if I were to install the database software only (on a Windows 7 Pro 64 bit machine on DHCP), do I have to create a listener first to be able to create an instance (using DBCA) and connect to the database locally?

Is the listener only meant to service incoming client requests, excluding local sqlplus sessions?

Thanks
Tom Kyte
April 23, 2012 - 1:32 pm UTC

you do not need a listener to create a local connection - you do not need a listener to create a database/instance

Ok, so why the dreaded error

Dhruva, April 23, 2012 - 4:45 pm UTC

Thanks for the clarification.

If I run the DBCA which sets the ORACLE_SID and PATH and then calls
<code>C:\app\product\11.2.0\dbhome_1\bin\oradim.exe -new -sid ORCL -startmode manual -spfile

The outcome of this command is "Instance Created"

After a few steps it calls CloneRmanRestore.sql, which tries to run
connect "SYS"/"&&sysPassword" as SYSDBA
which is when I receive the error "ORA-12560: TNS:protocol adapter error".

The database service does show that it is started. Can I safely assume that this is not because of network/listener issues? If the instance is up and running, what could cause a local connection to fail?

Out of curiosity, why should the DBCA insist on creating a listener first? Is there something that needs to be added to the listener configuration first for the DBCA to succeed?

I might think this is a support type question, but I'm just trying to understand the dependencies. I will raise an SR if I don't have much success in the next few days.

I've set the loopback adapter to a static IP, updated the hosts file, created ORACLE_HOSTNAME, created administrative share, et al, but to no avail.

Thanks in advance.</code>
Tom Kyte
April 24, 2012 - 7:36 am UTC

funny, since it is a local connection -

connect "SYS"/"&&sysPassword" as SYSDBA

only needs be

connect / as sysdba

the username and password are always ignored on a non-network connect as sysdba!

there is no network here, no sqlnet is being used, it is a 100% local connection.

Can you check the logs and any alert log entries.


DBCA is not creating a listener here, it created the instance and is now trying to connect to it. No net.


if the service is running, can you try connecting to it just from the command line? set your sid/home and sqlplus / as sysdba

Solved

Dhruva, April 25, 2012 - 12:27 pm UTC

So finally it works.

Trend Micro is the culprit. It has been blocking TCP connections without leaving a trail in the audit log or even throwing up warnings.

I had to uninstall it and installed Kaspersky which fulfils the requirements.

Thanks again

PS: As you suggested, sqlplus sys/anypassword as sysdba is able to connect, totally ignores the supplied password

Ch, May 09, 2012 - 11:41 am UTC

Hi Tom,

I used to have oracle client 9i on my XP to connect to a remote Oracle DB(10g) which worked fine. After I try to upgrade it to 11.2.0 the connection dropped out. I basically wipes out all the oracle client installs and reinstalled the 11g client using the runtime option and then the instant client option.

The folder network\admin only have sqlnet.ora by default so I added the tnsnames.ora and listener.ora. When I do tnsping with sid the connection seems to be ok. However when I try to connect through SQL server it throws

'cannot initialize the datasource object of ole db provider msdaora for linked server'

'ole db provider msdaora return message 'ORA-12560 TNS:protocal adapter error'

Any suggestion?

TNS Protocol Adopter Error

Adi, May 28, 2012 - 1:48 pm UTC

Hello..

Plz follow the below steps in ur laptop/desktop

Start-run-services.msc
in that start Oracle Service ORCL manually

It will work for sure..

For me its worked... Thanks

This fixed ORA-12560: TNS:protocol adapter error after new install

Michael Holley, June 27, 2012 - 10:01 am UTC

This simple solution fixed my problem after I verified services and listerner were started.

sqlplus scott/tiger@[databasename] as sysdba

In this case with 11g XE I will use: sqlplus scott/tiger@XE as sysdba

Good luck!

done

A reader, July 05, 2012 - 2:50 am UTC

services.msc worked dude..thanks..

yaa this one worked

gopi, July 07, 2012 - 2:45 am UTC

well bro the problem is solved....servces.msc works

Annoying

Doug, July 09, 2012 - 10:46 pm UTC

Hi Tom,

I had Oracle 11GR2 running fine on local machine and
am now unable to connect to database.

Even trying to connect locally without the Listener give and error

sqlplus / as sydba

gives ORA-12560: TNS:protocol adapter error

The only change I can think of is I had to install ODAC to compile a web application.

I have checked the env variable for ORACLE_SID and ORACLE_HOME on Win7 and all look good


I tried restarting the DB as well as Listener.

Any suggestiosn would be appreciated thankyou

Fixed it

A reader, July 10, 2012 - 12:27 am UTC

The Oracle Path shown at DOS prompt was ok but under env variables via control panel was messed up big time

Thanks

Oracle Newbie, August 02, 2012 - 1:08 pm UTC

Had the same error, was not automatically starting even though it is set that way - services.msc helped a lot

was unable to start the data base

A reader, October 15, 2012 - 10:45 pm UTC

Thanks guys it really helped me to resolve the issue.
ERROR:
ORA-12560: TNS:protocol adapter error.
Error resolved after going in to services.msc and manually restarting the service.

Switch directory paths, within PATH variable

E Ferguson, November 14, 2012 - 9:51 pm UTC

I switched the order (client\bin path follows
server\bin path) in the PATH and that fixes the error!
This worked!

I put the path of the server\bin before the client home path , in the PATH environment variable.

On windows , right click MyComputer, go to Properties, Advanced, Environment Variables, Edit PATH variable



Tns protocol adapter error

sudha, January 16, 2013 - 4:56 am UTC

thanqq....

Unable to find oracle services

Arshad, January 16, 2013 - 6:32 am UTC

Hi Tom,
I opened 'services' thing which list all the services. But unfortunately I am not able to find any service that starts with the name 'oracle'.
There is no service that has 'oracle' name in it.

Oracle Details:
SQL*Plus: Release 11.1.0.6.0

Thanks & Regards,
Arshad
Tom Kyte
January 16, 2013 - 12:19 pm UTC

are you on the database server machine?

RE: Unable to find oracle services

Arshad, January 16, 2013 - 11:04 pm UTC

///Followup January 16, 2013 - 12pm Central time zone:
are you on the database server machine? ///

Hi Tom,
Its not a server machine. Its a normal desktop allocated to me in my office.
Installation folder shows this name: Oracle - OraClient11g_home1
Tom Kyte
January 17, 2013 - 8:30 am UTC

then you do not need any services running, the database server does. a client just connects over the network.

make sure your tnsnames.ora file is set up correctly. ask your DBA for the correct connect string.

all of the advice on this page was for a local connection to a local database running on the machine sqlplus was.


you need to be using "sqlplus user/pass@tns-connect-string" and that tns connect string needs to be set up in your tnsnames.ora (or by using whatever name resolution method your site is using - consult your DBA)

ORA-12560: TNS:protocol adapter error

kdtv, February 01, 2013 - 11:00 pm UTC

Pls goto windows services.

Select "orcleserviceORCL" and START

Huraaaaaaaii !!!

adater error

A reader, February 04, 2013 - 2:22 am UTC

hi tom
i have installed oracle11g in pc at home while starting it with username:scott
password:tiger
i got this error ora-12560:tns:protocol adapter error pl help me

RE: Unable to find oracle services

Arshad, February 13, 2013 - 6:45 am UTC

//Followup January 17, 2013 - 8am Central time zone:
then you do not need any services running, the database server does. a client just connects over the network//

Hi Tom,
What if I want the oracle which runs & connects to DB of my machine only.
Which version(Product Name) will i need?

Please Reply as this Oracle client thing is creating a lot of confusion for me.

Thanks & Regards,
Arshad.

Tom Kyte
February 13, 2013 - 8:03 am UTC

you'd need a database running on your machine then - any version of Oracle database would do. If you are just playing around, Oracle XE might be what you are looking for.

http://www.oracle.com/technetwork/products/express-edition/overview/index.html

Thank you very much

A reader, February 17, 2013 - 10:51 am UTC


Ora-12560 TNS Adapter error

clara, February 20, 2013 - 1:17 pm UTC

this error occurs when the Oracle_sid you set in the environment variables is different to the one which is in the services.you can access services in this way(start--run--services.msc)

for example if oracle_sid='Koko' (Environment variable)then service must be:'OracleServiceKoko'

It is better first to check from the services then go to edit the oracle_sid in environment variables.

Hope this comment is helpful.

ORA-12560 error because of obsolete listener configuration

Gerold Manders, February 21, 2013 - 10:59 am UTC

If it is mentioned already I don't know, but the ORA-12560 error appears quite a lot on my PC. That PC runs 2 Oracle 10g databases on Windows 2003. In Paraguay we have a lot of power failures and this error can appear after one on this PC.

As already stated, I make sure the oracle service has been started, followed by a restart of the listener.

When the ORA-12560 still persists, I check the configuration from the Listener. For whatever reason the configuration lost the database entry I need.

Only after recreating the entry in the Oracle Net Manager, saving the configuration and restarting the listener (services.msc), I am able to contact the database again.

Renaming an existing (obsolete) entry does not work at all, it is really necessary to create a new entry.

Maybe this will help someone.

TNS PROTOCOL adapter error Solving Steps

Prasad, March 12, 2013 - 1:18 pm UTC


TNS PROTOCOL adapter error Solving Step

(This Steps only Windows O.S.)

go to run then type

Services.msc

and select oracle service sct.. you will display left handside

oracle service. sct start the service..

click the start.. after process complete then close the all

windows( not shut down ) then follow this steps..

1> go to start > all program > oracle- OraHome90 > application develoment > SQL PLUS

2> then select SQL PLUS you will display UserName , password, HostString

3> enter UserName- SCOTT

4> enter Password- Tiger
( This user id and password is by default in oracle )


UAC

Evgeny, March 27, 2013 - 5:42 pm UTC

am getting protocol adapter error

padmalatha, April 30, 2013 - 7:56 am UTC

while entering the user name and password am getting protocol adapter error what should i do

Re : "ORA-12560: TNS:protocol adapter error "

Yuvraj, May 17, 2013 - 1:35 pm UTC

Hi face similar issue when i tried to login using SQLPLUS....when i checked i found out that i had installed multiple Oracle Homes which were causing the issue... I suggest to use the correct SQLPLUS.exe from your current home and that should resolve the issue if you are using multiple Oracle Homes.

Please revert with tnsping, lsnrctl command Output and also content of TNSNAMES.ORA of your current file in use if this is not the scenario which i posted above

Tyler, June 04, 2013 - 6:25 pm UTC

Reviewer: E Ferguson from Chesapeake, VA
I switched the order (client\bin path follows
server\bin path) in the PATH and that fixes the error!
This worked!
-----------------------------------
This is the answer. My original path:
C:\app\<user>\product\11.2.0\client_1;C:\app\<user>\product\11.2.0\dbhome_2\bin;...
TNS:protocol adapter error

After reversing the order to:
C:\app\<user>\product\11.2.0\dbhome_2\bin;C:\app\<user>\product\11.2.0\client_1;...
It works!

ajaykumar, June 12, 2013 - 8:11 am UTC

services.msc is working thanks frd..helpful...

ORA-12560: TNS:protocol adapter error

MIB, July 04, 2013 - 6:18 am UTC

When the Advanced installation of ORACLE 10g then this problem occur...and the services.msc do not show the any ORACLE services which can be start...??
If any solution...is there and the reason of this problem...?

problem in installing and starting 12c

veer, September 03, 2013 - 1:53 am UTC

i was trying install oracle latest release 12c. suring installation it gave many error like file not found 'xyz'.
for every such error i was pressing continue, at thee installation step it got stuck on "updating registry.....home1" (59%)
after that i wait for 1 hour but no progress. i tried to install 8 times. always same error file not found and then stuck at 59 %.
i changed re-downloaded winzip and 12c oracle software.
and in 11g version i'm getting error "ORA-12560: TNS:protocol adapter error "
i restarted all the services from service.msc but still same error

os: windows 8
ram: 8Gb

Tom Kyte
September 04, 2013 - 6:41 pm UTC

I'm sorry, but I don't have and don't plan on having windows 8 personally. I've never installed on that platform and probably never ever will.

You probably should have stopped at the first error, gotten on the otn forums or opened a tar with support.

ORA-12560: TNS:protocol adaptor error

mali, September 06, 2013 - 8:22 am UTC

hi
i have oracle11g,for my project i create 3 database via configuration assistant tools then delete one of them
an after this i have this error: ORA-12560: TNS:protocol adaptor error.
by mistake both of my database have same pasword
for ex: when i want to connect one of this data base with system user, i have one pasword and perhaps database dont know connect which one.

I start all services
set oracle_sid=orcl
I run lsnrctl
I tns ping check & my listener.ora
and I loggin with sysdba@oracle_sid

but i have this error again

pleas help me
tnx

ORA-12560: TNS:protocol adapter error

MUTHUKUMAR PANDI, September 11, 2013 - 6:18 am UTC

ORA-12560: TNS:protocol adapter error
TYPE services.msc in windows search. Right click on services.msc and run. Then services window will pop up. In that try to find OracleServiceXe->Right click->Start.
Then go to sqlplus give ur username and password. It will get connected.

Need more insight on this issue

Firdous, September 30, 2013 - 7:57 am UTC

Dear Tom,

Your blogs as usual are extremely helpful and acts as catalyst for DBA's and Developers to resolve their issues.

I am stuck up with the same issue( I have Oracle8iEE installed on Windows2000, Connected to it through RDP)

I tried all possibliities to get my access on sqlplus session but so far no luck, getting ORA-12560.
The fact is, Services are up for listener/database(though not created yet(but service created through ORADIM successfully).

I am not sure, If it is a Terminal server(Dont know about this server), but is it an issue with Remotely connected access via RDP.

Please help me out.

Thanks

tns adapter error

mehmet yener, November 13, 2013 - 3:07 pm UTC

I installed plsql and try to login but I dont knwo my username and pass anyway my probles iss tns adapter error but I want to know my username and password when should I create it ? how can I get them ?

Thank you.
Regards

Need to Restart the service

Sengpala, November 16, 2013 - 3:12 am UTC

I am using Oracle XE 11g in Windown 7, and having the same issue. After reading this post, I stop all system/applications that connects to the db and restart the OracleServiceXE service. Then I am able to connect with Sqlplus.

Hope this help.

ORA-12560: TNS - PROTOCOL ERROR

Raju Edaboina, December 05, 2013 - 2:52 pm UTC

Even after restarting the oracleserver service, i am getting the same error(ORA-12560: TNS - PROTOCOL ERROR).Can anyone answer for my question??
My oracle service name oracleServiceDBTEST(my service name is dbtest.)

BillNet

Bill, February 05, 2014 - 3:46 pm UTC

Some of the issues I noticed could be fixed by installing a Microsoft Loopback Addapter. Just a thought. This solved a problem for me a while back.

Solved for 11g on Windows 2008 & Windows 7

Joseph Argenio, April 03, 2014 - 11:38 am UTC

We have a Windows 2008 DB server and Windows 7 client with Oracle 11.2 and the fix for one of our client programs getting the "Protocol Adapter" error was to set a system environment valiable: TNS_ADMIN equal to the folder location of the tnsnames.ora file.
Search the control panel for "env", then create a New value
We set TNS_ADMIN = /app/me.user/product/11.2.0/client_1/network/admin
your path may vary.

ORA-12560: TNS:protocol adapter error - Resolved

JF, May 03, 2014 - 2:43 pm UTC

Hello! Thank you for the explanation and example! I run the Oracle Express 10g version on my laptop with Windows 7 and Oracle gave me the ORA-12560 error after I allowed JAVA to update.

Per your suggestion, I went to Control Panel | Administrative Tools | Services and restarted both the OracleXETNSListener and the OracleServiceXE. Now, Oracle is working fine. I have a deadline tomorrow so your help just allowed me to get up and running with only an hour lost.

Thanks again!

It worked

Leena, June 09, 2014 - 6:44 pm UTC

Restarted oracleOUIHomeClientCache in services and it worked.

Thanks a lot!

Tejas

Tejas, June 15, 2014 - 4:54 am UTC

Nice solution of starting from servies.msc by jagannath.
Thank you

oracle

soma saha, July 20, 2014 - 7:30 am UTC

how to solve ora-12560:tns:protocol adapter for 10g

Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g

karincayazilim, August 31, 2014 - 6:43 pm UTC

C:\Users\KARINCA>tnsping XE

TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 31-AºU-
014 21:33:50

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = KARINCAB)(PO
T = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (10 msec)

C:\Users\KARINCA>SQLPLUS

SQL*Plus: Release 12.1.0.1.0 Production on Sun Aug 31 21:38:15 2014

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

Enter user-name: system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: syspdks
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: system@XE
Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> exit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bi
 Production

C:\Users\KARINCA>SQLPLUS

SQL*Plus: Release 12.1.0.1.0 Production on Sun Aug 31 21:40:15 2014

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

Enter user-name: syspdks@XE
Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL>


SOLUTION

karincayazilim, August 31, 2014 - 7:37 pm UTC

CLEAR
WINDOWS PATH:

REMOVE these:
C:\oraclexe\app\oracle\product\12.1.0\client_1\bin;
C:\oraclexe\app\oracle\product\12.1.0\client_1;

ADD these:
C:\oraclexe\app\oracle\product\11.2.0\server\bin;
C:\oraclexe\app\oracle\product\11.2.0\server;

Because the system gives an error in two ways.
You can define the order as follows:

::::::::Add path in order:::::::::SOLUTION:::::::
C:\oraclexe\app\oracle\product\11.2.0\server\bin;
C:\oraclexe\app\oracle\product\11.2.0\server;
C:\oraclexe\app\oracle\product\12.1.0\client_1\bin;
C:\oraclexe\app\oracle\product\12.1.0\client_1;

oracle services

chakravarthi, November 17, 2015 - 3:23 pm UTC

i dont find oracle services in services.msc
Chris Saxon
November 18, 2015 - 6:36 am UTC

Then you most likely dont have an oracle database created.

You need to run the Database Configuration Assistant

Another possible fix (Windows)

Patrick Martin, April 21, 2016 - 3:07 pm UTC

On windows, I faced the same issue. None of the prescribed solutions worked for me. However, I stumbled across this which fixed me.

I run the default XE service.

1. Open up windows services by running "services.msc"
2. For both OracleXETNSListener and OracleServiceXE (where XE is my Oracle SID, it may differ for you) Right click each service and select properties.
3. Select the Log On tab.
4. If you are using "Local System account", as I was, then ensure "Allow service to interact with desktop" is selected.
5. Restart the service.

Doing this for OracleXETNSListener and OracleServiceXE fixed my issue.

Best of luck!
Chris Saxon
April 22, 2016 - 4:40 am UTC

Thanks for the contribution

Connor

It's Really Good Working...

Deepak, May 17, 2016 - 5:40 pm UTC

Hello Sir...This Service Really Working Thanks For Give Your Time Here and This Small and Good Trick or Solution is Perfect

oracle 10gr2 installation TNS adaptor error

Ranjan, May 13, 2017 - 8:01 pm UTC

Respected Tom & Team,

Thank you again for the good work.

Here I am struggling with oracle 10g installation in windows 7 OS.
I have installed many times before in my windwows 7 but recently it is throwing error DATABASE CONFIGURATION ASSISTANT as ORA-12560:TNS : protocol adapter error ( and it exactly thrown on the screen when it is ORACLE DATABASE CREATION IN PROGRESS %2 completion screen).
I have tried installing many times but it throws same error at same point of time.

apart from this at the begining of installation one error I am getting which I checked as userverified.
below is the error log attached where it showing network configuration requirement failed.

I googled for the exact error and saw few people got the same error and nowhere I found solution to fix it , but in few cases
repairing windwos OS fix the issue which I dont really want to do as I should understand the actual cause of the issue and the fix.


Checking operating system requirements ...

Expected result: One of 4.0,4.1,5.0,5.1,5.2
Actual Result: 5.1
Check complete. The overall result of this check is: Passed
=======================================================================

Checking service pack requirements ...

Expected result: 1
Actual Result: 2
Check complete. The overall result of this check is: Passed
=======================================================================

Checking physical memory requirements ...

Expected result: 256MB
Actual Result: 1023MB
Check complete. The overall result of this check is: Passed
=======================================================================

Checking Network Configuration requirements ...

Check complete. The overall result of this check is: Failed <<<<
Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
Recommendation: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system.  See the Installation Guide for more details on installing the software on systems configured with DHCP.
=======================================================================

Validating ORACLE_BASE location (if set) ...

Check complete. The overall result of this check is: Passed
=======================================================================

Checking Oracle Home path for spaces...

Check complete. The overall result of this check is: Passed
=======================================================================

Checking Oracle Home path for location ...

Check complete. The overall result of this check is: Passed
=======================================================================

Checking for proper system clean-up....

Check complete. The overall result of this check is: Passed
=======================================================================

Checking for Oracle Home incompatibilities ....

Actual Result: NEW_HOME
Check complete. The overall result of this check is: Passed
=======================================================================


################




Long live :)
Connor McDonald
May 15, 2017 - 4:15 pm UTC

Try this.

Use DBCA to create scripts to generate your database.

Then use NETCA to precreate a listener.

Run the db create scripts manually.

Please elaborate

Ranjan, May 22, 2017 - 12:34 pm UTC

Please explain little bit how to configure manually.

Connor McDonald
May 23, 2017 - 1:21 am UTC

Then use NETCA to precreate a listener.

- create listener
- give it a name
- choose a port (typically 1521)
- done (this will start the listener as well)

Use DBCA to create scripts to generate your database.

- choose all the options as per normal
- on the last page you can either "create database" or "create scripts"
- choose the latter

Run the db create scripts manually.

- the scripts will be saved in oracle_home/admin/db/scripts
- run them via command window or shell

continuation to my previous post

ranjan, June 15, 2017 - 6:28 pm UTC

Thank you for the steps.
But it didnt help. The error I was getting because of the OS was curropted( as regedit entry were deleted by mistake and many os with files were not available). I tried installing many times(both manually and automatic) but nothing helped.
Finally I reinstall the OS and all went fine.
If anybody who is getting same exact error, please try to install the oracle database first, if it is not helping , please dont waste your valuable time, the only solution is to reinstall your OS(if your OS got corrupted like mine), and post that you are welcome to install oracle database.

:)
Connor McDonald
June 17, 2017 - 1:17 am UTC

Thanks for getting back to us

plz give quick reply

raju, July 12, 2017 - 6:48 pm UTC

TNS: Protocol Adapter Error
Chris Saxon
July 13, 2017 - 9:50 am UTC

Please give thorough explanation of what you're doing & the exact error you got

Helpful

A reader, December 14, 2017 - 12:36 am UTC


A reader, January 19, 2018 - 6:47 am UTC

Résoudre le problème de connexion ORA-12560 TNS protocole adapter

https://www.youtube.com/watch?v=tVr3fmS1JX4

ERROR:ORA-12560: TNS:protocol adapter error

A reader, February 09, 2018 - 6:34 am UTC

i am facing this issue on run sql command promt.
i have resolved this issue
ans:
1) got to windows services.
2) start the oracle MTS RECOVERY SERVICES.
3) START THE ORACLESERVICEXE

A reader, February 11, 2018 - 5:04 am UTC

yes it is long out of date.

Connor McDonald
February 13, 2018 - 12:49 am UTC

Can you elaborate on why this is out of date ?

Yes the versions used are old, but the advice is still valid no ?

find my problem

ankur gupa, February 20, 2018 - 4:41 pm UTC

ORA-12560: TNS:protocol adapter error
Chris Saxon
February 21, 2018 - 3:25 pm UTC

...?

21554001000110

0548541, July 09, 2018 - 8:30 am UTC

450004500DHY
Connor McDonald
July 12, 2018 - 9:39 am UTC

I agree.

A reader, September 16, 2018 - 11:49 am UTC

Really, It was useful for me.

After starting oracle services,I am able to login in database now.

Thanks

tns adapter error

ARVINTHSAMY M, February 22, 2019 - 4:50 pm UTC

after installing oracle 12c in my lap while logging in it sows tns adapter error. to make instace to run by manual ive approached it in services.msc. but there was also no oracle related instace to make it run....
what do i have to do ?

Connor McDonald
February 23, 2019 - 6:29 am UTC

If you don't have anything starting with 'Oracle..." in your services, then it sounds like you don't have Oracle on the machine, no?

A reader, February 26, 2019 - 11:39 am UTC

please window 10 +vm +solaris 11.3 +oracle 11g


then what i do

Connor McDonald
February 28, 2019 - 1:53 am UTC

Try this:

Log on to your VM (I assume the VM is solaris?) as the oracle user.

Run ". oraenv" to set your environment. If this does not work, check the contents of /etc/oratab or /var/opt/oracle/oratab to see if you have the right database definitions.

That should set your environment correctly, then try sqlplus / as sysdba

A reader, February 26, 2019 - 11:39 am UTC

please window 10 +vm +solaris 11.3 +oracle 11g


then what i do

RE ORA-12560: TNS:protocol adapter error

David Hays, November 03, 2019 - 8:41 pm UTC

Good lord....
Thanks Tom - that's exactly what was wrong. How embarrassing.

-dave
Chris Saxon
November 04, 2019 - 1:22 pm UTC

:)

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database