Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNSNAMES.ORA not in ORACLE_HOME
Add the entry TNS_ADMIN in your ORACLE.INI. It should point the directory that contains your local TNSNAMES.ORA file.
ie. TNS_ADMIN=C:/ORACLE/NETWORK/ADMIN
Tony van der Prijt <tprijt_at_bigfoot.com> wrote in article
<5oc13u$2j7$1_at_neptune.worldonline.nl>...
> Hi there,
>
> I wonder if someone knows the answer to the following question:
>
> I'm working in an environment where almost everything is stored on an
> fileserver. Even the oracle-client software. Since I'm developing a new
> database, I need different entries in the TNSNAMES.ORA file than the one
> stored on the fileserver. However, the network management department
won't
> allow me to edit the TNSNAMES.ORA file (rightfully so), but I do want to
> use the software from the fileserver, since that most closely resembles
the
> situation in which my end-users will work. The only file that needs to be
> different is the TNSNAMES.ORA-file. Is there a possibility under Windows
> 3.1 to have this file stored in a different directory than the
> ORACLE_HOME\NETWORK\ADMIN?
>
> Any help will be much appreciated,
> Tony van der Prijt.
>
>
>
>
Received on Mon Jul 07 1997 - 00:00:00 CDT