[en] Oracle Management Option changes

[en] Oracle Management Option (OMO) is a Snow License Manager module that enables Oracle administrators and license owners to manage Oracle database products in SLM under the Enterprise > Oracle overview menu item:

SLM900_Enterprise-Oracle-Reports_CUT-OUT_reduced-more.png

[en] The OMO ecosystem itself is made up of various components:

OMO-sys-diagram.png

[en] The NEW and UPDATED labels identify the changes in this version of OMO.

[en] The following changes in version 9.0.0 as compared to version 8.3 are covered in detail in the rest of this document:

  • [en] New: Snow Software Oracle Service

  • [en] New: Oracle Middleware discovery and data collection

  • [en] New tables in SnowLicenseManager database

[en] New: Snow Software Oracle Service

[en] Snow Software Oracle Service (also referred to as the Oracle service in this document) is a new Windows service that:

  • [en] Executes Oracle data cleansing, such as correcting Oracle Database Standard Edition to Standard Edition 2 for Oracle Database version 12.1.0.2.0

  • [en] Moves data for Oracle Databases to copy database tables (copied data is used to detect changes)

  • [en] Detects and tracks changes made by the SLM 9 Data Update Job to Oracle Databases

  • [en] Pulls data from the Inventory Server web API, transforms that data, and saves it in database tables

Note

[en] Snow Software Oracle Service is included in the Snow License Manager 9 installation process.

[en] Integration with Snow Inventory API

[en] The Oracle service pulls data from Snow Inventory Server through a REST web API that Snow Inventory Server exposes. All requests to the Snow Inventory Server API are authenticated with an API key, which is maintained by Data Update Job for Snow License Manager 9.

[en] Configuration

[en] The Snow Software Oracle Service configuration file is available in the following location: <SnowLicenseManager_path>\Services \Oracle\SnowSoftware.LicenseManager.Oracle.Service.exe.config

[en] The configuration section consists of several sections, of which the most important are processSchedule and appSettings, covered below.

[en] Scheduled tasks

[en] Scheduled tasks are controlled by the processSchedule section, which contains a collection of tasks. Tasks run successively and only one at a time, meaning that they might get delayed if the previous task is still running. If necessary, each task can also be controlled to postpone starting until Data Update Job completes.

OMO-for-SLM-9_0_0_CODE-SNIPPET_scheduled-tasks.png

[en] Test signaling

[en] Test signaling is used to attach a testing tool to the Oracle service. For production environments, this setting should be kept as false in normal circumstances.

OMO-for-SLM-9_0_0_CODE-SNIPPET_test-signaling.png

[en] Log location

[en] Oracle service log files are located in <SnowSoftware_path>\Logs\OracleService.

[en] Troubleshooting

[en] If you encounter issues with the Snow Software Oracle Service, please collect the following information for the development team:

  • [en] All available logs for the Oracle service.

  • [en] The content of all OMO tables from the SLM database.

[en] New: Oracle Middleware discovery and data collection

[en] Oracle Middleware is a set of Oracle software products used to connect Oracle Databases with application or reporting software.

[en] Introduced in this version of OMO is the ability to discover Oracle Middleware and collect its usage data in the organization's IT environment.

Note

[en] The inventory data for Oracle Middleware is transferred through API calls and not through Data Update Job.

[en] Data collection from Snow Inventory API

[en] The Oracle service pulls data from the Snow Inventory API at regular intervals, pre-configured usually for early morning. The data is received in JSON format and saved in staging tables, which are used to avoid lengthy processing during this stage. Data processing happens in separate tasks that are scheduled after data loading finishes.

[en] Data transfer and normalization

[en] The information that is gathered from the Snow Inventory API is a list of installed applications and application components. A distinct list of all newly discovered applications is saved in separate database tables, to be picked up from the DIS client and sent to the Global DIS repository to be analyzed—and if relevant—reported as a software product. These recognized software products are then connected to the corresponding record in the dbo.tblApplication database table. This is the DIS process know as normalization.

[en] After receiving DIS normalized data, the Oracle service uses another task to build Middleware normalized data. This data is created by translating the set of recognized applications into software editions, used options, and management packs.

[en] New tables in SnowLicenseManager database

[en] Table

[en] Purpose

[en] omo.EnvironmentChange

