Re: TNSNAMES.ORA not in ORACLE_HOME

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.

Try this: Create a copy of the oracle directory (\ORAWIN) struture from the fileserver (with no files in it). Copy the oracle.ini file to the ORAWIN directory, and change the win.ini Oracle key to point to it. Put your new tnsnames.ora etc in the orawin\network\admin. Edit the oracle.ini to either include the fillowing key under [oracle] TNS_ADMIN=path.

I personally havent had much luck with using tns_Admin, but then I didnt copy the whole of the network tree. If this doesn't work, there are other keys in the oracle.ini which point to networking stuff; you may have to copy some of the other files from the network tree to make it work.

Good luck!

-- 
Miles Thomas
Logica UK Ltd
thomasm "at" logica "dot" com
The above are personal opinions, and are
not necessarily the opinions of my employer.