Re: Use of OID for name resolution

From: Jared Still <>
Date: Thu, 22 Oct 2009 09:52:12 -0700
Message-ID: <>

We are using OID.
It is being replicated to another OID server for HA and patching.

( see 300436.1 Setting Up OID Replication in 10.1.2 / 10.1.4 )

In addition, we are using Oracle Names in proxy server mode. eg. Onames is getting its info from OID.

One interesting thing about OID is that it actually is not nearly as good as Oracle Names for automatic failover.

If the primary ONames server is down, no problem, the clients will quickly send a request to the secondary server.

OID on the other hand takes several minutes to accomplish the same thing, as it depends on TCP timeout, which is a global setting.

So with that in mind, we use CNAMEs for the OID servers, and switch the CNAME as needed.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: Home Page:

On Thu, Oct 22, 2009 at 8:50 AM, Martin Bach <>wrote:

> Hello all,
> if memory serves me right then the use of OID was free if it's used for
> name resolution (i.e. as replacement for tnsnames.ora), amongst other
> things.
> I am wondering if anyone uses OID for this-regardless of license option-and
> especially how you are protecting the OID against failure. I am not thrilled
> by the idea of the central naming repository failing and the phone ringing
> with angry users who can't connect to the systems any more.
> The background is that I'd like to sort out a lot of old tnsnames.ora
> entries on lots of machines which aren't centrally managed. In other
> words-try to get rid of the chaos.
> Thanks for any input!
> Martin
> --
> Martin Bach
> --

Received on Thu Oct 22 2009 - 11:52:12 CDT

Original text of this message