ERROR:ORA-12560: TNS:protocol adapter error

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.

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?

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.

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)

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

Hi ,

Check this note in metalink.

238664.1

Rgds,
Vijaya

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

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

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

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.

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

run msconfig and check in the services tab whether oracle services are stopped. If so, enable them