ORA-12560: TNS:protocol adapter error
Ora12560.bat
Right click this link, choose save as and enter ora12560.bat as filename.
Next run the batch file in a dos box.
Following applies for Windows:
First of all, make sure you have set the correct ORACLE_SID:
C:\>sqlplus system/manager SQL*Plus: Release 11.2.0.1.0 Production ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: C:\>set ORACLE_SID=ORA112 C:\>sqlplus system/manager SQL*Plus: Release 11.2.0.1.0 Production Connected to: Oracle DatabaseYou can either set it before you startup sqlplus, or set it in the registry (HKEY_LOCAL_MACHINE\Software\Oracle\Key_
When you have created a new registry value, make sure to open a new dos box before starting sqlplus.
If this does not work, probably the OracleService for the database is not running.
Check if the service is running, if not, startup the service.
It might be that the service is setup to only startup the service and not the instance as well.
On Windows, use the oradim utility to control this behaviour.
You will manually have to startup your database
C:\>sqlplus SQL*Plus: Release 9.2.0.7.0 - Production Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name: / as sysdba ERROR: ORA-12560: TNS:protocol adapter error Restart the service C:\>sqlplus SQL*Plus: Release 9.2.0.7.0 - Production Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name: / as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 126951228 bytes Fixed Size 454460 bytes Variable Size 109051904 bytes Database Buffers 16777216 bytes Redo Buffers 667648 bytes Database mounted. Database opened.If the service is running, you might be connected to the server using the Terminal Service Client / Windows Remote Desktop.
This is not supported by all versions of Oracle (before 9i).
One possible work around is to set the LOCAL environment variable in a dos box and try to connect again.
The difference between using LOCAL instead of ORACLE_SID is that LOCAL will try to connect through the listener, so it should run as well.
eg:
C:>set LOCAL=ORA920 C:>sqlplus SQL*Plus: Release 9.2.0.7.0 - Production Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name: / as sysdba ERROR: ORA-12541: TNS:no listener
C:>set LOCAL= C:>set ORACLE_SID=ORA920 C:>sqlplus SQL*Plus: Release 9.2.0.7.0 - Production Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name: / as sysdba Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production
If the service is started and you are not using terminal services/remote desktop (using an unsupported version of Oracle) and you are relying on the default ORACLE_SID set for the Oracle Home Directory, than you're probably using the incorrect %oracle_home%.
Use Oracle Locator express to change the Oracle Home, startup a new command prompt and try again.
If you are on Windows, you can use following batch script to do some default checks:
Ora12560.bat
Welcome to our forum for Oracle error: ORA-12560 Add your own message
please send me complete solution to create database in Oracle 9i
ORA-12560: TNS:protocol adapter error
then i entered scott as user, tiger as password after that i got a message like this
ERROR: ORA-12560: TNS:protocol adapter error
i install oracle9i in my system(xp2).then using username as system and password as manager and hoststring as no. but did not connect to database please help me.
This solved my problem.
http://compquiz.blogspot.com/2010/05/oracle-trouble-shooting.html
How can we do this... commands
Which services i have to start to resolve the issue.
plz give me the sol asap.
Thanks
ruchi
Can you please post the output of the batch script?
Probably you have no correct service installed
i also tried sys & manager it will also not worked.
n btw sorry for grossing u out with my lack f info for u ppl seem too la-di-da for words.
n btw sorry for grossing u out with my lack f info for u ppl seem too la-di-da for words.
You can use the database configuration assistant (dbca) for this
Check the forms configuration and adapt accordingly
without string name,it is not getting connected..geeting tns adapter error..help!
how can i solve this error.
please help me.
my db sid is orcl how can i find its serviice is runing.
rgds n advance
following errors are display while i am connecting sql*plus,
ora 12560 : tns protocol adapter error. How to solve this problem
set oracle_sid=orcl;
sqlplus /nolog
sql> connect sys/sys as sysdba
get this error
ORA-12560: TNS:protocol adapter error
please help me
Enter user-name: / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
then i set the :>set LOCAL=ORA920
now the error change form 12560 to 12154
plz help me
Check your tnsnames.ora file for the definition of ORA920
now i have given conn "/ as sysdba".
It is asking password.
Enter password:
what should i give here.
How to find the password for this.
You can try with oracle, manager, change_on_install
Any thoughs are going to be very appreciated...
Pedro
I even tried out the above solution C:\>sqlplus entered username and password, the result is the same error message, can you help me please..
Is it the one of forms? If so, change it to the one of the database.
You can use Oracle Locator Express to change the homes.
I even tried out the above solution C:\>sqlplus entered username and password, the result is the same error message, can you help me please..
thank you..
Can it be that it crashes for some reason?
But it throws an error Protocol Adapter error. Plz help me to solve this problem.
Thanks in advance
We are facing an issue while connecting to Oracle 10G Express Edition via SQL PLUS and OTL Interface.
It is giving the below error:
a??ORA-12560: TNS:protocol adapter errora??
This appears to be a common error with ORACLE. We tried all the options that we read in various DB forums.
Svrmgrl prompt appears. type Connect Internal
then again type startup
and open your oracle. It will be working now!!!!
Enter your message
waht to type in vista.
When I type in vista svrmgrl it shows no result foun & no prompt opens ,, pls help.
Starting as of Oracle 9 you will need to use sqlplus instead of svrmgrl
I checked for services...
What should I do next?
If not, please restart the service and check the oradim.log in your %ORACLE_HOME%/dbs directory
When you connect as "/ as sysdba", does it say "Connected to an idle instance" ?
When you try to connect to your database, you will see this behavior.
You have to change the default Oracle home back to the original one.
you can use our free tool "Oracle Locator Express" to change the Oracle home.
Click downloads on the left hand side, and choose the correct download.
Could not start the OracleOraDB10g_home1TNSListner service on local Computer
Error 3: The system cannot find the path specified.
To remove and recreate the Oracle Service:
oradim -delete -sid ORCL
oradim -new -sid ORCL -startmode AUTO
To remove and recreate the listener service.
You can use our free tool "Oracle Listener Remover" to remove the listener.
next recreate the listener service by typing:
lsnrctl start
Now whenever i try to enter the user name and password it giving me a ORA 12560 error. After that i deinstalled the software and reinstalled the software but the some component of the Oracle database is not installing properly and previously whenever i installed the oracle9i it ask me for the SYSTEM and other account password but now it not assking and even if i try the default id like
SCOTT and TIGER it not working and giving me ORA 12560 error....
If anyone is There please help me out because i cleared first paper of OCA 1zo 007 and just started prepartion of 1zo 147 paper and due to this mess i am not able do the practicse and check the output and how the query run
Tengo instalado forms 10g, pero cuando quiero correr la forma con el Oc4J arriba, el formulario no se muestra y me despliega el mensaje del ora-12650, y me muestra la pantalla de conexion, trato de conectarme a la base de datos y se queda hay no mostrando nada.
La conexion de sqlplus la ejecuta bien no tengo problemas, por favor si alguien me puede dar una luz se lo agradeceria.
Willi
username: scott
password: tiger.
it shows an error that is protocol adapter error. I don know what database name i gave for my database.. please tell me how to solve that protocol adapter error problem.. I need oracle 9i urgently.. Can anyone help me.. send the details of solving the problem how to solve it..
I installed oracle 9i database in winxp by giving software only option. Now i need to
create database on this. I know to create db in linux but i wanted to know how to create in winxp.
Please help me reguarding this issue.
but as i typed
SQL>startup
ora-01081:cannot start already-running
oracle - shut it down first
please solve my problem
i hv even started the service from my computer>manage>services
kindly help fast i hv to give my oracle xm on 7th september 08
please help....
While running oracle 10g form, the erroe message "ORA-12560: TNS:protocol adapter error" appears.
Although there is no problem while connecting to sqlplus.
Thank you..
Ahmad.
While running oracle 10g form the error message "ORA-12560: TNS:protocol adapter error" appears.
Although there is no problem while connecting to sqlplus.
Thank you..
Ahmad.
D:\>sqlplus
SQL*Plus: Release 9.0.1.0.1 - Production on Tue Sep 16 20:54:07 2008
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-24314: service handle not initialized
ORACLE initialization or Shutdown in Progress...
It appears when i tried to login to SQL using SCOTT/TIGER..
Thanx in advance..
sqlplus "/as sysdba"
startup force
Help me....................
C:\>sqlplus
SQL*Plus: Release 9.0.1.0.1 - Production on Wed Oct 22 14:32:07 2008
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-24314: service handle not initialized
Enter user-name:
what should i do?
I have a problem in SQL Developer and the problem is that is that getting connected to Oracle instance namely ORCL but i can access oracle using same credentials using SQL Plus but not connecting in SQL Developer tool. When i click on test it show Success but it is not neither connect or show some response
Is it basic authentication? If so, are you using the SID or Service Name?
The Connection type that i use is mostly TNS but it doesn't show any response even if i chooses the basic connection type too In Basic i use SID as 'ORCL'
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\landon kelsey>cd\
C:\>sqlplus / as sysdba >>>>>> I tried all sorts of combinations (works everytime under Fedora 9)
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Dec 31 21:19:57 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
XP Prof SP3 UNEVENTFUL SUCCESSFUL INSTALL...NO ERRORS
Yes I created a database!
ALL THESE 3 ARE SET
ORACLE_HOME
ORACLE_SID
ORACLE_GDN
FIREWALLS INTRUSION PREVENTION OFF
LISTENER ON
ORACLE DATABASE SERVER IS STARTED
REBOOTED MANY TIMES
I DO THE SAME THING UNDER FEDORA 9 AND EVERYTHING IS OK!
I've done a search on 12560 in this forum and I seen nothing I've forgotten.
I also did a google search and NOTHING
I could understand if it had been a week or two and I had messed with all sorts of internal.
It must therefore be something simple!
The problem with most Oracle docs is that they jump immediately
into the deep details where neophytes can't swim. This doc problem has only gotten worse.
Marketing content is also in the way.
files but NOT!
SQLDEVELOPER shows tabs for MySQL and MS SQL Server! Great! I don't remember seeing that under Fedora 9!
In order to solve your problem, can you please post the following info.
Open a dos-box (command prompt) and issue the following set command to see your ORACLE_SID environment
set ORACLE_SID
next, post the result of path command
path
Now, download following tool, choose (Download demo project - 4.44 Kb):
http://www.codeproject.com/KB/cs/svcmgr.aspx
You might need to have an account, it's free.
When you've downloaded the tool, execute it with following parameters:
C:\>svcmgr YOURMACHINENAME OracleServiceORA11G
Service Name : OracleServiceORA11G
Display Name : OracleServiceORA11G
Service Status : Running
Service Type : Win32OwnProcess
Service Can Stop : True
Service Can Pause / Continue : True
Service Can Shutdown : True
0 Depended Service(s) :
Change ORA11G of parameter OracleServiceORA11G to match your ORACLE_SID
Please paste the output of all commands so we can check if all this is ok.
You might also want to copy the following logfile:
C:\oracle\product\11.1.0\db_1\database\oradim.log
The directory can be different of course, change it to reflect your environment.
Set LOCAL=
set ORALCE_SID= MySID
My TNS-LISTNER IS working, database instance also running. I am able to connect through client but not to local instance from Remote Desktop
Your help is highly appreciated..
Thanks in Advance
KING
I have applications running on a Windows 2000 server.
They talk to an oracle 8.1.7 db on the same box via BDE.
Why is it that my applications start giving the ORA 12560 Protocol Adapter Error after about 2 days of problem free running.
There is also a Windows NT box with applications talking to the same DB which continue to run despite the errors on the applications on the first box.
Can anyone help?
Did you run the batch file? What was the result of the run?
I can able to login from the SQLPLUSW.exe with the required user/pwd and host
but when i try on SQLPLUS.exe the ORA-12560 is coming
Now this error is been resolved when i do "%oraclepath%>bin>sqlplus /nolog" and next is SQL>
i did
D:>path% SET LOCAL=ORA920
D:>path% SET ORACLE_SID="MYSID"(i know the name :) )
ANd Now when i directly used %path%>bin>sqlplus and it ask for username/pwd
user: valid one
password: valid one too : but this give me the ORA-12124 : TNS could not resolve the service...
Please provide the solution
but when i try on SQLPLUS.exe the ORA-12560 is coming
Now this error is been resolved when i do "%oraclepath%>bin>sqlplus /nolog" and next is SQL>
i did
D:>path% SET LOCAL=ORA920
D:>path% SET ORACLE_SID="MYSID"(i know the name :) )
ANd Now when i directly used %path%>bin>sqlplus and it ask for username/pwd
user: valid one
password: valid one too : but this give me the ORA-12154 : TNS could not resolve the service...
Please provide the solution
I have taken help from your website about error 12560. but not get successful result.
your website give help like
C:>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
Restart the service
C:>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 126951228 bytes
Fixed Size 454460 bytes
Variable Size 109051904 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
but when i am typing like
c:\>sqlplus (then Enter)
SQL*Plus: Release 9.2.0.7.0 - Production
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
Again want user-name not like your giving example on website
Please give detail how to solve this problem.
You can run the batch file which can be downloaded on top of the tip, this will correct some incorrect settings.
So please run the batch file, and put the output here if you still encounter problems.
i uninstalled it from start>all programs>oracle installation products>universal installer>deinstall products>selecting all trees and subtrees>remove.
i installed the setup again.then i got the listener but still the error persists.
but during the installation i notted that database failed to be created.i created it manually by:-
all programs>oracle-oracle>configuration and migration tools>database configuration assistant(one has to remember the "name.domain" filled during the installation,other settings are default one).
=> Install oracle 9i normally...
=> Go to "Database Configuration Assistant" and create a new DB...
This creates a new instance for you to use in SQL Plus.
Once the DB is successfully created U r DONE!!
Now open SQL plus and use scott/tiger to login.
Enjoy
i need oracle 10g dbase ,not oracle9i
I installed oracle10g db using windowxp ,now when i want to login in sqlplus it give an error i-e
ora12560 tns:protocol adapter error
plz give me essey solution
i will be thankful
ahmad
Enter your message above problem still iam having.pls help
What is the output when you run the batch script?
HI
after installing the oracle software i entered the
username:scott
password:tiger
it showed me an error sayin
ora-12560 TNS:protocal adapter error..
what shd i do?
can u plz tell me in detail
regards
aparna
Did you run th ebatch file? What is the result of it.
What checks did you already perform? Did you follow all steps in the explanation?
I had the same issue (ora-12560) when I tried to logon to Oracle database through remote desktop connection. If I directly logon to the console or logon to the console through VMWare, I do not have ora-12560 problem to logon to the database.
When I connect with form builder and then its connectivity with Ecplorer the Tns Error 12560 tns protocol error appear
make sure you provide a SID when making a connection
Iam not able to perform the error repairing thing as illustrated as above...
Are you on Windows? If so, did you try to run the batch script?
What is the output, can you please post it here?
i have an oracle database installed and it was working perfectly until recently. when i open the oracle instance it displayed the error message ORA-01033 oracle initilization or shut down in progress and when trying to connect from the SQLPLUS it will display the error message ORA-01260 TNS protocol adapter error. I have tried every possible methods please help.
Was a new ORACLE_HOME installed recently on this database server?
If so, and you are on Windows, you can use the Oracle Locator Express free tool to switch back to the original ORACLE_HOME.
If that still does not work, and you are on Windows, please post the results of the ora12560.bat file you can find on top of this description
oracle 10g inst was successfull but I am trying to login in the SQL PLus by giving the scott , tiger it gives me an error ORA-12560: TNS:protocol adapter error please help me as soon as posible
Is the OracleSID Service running on your system?
Open the Services Control Panel and see if it is active/running
I run the ora12560.bat but it doesn't work and it gives me this error :
Unable to start the OracleServicemydb
Use oradim to create a service:
oradim -new -sid mydb
what should I do ?
If the database you are trying to access is called MYDB, you will need to execute the command as given by the batch script:
oradim -new -sid mydb
I run the ora12560.bat but it doesn't work and it gives me this error :
Unable to start the OracleServicemydb
Use oradim to create a service:
oradim -new -sid mydb
what should I do ?
after installing the oracle software i entered the
username:scott
password:tiger
it showed me an error sayin
ora-12560 TNS:protocal adapter error..
what shd i do?
can u plz tell me in detail
but actually my default database is deleted from my friend & my own database is present in oracle. i don't want reinstall oracle. i think if i restore my default database its problem will solve so plz help me.
What is the result of the batch script?
after installing the oracle software i entered the
username:scott
password:tiger
it showed me an error sayin
ora-12560 TNS:protocal adapter error..
what shd i do?
can u plz tell me in detail
but actually my default database is deleted from my friend & my own database is present in oracle. i don't want reinstall oracle. i think if i restore my default database its problem will solve so plz help me.
REGARDS,
TUSHAR
i created 14 rows table....i want see in "empno,ename,...................deptno"the headdings are in oneline
type as below":
desc tablename;
hi i m viney i want to soultion about error 12560 tns protcal adapter error. how can i connect with oracle.
What are the steps you already performed to investigate this issue?
Did you run the ora12560.bat file? What was the output?
Can anybody help me out
First I install Developer 6, then i install oracle 9i.
When i try to connect to sql plus using scott/tiger or system/manager it gives following error
ORA-12560: TNS: Protocol adapter error
Can anybody urgently help me out please.
Thanks in advance
Ahmee - the known stranger
Use our Oracle Locator Express to switch back to the correct Oracle Home (the one of your database).
You also need to provided an Oracle SID when making the connection (your database name)
Hi All,
Can you please help me to resolve the error of TNS protocol. I have tried all the meathod mentioned above but none of it works for my system. I have Oracle 11g and i have dell laptop of 62bit OS. I have downloaded 64 bit version of 11g but still i am getting this error.Can someone help me with this?:(
Thanks
Theju
So did you set the ORACLE_SID before logging in via the command prompt?
Do you have a screenshot, or the output of the ora12560.bat command you can download from this page?
i have set the ORACLE_SID to orcl but still its not working. I followed the below steps.
C:>set ORACLE_SID=ORCL
C:>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: here i tried for sys,system,mysys,scott
Enter password:- Tried manager,oracle,tiger
It dint work:(
Hi,
I have problem logging in through command prompt. I installed oracle 10g on my system and it worked properly for a while then when i tried o open it on dos i get the message Error - ora - 1250: TNS: protocol adaper error. Pls i need some assistance on how to solve this problem. Thanks
Either set the ORACLE_SID before you connect to the database in ms-dos, or set the ORACLE_SID in the registry (HKEY_LOCAL_MACHINE\software\oracle\KEY_Oracle...)
i have set the ORACLE_SID to orcl but still its not working. I followed the below steps.
C:>set ORACLE_SID=ORCL
C:>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: here i tried for sys,system,mysys,scott
Enter password:- Tried manager,oracle,tiger
It dint work:(
So if you open up the Services window from Control Panel, you do have a service named OracleServiceORCL and it is running?
I did copy all the files to standby and trying to start the stand by with the credentials of primary database.
I am getting the error-ora - 1250: TNS: protocol adaper error
I did set the SID
Thanks in advance for the help.
James
Sir
When starting the stand by server logical getting error ORA-01031:insufficient privileges
Thanks
James
Make sure your user is in the ORA_DBA group
Make sure sqlnet.authentication_mode is set to NTS
Check the ORA-01031 error for more information
I DOWNLOAD THE ORACLE 10G FROM THE NET AND INSTALLED IN MY SYSTEM AND SAME WAS SUCCESSFULL, BUT I AM NOT ABLE TO OPEN THE SQL*PLUS, I REQURIED A USERNAME,PASSWORD AND HOST STRING FOR THE SAME. i ALREADY TRIED SYSDBA/MANAGER,SCOTT/TIGER BUT I AM NOT ABLE TO LOGIN. KINDLY HELP ME IN THIS REGARDS. I AM GETTING THE ERROR : TN PROTOCAL ADAPTER ERROR.
Did you set a ORACLE_SID before connecting to the database?
If you do not provide it during connect, it relies on the default ORACLE_SID. If this is not set as well, you will get this error.
So either set a ORACLE_SID, or connect using the SID: sqlplus system/manager@orcl
How to resolve error number ORA-12560: protocol adapt error in oracle, whenever i open SQL PROMPT it will occur. what can i do to not occur again this error.
How to resolve error number ORA-12560: protocol adapt error in oracle, whenever i open SQL PROMPT it will occur. what can i do to not occur again this error.
It's wrong info..
plz..dont beleive this ......
A lot of people were able to solve their problems using this information.
What's wrong with the info? Does it not work for you? If so, what steps did you do of this note? Did you run the batch file which is included? It should fix/tell you most of the common mistakes.
If after all these steps you still get this error, don't be afraid to supply some positive information/steps/examples of the actions you did, and we'll try to solve your problem. For free.
i'm using Oracle 10g in Windows 7 32-bit.
initially it was working properly..
But when i installed quick Heal total security 2010 after that i'm unable to connect Oracle 10g database.
while connecting i got error message as----
ERROR:
ora-12560 : TNS: protocol adaptor error
please help me out with this error.
Check that the install program did not remove the Oracle software folder from the %PATH% variable.
If so, reinclude your %ORCEL_HOME%/bin back to the PATH
Check to make sure you still have a registry entry HKEY_LOCAL_MACHINE\software\oracle\Key_<your oracle home name>, and that it includes an entry ORACLE_SID wjich points to the correct ORACLE_SID.
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.