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

I believe there is the option of using a TNS_ADMIN enivronment variable. I also seem to remember something about .tnsnames in your personal home directory. Most of these require some kind of file replication to properly maintain and a replication server to do the maintenance.

But if I understand your requirements, the best answer would be the Oracle Name Server.

Although at this time we do no use it (tnsnames.ora in network/admin) we are planning on evaluating it later this spring (it is going to be my task). Then the logistical problems with finding and maintaining tnsnames.ora disappear. With oracle names server you just have to make sure you have a backup server somewhere in case your primary does not respond. There is also the idea fo a well known names server.  

Igor Karasik 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

--
Gerry Sinkiewicz
sinkiege_at_snet.net Received on Sun Feb 14 1999 - 12:46:43 CST