RE: Upgrade directly to 8.1.7.3?

Hello Barbara

I did not worked with 8.1.7 but I installed patches in 8.1.6. I think (please check this) that maybe 8.1.7.3 is just a binary and external

files replacement and no scripts are run. In this case you need to run the scripts that convert the DB from 8.0.5 to 8.1.7
because they are not part of 8.1.7.3.

Anyway, I would suggest that you convert the DB to 8.1.7.2 and if everything is OK
upgrade later to 8.1.7.3. Upgrade like this does not need a new home and 1GB on disk.

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Baker, Barbara [SMTP:bbaker_at_denvernewspaperagency.com]
> Sent: Wed, February 27, 2002 6:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Upgrade directly to 8.1.7.3?
>
> 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

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