This content has been marked as final.
Show 12 replies
-
1. re:ERROR:ORA-12560: TNS:protocol adapter error
367198 Nov 8, 2002 5:03 AM (in response to 259579)I'm also having a hard time with the username and passwrd. I tried scott/tiger, system/manager and sys/change_on_install as sysdba but none work. please help. -
2. Re: ERROR:ORA-12560: TNS:protocol adapter error
579656 Jun 7, 2007 7:23 PM (in response to 259579)Im new with Oracle also and when i open SQLPLUS I get the same error. What should i do? Can I just uninstall Oracle and re-install it again? -
3. Re: re:ERROR:ORA-12560: TNS:protocol adapter error
585459 Jun 28, 2007 9:52 AM (in response to 367198)When installing oracle 9i there are two users sys and system who are created automatically,who have all the privileges however sys has more privileges. also the user scott is created by default. If you are not able to login then the installation may have not been done properly.better you deinstall all the products from oracle universal installer and then re-install oracle again. -
4. Re: re:ERROR:ORA-12560: TNS:protocol adapter error
521131 Jul 14, 2007 10:54 PM (in response to 585459)This error will come if Listener is not up or problem in tnsnames or database is not up.
1.Check the listener status by executing
lsnrctl status
2.check the tnsnames entry is proper t not by
tnsping INSTANCENAME
3.Check the database is up r not by checking the service in windows ,(process in Unix) -
5. Re: ERROR:ORA-12560: TNS:protocol adapter error
599487 Sep 24, 2007 1:42 AM (in response to 259579)hi,
did you found the solution to your problem of ORA-12560: TNS:protocol adapter error
i am trying to install it on windows XP pro.
Please help ASAP
reagrds
Nitin -
6. Re: ERROR:ORA-12560: TNS:protocol adapter error
428571 Sep 24, 2007 6:49 AM (in response to 599487)Hi ,
Check this note in metalink.
238664.1
Rgds,
Vijaya -
7. Re: re:ERROR:ORA-12560: TNS:protocol adapter error
609446 Nov 20, 2007 7:31 AM (in response to 521131)hi,
facing a same problem.try to connect client to server but getting a same error.
error:
SQL> connect scott/tiger as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error -
8. Re: ERROR:ORA-12560: TNS:protocol adapter error
614435 Dec 20, 2007 2:01 PM (in response to 259579)i had just oracle 8i & when i tried to start it it gives an error of protocol adapter error
what should i do to fix it
regards -
9. Re: ERROR:ORA-12560: TNS:protocol adapter error
604013 Apr 6, 2008 5:27 PM (in response to 259579)When starting server manager the following error is generated:
ORA-12560: TNS:protocol adapter error occurred
Cause:
Oracle classify this as a 'generic protocol adapter error'. In my experience it indicates that Oracle client does not know what instance to connect to or what TNS alias to use.
Possible Remedies:
* If running on the server (or workstation) that is running the database (i.e. if the database is local to the machine) then try explicitly setting 'ORACLE_SID'. e.g.
set ORACLE_SID=<sid>
and then try again. If this works then consider whether to make the change permanent by specifying it as a system variable.
FOR RUN THIS SID PLEASE REFER IT
Go to command prompt
C:\Document and settings\ORANGE> cd\
C:\> set oracle_sid=<DB name>
e.g C:\> set oracle_sid=<rajesh> {press enter}
C:\> sqlplus /nolog {press enter}
sql:\>connect sys/sys as sysdba {press enter} it cant ask for password directly connected
or
sql:\>connect sys as sysdba {press enter}
password : sys {press enter}
sql:\> connected
or
sql:\> connect scott {press enter}
Enter password :tiger {press enter}
sql:\> connected
or
sql:\> connect system {press enter}
Enter password :manager {press enter}
sql:\> connected -
10. Re: re:ERROR:ORA-12560: TNS:protocol adapter error
635573 Apr 23, 2008 5:08 AM (in response to 367198)I'm also having a hard time with the username and passwrd. I tried scott/tiger, system/manager and sys/change_on_install as sysdba but none work. please help. -
11. Re: re:ERROR:ORA-12560: TNS:protocol adapter error
635573 Apr 23, 2008 5:10 AM (in response to 367198)I am using Win Xp Pro. I just installed Oracle 9i After a clean complete uninstall but I am getting the error ORA-12560: TNS:protocol adapter error when I try to connect in Sqlplus using scott tiger or system manager so please help and tell me what to do to resolve the same -
12. Re: re:ERROR:ORA-12560: TNS:protocol adapter error
641241 May 25, 2008 3:40 AM (in response to 635573)run msconfig and check in the services tab whether oracle services are stopped. If so, enable them