Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

TNSNAMES.ORA shared location

342 views
Skip to first unread message

diversif

unread,
Jun 12, 1997, 3:00:00 AM6/12/97
to

Have you looked into 'Oracle Names' product to get rid of TNSNAMES
nightmare?

ZDENKA <928...@KNOTES.KODAK.COM> wrote in article
<33A030...@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
>

Allan Taunt

unread,
Jun 13, 1997, 3:00:00 AM6/13/97
to

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@newmicronpc>...


>Have you looked into 'Oracle Names' product to get rid of TNSNAMES
>nightmare?
>

>ZDENKA <> wrote in article

Martin J. Malley

unread,
Jun 13, 1997, 3:00:00 AM6/13/97
to

> > 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 ?
If you put a key in the registry under HKEY_LOCAL_MACHINE/Software/Oracle
call TNS_ADMIN and use to point to the network directory containing
tnsnames.ora and sqlnet.ora it works fine. For example:
TNS_ADMIN=G:\ORANT\NETWORK\ADMIN

Jay Hostetter

unread,
Jun 13, 1997, 3:00:00 AM6/13/97
to Martin J. Malley

You can also change the local TNSNAMES.ORA so that it has a single entry
which points to your network TNSNAMES.ORA:

ifile=G:\ORANT\NETWORK\ADMIN\TNSNAMES.ORA

--
****************************************
Jay Hostetter *
D. and E. Communications *
Ephrata, Pa. U.S.A *
Remove underscores in address to reply.*
****************************************

0 new messages