RE: OID and tnsnames.ora

Thanks for that.  I was unaware of pen.

-Mark


From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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).

http://siag.nu/pen

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.

Jared,

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

-Mark

From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Wednesday, August 19, 2009 4:01 PM
To: Bobak, Mark
Cc: genegurevich@xxxxxxxxxxxx<mailto:genegurevich@xxxxxxxxxxxx>; 
oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: OID and tnsnames.ora

On Wed, Aug 19, 2009 at 8:30 AM, Bobak, Mark 
<Mark.Bobak@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>> 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:
http://www.shutdownabort.com/tnsmanager/

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

++

Other related posts: