RE: shared tnsnames.ora

John - Here is a white paper on Oracle's site. I keep seeing where Oracle is encouraging people to switch to LDAP and that Names will eventually go away, and that has discouraged me from going the Names route. Maybe that will never occur and 10 years from now Names will be going strong. Of course, when I talk to our network people they say that we are going LDAP but they are still trying to chose which one :-)  

http://otn.oracle.com/products/oid/htdocs/namesmigration.html <http://otn.oracle.com/products/oid/htdocs/namesmigration.html>  

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, February 27, 2003 3:14 PM To: 'ORACLE-L_at_fatcity.com'

John

    In the past the answer was to set up Oracle Names. I think Oracle said they will be phasing that out in favor of LDAP systems. I believe if you are starting today the best idea would be to consider Oracle Internet Directory, or more generically an LDAP system of some type.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, February 27, 2003 1:56 PM To: Multiple recipients of list ORACLE-L

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

• john.fedock_at_us.kline.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).