RE: upgrade from 10.2.0.1 to 10.2.0.4
Date: Tue, 24 Feb 2009 10:03:01 -0500
And remember to backup your ORACLE_HOME, orainventory, and database before beginning.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber Sent: February 24, 2009 9:26 AM
Cc: dbvision_at_iinet.net.au; oracle list Subject: Re: upgrade from 10.2.0.1 to 10.2.0.4
Basically, you do this (standard upgrade methodology):
- Shutdown everything in the OH you want to upgrade.
- Install the 10.2.0.4 patchset.
- Startup upgrade
- run catupgrd.sql
- shutdown immediate/startup
- Run utlrp.sql
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 <Brian.Zelli_at_roswellpark.org<mailto:Brian.Zelli_at_roswellpark.org>> 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.
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of Nuno Souto Sent: Tuesday, February 24, 2009 5:27 AM Cc: oracle list
Subject: Re: upgrade from 10.2.0.1 to 10.2.0.4
Zelli, Brian wrote,on my timestamp of 24/02/2009 6:57 AM:
> HP UX Itanium 64 bit. I want to upgrade from 10.2.0.1 to 10.2.0.4.
> 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 10.2.0.1 for any appreciable length of time, then likely
the time columns in the scheduler package are stuffed up when you
upgrade to 10.2.0.3/4<http://10.2.0.3/4>.
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 10.2.0.4 upgrade, so if
the scheduler jobs stop working you know what the problem is anyway.
The 10.2.0.3/4<http://10.2.0.3/4> upgrade involves a step that upgrades the dictionary as
well, so no turning back the clock once done: take a backup before, just
Yes, it is a single step upgrade.
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au<mailto:dbvision_at_iinet.net.au> -- http://www.freelists.org/webpage/oracle-l 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. -- http://www.freelists.org/webpage/oracle-l -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 24 2009 - 09:03:01 CST