Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Licensing Issue
"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. >
>
>
>
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 theinstructions 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 theinstructions 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 10grelease 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 newsgroupReceived on Thu Jun 23 2005 - 23:52:45 CDT