RE: upgrade from 10.2.0.1 to 10.2.0.4
Date: Tue, 24 Feb 2009 08:37:56 -0500
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.
[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.
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 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.
-- Cheers Nuno Souto in sunny Sydney, Australia 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-lReceived on Tue Feb 24 2009 - 07:37:56 CST