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).