Tuesday, July 25, 2006

Oracle 10g Enterprise Manager Packages usage and licensing

The Enterprise Manager for Oracle 10g comes with a number of packages which need an additional license if you want to use them. These packages get installed automatically with Enterprise Edition and can be accessed from inside the EM-console (database control, grid control) as well as through APIs from inside the database.
These packages are as follows:
- Database Diagnostics Pack
- Database Diagnostics Pack
- Configuration Management Pack

What many DBAs do not know is the fact that you also need the additional licenses if you do not use the EM at all but use certain functionalities such as reports created with scripts located in $ORACLE_HOME/rdbms/admin or just by using certain procedures from a number of advisor packages, because these functionalities use the above listed packages.

Here is a list of functionalities which need additional licensing in Oracle 10g Enterprise Edition and how you access them:

- Database Diagnostic Pack includes:
- use of DBMS_WORKLOAD_REPOSITORY package
- use of DBMS_ADVISOR PACK if:
- when using any ADDM prefix for the value of the ADVISOR_NAME parameter
- when using any ADDM prefix for the value of the TASK_NAME parameter
- use of the view V$ACTIVE_SESSION_HISTORY
- use of any Data Dictionary view the DBA_HIST_ prefix in the name of the view
- use of any Data Dictionary view the DBA_ADVISOR_ prefix in the name of the view if query to these views retuns values from the ADDM or ADVISOR_NAME column or a value of ADDM* inthe TASK_NAME column or the corresponding TASK_ID

- use of any of the following reports created by using one of the following scripts from $ORACLE_HOME/rdbms/admin:
awrrpt.sql
awrrpti.sql
addmrtp.sql
addmrpti.sql
awrrpt.sql
awrrpti.sql
addmrpt.sql
addmrpti.sql
ashrpt.sql
ashrpti.sql
awrddrpt.sql
and awrddrpi.sql

- Database Tuning Pack includes (needs Diagnostics Pack as prerequisit!):
- use of the DBMS_SQLTUNE
- use of DBMS_ADVISOR if the parameter ADVISOR_NAME is set to SQL Tuning Advisor or SQL Access Advisor
- use of the script $ORACLE_HOME/rdbms/admin/sqlrpt.sql

- Configuration Management Pack
- software and hardware inventory with history function
- patching
- cloning
- policy framework

It is possible to disable the access to these packages from inside the EM-console by navigating to the SETUP link. If you cannot efford to buy these licenses you can still use the classical methods for performance tuning like statspack, sql tracing and performance statistics from the v$views.

24 Comments:

At Thu Jul 27, 09:34:00 PM, Anonymous Arun Gupta said...

This is very useful information. I was always looking for it but never could find it. Thanks so much!!

 
At Fri Jul 28, 11:14:00 AM, Blogger lutz_hartmann said...

Hi Arun,
thank you yery much for your feedback.
I try to publish things which aare not well known and just came across this info when I was preparing for a new course I will deliver shortly.
So stay tuned and spread the news! I will keep on blogging.
=;-)
Lutz

 
At Mon Jul 31, 03:39:00 PM, Anonymous Anonymous said...

Hi,
there is a new manual called Licensing Information that gives a nice overview of what do you get licensed with every pack.

Check it out at : http://download-uk.oracle.com/docs/cd/B19306_01/license.102/b14199/toc.htm


cheers,
pedro

 
At Tue Aug 01, 10:15:00 PM, Anonymous Tim Gotham said...

This is very useful information. How would this information change if the subject is standard edition? All of these options are in EM by default with standard edition also. Why doesn't Oracle disable all these non-licneseable features by default when installing standard edition of the DB?

 
At Wed Aug 02, 08:48:00 AM, Anonymous Pankaj said...

Thanks Lutz,
This is very useful information, but I am confused on the following point.
Shouldn't these packages should come pre-blocked. I mean... they should not be accessible till u buy those additional licenses. Many DBAs won't be knowing this and might be using these packages. How is Oracle going to tacle with that?

 
At Wed Aug 02, 09:53:00 AM, Anonymous John Holden said...

Ideally there would be some way of "switching on" the licensed options, to make a deliberate statement, "I have this licence", without which you simply can't use the added functionality.
I don't want to misuse software but Oracle does not make it easy.
John Holden

 
At Wed Aug 02, 03:02:00 PM, Blogger lutz_hartmann said...

Hi John,
yes you are definitely right. You can turn off the packages in OEM, but still it is not easy to catch up with the restrictions. It is virtually almost all new nice fancy funtionalities which need the additional license.
=;-(

 
At Wed Aug 02, 03:10:00 PM, Blogger lutz_hartmann said...

Hi Pankaj,
I agree with you but this policy is not new with Oracle. Already in older releases you had all the packages for OEM shipped and installed and if you wanted to use them you needed an additional license for them.
I do not make these policies, sorry.
But I hear what you are saying and I can understand your displeasure.
All we can do is cope with it, can't we.
But anyway, these functionalities are great I think and I am happy that we have them!
And can also understand that Oracle does not hand theem out for free.

It could be only much more easy to look through and thereby much more convenient for the customers.
=;-)

 
At Wed Aug 02, 04:38:00 PM, Anonymous Anonymous said...

