Re: Oracle Licensing Issue

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 23 Jun 2005 18:00:56 -0700
Message-ID: <1119574869.848500@yasure>

Andreas Sheriff wrote:

> "DA Morgan" <damorgan_at_psoug.org> wrote in message 
> news:1119570257.545835_at_yasure...
> 

>>Mark Bole wrote:
>>
>>>DA Morgan wrote:
>>>
>>>
>>>>Andreas Sheriff wrote:
>>>>
>>>>
>>>>>Hi,
>>>>>
>>>>>My eyes are starting to turn inside out.
>>>>>
>>>>>Does anyone have a good grasp on Oracle licensing?
>>>>>
>>>>>We currently have Oracle Enterprise 8.1.5 installed.
>>>>>Is 8.1.7 considered an update or another product altogether?
>>>>
>>>>
>>>>
>>>>8.1.7 is considered unsupported and obsolete.
>>>>
>>>>The only reason to move to 8.1.7 from 8.1.5 would be if you
>>>>made really bad purchasing decision from a third-party vendor
>>>>in which case you would need to know what the original license
>>>>said.
>>>
>>>
>>>Another reason would be to migrate to 9i, which is only supported coming
>>>from 8.1.7.4, not 8.1.5.
>>>
>>>AFAIK, Oracle RDBMS licensing covers all versions. It's the CPU or named
>>>users you are licensing (capacity), not the version. But you need paid
>>>support to download patches.
>>>
>>>-Mark Bole
>>
>>Are you sure? 10gR1 contains upgrade scripts going back to 8.0.5. as
>>follows:
>>
>>0800050.sql
>>0801050.sql
>>0801060.sql
>>0801070.sql
>>0900010.sql
>>0902000.sql
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)

> 
> 
> According to the OCP tests, an upgrade to 10gR1 can only come from 8.06, 
> 8.1.7, 9.x.  I don't know why you see scripts going back to 8.0.5, but I 
> wouldn't run them.  They're probably like the RBO in 10g.  It's there, but 
> it's no longer supported.

Here's one of the 10g file headers.

Rem
Rem $Header: a0800050.sql 04-nov-2003.10:27:15 weiwang Exp $ Rem
Rem a0800050.sql
Rem
Rem Copyright (c) 1998, 2003, Oracle Corporation. All rights reserved. Rem
Rem NAME

Rem      a0800050.sql - additional ANONYMOUS BLOCK dictionary upgrade.
Rem      		Upgrade Oracle RDBMS from 8.0.5 to the new release

Rem
Rem DESCRIPTION

Rem      Additional upgrade script to be run during the migration of a
Rem      8.0.5 database to the new release.
Rem
Rem	 This script is called from u0800050.sql and a0800040.sql
Rem
Rem	 Put any anonymous block related changes here.
Rem	 Any dictionary create, alter, updates and deletes
Rem 	 that must be performed before catalog.sql and catproc.sql go
Rem	 in c0800050.sql
Rem
Rem      The upgrade is performed in the following stages:
Rem        STAGE 1: additional steps to upgrade from 8.0.5 to 8.1.3
Rem        STAGE 2: upgrade from 8.0.5 to 8.1.3
Rem        STAGE 3: upgrade from 8.1.3 to 8.1.4
Rem        STAGE 4: upgrade from 8.1.4 to new release

Rem
Rem NOTES

Rem      * This script must be run using SQL*PLUS.
Rem      * You must be connected AS SYSDBA to run this script.

Rem

Rem    MODIFIED   (MM/DD/YY)
Rem    weiwang     11/03/03 - change force drop queue to drop queue
Rem    weiwang     09/08/03 - fix sigature of kwqa_3gl_createqueue
Rem    smalathe    03/11/02 - Bug2177840: Populate lcname in 
repcat$_repcolumn
Rem    rburns      02/08/01 - fix aq affinities

Rem arrajara 01/18/01 - Obsolete "r" scripts. Move the contents to "a" Rem arrajara 01/14/01 - Move repl specific non-proc stmts to "c" script
Rem rkambo 12/11/00 - validate object types being used by queue tables
Rem arithikr 12/11/00 - 1489592: remove def$_pushed_transactions table,

Rem                           insert and update aq$_queue_table_affinities.
Rem    jdavison    04/11/00 - Modify usage notes for 8.2 changes.
Rem    rshaikh     11/10/99 - add commit
Rem    rshaikh     11/01/99 - move 8.1.3 and 8.1.4 upgrade here
Rem    mkamath     02/04/99 - fixing AQ propagation upgrade
Rem    mrhodes     01/05/99 - set AQ compatible to 8.0
Rem    ato         12/10/98 - fix AQ CreateQueue
Rem    rshaikh     10/15/98 - add comments advanced replication
Rem    ato         09/10/98 - rollback 3gl callouts
Rem    ncramesh    08/04/98 - change for sqlplus
Rem    rshaikh     07/21/98 - call a0801030.sql
Rem    liwong      07/21/98 - Add repcat$_repcat.flag 

Rem    hasun       06/30/98 - Apply snapshot upgrade from old u0800050
Rem    ato         06/12/98 - recreate existing AQ objects as first 
class obje
Rem    rshaikh     06/17/98 -  move all anonymous block stmts from
Rem			      u0800050.sql here

History goes back to 1998. So my presumption is the OCP is wrong again. What a huge surprise. I'd better go get my nitro pills for my heart.

-- 
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:00:56 CDT