Oracle License Audit

 

I found out yesterday that we have an Oracle license audit in January, so I spent yesterday having a look at everything we have to check what features we are using…

Our licensing situation is a little different to anywhere I’ve worked before, in that they are based on the number of Full Time Employees (FTEs), not on named users or processors. As a result, we don’t need to worry about the number of installations we have. We just need to make sure we are not using features we are not licensed for.

Database Licenses

The database side is quite easy because we have FTE licenses for Enterprise Edition, Diagnostics and Tuning Pack and Partitioning. I checked the DBA_FEATURE_USAGE_STATISTICS view on each server and everything looks OK.

WebLogic Licenses

On the WebLogic front things are a little trickier. Since many of the licenses were bought in the Oracle Application Server era, we have to make sure we are only using features applicable for the WebLogic Server Basic license, which we have an FTE license for also. There is an overview of the restrictions in theย Restricted Primary Services in WebLogic Server document. Also, there is a really handy MOS note,ย WebLogic Server Basic License Feature Usage Measurement Script (Doc ID 885587.1), which includes a WLST script that checks which features you are using and reports non-compliance with the WebLogic Server Basic license. It’s pretty simple to use. Just do the following for each domain on your server.

$ export MW_HOME=/u01/app/oracle/middleware
$ export DOMAIN_HOME=$MW_HOME/user_projects/domains/ClassicDomain
$ . $DOMAIN_HOME/bin/setDomainEnv.sh

$ java weblogic.WLST ./wls_basic_measurement.py

You are prompted for the AdminServer connection details.

  • Username: weblogic
  • Password: mypassword
  • Admin URL: t3://myserver.example.com:7001

It then chucks out a page of output with errors listed for any non-compliance.

Developer/Programmer Licenses

We have people using Oracle Forms, JDeveloper and Pro*C, which we have Named User Plus licenses for. We’ve recently gone through a desktop refresh in our department, so many people have their old PCs hanging about (just in case). The department used to be bigger, so even with the extra PCs hanging around we are over-licensed really, but this will be a good opportunity to convince people to wipe and let go of their old PCs. ๐Ÿ™‚

So after my initial panic, everything looks OK, but I will be interested to see what the license police make of it all. ๐Ÿ™‚

Cheers

Tim…

Update: I guess I was not very clear about the purpose of this post. I am not suggesting this is all that is necessary to prepare for an Oracle license audit. I was not suggesting you don’t need the help of ย licensing specialists. I currently work for a University, which negotiates its licenses as part of a large group of Universities. As a result, the licensing is very broad. It is quite different to the process individual companies have to go through. This was just a quick fact-finding mission for me, so I didn’t get any nasty surprises in the new year. ๐Ÿ™‚

Thank you to those that commented to pointing out how this post could be misinterpreted. ๐Ÿ™‚

Update 2: We passed the audit with no issues.

Author: Tim...

DBA, Developer, Author, Trainer.

8 thoughts on “Oracle License Audit”

  1. They will say “you need more licenses.” I’ve yet to meet an Oracle sales guy who did not claim that I would have to buy WebLogic full licenses. Good luck explaining WebLogic Basic to them.

  2. Don’t just rely on DBFUS for db options usage; there are lots of other things and options to check! Server specs and architecture should also be checked. Remember that Developer/Programmer are generally Named User Plus-type licenses and not based on the number of desktops.

  3. At what point do you call in licensing/SAM specialists?
    After the DBA’s do the initial checks? Or when Oracle say you need more licenses?

  4. @Paul: Server spec and architecture is not a problem for us. Our licenses allow us to run on anything. Agreed about Developer/Programmer. Just trying to minimize the scope for bullshit. ๐Ÿ™‚

    @Allan: Our licenses are renegotiated quite regularly, as part of a group of big group Universities. The licenses are quite broad, so I’m not sure a license specialist is really necessary for this place. That is certainly not the case for many companies though.

    I’m just looking for hidden surprises. ๐Ÿ™‚

    Cheers

    Tim…

  5. Indeed, it is easier to analyze options since DBA_FEATURE_USAGE_STATISTICS data dictionary view was Introduced in Oracle 10G.
    For older versions the DBA had to query the v$option view and check for each parameter if objects were created, that was a tough work ๐Ÿ™‚

    e.g for 2 options:
    select value from v$option where parameter = ‘Oracle Label Security’;
    select count(*) from lbacsys.lbac$polt where owner ‘SA_DEMO’;

    SELECT value from v$option where parameter=’Spatial’;
    select count(*) “SDO_GEOM_METADATA_TABLE”
    from MDSYS.SDO_GEOM_METADATA_TABLE;
    ..for all the options…

    You can email me if somebody wants this (long) script.

  6. Hi
    What all they check in Audit ?
    Do they emphasis on Customizations done after implementation of EBS ?

  7. Ramesh:

    The process will depend on a number of factors. For us, it was mostly running scripts to check what features we were using.

    We don’t use EBS, so I can’t comment on that…

    Cheers

    Tim…

Comments are closed.