What others have already recommended, but on top of that I would be careful with a shutdown abort prior to startup upgrade. I've had cases at more than 1 customer where I could reproduce core dumps (ORA-7445) and ORA-600's doing that. And yes, some version of the upgrade guide recommends to do exactly this. I would however do a shutdown immediate if you're planning to run the upgrade afterwards. And this coming from a great fan of shutdown abort ;-) My CHF 0.02 Stefan ========================= Stefan P Knecht CEO & Founder s@xxxxxxxx 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 Wallisellen Switzerland Phone +41-(0)8400-10046 Cell +41 (0) 79 571 36 27 info@xxxxxxxx http://www.10046.ch ========================= On Thu, Oct 21, 2010 at 2:28 PM, 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 > > >