Re: Upgrade 8.0.5 to 8.1.7.2

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