We are running NT clients. I have added a TNS_ADMIN key to the registry
pointing to the directory holding the tnsnames.ora. I set that key to the
network directory and all is well.

-----Original Message-----
From: Fedock, John (KAM.RHQ) [mailto:John.[Email Address Removed] Thursday, February 27, 2003 2:50 PM
To: LazyDBA.com Discussion
Subject: RE: shared tnsnames ??? How to support a large number of users
using the client



I am looking for info on how you support a large number of PCs (200+) and
keep each ones tnsnames.ora file in sync. It seems that most people do not
touch them. Some try to modify them and when new databases are created, the
tnsnames.ora files must be changes as well. It seems to be that a shared
tnsnames.ora file on a network drive may work. I remember a thread awhile
back about the order of resolution (home directory, then OH/network/admin
....). Again, I am asking about people using the Oracle client to connect
to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers. I have just
started to think about this and posted here before I started my MetaLink
search.


TIA for any info.

JF



John Fedock
"K" Line America, Inc.
www.kline.com
* john.[Email Address Removed]



Oracle LazyDBA home page