ORA-12560: TNS:protocol adapter error

    Following applies for Windows:

    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.


Commercial
Forum Messages
26-JAN-2008 03:31:19Mohammed Abdul Quddus Reply
I wann create database from command prompt I created an instance init but whenever i m going to start that service by using oradim service not start.
please send me complete solution to create database in Oracle 9i
ORA-12560: TNS:protocol adapter error
26-JAN-2008 03:32:59Regarding AuditMohammed Abdul Quddus Reply
Information about Audit.
How can we do this... commands
03-FEB-2008 13:50:27errorKaviarasu Reply

Which services i have to start to resolve the issue.
04-FEB-2008 02:33:35Startup the databaseDbMotive Reply
On windows, you need to make sure the OracleServiceSID is running.
04-FEB-2008 20:28:12TNS:Protocol Adapter ErrorM Sriram Reply
I had installed Oracle 10 g on my new XP system, I didn't opted for creating the stater database while installation and the Oracle setup was sucessfull. While I start the Sqlplus and provide the login as scott/tiger , it gives me the following error : TNS:Protocol Adapter Error
05-FEB-2008 10:54:45First create a databaseDbMotive Reply
If you didn't choose to create a database, you will have to create a new database.
You can use the database configuration assistant (dbca) for this
07-FEB-2008 15:16:17ora-12560:tns:protocol adapter errorsamy Reply
when i want to view my module in form developer by web page this error will appeared. please give me some advice thanks.
08-FEB-2008 02:34:05ORACLE_SID not setDbMotive Reply
The ORACLE_SID is probably not configured in the forms server, so connections to a database will not work.
Check the forms configuration and adapt accordingly
08-FEB-2008 03:14:56help for ORA-12560xyz Reply
please can anyone help out...my machine has only one database..if i try to connect yo database(10g)
without string name,it is not getting connected..geeting tns adapter error..help!
08-FEB-2008 03:24:15Define ORACLE_SIDDbMotive Reply
You have to define the ORACLE_SID
19-FEB-2008 11:43:23errorpoo Reply
when i'm creating maual database that time i'm getting an error "ora-12560:tns:protocol adapter error"
how can i solve this error.
please help me.
23-FEB-2008 13:21:13database serviceoragirl Reply
hi all..
my db sid is orcl how can i find its serviice is runing.


rgds n advance
27-FEB-2008 00:14:20tns protocol adapter errorr.suresh Reply
hai i am sureh,

following errors are display while i am connecting sql*plus,

ora 12560 : tns protocol adapter error. How to solve this problem

04-MAR-2008 23:58:20ORA-12560: TNS:protocol adapter errorsayeem Reply
First i connected as system/password@hostname,
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.
05-MAR-2008 02:54:53Password given at creation timeDbMotive Reply
It is the password you had to supply at creation time.

You can try with oracle, manager, change_on_install

07-MAR-2008 15:35:50ORA-12560: TNS:protocol adapter errorPedro Reply
Having the same talked by most here but in my is brand new installation (no instance) and after conclude the installation succesfuly once I try to create a new instance using the graphic api brough by oracle, the dam message appear again and again???, can someone help me out, i tried last night up to 3am and nothing... By the way my O.S. is Windows 2008Server 32b and Ora 10g R2 for vista 32b.

Any thoughs are going to be very appreciated...

Pedro
13-MAR-2008 11:13:14ORA-12560: TNS:protocol adapter errorAvan Reply
I have oracle database express edition when I try to connect from form builder 10g I get this error, and my OS is Windows Vista.
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..
13-MAR-2008 11:22:58Oracle HomeDbMotive Reply
As you have both an Oracle database and Oracle forms, what is your current Oracle home?
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.
13-MAR-2008 11:35:25ORA-12560: TNS:protocol adapter errorAvan Reply
I have oracle database express edition when I try to connect from form builder 10g I get this error, and my OS is Windows Vista.
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..
13-MAR-2008 11:43:40ORA-12560: TNS:protocol adapter errorAvan Reply
so, should I change to oracle database 10g? but it slows down my computer..
thank you..
14-MAR-2008 06:06:45protocol adaptor errorrahul singh Reply
i am trying to login through scott/tiger but not able to login it show protocol adaptor error and sometime it show database is not started or shutting down in progress. so can anyone please help me.
14-MAR-2008 09:57:42Service runningDbMotive Reply
Are you sure the service is running?

Can it be that it crashes for some reason?

14-MAR-2008 12:04:45ORA-12560: TNS:protocol adapter errorAvan Reply
now I have oracle database 10g express edition when I try to connect from form builder 10g or from command prompt I get the same error, could my OS (Windows Vista) cause this problem?
21-MAR-2008 09:13:32Protocol adapter errorT Mala Reply
Now only i installed Oracle 9i server. I tried to connect to Oracle using scott/tiger.
But it throws an error Protocol Adapter error. Plz help me to solve this problem.

