Skip to main content
Matrix42 Self-Service Help Center

Oracle Inventory

Overview

Matrix42 Software Asset and Service Management delivers the Oracle database inventory feature by integrating with an external scanner. This system scans computers for Oracle applications and returns results to Matrix42 Software Asset and Service Management. Based on imported data, Matrix42 Software Asset and Service Management creates fingerprints and installations for Oracle applications, thus launching the Oracle license management process. The integration is implemented by using the Oracle Database Inventory Data Provider.

The Oracle Database Inventory Data Provider is delivered as an add-on to Matrix42 Software Asset and Service Management. To use it, you should activate the m42OracleDatabaseCompliance license certificate.

ADM_Oracle_Cycle.png

Import of Oracle Inventory Data

1 - Activating the Oracle Database Inventory Data Provider

The import of Oracle inventory data is triggered manually by executing the Activate action for the Oracle Database Inventory Data Provider and automatically by the Oracle Database Compliance engine activation.

2 - Launching the Oracle Connector Workflow

The Oracle Database Inventory Data Provider starts the Oracle Connector workflow. It is a server workflow that is always run in Matrix42 Software Asset and Service Management.

3 - Launching the Oracle Connector Data Collector Workflow

The Oracle Connector workflow creates jobs according to the enabled configurations of the Data Provider. The configurations contain data that is required for establishing the connection with the Scan Engine for Oracle Databases and stipulate the list of computers for which the inventory data should be imported. When the Data Gateway service finds the jobs, it starts the Oracle Connector Data Collector workflow.

4 - Collecting Oracle Inventory Data

Based on the list of computers that is specified in the Data Provider configuration, the Oracle Connector Data Collector workflow retrieves the Oracle inventory data and saves it as a package of XML files:

  • Oracle Systems.xml
    Contains hardware and software details for computers that have been scanned.
  • Oracle Instances.xml
    Contains Oracle database instances that run on the computers that have been scanned.
  • Oracle Features Catalog.xml
    Contains a complete list of Oracle features and their versions.
  • Oracle Features.xml
    Contains features that are relevant for the detected Oracle database instances and information on their usage.
  • Oracle Options Catalog.xml
    Contains a complete list of Oracle options and their versions.
  • Oracle Options.xml
    Contains options that are relevant for the detected Oracle database instances and information on their usage. 

5 - Passing Oracle Inventory Data to Matrix42 Software Asset and Service Management

The Data Gateway passes XML files to the Oracle Connector workflow.

6 - Creating and Updating Objects Based on Imported Data

The Oracle Connector workflow executes import definitions for each of the received XML files. It uses the XML files as data source to update existing objects with new values and create new objects in Matrix42 Software Asset and Service Management.

The following import definitions are executed:

  • Oracle: Import Computers
    The import definition updates the existing computer records with the data relevant for Oracle license management. It uses the Oracle Systems.xml file as a data source.
  • Oracle: Import Hosts
    The import definition updates the host-virtual machine relationship for the existing computer records. It uses the Oracle Systems.xml file as a data source.
  • Oracle: Import Instances
    The import definition updates the existing database instances and creates new ones based on the imported Oracle inventory data. It uses the Oracle Instances.xml file as a data source.
  • Oracle: Import Features Catalog
    The import definition updates the list of all Oracle features. This list is for system use only. It uses the Oracle Features Catalog.xml file as a data source.
  • Oracle: Import Features Usage
    The import definition updates data on features for each running database instance. It uses the Oracle Features.xml file as a data source.
  • Oracle: Import Options Catalog
    The import definition updates the list of all Oracle options. This list is for system use only. It uses the Oracle Options Catalog.xml file as a data source.
  • Oracle: Import Option Usage
    The import definition updates data on options for each running database instance. It uses the Oracle Options.xml file as a data source.

Configuring Oracle Inventory Data Provider

A valid and activated m42OracleDatabaseCompliance license certificate is required to run the Oracle Data Provider. If you do not own such a certificate yet, you can contact a Matrix42 sales representative to purchase it.

For information on required ports, see Ports Used by Connectors and Data Providers.

For every instance of the Scan Engine for Oracle Databases, you need to set up a configuration for the Oracle Database Inventory Data Provider by specifying the following data:

  • Settings to connect to the Scan Engine for Oracle Databases
  • The Data Gateway that will run the Data Provider configuration
  • List of computers to scan

To add a new Data Provider configuration:

  1. In Matrix42 Software Asset and Service Management, open the Data Providers search page under Administration > Integration.
  2. Double-click the Oracle Database Inventory Data Provider to open it. The properties dialog contains the Configurations list where configurations for this provider can be managed.
  3. To add a new configuration for the Data Provider, use the  button. The new properties dialog will open.
  4. Fill in the GeneralIncluded Computers and Excluded Computers dialog pages for the new configuration.
  5. Click OK to save the configuration, and then click Save or OK to save changes for the Data Provider.

 

 

  • Was this article helpful?