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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Licensing Issue

Re: Oracle Licensing Issue

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Thu, 23 Jun 2005 21:52:45 -0700
Message-ID: <WlMue.2280$8o.204@fed1read03>


"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1119574869.848500_at_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)

This is quoted straight from the Sybex 10g certification book: Oracle 10g supports the direct upgrade of database from the following releases:

*    Oracle 8 Release 8.0.6
*    Oracle 8i Release 8.1.7
*    Oracle 9i Release 1 -- 9.0.1
*    Oracle 9i Release 2 -- 9.2.0

And this is quoted directly from the 10gR1 upgrade manual: Determine the Upgrade Path to the New Oracle Database 10g Release The path that you must take to upgrade to the new Oracle Database 10g release depends on the release number of your current database. Table 2-1 contains the required upgrade path for each release of the Oracle Database. Use the upgrade path and the specified documentation to upgrade your database.

Table 2-1 Upgrade Paths

      Current Release Upgrade Path
      7.3.3 and Lower
      7.3.4

      8.0.3

      8.0.4

      8.0.5
     Direct upgrade is not supported. Complete the following steps to 
upgrade to the new Oracle Database 10g release:
        1.. Upgrade to an intermediate Oracle Database release using the 
instructions in the intermediate release' s documentation.

        2.. Upgrade the intermediate release database to the new Oracle Database 10g release using the instructions in Chapter 3, "Upgrading a Database to the New Oracle Database 10g Release".

      8.0.6 Direct upgrade is supported. Upgrade to the new Oracle Database 10g release using the instructions in Chapter 3, "Upgrading a Database to the New Oracle Database 10g Release".

      8.1.5
      8.1.6
     Direct upgrade is not supported. Complete the following steps to 
upgrade to the new Oracle Database 10g release:
        1.. Upgrade to an intermediate Oracle Database release using the 
instructions in the intermediate release's documentation.

        2.. Upgrade the intermediate release database to the new Oracle Database 10g release using the instructions in Chapter 3, "Upgrading a Database to the New Oracle Database 10g Release".

      8.1.7
      9.0.1

      9.2
     Direct upgrade is supported. Upgrade to the new Oracle Database 10g 
release using the instructions in Chapter 3, "Upgrading a Database to the New Oracle Database 10g Release".

Both the manual and the certification guide *specifically* state that upgrade below 8.0.6, 8.1.7, respectively is not supported, but you can do an intermediate upgrade till you get to 8.0.6 or 8.1.7, respectively, then do the 10g upgrade. You may see spurious scripts for upgrade from lower versions. You have my permission to try them on your production system and see what happens. :-D

*Disclaimer: Poster does not advocate nor suggest actually using unsupported upgrade scripts and the previous comment is not to be taken as actual permission to use unsupported scripts.

Now either both the certification guide and the Oracle upgrade manual are dead wrong, or there might be some left over pieces from the install process.

You know how sometimes you get a hankerin' to take apart your engine, but when you put it back together there are some extra parts left over? You don't need those, right?

The studying for the OCP/OCA certification(s) drilled Oracle fundamentals into my skull. I still have the scars. I did not "buy the answers" as some others have suggested of other OCP's. I had to read the certification guide, the manuals, experiment, and take SelfTest practice tests till I knew the knowledge and theory behind the questions. I did not memorize the questions. I learned the theories and application of the theories. It didn't hurt either that I've been working with an 8i production system for the past 5 years. :-D

-- 
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup 
Received on Thu Jun 23 2005 - 23:52:45 CDT

Original text of this message

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