Re: Upgrade session interrupted - nohup catupgrd.sql?

From: Howard Latham <howard.latham_at_gmail.com>
Date: Thu, 21 Oct 2010 13:37:58 +0100
Message-ID: <AANLkTimtopN1fNBZocn6hHjpGcj9pGt-bf9axwiuZjbr_at_mail.gmail.com>

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_at_gmail.com> 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
> - _at_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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Howard A. Latham

Sent from my Nokia N97

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

Received on Thu Oct 21 2010 - 07:37:58 CDT