ORA-12560: TNS:protocol adapter error

[Former Member]

Hi Gurus,

I am installing Oracle 9i in windows server2003. after installing . when i am trying to login to oracle , through sqlplus "\as sysdba"

then it's giving the error ORA-12560: TNS:protocol adapter error please help me out. what is the solution without the formaat the OS and reinstall plesae any suggestions

[Former Member]

Dear Reddy,

please provide some details regarding the installations

Are you trying to install SAP or Oracle ?

if you are trying to install SAP ,you install Oracle without database and at DB instance the database is created and the related service is created i.e OracleService<sid>

its not possible to connect as sysdba without DB ,related services and the environment variables

you may continue install SAP without formatting the OS or uninstalling DB

Regards

George

reward points if this helps you

[Former Member]

Hi,

Try following,

set oracle_sid=<your sid>

set oracle_home=<your Oracle Home>

set path=%oracle_home%\bin;%path%

sqlplus "/as sysdba"

Please let me know the result, if it works.

Thanks and Regards,

Abhishek Thota

[stefan_koehler]

Hello Raj,

this information is not enough.

If you try to login with sqlplus "/ as sysdba" you are not using the SQL*NET.

Have you set the correct SID in your environment?

Regards

Stefan