One other thing you could look into is setting up an Oracle Names Server...

http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/nam
ingcf.htm#494320
<http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/na
mingcf.htm#494320>

kevin-

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



Oracle LazyDBA home page