Oracle verified data in Snow License Manager

Overview and implementation

2022-03-09

Description

Snow Software is a verified third-party tool vendor for Oracle Databases and Database options. Oracle's verification certifies that the Oracle Database data collected by Snow License Manager is accurate and complete, and accepted during an audit as an alternative to installing Oracle tooling.

The verified Oracle Database data can be downloaded as a ZIP file from the Oracle overview section in Snow License Manager, provided that the requirements described below are fulfilled.

Requirements

  • To accurately detect the data, the following Snow products must be installed in the following environments:

    Snow products

    Environments

    • Snow Inventory Agents for Windows, Linux, or Unix, version 6.0 or later

    • Snow Inventory Oracle Scanner, version 7.0 or later

    • Snow Inventory Oracle Hardware Scanner, version 1.0 or later

    All environments containing Oracle Database product installations, and any of the following environments, depending on the virtualization technology used:

    • Oracle Solaris Zones – on the Global Zone

    • Oracle VM Server for SPARC – on the Control Domain

    • Oracle VM Server for x86 – on the Dom0

  • In addition, the following must be installed to gather data from a VMware infrastructure:

    • Snow Integration Manager, version 5.39 or later

    • VMware vSphere Connector

  • For the data to be available via the Snow License Manager user interface, Snow License Manager version 9.20 or later, with Oracle Management Option enabled, is required.

  • The Snow License Manager user role must have the Ability to access and manage Oracle verified mode privilege enabled to access the Oracle verified data view in the Snow License Manager user interface. Roles and privileges are managed via Snow Management and Configuration Center.

Overview of the process

In short, the process of gathering Oracle verified data for Oracle Databases and Database options is as follows:

  1. Installing the infrastructure

    The required infrastructure specified above must be installed and configured.

    For more information on how to install and configure the required Snow products, see:

    Note that there are two alternative ways of distributing the Snow Inventory Oracle Scanner and Snow Inventory Oracle Hardware Scanner, see Distribute the Snow Inventory Oracle Scanner and Snow Inventory Oracle Hardware Scanner.

  2. Data gathering

    • Each time the agents perform their regular scan, as part of the Oracle scanners execution, a set of scripts is run, gathering data about basic hardware information for the inventoried computers and the usage of Oracle Database product installations.

    • The VMware vSphere Connector gathers data about the VMware infrastructure according to the connector configuration.

  3. Data processing

    The data is processed and made available in Snow License Manager. The frequency of the updates to Snow License Manager depends on the scan cadence configured by the customer.

  4. Downloading Oracle verified data

    Via the Snow License Manager user interface, you can export Oracle verified data for the entire estate or for a selection of it. See Oracle verified data view for more information.

    The final output is a ZIP file with the following content:

    • Software data output in six CSV files:

      • ORCL_DBA_USERS.csv - contains information of all Oracle Database users.

      • ORCL_V$SESSION.csv - contains information of all Oracle Database sessions.

      • ORCL_V$LICENSE.csv - contains information about license limits.

      • ORCL_OPTIONS.csv - contains information about the Oracle Database Options usage. The output is used by Oracle to determine Oracle Options and Management packs usage.

      • ORCL_DETAIL.csv - contains aggregated data from both Hardware and Software data outputs.

      • ORCL_OVERVIEW.csv - contains aggregated data from both Hardware and Software data outputs.

    • Hardware data output in TXT files.

    • VMware (vCenter) related data output in two CSV files (per vCenter).

Distribute the Snow Inventory Oracle Scanner and Snow Inventory Oracle Hardware Scanner

Distribute the Snow Inventory Oracle Scanner and Snow Inventory Oracle Hardware Scanner in one of the following ways:

  1. Manually replace the required artifact (sios.jar) in the agent’s folder. The following artifacts are needed:

    • sios.jar (version 7.0)

    • siohws.jar (version 1.0)

    • Scan-SIOHWSLauncher.snow-ps1 (version 1.0) for Windows only

    If the Oracle scan is not already enabled, make sure to enable it by configuring the Oracle element in the snowagent.config file. See configuration-doc.html for a complete list of all configuration parameters.

  2. Use agent installation packages. On the target environments, uninstall the old agents currently in use and install the new package.