Re: Q: Is Oracle 24*365 possible?

From: Dave Waterworth <pscdaw_at_ihug.com.au>
Date: Thu, 23 Sep 1999 00:47:43 +1000
Message-ID: <7saqbk$9dv$1@toto.tig.com.au>

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 - 09:47:43 CDT