[en] Keeps track of changes coming in from Snow Inventory server into SLM. EnvironmentChangeData is the deserialized JSON that contains the changes, while ItemId is the appropriate ID of the item changed (DatabaseID, InstanceID, AddOnID, and so on)

[en] omo.EnvironmentChangeGroup

[en] Environment change group with appropriate source table name and key name

[en] omo.EnvironmentChangeType

[en] Environment change type with name

[en] omo.DatabaseOptionsOverride

[en] Overrides for Installed and Used fields in omo.DatabaseOptions.

[en] omo.DatabaseManagementPacksOverride

[en] Overrides for Agreed and Granted field in omo.DatabaseManagementPacks.

[en] OracleDatabaseLifetimeSupport

[en] Support dates for Oracle databases

[en] omo.SoftwareEnvironment

[en] Keeps records for software environment Name (Production, Development, and so on)

[en] omo.Database

[en] Copy of dbo.tblOracleDatabase

[en] omo. DatabaseOptions

[en] Copy of dbo.tblOracleDatabaseOptions

[en] omo. DatabaseManagementPacks

[en] Copy of dbo.tblOracleDatabaseManagementPacks

[en] omo. DatabaseInstances

[en] Copy of dbo. tblOracleDatabaseInstances

[en] omo.DatabaseServers

[en] Copy of dbo. tblOracleDatabaseServers

[en] omo.DatabaseUsers

[en] Copy of dbo. tblOracleDatabaseUsers

[en] omo.DatabaseSessions

[en] Copy of dbo. tblOracleDatabaseSessions

[en] omo.DatabaseFeatureUsageStats

[en] Copy of dbo.tblOracleDatabaseFeatureUsageStats

[en] omo.DatabaseManagementPacksSummary

[en] Copy of dbo.tblOracleDatabaseManagementPacksSummary

[en] omo.DatabaseProperties

[en] Copy of dbo.tblOracleDatabaseProperties

[en] omo.MiddlewareProduct

[en] Operational table for recognized Oracle middleware products

[en] omo.MiddlewareProductEditionType

[en] Operational table for resolved Oracle middleware software product edition types (such as Oracle WebLogic Server Standard Edition)

[en] omo.MiddlewareProductEdition

[en] Operational table for resolved Oracle middleware software product editions (such as Oracle WebLogic Server Standard Edition 12c)

[en] omo.MiddlewareInstallation

[en] Operational table for inventoried and recognized Oracle middleware software

[en] omo.MiddlewareServer

[en] Operational table for servers that have installed Oracle middleware software

[en] omo.MiddlewareDomain

[en] Operational table for Oracle middleware domain configuration

[en] omo.MiddlewareDomainCluster

[en] Operational table for Oracle middleware domain configuration about clusters

[en] omo.MiddlewareDomainManagedServer

[en] Operational table for Oracle middleware domain configuration about managed servers

[en] omo.MiddlewareDomainClusterManagedServer

[en] Operational table for Oracle middleware domain configuration about clusters the managed servers are associated with

[en] omo.ScanMiddlewareComponent

[en] Staging table for inventoried data about Oracle middleware components

[en] omo.ScanMiddlewareDomain

[en] Staging table for Oracle middleware domain configuration

[en] omo.ScanMiddlewareDomainCluster

[en] Keeps records for Oracle middleware domain configuration about clusters

[en] omo.ScanMiddlewareDomainManagedServer

[en] Keeps records for Oracle middleware domain configuration about managed servers

[en] omo.ScanMiddlewareServer

[en] Staging table for servers that have installed Oracle middleware software

[en] omo.ScanMiddlewareFeatures

[en] Staging table for inventoried data about Oracle middleware features

[en] omo.ScanMiddlewareDistribution

[en] Staging table for inventoried data about Oracle middleware distributions

[en] omo.TaskExecutionAudit

[en] Audit table for Oracle task scheduler

[en] dis.tblOmoMiddlewareHarvest

[en] DIS table for records about Oracle middleware products that are still not recognized

[en] dis.tblOracleEditionBundle

[en] DIS table for meta-configuration related to Oracle middleware edition resolving

[en] dis.tblOmoMiddlewareHarvestApplicationMap

[en] DIS table for recognition of Oracle middleware software based on MiddlewareHash

[en] dis.tblApplication_Version

[en] DIS table for additional information related to Oracle middleware editions and versions