How to trace an Oracle DB unlicensed install - Support and Troubleshooting

How to trace an Oracle DB unlicensed install Summary This article explains how the Oracle Database license metrics are calculated and how to trace an unlicensed install.

The Oracle DB Named User Plus (NUP) License Metric calculation is as follows: For Oracle DB Enterprise Edition: Highest of the below two:

Physical host CPU Count x No. of Cores per CPU x Core Factor x Metric Attribute ( Minimum Users Per Processor ) Number of Client Access Records per Physical Server For Oracle DB Standard Edition: Highest of the below two:

Physical host CPU Count x Metric Attribute ( Minimum Users Per Processor ) Number of Client Access Records per Physical Server

For Oracle DB Per Processor License Metric Calculation: For Oracle DB Enterprise Edition: Physical host CPU Count x No. of Cores per CPU x Core Factor For Oracle DB Standard Edition: Physical host CPU Count Release Paris

Instructions How the calculation is done for a physical host:

The license calculation starts with the Software Installation record in cmdb_sam_sw_install table. If the Software Installation is installed on a Virtual Server then we will need to find the Physical Server and get a list of all Software Installations installed on it. This is done by: From the related lists of the virtual server, find the name of the physical server navigating to System Definitions > Database Views > samp_vminstall_on_pinstall view > Try it Filter: Child is and Normalized Product is You will get a list of all the Software installation records on that physical server. Now, add sys_id field to the form and copy the list of sys_ids . If however, the Software Installation is on a Physical Server, then just note the sys_id of this installation record. Get the list of Oracle DB instances that are linked to those installations by navigating to Oracle Instances cmdb_ci_db_ora_instance table and filter on: Software Install is Note the sys_ids of those oracle instances Finally, open the Client Access samp_sw_client_access table and filter on: Database Instance is Add the Total user count of all the records and that will give you the total number of Client Access Records. Finally add this to the calculation provided earlier to see the number of licenses needed. Related Links In Pre-Paris releases, the license is calculated per Oracle Instance instead of per Physical Server. At least 1 Client Access record is needed in order to calculate the NUP license for that Physical server. Client Access records are created manually. This can be done by querying the oracle_dba_users table to identify which applications/devices/users are accessing the Oracle database server instance.