Re: Implemented TNS_ADMIN on NT?

Could be a couple of things causing this problem.

1. TNS_ADMIN is pointing to the wrong directory.
2. Client has no access to the share.

Have you considered Oracle Names? It's purpose is similar - a centralized location to maintain TNS information. In Net8 it's quite east to set up with the Net8 Assistant.

--
Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA


                                                                                                                   
                    "Hathi,Manish                                                                                  
                    "                    To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <mhathi_at_mwd.d        cc:     (bcc: CHUCK HAMILTON/QVC)                                         
                    st.ca.us>            Subject:     Implemented TNS_ADMIN on NT?                                 
                    Ext: NA                                                                                        
                    Sent by:                                                                                       
                    root_at_fatcity.                                                                                  
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    05/05/00                                                                                       
                    08:16 PM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L                                                                                       
                                                                                                                   
                                                                                                                   




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:
     a. Current working directory from where an application is executed
     b.TNS_ADMIN environment variable
          If the TNS_ADMIN environment variable is not defined on
Windows platforms, TNS_ADMIN it may be in the registry
     d.If TNS_ADMIN is not defined, $ORACLE_HOME/network/admin on UNIX
and ORACLE_HOME\network\admin on Windows platforms


<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
--
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