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.

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
in case.
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-l