Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recipe for application design to run on RAC

RE: Recipe for application design to run on RAC

From: Jesse, Rich <>
Date: Fri, 29 Nov 2002 09:58:51 -0800
Message-ID: <>

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 Jesse                           System/Database Administrator              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Hemant K Chitale []
> 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:
Author: Jesse, Rich

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Fri Nov 29 2002 - 11:58:51 CST

Original text of this message