Re: Q: Is Oracle 24*365 possible?

Dave

Until you get to Oracle8, your application needs to trap the errors that occur when the instance fails, then switch to the other instance. Applications developed with the Oracle8 OCI libraries can transparently failover.

Not sure what you mean by the "common cause failure rate", but unless your application is designed specifically with OPS in mind, I wouldn't switch to it without a good deal of up-front redesign work. This changes of course with Cache Fusion in 8i, but you're not on that release.

HTH. Pete

Dave Waterworth wrote:

> What happens to client applications which are connected to one instance of
> parallel server system when that instance fails? Do they seemlessly connect
> to a good instance, or does the client receive an ORA-XXX message (we're
> running Oracle 7.3.4)? How well does parallel server work in practise, does
> the added level of complexity increase the common cause failure rate
> significantly?
>
> Cheers
>
> Dave Waterworth
>
> Jonathan Gennick <jonathan_at_gennick.com> wrote in message
> news:37f3282d.13396083_at_netnews.worldnet.att.net...
> > On Tue, 21 Sep 1999 14:01:17 +0200, "Johan Wegener"
> > <xjw_at_xdde.xdk> wrote:
> >
> > >Is it possible to have an Oracle instance and its data online around the
> > >clock, 365 days a year while "guaranteeing" against loss of data?
> >
> > It should be possible, but I think you would need to look at
> > using the Parallel Server configuration to achieve this type
> > of reliability. That way you have multiple instances going
> > at once, and if one fails the others will still be running.
> > I don't think that you can "guarantee" a complete lack of
> > problems though.
> >
> > Jonathan
> >
> > _____________________________________________________
> > jonathan_at_gennick.com
> > http://gennick.com
> > Brighten the Corner Where You Are
> >
> >

Received on Wed Sep 22 1999 - 11:41:53 CDT