I admit, I’m a bit of a fan of the Oracle Database Appliance. And I also admit there are some characteristics of the X5-2 ODA’s which made it sometimes a bit hard to fit in the needs of the customer. I’ll come to that later in this post. With the introduction of the two entry-level ODA’s I wrote about in a former blogpost , the ODA X6-2S and the ODA X6-2M, Oracle has made an effort to reach out to the smaller business to fill in their needs. But will it be a succes? This blogpost is about the kind of customer-challenges the ODA (at least one of the series) could be a solution for.
Since Oracle Enterprise Manager 12C it is possible to allocate the costs of IT resources to the people of organizations who consume them. This is done through the use of the plugin ‘Consolidation Planning and Chargeback’ .
Pete Sharman wrote an excellent blog about configuring this plugin in Enterprise Manager 12c, and it’s not my intention to copy his work, so I’d like to focus on complementary stuff regarding Oracle Enterprise Manager 13c.
In this article a short note about how simple it is to install the plugin in OEM13c and of course some important new features within the plugin
Be aware that by using this plugin you need the Cloud Management Pack – license!
Still loving the idea to use Oracle Enterprise Manager as a ‘kind of ‘ Software Asset Management Tool, and get regular centralized reports that tells me what Oracle software is running and if there are changes in use of licenses over time. The necessary data is already there in the OEM repository, so there should be standard report facilities to get me informed (other then my own sql-reports from the repository). And guess what, these reports are available.
The Usage Tracking Reports, including the two reports which are important for monitoring the use of licensing, were already present in OEM 12C (wrote about it a while ago) , and I was curious if the usability and functionality improved in OEM 13C (as told me at the demogrounds of OOW2015..).
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 220.127.116.11 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.
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).