Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: This should be an easy "TSN: could not resolve service name" problem:
But it does have an impact on which SQL*Plus gets picked up first.
if you're CD'ed into an arbitrary directory.
"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
news:92eeeff0.0301201154.20d34fdc_at_posting.google.com...
> "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
news:<hXTW9.4109$V6.6385_at_news.indigo.ie>...
> > But does this not then stop use of the Oracle Home Selector applet....
> >
> > which alters the PATH variables and not the TNS_ADMIN...
> >
> > but yes I agree with you saying this is good for multiple homes but not
for
> > <developers> .... anyway it can all be found in manuals...
>
>
> System PATH has nothing to do with which configuration files are read
> by sqlplus. When launched, it searches for oracle.key file under bin
> folder and uses whichever regisrty home is pointed to in the file. If
> TNS_ADMIN is not defined in the registry home or as a system variable,
> sqlplus uses configuration files pointed to by Oracle_home in the
> registry.
>
> Regards
> /Rauf Sarwar
Received on Tue Jan 21 2003 - 04:41:38 CST