OracleInventoryUser
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
.)
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 launchsqlplus
is typically achieved by including the account name in the operating system group owning Oracle inventory (by default calledoinstall
, 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:
of course substituting the actual account name for the placeholder (for more details, see your Oracle documentation).CREATE USER ops$OracleInventoryUser IDENTIFIED EXTERNALLY;
- Having
sqlplus
(running asOracleInventoryUser
) successfully connect to the database instance can be achieved in either of these two ways:- When
OracleInventoryAsSysdba=True
(or is unspecified, since the default isTrue
), theOracleInventoryUser
account must also be a member of the Oracledba
group. In this case,ndtrack
logs into the database instance with the command:sqlplus "/ as sysdba"
Note: WhenOracleInventoryAsSysdba=True
butOracleInventoryUser
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 thedba
group), and uses the same account name to take inventory of the database instance. - When
OracleInventoryAsSysdba=False
, the OS account need not be in thedba
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 IT Asset Management System Reference). In this case,ndtrack
logs into the database instance with the command:sqlplus "/ "
- When
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.#
) 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:
|
Default value |
None. (See note above for impacts when this preference is not specified.) |
Example value |
|
Command line
Tool |
Either:
|
Example |
|
Registry
Installed by |
Manual configuration |
Computer preference |
[Registry]\ManageSoft\Tracker\CurrentVersion
in the config.ini or ndtrack.ini
file:
|
IT Asset Management (Cloud)
Current