Re: Upgrade 8.0.5 to 8.1.7.2

Kevin,

Thanks for the warning. Our upgrade is from 816 to 8.1.7.2. Maybe that will make it different. From 805 to 8172. I think you must go to 817 first. Since we are already on 816, it is another story. I personally like go to 817, then 8172. But my colleague want take the chance to go directly to save time. Oracle support said it is not a problem, but they STRONGLY suggest follow the path.

Joan

Kevin Lange wrote:
>
> Joan;
> I am about to upgrade from 8.0.5 to 8.1.7.2 myself and I have been reading
> the Documentation. It clearly states that the PATCH must be applied to an
> 8.1.7 Database.
>
> Page 1 of 165 of the Oracle 8i Patch Set Notes: The last line in Paragraph
> 1 states:
>
> This is not a complete software distribution and you must install it over an
> existing 8.1.7 Oracle Server Installation.
>
> Under System Requirements, the table clearly shows that the RDBMS Baseline
> Release should be 8.1.7.0.0
>
> If you are going to apply an 8.1.7.2 patch to an 8.0.5 database you will
> probably do something you will regret.
>
> Kevin
>
> -----Original Message-----
> From: Joan Hsieh
> Sent: Wednesday, September 26, 2001 2:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Upgrade 8.0.5 to 8.1.7.2
>
> I original posted this question. Oracle support and the list member all
> suggest to install the 817 first -> upgrade -> apply patch. However,
> Oracle support said it will be ok if directly apply patch then upgrade
> later. Since we need to upgrade our peoplesoft tools and oracle in the
> same day, so we chose directly goes to 8172, eliminated the middle step.
> So far no problems with that. (not fully tested yet, just on test
> machine. Next week, we will go to production machine)
>
> Joan
>
> Binley Lim wrote:
> >
> > In the 8.1.7.1 patchset, it was stated quite clearly that you must
> upgrade, then apply the patch.
> >
> > In the 8.1.7.2 patchset, this requirement seems to have gone. So,
> interpret that how you like, but doing things in order should be the
> preferred option.
> >
> > One gotcha was leaving optimizer_features_enable unchanged after the
> upgrade. This was causing coredumps in queries involving views with
> co-related sub-queries. Changing the parameter to 8.1.7 seems to have fixed
> he problems.
> >
> > >>> bakerb_at_rockymountainnews.com 09/25/01 08:06AM >>>
> > 8.1.7 has not been installed. We need to upgrade our databases from 8.0.5
> > to 8.1.7.2
> >
> > I believe someone recently posed the question of whether to go from
> > 8.0 to 8.1.7 -> upgrade the database -> apply patchset for 8.1.7.2
> > -> upgrade the database
> > OR
> > install 8.1.7, immediately apply patchset, then upgrade the
> database
> > directly to 8.1.7.2
> >
> > I believe the concensus was for the 2nd option.
> >
> > After I run u0800050.sql, do I still need to walk through all the steps
> > associated with the patchset (i.e., disable systrem triggers, alter
> session
> > set events '10520 trace....', etc. etc.)
> >
> > Has anyone experienced problems going directly to patchset without
> upgrading
> > the database in the middle?
> > Any gotcha's??
> >
> > Thanks for any help!
> >
> > Barb
> >
> > (Environment: Solaris 2.6; current version 8.0.5.2.1; MTS; HA Cluster
> 2.1)
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Baker, Barbara
> > INET: bakerb_at_rockymountainnews.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Binley Lim
> > INET: Binley.Lim_at_ird.govt.nz
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).