RE: OID and tnsnames.ora
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: Jared Still <jkstill@xxxxxxxxx>
- Date: Wed, 19 Aug 2009 16:17:38 -0400
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; 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
Other related posts:
