Re: This should be an easy "TSN: could not resolve service name" problem:

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 22 Jan 2003 09:12:17 -0800
Message-ID: <92eeeff0.0301220912.536d99e2@posting.google.com>

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<CluX9.4497$V6.6677_at_news.indigo.ie>...
> OK rauf ... you win.
>

The idea is not to win or loose but to provide correct information.

You are right that if sqlplus is launched from any directory, then first ORACLE_HOME\bin directory listed in the system path will automatically become sqlplus home... no problem if your configuration files reside there, however, if you are using configuration files from different home, you will get ORA-12154... Unless TNS_ADMIN variable is defined, which is global and eliminates all that.

Regards
/Rauf Sarwar Received on Wed Jan 22 2003 - 11:12:17 CST