Re: TNSNAMES.ORA shared location

Zdenka,

If you are running 16-bit Oracle client software put the entry TNS_ADMIN=OracleNetFilesLocation
 alternatively if you are running 32-bit Oracle client software put the registry entry HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\TNS_ADMIN=OracleNetFilesLo cation
where OracleNetFilesLocation is the path to the tnsnames.ora file (eg. K:\Orant\Network\Admin or \\ServerName\PathName)

To automatically put the entries in the registry create the file ShareTNS.reg (note the extra \'s for the UNC path) with the following lines, and then simply run it:
-----snip-----
REGEDIT4 ; This file is used in conjunction with the Regedit utility to specify the location
; for the Oracle SQL*Net configuration files.

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"TNS_ADMIN"="\\\\ServerName\\PathName"
-----snip-----

Hope this helps.

Allan Taunt.

Global Information Solutions
Christchurch
New Zealand.  

 diversif wrote in article <01bc7736$05a6fb60$8b98b8cd_at_newmicronpc>...
>Have you looked into 'Oracle Names' product to get rid of TNSNAMES
>nightmare?
>
>ZDENKA <> wrote in article
><33A0305C.CF7_at_KNOTES.KODAK.COM>...
>> I have been running Oracle 7.3 on NT ver 4 environment. I would like to
>> store tnsnames.ora file on the server and then make it available to all
>> clients. Do I have to go in the registry and create the environment
>> variable to do that, or is there another way ?
>>
>> Any help would be appreciated . Thank You.
>>
>> Regards
>> Zdenka Spoljaric
>>
>
Received on Fri Jun 13 1997 - 00:00:00 CDT