Re: Upgrade session interrupted - nohup catupgrd.sql?

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