OracleInventoryUser

FlexNet Manager Suite 2022 R1 (On-Premises)

Command line | Registry

OracleInventoryUser specifies an operating system account which the FlexNet inventory agent may use when collecting inventory data from an Oracle Database on a UNIX host. This preference applies only to UNIX-like platforms.

(On Microsoft Windows, ndtrack executes as SYSTEM, which must be a member of the ora-dba database group on the Windows Server. For manual execution on the command line in Microsoft Windows, you can alternatively specify another account that has administrator privileges and is a member of ora-dba.)

On UNIX-like platforms, there are additional requirements. FlexNet inventory agent must first use the operating system account named in OracleInventoryUser to invoke the Oracle-supplied sqlplus executable, and then (without requiring additional passwords) have sqlplus connect to the database instance to gather inventory. In order for the database instance to trust the OracleInventoryUser account without additional passwords, the database instance must be configured to allow operating system (OS) authentication for that account.
  • Giving the OracleInventoryUser account the necessary privileges to launch sqlplus is typically achieved by including the account name in the operating system group owning Oracle inventory (by default called oinstall, named at Oracle installation) for each installation of Oracle Database.
  • Configuring for OS authentication requires that you check the OS authentication prefix (default ops$) for this database instance, and then register the account with a command like:
    CREATE USER ops$OracleInventoryUser IDENTIFIED EXTERNALLY;
    of course substituting the actual account name for the placeholder (for more details, see your Oracle documentation).
  • Having sqlplus (running as OracleInventoryUser) successfully connect to the database instance can be achieved in either of these two ways:
    • When OracleInventoryAsSysdba=True (or is unspecified, since the default is True), the OracleInventoryUser account must also be a member of the Oracle dba group. In this case, ndtrack logs into the database instance with the command:
      sqlplus "/ as sysdba"
      Note: When OracleInventoryAsSysdba=True but OracleInventoryUser is not set, ndtrack analyzes the services process listings to extract the SID of running instances of Oracle Database. It then identifies the user account that launched that process (which account is assumed to be a member of the dba group), and uses the same account name to take inventory of the database instance.
    • When OracleInventoryAsSysdba=False, the OS account need not be in the dba group, but must still be registered for OS authentication (as noted above). As an Oracle user, this account must also have appropriate permissions for inventory gathering (for table-level permissions, see Appendix C: Oracle Tables and Views for Oracle Inventory Collection in the FlexNet Manager Suite System Reference PDF, available through the title page of online help). In this case, ndtrack logs into the database instance with the command:
      sqlplus "/ " 
Tip: If you are setting OracleInventoryUser, and the path used to start the target Oracle database instance included a symbolic link, you might also consider whether to set an environment variable for this account that identifies the ORACLE_HOME for the target database instance. For more insight, see UserDefinedOracleHome.
Warning: The user name of the operating system account must not include a hash (#) character, as this causes a failure when attempting to upload the generated .ndi files to the application server.

Values

Values / range

An exact match for any Oracle user name that:
  • Is also an operating system account
  • Has OS authentication enabled
  • Is a member of oinstall (or equivalent group, granting execute permissions for sqlplus)
  • Is either a current member of the dba group on the UNIX host server; or has adequate permissions for inventory gathering (check descriptions above).

Default value

None. (See note above for impacts when this preference is not specified.)

Example value

dbauser

Command line

Tool

Either:
  • FlexNet inventory agent (ndtrack) locally installed on the UNIX server (the preference may be on the command line or in config.ini)
  • The tracker (ndtrack.sh) executed remotely from an inventory beacon in the zero footprint inventory collection case (the preference may be on the command line or in ndtrack.ini).

Example

-o OracleInventoryUser=dbauser

Registry

Installed by

Manual configuration

Computer preference

[Registry]\ManageSoft\Tracker\CurrentVersion in the config.ini or ndtrack.ini file:
[ManageSoft\Tracker\CurrentVersion] 
OracleInventoryUser=dbauser

FlexNet Manager Suite (On-Premises)

2022 R1