Skip to content
  • There are no suggestions because the search field is empty.

Licenseware Collector

This article explains how to use the data_collection.sql script to gather Oracle Database usage data for analysis in Licenseware's Oracle Database Manager (ODBM) app.

The data_collection.sql script is a custom Licenseware tool designed to extract detailed Oracle Database usage information. It collects the necessary technical data to analyze:

  • Feature usage statistics
  • Options and management pack usage
  • Instance configuration details

Unlike Oracle’s Review Lite scripts, this script does not generate a human-readable output, but it gathers all the raw data required for automated ingestion by Licenseware.

The resulting file can be uploaded to the Oracle Database Manager (ODBM) app for compliance validation, feature usage tracking, and optimization insights.

Script Access

To request the script, please contact:
📧 support@licenseware.io
Or visit the Licenseware Knowledge Center for more information.

Requirements

  • System privileges: SYSDBA access is required.
  • Environment: Access to the database server and SQL*Plus terminal.
  • File permissions: Ensure the Oracle user has write access to the output directory.

How to Run the Script

  1. Copy the script to the target database server.

  2. Open a terminal and navigate to the script’s location.

  3. Start a SQL*Plus session with administrative privileges:

    bash
    CopyEdit
    sqlplus / as sysdba

  4. Execute the script:

    sql
    CopyEdit
    SQL> @data_collection.sql

  5. Once complete, the script will generate a file named in the following format:

    php-template
    CopyEdit
    HOST_NAME._<DB_NAME>_lware_collector.csv

  6. Retrieve the output file and prepare it for upload to Licenseware.

Collected Data

The script captures:

  • Oracle Database version
  • Instance configuration
  • Feature usage statistics (via DBA_FEATURE_USAGE_STATISTICS)
  • Options and management pack usage indicators

Troubleshooting

Issue Resolution
Can't connect with / as sysdba Ensure you are logged in as the oracle user, not root.
Can't spool to file Verify the oracle user has write permissions to the output directory.
Script not found Ensure your terminal is in the directory where the script is located. Use cd /path/to/script before execution.

Next Steps: Upload to Licenseware

After obtaining the lware_collector.csv file, upload it directly into the Oracle Database Manager (ODBM) app in Licenseware. The app will parse and analyze the data to generate insights on:

  • Option and pack usage
  • Licensing exposure
  • Optimization opportunities