Keeping track of Oracle licenses with OEM12c – reports

Wouldn’t be nice to get regularly informed how (in)compliant you are with Oracle licenses in an easy – centralized – way, and therefore not have to worry about visits of Oracle’s LMS – License Management Services? I think that would be nice for the most of us. Running LMS-scripts on the target databases, hosts and middleware is for now the most thorough way to get informed about possible incompliancy. Or in some cased,  using some clever – but informal and mostly incomplete – scripting on the OEM-repository.

But… Oracle is making serious attempts to make this easier, by integrating the LMS-information  in the repository of Oracle Enterprise Manager and make this available through a couple of (BI Publisher) reports:

  • Database Usage Tracking Report
  • Database Usage Tracking Summary Report

When running these reports (Enterprise –> Reports  -> BI Publisher Reports) with OEM out of the box, unfortunately no data will be shown. There are some manual configuration and upgrades to be done. In the rest of the post I’ll explain some hurdles you have to overcome to get this working.

By the way, it’s not unthinkable that LMS will accept the outcome of these reports as a valid source for counting the (in)compliancy on a relative short notice.

By |May 16th, 2015|Categories: Database, licensing|Tags: , , |0 Comments

Oracle has changed the exhange rate of the Euro

For years the number of 0.7893 meant something to those who are working on regular basis with licenses in Europe. This number is the ‘Current local Pricing Exchange rate’.

And Oracle is entitled to change this rate twice a year:


By |March 2nd, 2015|Categories: licensing|Tags: , |0 Comments

Licensing ODA on NUP’s ?

Since Oracle launched the Oracle Database Appliance it is clear that only the Enterprise Edition is allowed on the machine. But for me it was still a little bit fuzzy if and what kind of licensing requirements is needed. More direct : may the ODA be licensed on NUP´s ? Some statements while investigating:


Customers are only required to license processor cores.


Licensing on processor cores, but not processor metric! Diving deeper….

By |April 23rd, 2013|Categories: licensing|Tags: , , |2 Comments

ODA – a brief view on a virtualized platform

Received a pdf from Oracle with the new features of the Oracle Database Appliance (when you are using the OracleVM-option).

Among other things, the two last sheets about the licensing had my attention too. I’m just showing the slides, haven’t worked with it, so I can’t tell you in detail the experiences. But the slides may give you an idea how the Virtualized Platform will look like in the new ODA, and how it will be licensed.















By |February 8th, 2013|Categories: Database|Tags: , , |2 Comments

How many NUP’s you really need when using Oracle Database ?

Something about licensing. Boring for the most of us, but this may save you a lot of money…. The next is not completely new, but I never had it on writing, so found it worthfull to blog.  The following has by the way no legal status and I’m not held responsible for any claims Oracle might want to put on your company (that is, can’t afford a lawyer..)

Maybe you know the rule: When using Oracle Enterprise Edition database, and want to license by NUP’s – Named User Plus Licenses – you are bound to a minimum of 25 users per Oracle-defined processor. So using a server with one Intel-based quad-core processor (with a factor of 0,5), you have to pay for (4 * 0,5 =) 2 Oracle processors, which is equal to a minimum of 50 users.

This has  been defined in the Software Investment Guide (page 14):

Minimums for this metric may be discrete quantities, or they may be based on the number of processors in the machine on which the software will be installed and/or run. For example, the minimum for the Database Enterprise Edition, the iAS Standard Edition and the iAS Enterprise Edition is 25, 10 and 10 Named Users Plus per Processor, respectively

Let’s stick for a moment on the Enterprise Edition of the database, and the example above. When a second server (1 quad core) is added, also with an Enterprise Edition database on it you’ll have to pay for a total of 100 NUP’s.

But what if I only have got 60 users (non human operating device included) who are directly or indirectly authorized to use those two databases / nodes. Will I pay for 60 users or 100 ? To be sure I asked this question to my contact at LMS (License Management Service at Oracle).

By |December 14th, 2012|Categories: licensing|Tags: , |2 Comments