Some users may experience issues accessing the case portal. For more information, please click here.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

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

Summary

OLE DB provider for Oracle is installed but "OLE DB provider for Oracle is not installed" message is logged in the action status.

Symptoms

Oracle database inventory requires 32 bit OLE DB Provider for Oracle on the beacon server.
OLE DB Provider for Oracle is installed but the Oracle database inventory in the action status of the Discovery Device Properties page shows like the following messages in the Details of Last Failure.
Error 0x0800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.connection".
Error 0x0800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.connection".
OLE DB provider for Oracle is not installed

Cause

OLE DB Provider for Oracle was installed after Inventory Beacon installation and Flexera Inventory Beacon Engine service has not restarted after OLE DB Provider for Oracle installation.

Resolution

  1. Stop Flexera Inventory Beacon Engine service.
  2. Restart Flexera Inventory Beacon Engine service.
  • Don't use the restart button or menu, it needs to stop the running Flexera Inventory Beacon Engine service and then restart it.

Additional Information

If the same error occurs after restarting Flexera Inventory Beacon Engine service, there is a possibility that Oracle installer failed to register OLE DB Provider for Oracle.
Run like the following commands and then restart Flexera Inventory Beacon Engine service.
  1. Open a Command prompt in administrator mode
  2. cd %ORACLE_HOME%\bin
Example: cd \oracle\product\11.2.0\client_1\BIN
  1. Register the dll of OLE DB Provider for Oracle
Example: Oracle 11gR2
32 bit environment
c:\Windows\system32\regsvr32.exe OraOLEDB11.dll
64 bit environment
c:\Windows\SysWOW64\regsvr32.exe OraOLEDB11.dll

Related KB Articles

000017831
Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Jan 30, 2019 02:38 AM
Updated by: