Oracle-L: RE: shared tnsnames.ora

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Thu, 27 Feb 2003 13:38:55 -0800
Message-ID: <F001.0055C2FF.20030227133855@fatcity.com>

Easy to maintain?????? The "maintenance" of an alias is to DELETE it, then add it again. Oracle officially does not support maintenance of alias information in ONames. This really bites, especially when your network domain changes.

The solution is to modify the repository directly. If you're using a region DB, you can modify the repository directly. Of course, this isn't supported, either...

It IS easy to add/delete aliases, but not to change them.

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

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

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: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.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 - 15:38:55 CST