I have two databases on one machine. I can login to only one db at a time. If I try to connect other db it gives me the error:

TNS listener currently does not know service requested in connect descriptor.

Even if I set the oracle_sid "ORADB", it get connected to "ORADEV". And if I specify the Connect identifiet it gives me TNS error.

Kindly assist.

Regards,
Mayura