Re: how can I tell Oracle 9i to look on a network share for the tnsnames.ora file?

david_pierce_at_vmed.org (Celler Dweller) wrote:

>I have been asked to centralize the management of the TNSNAMES.ORA
>file. I read in another post that I could create a shortcut from my
>%ora home\network\ADMIN dir called tnsnames.ora and have it point to a
>real tnsnames.ora file on a network share. In the windows world a
>shortcut has an .lnk extension so I don't think this will work. I
>tested it quick and it failed. How can I tell Oracle 9i to look on a
>network share for the tnsnames.ora file?
>WIN2k clients
>Unix Database Server

2 steps:

Map a drive letter to the network share.( for example assume L: is set to \\networkserver) place and add an entry in the system environment variables called TNS_ADMIN and set it to
L:\oracletnslocation

Your workstation will now look first for the tnsnames.ora file in that location.. Be sure users have read rights to that location and that the drive mapping is set to reconnect on logon. Received on Tue Apr 13 2004 - 11:51:00 CDT