Re: Where Oracle client looks for tnsnames.ora file ?

In article <36C6C753.A3CDBABA_at_mercury.co.il>,   Igor Karasik <ikar_at_mercury.co.il> wrote:
> Hi,
>
> Do anybody know about way to specify to Oracle client where look for
> tnsnames.ora file ?
>
> I know that by default Oracle client looks tnsnames.ora file in current
> directory and in
> $ORACLE_HOME/net80/admin, but I want to use tnsnames.ora
> from different place. (I have many different Oracle clients versions and
>
> I don't want to change tnsnames.ora in each installation)
>
> Please reply by E-Mail: ikar_at_usa.net

  Igor,

You need to set TNS_ADMIN as an environmental variable on Login (I am assuming a UNIX environment)
Set this to the path of where you want to relocate your tnsnames.ora This could be set in your .profile file like this..

TNS_ADMIN=/home/mjw
export TNS_ADMIN

Matt Weishan
Senior Oracle Instructor
Greenbrier & Russel Inc.
mweishan_at_gr.com
>
> Thanks, Igor
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Feb 14 1999 - 18:42:59 CST