Purpose:
This write-up aims to highlight all events related to the successful positioning of license compliance for Oracle Options and Management Packs in the SAM workspace.
Pre-requisites:
Below plugins has to be activated:
- Discovery and Service Mapping Patterns (sn_itom_pattern).
- At least Discovery (com.snc.discovery) should be activated.
- MID server to connect to the network
- Data Collection for Oracle Global Licensing and Advisory Services(sn_itom_oracleglas)
- Software Asset Management Professional(com.snc.samp)
- Software Asset Management Professional for Oracle(com.snc.samp.oracle)
How it works:
The process of fetching and showcasing the license position for Oracle Options & Management packs has two major part.
- [ITOM] Discovery of options & management packs
- [SAM] Leverage the output of discovery and obtain license position
Part 1 - Discovery of options & management packs:
Refer Oracle Global License Advisory Services (GLAS) data collection
Part 2 - Consuming discovery output for license position:
Post the discovery of GLAS data is successful, we should have below tables loaded with Oracle Options data:
Now, scheduled job: SAM - Evaluate database option usage from Oracle GLAS data (will call it Oracle Option Job from here) runs on a weekly basis. And parses the data from different tables pertaining Oracle data (primarily Oracle instance, Relationship and ORCL_OPTIONS) and loads the data accordingly into Oracle Options(samp_oracle_options) table.
When the reconciliation happens for Oracle, the recon. engine considers data from this table for establishing license position of Options & Management packs.
Below is the logic that executes when the Oracle Option job triggers:
Major events in the job:
- 1st event: Sets the currently used status to ‘Not in Use’ for all the entries in Oracle Options(samp_oracle_options) table and cleans the usage information.
- 2nd event: For all the new oracle instances, create new entries in the Oracle Options(samp_oracle_options) table with not in use status against all the options permitted by Licensable Oracle Options(samp_oracle_option_set) table.
The Licensable Oracle Options(samp_oracle_option_set) table provides the complete list of database options and management packs that you can create software models for.
- 3rd event: For each options available in the Licensable Oracle Options(samp_oracle_option_set) table, the job processes the options by its applicable features first and then by rules.
- Options processing with feature: Entries at Oracle Feature Option Mappings (samp_oracle_feature_option_mapping) table are used to map the features to the appropriate database options and management packs at the database instance level. During processing, the job leverages database view samp_dba_features_for_instance. This view holds features discovered against respective oracle instances(cmdb_ci_db_ora_instance). Post this part of the action is completed, Oracle Options(samp_oracle_options) table gets loaded with options where usage time is determined by use of its corresponding features.
- Options processing by rule: Usage information of the Options are determined based on usages managed at Signals for oracle options (samp_oracle_option_signals ) table. The job leverages database view samp_oracle_option_signals to process the records. This view holds options discovered against respective oracle instances(cmdb_ci_db_ora_instance). The option information with its usage timestamp gets loaded in the Oracle Options(samp_oracle_options) table.
Important tables & Database views:
- Oracle Options [samp_oracle_options] : Holds Options with instance and last, first used, currently used timestamp. This table is basically used during reconciliation.
- Licensable Oracle Options [samp_oracle_option_set ] : In scope options and mgmt. packs for SAM
- Oracle Feature Option Mappings [samp_feature_option_mapping] : Maps different features with the options
- Database view {samp_dba_features_for_instance } : Houses features mapped with the oracle instances
- Tables involved in this view:
- cmdb_rel_ci
- cmdb_ci_db_ora_instance
- cmdb_ci_orcl_options
- Database view {samp_options_for_instance} :Maps options with oracle instances
- Tables involved in this view:
- cmdb_rel_ci,
- cmdb_ci_db_ora_instance
- cmdb_ci_orcl_options
- Signal for oracle options (samp_oracle_option_signals ) : Houses feature, Option, usage indicators.
- Signal Enabled for Instances [samp_signal_to_option_instance] : Holds overall map of the database, database instance, option and its signals
- Default options for feature in use [samp_option_for_feature_inuse] : Default options for feature in use
- Unreported Database Options Usage [samp_unreported_database_options_usage] : To gain visibility into the Oracle Database options and management packs that are being used on undiscovered database instances.
SAM Maintenance:
Now that Oracle Options [samp_oracle_options] table is loaded with needed data, SAM reconciliation can progress.
To progress for a proper compliance though, SAM admin has to keep in mind that:
- Each Options & Management packs demands separate software models to be created. Meaning, the entitlement of the database should be separate and should not be used for measuring these options and management packs.
- Each software models should have its own entitlements.
- The license metric of the entitlement of the database and options should be same. If Oracle database software model is measured on per processor then corresponding options should be measured on per processor only and not on Named User Plus.
Post reconciliation, License compliance on SAM workspace for Options & Management Packs are listed individually under Database but separate from the Database edition:
Useful Links:
4 Comments
