Summary
This article will explain the reason why Oracle License will have status "in breach" but License Entitlement is still greater than raw consumption and how to fix.Synopsis
From FlexNet Manager Platform version 2015 + , 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.Further more 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 'In Breach".Workaround
Please check those In Breach Oracle license -> Consumption tab to find out which server is existing across the DB License & Option License with different type.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 nup.computername,
nup.InstanceName,
nup.license as 'nup license',
nup.[option pack] as 'nup option',
oracleproc.license as 'oracle proc license',
oracleproc.[option pack] as 'oracle proc option'
from
(
select i1.ComplianceComputerID,
i1.InstanceID,
cc.ComputerName,
i1.InstanceName,
sl.name as 'license',
fullname as 'option pack' from Instance i1
join SoftwareLicense sl
on sl.SoftwareLicenseID = i1.SoftwareLicenseID
join softwaretitle st
on st.softwaretitleid = i1.softwaretitleid
join ComplianceComputer cc
on cc.ComplianceComputerID = i1.ComplianceComputerID
and st.SoftwareTitleTypeID in (2,3)
where licensetypeid = 17
) nup
join
(
select i1.ComplianceComputerID,
i1.InstanceID,
cc.ComputerName,
i1.InstanceName,
sl.name as 'license',
fullname as 'option pack' from Instance i1
join SoftwareLicense sl
on sl.SoftwareLicenseID = i1.SoftwareLicenseID
join softwaretitle st
on st.softwaretitleid = i1.softwaretitleid
join ComplianceComputer cc
on cc.ComplianceComputerID = i1.ComplianceComputerID
where licensetypeid = 16
and st.SoftwareTitleTypeID in (2,3)
) oracleproc
on oracleproc.ComplianceComputerID = nup.ComplianceComputerID
and oracleproc.InstanceName = nup.InstanceName
