RE: OID and tnsnames.ora

From: Bobak, Mark <>
Date: Wed, 19 Aug 2009 16:56:17 -0400
Message-ID: <>

Thanks for that. I was unaware of pen.


From: [] On Behalf Of S. Anthony Sequeira Sent: Wednesday, August 19, 2009 4:28 PM To: Oracle L
Subject: Re: OID and tnsnames.ora

Try pen for failover and load balancing (after a fashion).

I'm using it to failover squid, LDAP, apache and SSH.

The price is right!

Bobak, Mark wrote:
Which is why I have two LDAP servers behind a load balancer…. ☺

Of course, load balancers cost money, but, fortunately, we had one that was already on the floor that we could use.


What does NAMES do to avoid the TCP timeout? How does it avoid that problem?


From: Jared Still [] Sent: Wednesday, August 19, 2009 4:01 PM To: Bobak, Mark
Cc:<>;<> Subject: Re: OID and tnsnames.ora

On Wed, Aug 19, 2009 at 8:30 AM, Bobak, Mark <<>> wrote: Hi Gene,

OID is a bear, and if all you want to do is use it for a centralized repository for service name resolution, I strongly recommend you look at:

It will take about 30 minutes to set up, tops. It doesn't even require installation of an Oracle client.

I've been running it in all environments (dev, preprod, and prod) for over a year. No problems, no hiccups, no crashes.

I still prefer SQL Names, too bad Oracle did away with it.

Names had one very nice feature that LDAP based name resolvers do not have: If the primary names server goes down, requests will quickly go to the secondary server.

With an LDAP (OID and tnsmanager) based system, the failover occurs only after the TCP timeout, which might be awhile, on the order of minutes.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


S. Anthony Sequeira


"I got a question for ya. Ya got a minute?"

  • two programmers passing in the hall

-- Received on Wed Aug 19 2009 - 15:56:17 CDT

Original text of this message