From the Upgrade Guide (http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/upgrade.htm#i1011600): "Resource Limits If you run out of resources during the upgrade, then increase the resource allocation. After increasing the resource allocation, you should perform a SHUTDOWN ABORT and restart the instance (in UPGRADE mode) before rerunning the catupgrd.sql script or restarting DBUA." Cheers, cam On Thu, Oct 21, 2010 at 1:46 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote: > Usually running catupgrd multiple times wont cause any problems. I have > seen several problem solutions that recommend the re-running of catupgrd. > > On Thu, Oct 21, 2010 at 7:37 AM, Howard Latham <howard.latham@xxxxxxxxx> > wrote: >> >> Be very careful - A collegue once ran an Oracle upgrade script twice and >> ended up with a bricked database. >> >> >> On 21 October 2010 13:28, cam <kadmon@xxxxxxxxx> wrote: >>> >>> Hello all, >>> >>> This seems like an obvious and common one but I haven't managed to >>> find any relevant Q&As here or on the OTN discussion boards. >>> >>> While remotely running catupgrd.sql to take an instance from 9.2.0.8 >>> to 11.1.0.7 my session was killed... When I got back on, I decided the >>> situation was closest to the situation described under Resource >>> exhaustion in the 11g Upgrade guide and went for: >>> >>> - shutdown abort >>> - startup upgrade >>> - @catupgrd.sql >>> >>> This seems to have just completed successfully but I'd be interested >>> in any responses to the following: >>> >>> - does this seem like the correct way to resume the upgrade - it isn't >>> explicitly documented anywhere. >>> - since its not interactive, I assume its OK to nohup catupgrd - but >>> people don't often seem to do it. Can anyone confirm that it works and >>> doesn't get confused for some reason? >>> >>> cam >>> -- >>> //www.freelists.org/webpage/oracle-l >>> >>> >> >> >> >> -- >> Howard A. Latham >> >> Sent from my Nokia N97 >> > > > > -- > Andrew W. Kerber > > 'If at first you dont succeed, dont take up skydiving.' > -- //www.freelists.org/webpage/oracle-l