RE: upgrade from to

From: <>
Date: Tue, 24 Feb 2009 10:03:01 -0500
Message-ID: <>

And remember to backup your ORACLE_HOME, orainventory, and database before beginning.

From: [] On Behalf Of Andrew Kerber Sent: February 24, 2009 9:26 AM
Cc:; oracle list Subject: Re: upgrade from to

Basically, you do this (standard upgrade methodology):

  1. Shutdown everything in the OH you want to upgrade.
  2. Install the patchset.
  3. Startup upgrade
  4. run catupgrd.sql
  5. shutdown immediate/startup
  6. Run utlrp.sql
  7. Done.

The biggest problem I had was the undo setting. I had the undo retention set too high, and I ran out of undo tablespace, and everything froze waiting for my undo retention time to elapse. On Tue, Feb 24, 2009 at 7:37 AM, Zelli, Brian <<>> wrote: I've sifted thru the metalink note 553812.1 and then it pointed me to 550739.1 which then points me to another couple of notes. Is there someone who went thru this and can just give me the freakin cliff notes on it? I tired to follow the scripts but it keeps getting confusing.


-----Original Message-----
From:<> [<>] On Behalf Of Nuno Souto Sent: Tuesday, February 24, 2009 5:27 AM Cc: oracle list
Subject: Re: upgrade from to

Zelli, Brian wrote,on my timestamp of 24/02/2009 6:57 AM:
> HP UX Itanium 64 bit. I want to upgrade from to
> Can I do this straight or do I have to move thru versions? Also I
> keep seeing something about timezone 4. My version has timezone 2.
> What's the deal with this?

If you've run for any appreciable length of time, then likely the time columns in the scheduler package are stuffed up when you upgrade to<>. There is a note on Metalink about this and which script you need to run to fix the problem. It is not included in the upgrade, so if the scheduler jobs stop working you know what the problem is anyway. The<> upgrade involves a step that upgrades the dictionary as well, so no turning back the clock once done: take a backup before, just in case.
Yes, it is a single step upgrade.

Nuno Souto
in sunny Sydney, Australia<>

This email message may contain legally privileged and/or confidential information.  If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited.  If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

Andrew W. Kerber

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

Received on Tue Feb 24 2009 - 09:03:01 CST

Original text of this message