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/

$ java weblogic.WLST ./

You are prompted for the AdminServer connection details.

  • Username: weblogic
  • Password: mypassword
  • Admin URL: t3://

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. 🙂



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.

The Wolf Gift

The Wolf Gift is the first in The Wolf Gift Chronicles by Anne Rice.

Followers of the blog will know that I made a conscious attempt to get into reading a few years ago, having made it to my late 30’s (at the time) having only read a handful of books in my life. Having made the decision to begin reading, the first series of books I chose were The Vampire Chronicles by Anne Rice. I loved The Vampire Chronicles. I loved New Tales of the Vampires. I loved Lives of the Mayfair Witches. I couldn’t face any of the religious or romance novels by Anne Rice, so once I had finished these three series, I thought that was the end of the line for me.

Fast forward a few years and Anne Rice has returned to her roots and started a new series called The Wolf Gift Chronicles, which is not surprisingly about Werewolves. For me, this is like coming home. I like the way Anne Rice writes. I find it very easy to read and typically the pace of her stories suites me perfectly. The Wolf Gift is no exception.

If you’ve been suffering from Anne Rice withdrawal symptoms, you really need to read The Wolf Gift. I don’t think you will be disappointed.




Is this the most committed UKOUG Tech13 attendee?

Imagine for a second that you come from Brazil and are currently working in Angola. Would you be taking a trip to Manchester to attend UKOUG Tech13? That’s what Alex Zaballa did.

If there was an award for, “Most Committed UKOUG Tech13 Attendee”, he’s got to be in with a shot at it. 🙂




UKOUG Tech13 : Monday

I’ve mentioned a couple of times before, I’m only attending Monday of UKOUG Tech13. One of my colleagues quit, so there is no DBA at work today while I’m out on a jolly. 🙂

My session was at 09:00, which meant getting up at 05:00 to get the train to Manchester. While I was on the train I did a final run-through of my presentation and surfed the net on the train WiFi. I left the house in the dark. It was still dark by the time I got to Manchester. The winter is so depressing!

My talk went pretty well. There were quite a lot of people there, but when you are presenting in an auditorium it looks really empty. 🙂 I think I got a bit excited because I finished early. That rarely happens to me, but it did leave room for an extended question and answer session, which was pretty cool. I was asked a variety of questions, some of which were really quite challenging. I came out and bumped into Jonathan Lewis, which gave me the perfect opportunity to discuss some of the issues with him. I think I will be adding a few points to my article to pick up on some of the themes raised by the questions. It’s always good when interactions with people open up new trains of thought. Thanks to everyone that came along, everyone who asked such good questions and everyone that said really nice things about the presentation on Twitter. 🙂

I kind-of missed the next session because I kept bumping into people and chatting. Meeting up with friends, new and old, is one of the best things about conferences for me. Amongst others, I had a quick chat with the previous Optimizer Lady (Maria Colgan) and said hello to the new Optimizer Lady (Tom Kyte). Tom has taken his new role to heart, turning up in a skirt and knee length boots!

Next up was “Self-Provisioning Pluggable Databases Using PL/SQL” by Brynn Llewellyn. I’ve been playing around with pluggable databases for a while now, but it’s still early days for me, so there were quite a few neat things that came out of this talk, including the use of DBMS_SQL to perform operations in the scope of a pluggable database and scheduler jobs of type SQL_script.

After that session I bumped into Melanie Caffrey and Martin Widlake and we chatted about the current state of software development in the age of “Coding-By-Google”, before I started to stuff myself with food.

The next session was “Introduction to the New Oracle Database In-Memory Option” by Maria Colgan. It all looks so simple and cool it can only be the result of witchcraft! It’s surprising how many long standing bits of the Oracle optimizer go into making the in-memory database work…

From there it was a quick trip across the road to watch Doug Burns speak about Database as a Service (DBaaS) at OakTable World UK 2013. This is a subject that I have a big interest in and one that I know very little about.

I did intended to go to another session, but I got chatting to Debra Lilley (who is not technical), Sten Vesterli, Lonneke Dikmans, Ronald Luttikhuizen and Simon Haslem instead.

From there is was a quick trek over to the station to start my journey home. I’m now just about to arrive in Birmingham.

Overall it’s been a really cool day. I got to present, see some great sessions and meet lots of cool people! Thanks to everyone involved in the organisation of UKOUG Tech13 and OakTable World UK 2013. Thanks to the Oracle ACE Program, who didn’t have to pay for anything this time, but allow me to keep doing what I do. Thanks also to my current employer, who paid for my train ticket. 🙂

Back to work tomorrow, where I’ll be doing one of my fortnightly Tuesday presentations…