RE: ZERO Database Downtime???

You can't apply 10.2.0.2 without a full outage - from the patch notes ...

Set the CLUSTER_DATABASE initialization parameter to FALSE: <snip>
SQL> STARTUP UPGRADE As an aside, I would suggest anyone using ASM go directly to 10.2.0.2. Do not pass GO, do not collect 10.2.0.1.

Cheers,
Duncan.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tom Fox Sent: 29 March 2006 22:55
To: Jeremiah Wilton
Cc: oracle-l_at_freelists.org
Subject: RE: ZERO Database Downtime???

Yeah, that's what I meant. I would accept the invitation, but I don't have RAC running. :) It was just a quick thought off the top of my head.

From that blurb you wrote, I guess they took away the UPGRADE option in 10gR2. Is this related to their thought that RAC can be upgraded in a somewhat rolling state?

--Tom

On Wed, 29 Mar 2006, Jeremiah Wilton wrote:

> By this you must mean, first upgrade ORACLE_HOME binaries for each node, one
> at a time, then run the u10*.sql upgrade script on the database while
> everyone is connected and working.
>
> I would invite you to try this. Besides brief pauses in operation for the
> attrition and adding of each node, you can expect many invalid objects
> causing errors for users and many failed statements in the upgrade script
> due to ORA-54, leaving the upgrade in an unknown state. There is a reason
> the documentation says to run the upgrade script with the instances started
> in UPGRADE mode with no other users connected.
>
> Here's the blurb on UPGRADE mode from the docs:
>
> The UPGRADE keyword allows you to open a pre-10.2 database. It also
> restricts logons to AS SYSDBA sessions, disables system triggers, and
> performs additional operations that prepare the environment for the upgrade.
>
> --
> Jeremiah Wilton
> ORA-600 Consulting
> Recoveries - Consulting - Seminars
> http://www.ora-600.net
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Tom Fox
>
> Why wouldn't you upgrade all instances to the latest version first, then
> apply the database upgrade after all instances are up?
>
> This would allow for no database downtime.
>
>

--
http://www.freelists.org/webpage/oracle-l



==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

--
http://www.freelists.org/webpage/oracle-l