If you're thinking of going ONAMES, consider OID. There are downsides to each, however, that you'll need to consider.
1) There is no mechanism in ONAMES to modify an alias. As per Oracle Support, you'll need to drop and recreate the alias instead. (Or you can modify the repository directly, but that's not encouraged) 2) Replication on OID is one huge PAIN! Because of the way OID works, the two OID DBs are not fully replicated. Instead, it's an AR hack. As of 9.0.1 at least, replication was unstable enough for us to dump OID completely. That and the fact that Oracle Support was of very little help, the documentation is HORRIBLE, and apparently RH 7.1 Linux isn't the best platform for OID 9.0.1. Just some things to consider... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 29, 2002 9:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Recipe for application design to run on RAC > > > > No one here [including me !] knows Oracle Names or OID. > There's a profusion of TNSNAMES.ORA files for various databases > and applications but not Oracle Names. > > I've been thinking and thinking of Oracle Names for a year and > haven't got around to it . [I guess you'll think twice before hiring > me as a DBA <: ] > > Hemant > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
