This article describes the procedure to use the Flexera Software-provided script to create an Oracle user for Oracle database inventory collection.
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:
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.
The following is the process to create an inventory collection user for Oracle database inventory:
Where, parameter is case sensitive, and can take any of the following values:
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.
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 |
on Jun 09, 2018 02:09 AM - edited on Mar 02, 2020 11:33 AM by JohnTech
Both files match with eachother so perhaps 1 can be removed?