Summary
This article describes the procedure to use the Flexera Software-provided script to create an Oracle user for Oracle database inventory collection.
Synopsis
Although Flexera Software recommends inventory collection through Flexera inventory collection components (FlexNet inventory agent or FlexNet inventory beacon), you may choose to collect Oracle database inventory through any of the following additional methods:
- Direct inventory collection process: The inventory collection component of the inventory beacon (FlexNet Beacon engine) connects directly to each of the targeted Oracle databases within its assigned subnet using the discovery information from the selected source (Port scan, SNMP scan, TNS Names file, Gather Oracle database environment inventory).
- Manually deploying and executing the inventory collection component (ndtrack) as an externally-authenticated account: The inventory collection component (ndtrack) runs locally as an externally-authenticated user to collect Oracle database inventory. An externally-authenticated user is maintained by Oracle database but authenticated by the operating system. This feature is helpful when you wish to use a database user that is not a member of the dba group.
- Executing the inventory collection component (ndtrack) as an externally-authenticated account from the appropriate inventory beacon: The inventory collection component (ndtrack) runs as an externally-authenticated user from the appropriate inventory beacon, using the OracleInventoryUser parameter.
Note: The support for inventory collection through an externally-authenticated account (any of the last two methods in the above list) is available only for supported UNIX-based Oracle servers when you have FlexNet Manager Suite 2015 R2 SP4 or later. This feature also requires you to create an operating system user with the same name as the externally-authenticated database user (without the OPS$ prefix). For example, for an exernally-authenticated user OPS$RSMITH, you need an operating system user with a name RSMITH. For more information on externally-authenticated users, see Oracle documentation.
Each of the above-stated inventory collection methods require an Oracle user with the read-only access to certain Oracle tables and views on all the target Oracle servers. This user can either be specified with the ndtrack command line option or can be added to the OracleInventoryUser setting in the ndtrack.ini file (only when running from the appropriate inventory beacon). One helpful practice is to create the same user on every Oracle server.
This article lists the steps to create the desired inventory collection user by running a Flexera Software-supplied script. For details on the available inventory collection methods, see the Oracle Discovery and Inventory chapter of the FlexNet Manager Suite System Reference Guide that is accessible through the title page of the online help.
Discussion
Creating an Oracle User for Inventory Collection
The following is the process to create an inventory collection user for Oracle database inventory:
- Open the command prompt as a user with administrative privileges on the Oracle database. Typically this will require the sysdba privilege, using connect as sysdba.
- Run the attached script to create an externally-authenticated user on the database using the following syntax:
@/<path_to_script>/create_oracle_audit_user.sql <parameter>
Where, parameter is case sensitive, and can take any of the following values:
- remote: When running Oracle introspection from the inventory beacon for direct inventory collection method. Make sure to register this user in the secure Password Store on the appropriate inventory beacon.?
- local: When running ndtrack as an externally-authenticated user either locally on the Oracle server or from the appropriate inventory beacon. When using the latter approach, make sure to register this user in the secure Password Store on the appropriate inventory beacon.
Additional Information
Additional information
An Oracle user created with the attached script provides the read-only access to the following tables and views. For details on the available inventory collection methods, see the Oracle Discovery and Inventory chapter of the FlexNet Manager Suite System Reference Guide that is accessible through the title page of the online help.
- ALL_SDO_GEOM_METADATA SELECT
- DBA_ADVISOR_TASKS SELECT
- DBA_AUDIT_TRAIL SELECT
- DBA_AWS SELECT
- DBA_CPU_USAGE_STATISTICS SELECT
- DBA_CUBES SELECT
- DBA_DV_REALM SELECT
- DBA_ENCRYPTED_COLUMNS SELECT
- DBA_FEATURE_USAGE_STATISTICS SELECT
- DBA_FLASHBACK_ARCHIVE SELECT
- DBA_FLASHBACK_ARCHIVE_TABLES SELECT
- DBA_FLASHBACK_ARCHIVE_TS SELECT
- DBA_INDEXES SELECT
- DBA_LOB_PARTITIONS SELECT
- DBA_LOB_SUBPARTITIONS SELECT
- DBA_LOBS SELECT
- DBA_MINING_MODELS SELECT
- DBA_OBJECT_TABLES SELECT
- DBA_OBJECTS SELECT
- DBA_RECYCLEBIN SELECT
- DBA_REGISTRY SELECT
- DBA_SEGMENTS SELECT
- DBA_SQL_PROFILES SELECT
- DBA_SQLSET SELECT
- DBA_SQLSET_REFERENCES SELECT
- DBA_TAB_PARTITIONS SELECT
- DBA_TAB_SUBPARTITIONS SELECT
- DBA_TABLES SELECT
- DBA_TABLESPACES SELECT
- DBA_USERS SELECT
- DUAL SELECT
- GV_$INSTANCE SELECT
- GV_$PARAMETER SELECT
- MODEL$ SELECT
- REGISTRY$HISTORY SELECT
- ROLE_SYS_PRIVS SELECT
- SDO_GEOM_METADATA_TABLE SELECT
- USER_ROLE_PRIVS SELECT
- USER_SYS_PRIVS SELECT
- UTL_INADDR EXECUTE
- V_$ARCHIVE_DEST_STATUS SELECT
- V_$BLOCK_CHANGE_TRACKING SELECT
- V_$CONTAINERS SELECT
- V_$DATABASE SELECT
- V_$INSTANCE SELECT
- V_$LICENSE SELECT
- V_$OPTION SELECT
- V_$PARAMETER SELECT
- V_$SESSION SELECT
- V_$VERSION SELECT
Below are SQL scripts that are referenced in the documentation FNMS System Reference guide (page 108).
| CONTENT.ODM_DOCUMENT |
| DMSYS.DM$MODEL |
| DMSYS.DM$OBJECT |
| DMSYS.DM$P_MODEL |
| LBACSYS.LBAC$POLT |
| ODM.ODM_MINING_MODEL |
| ODM.ODM_RECORD |
| OLAPSYS.DBA$OLAP_CUBES |
| SYSMAN.MGMT$TARGET |
| SYSMAN.MGMT_ADMIN_LICENSES |
| SYSMAN.MGMT_FU_LICENSE_MAP |
| SYSMAN.MGMT_FU_REGISTRATIONS |
| SYSMAN.MGMT_FU_STATISTICS |
| SYSMAN.MGMT_INV_COMPONENT |
| SYSMAN.MGMT_LICENSE_CONFIRMATION |
| SYSMAN.MGMT_LICENSE_DEFINITIONS |
| SYSMAN.MGMT_LICENSES |
| SYSMAN.MGMT_TARGET_TYPES |
| SYSMAN.MGMT_TARGETS |
| APPLSYS.FND_APP_SERVERS |
| APPLSYS.FND_NODES |
| APPLSYS.FND_PRODUCT_INSTALLATIONS |
| APPLSYS.FND_APPLICATION_TL |
| APPLSYS.FND_USER |
| APPLSYS.FND_RESPONSIBILITY |
| APPS.FND_USER_RESP_GROUPS |
Related Articles
SNMPv3 access required for complete inventory collection 4Number of Views Resolve Oracle database inventory failure with the “OraOLEDB.Oracle provider is not installed” error 36Number of Views How the FlexNet inventory agent determines ORACLE_HOME on Unix-like operating systems when gathering Oracle Database inven… 85Number of Views Remote Oracle Database inventory may create inventory devices with IP address as their name when inventory gathering fails 4Number of Views Collecting Oracle Database inventory from RDS instances hosted in Amazon Web Services 16Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago