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