Back in April last year we published a comparison of five SAM tools with Oracle License Management capabilities (See: Oracle License Management Group Test – The Results).
This previous group test above was based on a questionnaire completed by participating vendors and an online briefing to quiz vendors on their capabilities.
For 2016, we would like to take this up a notch by formally benchmarking tool manufacturers against an open standard (This article) using real customer data.
An open standard for Oracle Database License Management
The details published below are a first draft of our open standard for the management of Oracle database.
i.e. If I want to invest in tooling to manage the risk and cost of Oracle database licensing in my environment – what should I be looking for?
We are publishing this standard so that others may add or critique it – please provide your feedback via the comments below and we will update the standard accordingly.
The ITAM Review will use this standard to verify tools for Oracle License Management. Oracle already run their own verification process for tools (Further info here). The ITAM Review verification process has two notable differences compared to the Oracle LMS program:
- Our verification process will be open, transparent and collaborative. It will evolve with the industry over time (Hence sharing this open standard).
- Oracle’s current tool verification process relates to inventory only and not the Oracle license management reconciliation process. The ITAM Review verification will test both inventory and reconciliation (as you can read below).
Tools will be benchmarked using real customer data to independently verify whether they meet the criteria below.
Oracle Database License Management Verification Standard V1.0
Version 1.0 Published 17th November 2015
- Are all the prerequisites required for successful discovery and Oracle license management reconciliation included in the documentation?
- Does the customer or partner need to get more privileges along the way (root access when pre-requisite says read only, access to OVMM etc.) to complete the inventory?
- Ability to select and scan a network segment for the existence of Oracle instances when their existence is not known
- DB version (Major and minor versions numbers e.g. Oracle 22.214.171.124)
- DB edition
- Options installed
- Options in use
- Access to raw data (user names, times and dates an option has been used)
Hardware set up
- Physical or virtual (If virtual relationship to physical host and cluster)
- Host hardware data incl. failover and other passive servers
- Ability to capture the complete hardware cluster
- Ability to interpret hardware partitioning according to Oracle rules e.g. IBM, SUN, etc.
- Ability to determine number of licensable cores in an Oracle VM set up
- Are the installations automatically assigned to the right product/license
Contract, License, Organization and Financial data
- Manual or batch import
- Skills profile – Is this something a SAM person could do or Oracle DB expert?
- Support for all Oracle contract levels and interdependencies
- Order number, contract number, support number and support contract number
- Are all Oracle license models supported
- Processor, NUP, nonstandard and old models
- Organization structure support
- Financial data management
Compliance calculation & reporting
- Is compliance calculated automatically?
- Are prerequisites considered e.g. if tuning is used then you also need diagnostics
- Are unlicensed product installations shown as missing licenses or only the licensed ones?
- Does the calculation take into consideration complete hardware clusters, hardware partitioning, DB options used by Oracle’s own users only, options used in the past that trigger an audit risk
- Can licenses be tied to a server or business unit etc.?
- Can licenses be handled as a pool?
Does the tool automatically generate an Oracle Server Worksheet?
User friendliness and user manuals
- Is there a manual that guides the SAM manager through the set up and management of the tool?
- Is there a help desk that will answer customer SAM work related questions?
- An active user group, forum, external consultants or other support network for the customer?
CALL FOR CRITIQUE
We welcome your feedback on this first draft, have we missed anything? is it realistic? Please let us know via our contact form or leave a comment below. Thanks, Martin
About Martin Thompson
Martin is also author of the book "Practical ITAM - The essential guide for IT Asset Managers", a book that describes how to get started and make a difference in the field of IT Asset Management.
On a voluntary basis Martin a contributor to ISO WG21 which develops the ITAM International Standard ISO/IEC 19770.
Learn more about him here and connect with him on Twitter or LinkedIn.