Oracle-L: Re: shared tnsnames.ora

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Thu, 27 Feb 2003 12:24:29 -0800
Message-ID: <F001.0055C0DD.20030227122429@fatcity.com>

Use Oracle Names. Easy to setup/maintain. never touch a client config again.

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

                                                                                                                                                 
                      John.Fedock_at_us.kl                                                                                                          
                      ine.com                  To:       ORACLE-L_at_fatcity.com                                                                    
                      Sent by:                 cc:                                                                                               
                      root_at_fatcity.com         Subject:  shared tnsnames.ora                                                                     
                                                                                                                                                 
                                                                                                                                                 
                      02/27/2003 12:56                                                                                                           
                      PM                                                                                                                         
                      Please respond to                                                                                                          
                      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.

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: Ron Thomas
INET: rthomas_at_hypercom.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). Received on Thu Feb 27 2003 - 14:24:29 CST