Summary

This article will explain the reason why Oracle License will have status "At risk" but License Entitlement is still greater than raw consumption and how to fix.

Synopsis

Sometimes user will notice the Oracle License with type such as Name User Plus or Oracle Processor ; the license entitlement number is still greater or quails to raw consumption, but license status will showing Red -- In Breach.

Furthermore when you open the license, on Compliance tab you will find the breach reason: "Option License does not match instance"

Discussion

This is happens when on an Oracle server, the database instance is consuming one Oracle license type (eg: Oracle Processor), however the corresponding Database Option of the instance is consuming the other license type (eg: Oracle Name User Plus) or vice versa. This mismatch warning will be shown and reported as 'At Risk".

Troubleshooting

Please check the Consumption tab details on the at risk Oracle licenses tab to find out which devices are shown consuming a Database license and Database Option license that have different types. 

The following query can also be used to identify Oracle instances associated with both types of Oracle licenses and identify the options tied to the conflict license. Once the consumption is under the same Oracle License type, followed by a reconcile. The alert will be removed and License Compliance status will be back to 'Compliant'

select cc.ComputerName, ip.InstanceName
	, ParentLicense = slp.Name, ParentTitle = stp.FullName, ParentLicenseType = slpt.TypeDefaultValue
	, ChildLicense = slp.Name, ChildTitle = stc.FullName, ChildLicenseType = slct.TypeDefaultValue
from
	ComplianceComputer cc
	
	join Instance ip on ip.ComplianceComputerID = cc.ComplianceComputerID
	join SoftwareLicense slp on slp.SoftwareLicenseID = ip.SoftwareLicenseID and slp.LicenseTypeID in (16 /* Oracle Processor */, 17 /* Oracle NUP */)
	join SoftwareLicenseType slpt on slpt.SoftwareLicenseTypeID = slp.LicenseTypeID
	join SoftwareTitle stp on stp.SoftwareTitleID = ip.SoftwareTitleID

	join Instance ic on ic.ParentInstanceID = ip.InstanceID
	join SoftwareLicense slc on slc.SoftwareLicenseID = ic.SoftwareLicenseID and slc.LicenseTypeID != slp.LicenseTypeID
	join SoftwareLicenseType slct on slct.SoftwareLicenseTypeID = slc.LicenseTypeID
	join SoftwareTitle stc on stc.SoftwareTitleID = ic.SoftwareTitleID