Re: oracle upgrade without downtime?

From: Martin Haltmayer <Martin.Haltmayer_at_d2mail.de>
Date: Sat, 05 Jan 2002 01:32:27 +0100
Message-ID: <3C36499B.68DC1825@d2mail.de>

They don't.

Assume you have to apply a patch. Applying a patch according to the docs of 8.1.7.2 and 9.0.1.2 implies running catalog.sql and catproc.sql, "create or replace java system", starting with _system_trig_enabled = false and the like. Even on a fast system (E10K in our case with 32 processors) it took nearly an hour to get it done. Because you are working on the database as a whole you cannot start one instance of an OPS (or RAC) cluster.

This is a major weak point in using Oracle for high-availability installations. So prepare for an hour downtime each time you apply a patchset.

For upgrading it is even worse because you have to run more scripts.

Regards,

Martin

Ray Stell wrote:
>
> How do 24x7 shops upgrade oracle software without downtime?
> ===============================================================
> Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
Received on Fri Jan 04 2002 - 18:32:27 CST