RE: Upgrade 8.0.5 to 8.1.7.2

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-----
Sent: Wednesday, September 26, 2001 2:35 PM To: Multiple recipients of list ORACLE-L

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: Kevin Lange
  INET: kgel_at_ppoone.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).