you excluded change management (which is separate as well)

There is also provisioning for cloning Oracle and O/S software to other nodes and distributing patches to the oracle software (app server and db) as well as linux o/s.

Service Level Management is actually one of the most useful things Oracle has released for performance monitoring because you monitor and record apps or sql or ldap, etc.. performance from a real end user's perspective, not just some metrics in the DB.

 
At Thu Aug 03, 11:59:00 AM, Blogger lutz_hartmann said...

Hi anonymous,
thank you for mentioning the change management.
Is this something different from what I posted?:
Configuration Management Pack
- software and hardware inventory with history function
- patching
- cloning
- policy framework
=;-)

 
At Thu Aug 03, 02:48:00 PM, Anonymous Anonymous said...

My assumption based on the above is
that if you use Oracle Standard Edition, Oracle Enterprise Manager and no management packs and don't use any of the views mentioned above then there is no additional license cost. So based on this, I assume I can use OEM for Backup and Recovery.
Actually I'm still waiting back for an answer from Oracle with respect to this.

 
At Mon Aug 07, 05:09:00 PM, Blogger lutz_hartmann said...

Hi anonymous,
I have asked development and here is the answer:

No additional licensing for RMAN, whether db or grid control.

There are feature differences between standard and enterprise editions, check:
http://www.oracle.com/technology/products/database/oracle10g/pdf/twp_general_10gdb_product_family.pdf

Hope this helps
=;-)
Best regards,
Lutz

 
At Mon Aug 14, 11:28:00 AM, Anonymous Anonymous said...

I do not agree with oracle.
I buy the expensive rdbms enteprise edition and also I must pay for options that allow its management.
It' is incredible !!

 
At Mon Aug 14, 11:32:00 AM, Anonymous Anonymous said...

It is incredible that I must pay for options that allow the management of database.

I don't belive it ! : - ((

 
At Mon Aug 14, 01:44:00 PM, Blogger lutz_hartmann said...

Hi anonymous, these packages have always been extra cost options.
You can get tools like these from 3rd. party vendors also, and they also are not for free.
The other possibilty would be to create your own framework using PL/SQL or JAVA or something.

Sorry for this, I can understand you being upset!
=;-)

 
At Tue Sep 19, 06:36:00 PM, Anonymous Anonymous said...

Can you use the 'awrrpt.sql' and 'addmrpt.sql' reports on Oracle 10g standard edition without licenses?

It isn't clear to me sorry.

Thanks,

Russell

 
At Tue Sep 19, 06:37:00 PM, Anonymous Anonymous said...

Can you use the 'awrrpt.sql' and 'addmrpt.sql' reports on Oracle 10g standard edition without licenses?

It isn't clear to me sorry.

Thanks,

Russell

 
At Fri Sep 29, 07:41:00 AM, Blogger lutz_hartmann said...

you need to have the license for the EM packages, yes!
=;-(

 
At Sun Feb 11, 08:58:00 AM, Blogger lutz_hartmann said...

Hi Russel,
I had a look at the docomentation and as you can see here, all these packages are only for Enterprise Edition:
http://download-uk.oracle.com/docs/cd/B19306_01/license.102/b14199/editions.htm#CJACGHEB
I am not sure that addmrpt.sql would even be there in Standard Edition.
You must check and try. I am pretty sure that it will not work.
=;-)

 
At Wed Feb 14, 10:45:00 PM, Blogger lutz_hartmann said...

Hi Russel,
I have installed 10gR2 Standard Edition today on Linux just to find it out definitely.
And I was very much surprised:
ADDM works and the PACKAGES are available.
The docu says very clearly that these packages are only available for Enterprise Edition and that they are Extra Cost Option.

I do not understand it, sorry.
You find me puzzled.
=8-)

 
At Mon Oct 01, 10:44:00 PM, Anonymous Anonymous said...

Hi Lutz,
I have Oracle 10g running on one of my development database but the backup that I set up using the EM does run every after 6 miniutes thus filling up the recovery file dest size in a day. I checked the set up of the backup and it looked exactly the same as the other database servers but just can not figure out the problem. The other database servers are backing up once a night except this particular one which runs every 6 minutes.
Thank you in advance for your help on this issue.
BR,
Enayet Khan

 
At Wed Mar 12, 11:56:00 AM, Anonymous Anonymous said...

Hi Lutz,

they are there in Standard Edition but if you use them you must upgrade to Enterprise Edition and License them

 
At Thu May 08, 10:45:00 AM, Anonymous Anonymous said...

Hi Lutz,

we have Standard Edition installed and we are also able to activate and use these packages, but you can only buy the licence for the packages, if you have Enterprise Edition Licence. That´s what Oracle said to us.

Kind Regards

Detlef

 
At Wed Aug 27, 10:58:00 PM, Anonymous Anonymous said...

And they are installed on a brief trial period. If you dont uninstall, you need to pay.

 

Post a Comment

<< Home