Re: Oracle Licensing Issue

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 23 Jun 2005 18:04:07 -0700
Message-ID: <1119575060.965159@yasure>

makbo_at_pacbell.net wrote:
> DA Morgan wrote:
>

>>Mark Bole wrote:
>>
>>>DA Morgan wrote:
>>>

>
> [...]
>

>>>Another reason would be to migrate to 9i, which is only supported coming
>>>from 8.1.7.4, not 8.1.5.
>>>

>
> [...]
>

>>Are you sure? 10gR1 contains upgrade scripts going back to 8.0.5. as
>>follows:
>>
>>0800080.sql
>>0801050.sql
>>0801060.sql
>>0801070.sql
>>0900010.sql
>>0902000.sql

>
>
> Can't say I've tested it. But I was going by the following note
> 159657.1. Maybe 10g has made things better?
>
> "Upgrade path for Oracle 8i [to 9i]:
>
> If your old release version is 8.1.5 or 8.1.6, then direct upgrade to
> Oracle 9.2 is NOT supported. You must first upgrade this version to
> 8.1.7. After the
> upgrade to 8.1.7 or your version IS 8.1.7, you can directly upgrade
> your
> database to Oracle 9.2. However, if your target release is 9.0.1,
> direct upgrade from 8.1.5 and 8.1.6 is supported. "

Once again the header from a 10g file.

Rem DESCRIPTION

Rem     This script is to be used for upgrading an 8.0.6 database to the
Rem     new release.  This script provides a direct upgrade path from 8.0.6
Rem     to the new Oracle release.
Rem
Rem      The upgrade is partitioned into the following 5 stages:
Rem        STAGE 1: call i0800050.sql:
Rem                 This loads all tables that are necessary
Rem                 to perform basic sql commands.
Rem        STAGE 2: call utlip.sql to invalidate views, procedures, 
packages...
Rem        STAGE 3: call c0800050.sql:
Rem                 This performs all necessary dictionary
Rem                 upgrade to bring the db from 8.0.5 to the
Rem                 new release.
Rem        STAGE 4: call a0800050.sql:
Rem                 This performs all necessary upgrade using
Rem                 anonymous blocks.
Rem        STAGE 5: call cmpdbmig.sql
Rem                 This calls the upgrade scripts for all of the
Rem                 components that have been loaded into the database

Note STAGE 4 and 5. I see nothing indicating a need to move to 8.1.7. Could be wrong. But it isn't here in $ORACLE_HOME/rdbms/admin.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Jun 23 2005 - 20:04:07 CDT