Thanks in advance
25-MAR-2008 09:23:28ORA-12560: TNS:protocol adapter errordnyaneshwar munde Reply


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.



25-MAR-2008 09:54:03How do you connectDbMotive Reply
Can you give an example of how you connect, both via sqlplus and OTL?

27-MAR-2008 12:26:40Solution for AboveSareetam Reply
Type svrmgrl at Run.
Svrmgrl prompt appears. type Connect Internal
then again type startup
and open your oracle. It will be working now!!!!
02-APR-2008 10:50:58ORA- 12560: TNS: protocol adapter errorAshis Mohapatra Reply
Yester day it was working fine from today its showing "ORA- 12560: TNS: protocol adapter error" error.
I checked for services...
What should I do next?
: ->  02-APR-2008 13:03:24What is the statusDbMotive Reply
Is your service running?

If not, please restart the service and check the oradim.log in your %ORACLE_HOME%/dbs directory

07-APR-2008 10:28:21prob with starting sqlplussundeep malik Reply
on starting oracle i got an error tns: protocol adapter error
: ->  07-APR-2008 10:55:23Result requestedDbMotive Reply
Can you post the output of the steps performed?

When you connect as "/ as sysdba", does it say "Connected to an idle instance" ?

12-APR-2008 13:33:15TNS ProblemsAlabi Oluyomi John Reply
Is there a comprehensive material on Oracle TNS?
: ->  14-APR-2008 08:19:24Check documentationDbMotive Reply
Oracle has all the manuals online, check tahiti.oracle.com
17-APR-2008 08:03:01tns protocole error.abdul jaleel.t.k Reply
my database was working before.when i installed forms ans reports for 10g,my 9i database is not working..telling tns protocole error.ORA-12560: TNS:protocol adapter error
: ->  17-APR-2008 08:41:03Different Oracle HomeDbMotive Reply
Forms is installed into a different Oracle home, which will become the default after installation.

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.
: ->  07-MAY-2008 07:23:42ora-12560 error manoj kumar sharma Reply
when i am connect as sysdba. i get ora-12560 error.

set oracle_sid=orcl;
sqlplus /nolog
sql> connect sys/sys as sysdba
get this error
ORA-12560: TNS:protocol adapter error

please help me
10-MAY-2008 08:56:01ORA - 12560jayakiran Reply
When my application is running with the oracle database and suddenly if oracle gets shutdown for 5 minutes and if it again gets startup then my application try to get connection at that time it throwing this error. If i bring's down my application also and getting restarted everything it is getting and working fine!! But when it's(oracle) gets disconnected when my application is running it is trying to connect means it is not getting connected. Please help regarding this issue...?
:: ->  14-MAY-2008 14:02:16Do you have a service ORCLDbMotive Reply
Do you actually have a service OracelServiceORCL running?

22-MAY-2008 13:36:58ORA-12560: TNS:protocol adapter errorA.F. Aktaruzzaman Reply
OracleOraDb10g_home1TNSListner and OracleServiceORCL service are not started. Path to executable is blank in service Properties. If start the service then giving error message:

Could not start the OracleOraDB10g_home1TNSListner service on local Computer
Error 3: The system cannot find the path specified.
: ->  22-MAY-2008 13:49:30Remove and recreateDbMotive Reply
The best thing you can do is to remove the services and recreate them.

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


23-MAY-2008 09:38:59In Real Troublerahul Reply
I am already installed the Oracle9i but after one month of time. I stop working on it.
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
:: ->  04-JUN-2008 07:07:50ora-12154 TNS: could not resolve service nameMuhammad Ashraf Kamboh Reply
I am ashraf kamboh Punjab University Lahore Pakistan
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
::: ->  04-JUN-2008 10:19:19Check tnsnames.oraDbMotive Reply
Because you set LOCAL you are going via a listener.

Check your tnsnames.ora file for the definition of ORA920
30-JUN-2008 10:43:49ORA-12560: TNS:protocol adapter errorRatshi Reply
I am trying to login in the SQL PLus it gives me an error ORA-12560: TNS:protocol adapter error please help
: ->  04-JUL-2008 15:49:46I am trying to login in the SQL PLus scott/tiger it will give an error ORA-12560: TNS:protocol adapter error please helpdarshan Reply
i am trying to login through scott/tiger but not able to login it show protocol adaptor error .
i also tried sys & manager it will also not worked.
18-JUL-2008 21:33:18ora-12650william Reply
Hola..
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
Add your message for ORA-12560
Name:email:
Validation Code:z2njdfu72y537v00j
Enter Code above:
Title:
State your problem: