Re: OID and tnsnames.ora
Date: Wed, 19 Aug 2009 21:28:08 +0100
Message-ID: <4A8C6058.4050809_at_sequeira.org.uk>
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…. 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_at_gmail.com]
> *Sent:* Wednesday, August 19, 2009 4:01 PM
> *To:* Bobak, Mark
> *Cc:* genegurevich_at_discover.com; oracle-l_at_freelists.org
> *Subject:* Re: OID and tnsnames.ora
>
>
>
> On Wed, Aug 19, 2009 at 8:30 AM, Bobak, Mark <Mark.Bobak_at_proquest.com
> <mailto:Mark.Bobak_at_proquest.com>> 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 ++ -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 19 2009 - 15:28:08 CDT