Oracle-L: Is this a good upgrade path from 8.0.4 to 8.1.7.2?

From: <Cherie_Machler_at_gelco.com>
Date: Thu, 06 Jun 2002 08:43:33 -0800
Message-ID: <F001.0047649B.20020606084333@fatcity.com>

We are preparing to do an upgrade of our Data Warehouse on Sun Solaris from version 8.0.4.0.0 to 8.1.7.2.

We've done a number of upgrades in the past but this is the first time we are going from 8.0.4 to 8.1.7.

Following is the basic, high level plan:

Upgrade from 8.0.4 to 8.1.7.0 (Oracle software already pre-installed in separate Oracle Home).
Apply 8.1.7.2 patchset
Apply separate one-off-patch that we had created for a star transformation bug.

We are going to use the manual migration method as outlined in the 8.1.7 migration manual.

I've already tested this approach on a full-size RMAN clone of production that we moved to our QA box. However, that box already had 8.1.7.2 pre-installed on it before I actually migrated the database.

Just wondering if anyone has gone directly from 8.0.4 to 8.1.7.2. Are there any gotchas or concerns? At one point I thought we might have to upgrade from 8.0.4 to 8.1.5 and then from 8.1.5 to 8.1.7. But now I can't find anywhere in the documentation where it says that I need to do that so we are thinking about saving a little time and going straight from 8.0.4 to 8.1.7.

This is a 200 Gig warehouse which uses Verita Quick I/O, partitioning, star schema, etc.

Thanks to anyone who can alert me to any potential pitfalls. I cannot afford any glitches at all on this upgrade.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Cherie_Machler_at_gelco.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). Received on Thu Jun 06 2002 - 11:43:33 CDT