Re: Upgrade session interrupted - nohup catupgrd.sql?

From: <troach_at_gmail.com>
Date: Thu, 21 Oct 2010 13:31:57 +0000
Message-ID: 605480165-1287667907-cardhu_decombobulator_blackberry.rim.net-1868598587-_at_bda021.bisx.prod.on.blackberry>



You got a lot of comments which are good. When running these things remote I always use screen so that if my session is disconnected I am able to reconnect without it getting killed due to a network interrupt or something happening on the client side like Windows trying to automatically restart due to a windows update or a system crash. Just my 2 cents :) Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: cam <kadmon_at_gmail.com>
Sender: oracle-l-bounce_at_freelists.org Date: Thu, 21 Oct 2010 13:28:42
To: <oracle-l_at_freelists.org>
Reply-To: kadmon_at_gmail.com
Subject: Upgrade session interrupted - nohup catupgrd.sql?

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

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Thu Oct 21 2010 - 08:31:57 CDT

Original text of this message