Re: Upgrade session interrupted - nohup catupgrd.sql?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 21 Oct 2010 07:46:42 -0500
Message-ID: <AANLkTin++hQjR0VoeEF9BFeN7m_mspr2Of7xqD1mP-9=_at_mail.gmail.com>



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_at_gmail.com>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_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
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 21 2010 - 07:46:42 CDT

Original text of this message