Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where Oracle client looks for tnsnames.ora file ?

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

From: Andrew Protasov <a_protasov_at_hotmail.com>
Date: Sun, 14 Feb 1999 21:20:47 GMT
Message-ID: <7a7en8$196$1@nnrp1.dejanews.com>

Hi Igor,

You can do it.

  1. Create network dirctory like f:\net8\admin (any name).
  2. Copy contents of your e:\orant\net8\admin directory to f:\net8\admin.
  3. Add to each client environment set tns_admin=f:\net8\admin

All clients will use the same tnsnames.ora.

Andrew Protasov

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
>
> 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 - 15:20:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US