Re: upgrade from 10.2.0.1 to 10.2.0.4
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Brian.Zelli@xxxxxxxxxxxxxxx
- Date: Tue, 24 Feb 2009 08:25:39 -0600
Basically, you do this (standard upgrade methodology):
1. Shutdown everything in the OH you want to upgrade.
2. Install the 10.2.0.4 patchset.
3. Startup upgrade
3. run catupgrd.sql
4. shutdown immediate/startup
5. Run utlrp.sql
6. 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
<Brian.Zelli@xxxxxxxxxxxxxxx>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.
>
>
>
> ciao,
> Brian
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxx
> --
> //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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
