Re: Upgrade session interrupted - nohup catupgrd.sql?
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