For secure environments (for example, Oracle servers secured by firewalls), Flexera offers a stand-alone Oracle inventory collection agent that can be deployed on a compatible Windows server.
This article explains what you need to know and do to use it.
Discovery and inventory information is a prerequisite to performing license consumption calculations in FlexNet Manager Suite. We recommend that you deploy one or more inventory beacons on your network, and use any of the supported inventory collection methods to collect Oracle inventory. Each inventory beacon collects discovery and inventory information from the devices within its assigned subnet and sends this information to FlexNet Manager Suite. To collect inventory, each inventory beacon requires a network connection to the target Oracle servers within its assigned subnet.
In secure environments (for example, Oracle databases secured by firewalls), you may not be able to establish a network connection between each installed inventory beacon and the Oracle servers within its assigned subnet, or you may not be able to install any inventory beacon at all. For such environments, Flexera offers a stand-alone Oracle inventory collection agent that can be deployed on a compatible Windows server. The stand-alone agent collects and saves the Oracle Database inventory information (.ndi files) to a specified location. You can collect hardware inventory (required for Oracle processor-based licenses) through the locally-installed ndtrack or any third-party inventory database. If you do not deploy the agent on an inventory beacon, you will have to transfer the collected data to FlexNet Manager Suite, for performing license consumption calculations.
Note: Flexera recommends that you use the stand-alone inventory agent, and not ORATrack, for collecting inventory data on Oracle installations. The stand-alone inventory agent collects hardware information as well as Oracle installation data (whereas ORATrack only collects Oracle data), so it will provide a more comprehensive result.
This document describes the installation and operation of the stand-alone Oracle inventory agent.
The Oracle Discovery and Inventory chapter of the Systems Reference Guide PDF explains the supported inventory collection methods.
The stand-alone Oracle inventory agent has been designed to remotely collect Oracle Database inventory from Oracle servers when you cannot use any of the inventory collection methods recommended by Flexera. You can deploy this agent on any computer with Windows desktop (Windows 7 or higher) or Server (2008 or 2012) edition. After you configure the agent with details of the target Oracle servers, the agent can connect to each Oracle server using the Oracle Data Access Component (ODAC) driver (installed as a part of Oracle client on the computer where the agent is deployed). The agent then uses a pre-configured audit database user to extract Oracle inventory. The collected information is saved to a configured location from where it can be uploaded to FlexNet Manager Suite for license consumption calculations. The following diagram illustrates the process of Oracle inventory collection through the stand-alone Oracle inventory agent.
Important: We recommend that you use the stand-alone Oracle inventory agent only for Oracle hosts that have a single Oracle database service running on them.
To collect Oracle inventory through the stand-alone Oracle inventory agent, complete the following steps:
The following are the prerequisites for inventory collection using the stand-alone Oracle inventory agent:
An audit account with read-only permissions on the Oracle Database for all the tables and views needed for collecting Oracle inventory. One helpful practice is to use the same set of credentials on all servers. You can use a specially designed script to create and configure an audit user (for example, fnmoaudit) on each Oracle server with a password of your choice. To get this script, go to this Knowledge Base article on the Flexera Community. The script is available as an attachment at the bottom of the page.
For details about Oracle tables and views required for inventory collection, see the Appendix below.
The stand-alone Oracle inventory agent is shipped as a zip archive. You can deploy this agent on a computer with a compatible version of Microsoft Windows. Follow these steps to deploy the agent:
To enable the stand-alone Oracle inventory agent to collect inventory from target Oracle databases, register every target Oracle server with the agent, and record the Oracle service name for each Oracle server in the oratrack.ini file. Follow these steps to configure the agent:
|server||Query specified server|
|-a||Query all configured servers|
|-l||List configured servers and credentials|
|-s||Set logon credentials for server|
|-d||Delete logon credentials for server|
oratrack.exe -d <server name>where <server name> is the name of the target Oracle server.
oratrack.exe -s <server name>where <server name> is the name of the target Oracle server that is to be registered with the agent. The agent prompts you to enter the credentials of the audit user created on this server with the user creation script.
Note: The oratrack.exe tool encrypts the password automatically, before saving it to the oratrack.ini file.
Your agent is now ready to collect inventory from target Oracle servers.
Warning: We do not recommend using the stand-alone Oracle inventory collection agent with Oracle hosts running multiple Oracle Database services. If you are using the stand-alone Oracle inventory agent to collect inventory from such an Oracle host, you need to:
When you have registered all target Oracle servers with the stand-alone Oracle inventory agent, you can run the agent to collect Oracle Database inventory from the registered Oracle servers. Follow these steps:
The agent runs and displays some log messages. Wait until the command execution is over.
sqlplus fnmoaudit/<password>@<oracle instance>where fnmoaudit is the name of the audit user, <password> is the password for the audit user, and <oracle instance> is the name of the Oracle server. Contact your network administrator to resolve any connection errors.
The license consumption calculation process of FlexNet Manager Suite requires the collected .ndi files for calculating your Oracle license position.
If you have installed FlexNet Beacon software, you can manually transfer the collected inventory (.ndi) files to the Warehouse directory\Incoming\Inventories folder. The inventory beacon uploads the inventory to FlexNet Manager Suite.
If you have not installed any inventory beacon, you can use any third-party methods to export the imported inventory to the C:\ProgramData\Flexera Software\Incoming\Inventories folder on the FlexNet Manager Suite server.
Some Oracle license calculations (for example, processor-based) are dependent on the hardware information of the host. To get accurate license consumption calculations, FlexNet Manager Suite advises you to gather and upload the hardware inventory of the target Oracle hosts, in addition to the Oracle Database inventory. You can use any third-party inventory system, or any Flexera recommended inventory collection method, to collect hardware inventory from the target Oracle servers. For more information about the inventory collection methods supported by Flexera, see the Oracle Discovery and Inventory chapter in the System Reference Guide PDF.
You can easily uninstall the stand-alone Oracle inventory agent by following these steps:
You need to create a database audit account on each of the target Oracle servers to collect Oracle inventory using the stand-alone Oracle inventory agent. The database account must have read-only access to the following tables and views. These tables contain only internal database information, and no user or application data. The database administrator can use a script from Flexera to create a user fnmoaudit on all target Oracle servers.
on Mar 03, 2021 05:06 PM - edited on Jun 27, 2022 10:38 PM by mpaladino
Good to have this enhancement and thanks for sharing it
This solution doesn't seem to work. Getting the following error like the license has changed...
Failed to open inventory for oradbserver.company.com: 0xe1a50015.
License term PurlBladeOracle was not found in file D:\ORAtrack\oratrack.xml
Oracle inventory failed for server oradbserver.company.com.
Is there anything similar for UNIX devices?