Re: Dynamic Reconnection after a Failure in Distributed Databases

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 29 Apr 1999 09:03:12 -0700
Message-ID: <372882C0.377505F8@us.oracle.com>

Transparent application failover is supported in Oracle8, but is normally used in Parallel Server, or alternatively FailSafe. It needs the OCI version 8 libraries, so anything that is not linked with them won't be able to use this.

In a distributed environment, I have heard people talking about doing something similar by trapping the error codes that indicate failure in the application, but nobody I know has implemented it. In any case, I'd look seriously at your application to see if it even makes sense in a distributed environment. If transactions are frequently distributed rather than just remote, and parts of the databases die, do you really want to leave in-doubt transactions in your environment?

HTH. Pete

Thushara wrote:

> Hi
>
> I am just wondering if anyone knows where to get information related to my
> Subject Listed above.
>
> My problem is as follows :
>
> Is there any method available to Dynamically Connect Clients to another
> server running in a Distributed Databases, after failure of the server they
> are attached to ? OR any other way to allow those clients to use the database
> in another site (which we can assume a replicated copy ) ?
>
> If there are any method available or if you know any relevant reference to
> that problem, please let me know.
>
> Thanks a lot
>
> Thushara

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Thu Apr 29 1999 - 11:03:12 CDT