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
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>
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
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
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.
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"
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
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.
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
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.
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
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
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
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?
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.
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.
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
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.
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.
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
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
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
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>
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
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
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.
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
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
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!
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 :)
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.
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.
:)
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
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
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.
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
February 21, 2018 - 3:25 pm UTC
...?
21554001000110
0548541, July 09, 2018 - 8:30 am UTC
450004500DHY
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 ?
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
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
November 04, 2019 - 1:22 pm UTC
:)
ORA-12560: TNS:protocol adapter error
Vib, November 16, 2022 - 5:44 pm UTC
I am trying to install Oracle xpress edition in my laptop. every time it fails with error ORA-12560: TNS:protocol adapter error
Kindly advise and how to contact oracle tech support for same if need call assistance.?
November 21, 2022 - 11:57 am UTC
I've got a quick install video - see if that helps
ORA-12560 : TNS:protocol adapter error
A reader, November 23, 2022 - 8:44 am UTC
Oracle backup failed: ORA-12560 : TNS:protocol adapter error
Oracle backup failed: RMAN-04005: error from target database:
Oracle backup failed: RMAN-00554: initialization of internal recovery manager package failed
Oracle backup failed: RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
Oracle backup failed: RMAN-00571:
I received this error message while RMAN backup and even not able to connect through OS using "sqlplus / as sysdba".
Database version is: 11gR2
OS: Windows 2012R2
Any clue for this?
November 25, 2022 - 5:21 am UTC
Check the service (Start => Run => services.msc) is started.
ORA-12560 : TNS:protocol adapter error
A reader, November 23, 2022 - 9:02 am UTC
D:\oracle\11gr2\BIN>sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Wed Nov 23 08:59:48 2022
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error