RE: 10g - Sqlnet and redundant oid servers

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • To: Jared Still <jkstill@xxxxxxxxx>
  • Date: Tue, 4 May 2010 11:26:21 -0400

Very cool!  Thanks Jared, I wasn't aware of that.

-Mark

From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Tuesday, May 04, 2010 11:25 AM
To: Bobak, Mark
Cc: cjnewman@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: 10g - Sqlnet and redundant oid servers

On Tue, May 4, 2010 at 8:06 AM, Bobak, Mark 
<Mark.Bobak@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>> wrote:

Second, would be something like Oracle clusterware.

A third option:  http://www.inlab.de/balance.html

I have not yet implemented this in production, but do plan to
when I get time to finish documenting the test and implementation.

It  is simple to use, this line will send OID queries
to ororaldap02 should 01 be down:

  balance 389 ororaldap01:390 ! ororaldap02:390

It is not however a clustering or failover technology.
Should the server that balance is running on go down completely,
then you will still not have a server.

Still, it is better than depending on the TCP timeout, which is useless.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com



Other related posts: