Re: Upgrade 8.0.5 to 8.1.7.2

I think I didn't make it clear at beginning. I apologize for that. We did apply the 8172 patch to 817, not 8.0.x or 8.1.6.

Our upgrade path is installed the 817 on a different oracle home, --> apply 8172 patch to 817 ---> upgrade 816 to 8172.

Joan

Joan Hsieh wrote:
>
> 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).