Re: Common TNSNames.ORA file

you can also use the IFILE parm in a tnsnames.ora file, works just like the IFILE parm in the init.ora file. this gives you the flexibility to have a common for most and add special entries that might pertain just to a group of people.

joe
http://www.oracle-dba.com

Dean Mah wrote:

> Posted and mailed...
>
> George Mansoor wrote:
>
> > Is there a way to create a single TNSNames.ora file that all my clients
> > can access on a network drive? I don't see it in any of the SQL*Net
> > docs.
>
> You can set your TNS_ADMIN variable to point to the directory that contains
> the tnsnames.ora file. In Win95 and WinNT, you will need to add this
> variable to the registry. In Win3.x, you will have to set this variable in
> the oracle.ini file.
>
> Dean

--
Joseph S. Testa, Oracle Database Administrator
Vice-President Ohio Oracle Users Group, http://www.ooug.org
OOUG welcomes Steven Feuerstein to Columbus OH in Oct, if your company is
interested in becoming a corporate sponsor for this event, send
mailto:vice_pres_at_ooug.org.
Want some remote DBA work done? mailto:teci_at_oracle-dba.com
ICQ http://wwp.mirabilis.com/2832230