Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: restarting a 8.1.7 -> 9.2.0 upgrade

Re: restarting a 8.1.7 -> 9.2.0 upgrade

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Sun, 12 Sep 2004 12:35:07 -0400
Message-ID: <BAY2-F10sYfO5vTcvut000185a0@hotmail.com>


Yes, this script can be run again if it failed/crashed during upgrade. Just make sure you have put database in NOarchivelog mode as it writes a lot and generates a lot of redo logs.

I have faced it couple of time and I started it again from 'startup migrate' and then applied upgrade script.

If java objects installed then you have to increase shared_pool_size to 150MB+ and java_pool_size to 150MB+ during upgrade process then put it back to original size.

Regards
Rafiq

From: Jeremiah Wilton <jwilton_at_speakeasy.net> Reply-To: jwilton_at_speakeasy.net
To: "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS_at_GE.COM> CC: oracle-l_at_freelists.org
Subject: Re: restarting a 8.1.7 -> 9.2.0 upgrade Date: Sun, 12 Sep 2004 00:36:00 -0700 (PDT)

On Sun, 12 Sep 2004, Adams, Matthew (GE Consumer & Industrial) wrote:

> Anybody know where it might be documented whether=20
> the upgrade script can be restarted if the machine
> crashes during the upgrade? (as it just did)

If you mean can you rerun u0801070.sql, I think you can without adverse effects.

Or you can look at where it left off in your spool file (you are spooling output, right?), and just execute the rest of u0801070.sql.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
To search the archives - http://www.freelists.org/archives/oracle-l/

_________________________________________________________________
Donít just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/
Received on Sun Sep 12 2004 - 11:30:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US