To gather Oracle Database inventory from a beacon, you need the 32-bit version of Oracle Provider for OLE DB installed on your system. If this driver isn't installed, or if it's installed improperly, you will see errors in the trace level log files generated by the inventory beacon like the following:
(0,Error/Occurrence/Error/279/301): Error Occurrence (s279m301): Error 0x800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "XXXXX.Connection".
(Inventory/Oracle/Query): Unable to connect to DB
(Inventory/Oracle/SDK): Oracle OLEDB provider was not found. Error 0x800a0e7a
(0,Error/Occurrence/Error/421/200): Error Occurrence (s421m200): OLE DB provider for Provider=OraOLEDB.Oracle is not installed
You may also see an error appear in the status message when viewing the Discovered Device Properties for an Inventory Device, such as the one below:
How to resolve the error
- Install the Oracle OLE DB Provider (32-bit) driver on the inventory beacon that performs your Oracle inventory rule.
NOTE: Please review the System Requirements and Compatibility Guide for your version of FlexNet Manager Suite at docs.flexera.com to determine the minimum required version of the driver you need.
- After the driver is installed, restart the FlexNet Beacon engine before running an Oracle inventory rule.
How to check whether the Oracle Provider for OLE DB is installed and registered correctly on an inventory beacon
OLE DB Provider for Oracle is installed on the beacon server but Oracle database inventory fails with "OLE DB provider for Oracle is not installed" message