AW: Implemented TNS_ADMIN on NT?

From: Daiminger, Helmut <Helmut.Daiminger_at_gedas.de>
Date: Mon, 8 May 2000 11:26:12 +0200
Message-Id: <10491.105146@fatcity.com>

Why don't you try Oracle Names Server? That way all connection requests would be resolved by the Names Server and no modification at the client = side
is necessary.

When you install an Oracle client you only need to give it the names = servers
to use in the sqlnet.ora file.

hth,
Helmut

-----Urspr=FCngliche Nachricht-----
Von: Hathi,Manish [mailto:mhathi_at_mwd.dst.ca.us] Gesendet am: Samstag, 6. Mai 2000 02:16
An: Multiple recipients of list ORACLE-L Betreff: Implemented TNS_ADMIN on NT?

Hi,
Has anyone implemented successfully the following for Oracle8i on NT4

GOAL:
Store the "tnsnames.ora" in a dir. on a shared network drive so that = all
client NT workstations have access to
that directory.
Specify the TNS_ADMIN variable in the client workstation's registry to = point
to this shared network dir.

Why would I want to do this? Well this question is from a friend and = their
shop has a number of test/development databases. For every new database added, the tnsnames.ora is to be modified from client machines. They = want a
solution so that all clients point to a single tnsnames.ora

The documentation says that TNS_ADMIN var. in the registry can do this.
<FROM DOC>

The search order for SQLNET.ORA and TNSNAMES.ORA follows:=20

Current working directory from where an application is executed=20 b.TNS_ADMIN environment variable=20 If the TNS_ADMIN environment variable is not defined on Windows platforms, TNS_ADMIN it may be in the registry=20 d.If TNS_ADMIN is not defined, $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows platforms=20
<END-FROM DOC>

I tried doing this but the after setting tns_admin on client = workstation
registry, SQL*PLUS cannot connect to any database.

Any comments appreciated.

Thanks,

Manish
--=20
Author: Hathi,Manish
INET: mhathi_at_mwd.dst.ca.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon May 08 2000 - 04:26:12 CDT