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

Home -> Community -> Usenet -> c.d.o.misc -> Re: how can I tell Oracle 9i to look on a network share for the tnsnames.ora file?

From: DJ <nospamplease_at_goaway.com>
Date: Fri, 9 Apr 2004 20:15:29 +0100
Message-ID: <MCCdc.86$02.26@newsfe3-win.server.ntli.net>

"Celler Dweller" <david_pierce_at_vmed.org> wrote in message news:eefa08b9.0404090956.626ef52a_at_posting.google.com...
> 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

look at the TNS_ADMIN environment variable Received on Fri Apr 09 2004 - 14:15:29 CDT