Ora-12560 TNS protocol error

[sethi]

Dear Friends


I am Gurpreet Singh Sethi From India. I have a small problem. I was having 2 database on my machine named
BS & Rman

when ever i use to open svrmgrl for BS database i have to first set the oracle_sid . For some reason i delete Rman database and now When i use to open svrmgrl then it show me The error ORA-12560 TNS Protocol Error. My tnsname.ora and Listner.ora all are well configured. Please See this problem and post any answer.

Thanks In Advance

Sethi Gurpreet Singh

[Raminder]

Please tell us:

(a) Operating system
(b) Oracle version

Check your tnsnames.ora again. Are all references to deleted database (sid) deleted in the tnsnames.ora file?

[sethi]

Dear O/s Is NT and Database is 8i 8.1.5 .


I have cheched all the nexessary files like Tnsnames.ora & Listener.ora.

Thanks

Sethi Gurpreet Singh

[Edited by sethi on 09-06-2001 at 12:28 AM]

[sethi]

Dear O/s Is NT and Database is 8i 8.1.5 .


Thanks

Sethi Gurpreet Singh

[pst]

Hi sethi,

Setting the oracle_sid is a must for entering the server manager mode on unix and even in NT.

But in nt, by default it will pick up the first database created. Even if you delete all other entries of other db's , it will still look for that name.

If you can edit the registry, you will be able to change that.
If you go under
HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME0
here you will see the oracle_sid value set. You just have to modify this value to the required one, which in your case is BS.


cheers

pst