Re: local tnsnames.ora, if network file is write protected

By default Oracle tools look in the local <ORACLE_HOME>/network( or Net80)/admin directory to find the tnsnames.ora file..

If you place a copy of the network one there and add your new entry, it should work..

You can specify a location by setting an environment variable called TNS_ADMIN - specify the directory you want it to look in...

TNS_ADMIN=c:\mylocation\

mumienschubser_at_web.de (Jens) wrote:

>Hi all,
>
>in our company network exists a write protected tnsnames.ora, which is
>used from SQL-Net based applications on the nt 4.0 clients.
>
>I've to connect to a new database. It works fine, if I note the
>complete address description in SQLPlus.
>
>Is there any way to define a local tnsnames.ora for my nt 4.0 client
>with an alias for this description like I can do on UNIX
>(.tnsnames.ora in the users root)?
>
>Thanks in advance.
>Jens.

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Mon Jun 23 2003 - 18:30:23 CEST