RE: Recipe for application design to run on RAC

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
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Hemant K Chitale [mailto:hkchital_at_singnet.com.sg]
> 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: 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).