Re: preparing for first upgrade as dba

Ben wrote:
> currently running 9.2.0.5 Ent Ed on AIX 5.2
> We are gearing up for upgrading to 10gR2 (10.2.0.1) and this will be
> the first major release upgrade that I've had to perform. I am
> studying the general upgrade manuals, release notes, metalink notes
> for os versions, etc. I've gotten opinions on training and consulting
> for assistance and I'm fairly certain we are going to bring in a
> consulting firm for help.
> In reading the various documentation it says to patch the freshly
> installed 10.2.0.1 to the latest patches and critical updates. I'm
> curious though (I've looked in meta link and can't find this spelled
> out anywhere), If I apply the patch to 10.2.0.3 does that include
> 10.2.0.2 as well?

Yes.

> Also, what about the critical patch updates for
> security and such. If I apply the latest the CPU, would that be
> equivilant to applying the patch to get to 10.2.0.3?

Depends. You need to search of the quarterly updates.

Be sure you practice several times on a test machine before touching production and on production, make sure you not only have a full backup, but make sure you can restore from it.

One of my clients, two months ago, did everything right except test their backup. It was rather ugly. (vendor update not an Oracle update).

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org