Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Upgrade directly to 8.1.7.3?

RE: Upgrade directly to 8.1.7.3?

From: Cunningham, Gerald <Gerald.Cunningham_at_usi.net>
Date: Wed, 27 Feb 2002 12:13:38 -0800
Message-ID: <F001.0041A300.20020227121338@fatcity.com>


Hi Barabara,

The wording is a bit clumsy, isn't it?

I would think you'd be fine since you're not really applying a patch, you've already got the binaries in place. The 4th digit is just bug fixes, the upgrade scripts (catalog.sql, catproc.sql, catrep.sql, etc. should be the same across all 8.1.7.x installs. Right?

Of course I could be completely wrong!

-----Original Message-----
Sent: Wednesday, February 27, 2002 11:08 AM To: Multiple recipients of list ORACLE-L

Solaris 2.6
Oracle 8.0.5 --> Oracle 8.1 --> Oracle 8.1.7.3

I have a Solaris box with a test and a production database. I have 2 code trees: 8.0.5, and 8.1.7 patched up to level 8.1.7.2. With Oracle's blessing (really, I opened a tar), I upgraded the test database directly from 8.0.5 to the 8.1.7.2 patch level. Did not pass go. Did not collect $200.

OK, here's a surprise. I still have not had an opportunity to upgrade production, which is still at 8.0.5, and now I'd like to upgrade it to patch level 8.1.7.3. However, the 8.1.7.3 patch documentation states that "When migrating a database from an earlier release, you must complete the database migration to the 8.1.7 release prior to applying this patch set."

If I believe this note, then I believe I must install a new code tree with a vanilla 8.17, then upgrade production from 8.0.5 to 8.1.7, then immediately upgrade again to 8.1.7.3 My problem: I don't have an extra gig of space to devote to another code tree. (And obviously I want to thoroughly test the test database with exactly the same version I'll be running in production, i.e., 8.1.7.3.)

I don't see a good reason not to go immediately to 8.1.7.3, especially since I was able to go directly to 8.1.7.2 with the test database, which worked nicely. However, this is a critical database, and I'd just as soon not screw it up.

Any words of widsom?

Thanks for any help.

Barb
qqqqqqqqqqqqq
(Jesse: I'm currently taking classes for the q-impaired. I'm feeling much better now.)

--

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

Author: Baker, Barbara
  INET: bbaker_at_denvernewspaperagency.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: Cunningham, Gerald
  INET: Gerald.Cunningham_at_usi.net
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 Wed Feb 27 2002 - 14:13:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US