Re: OID and tnsnames.ora
- From: "S. Anthony Sequeira" <tony@xxxxxxxxxxxxxxx>
- To: Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Aug 2009 21:28:08 +0100
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…. J
>
>
>
> 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
>
>
--
S. Anthony Sequeira
++
"I got a question for ya. Ya got a minute?"
-- two programmers passing in the hall
++
Other related posts:
