Oracle Discovery Error 0x800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.Recordset".

Yes

Summary

This article will describe a scenario that product error will occur when Inventory Manager does Polmerge process or Oracle Discovery process, even the corresponding Oracle Drive are installed. The root cause is due to missing a system dll file ('C:\Program Files (x86)\Common Files\System\msadc\msdaprst.dll'). It may have been removed by Symantec antivirus software due to security reasons.

Symptoms

This article will describe a scenario that product error will occur when Inventory Manager does Polmerge process or Oracle Discovery process, even the corresponding Oracle Drive are installed. The root cause is due to missing a system dll file ('C:\Program Files (x86)\Common Files\System\msadc\msdaprst.dll'). It may have been removed by Symantec antivirus software due to security reasons.

The Oracle Discovery error message: Error 0x800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.Recordset".

This msdaprst.dll is currently a required component for our Oracle Inventory

Cause

For security reason , this file may have been removed by antivirus software.

This Symantec document refers to the PCI DSS standard and specifically CIS Security Configuration Benchmark For Microsoft IIS 7 which contains:

1.1.2 Remove or Rename Well-Known URLs (Scored)

7. Ensure nothing exists at %programfiles%\Common Files\System\msadc

Reference:
The Symantec Documents (https://www.symantec.com/business/support/index?page=content&pmv=print&impressions=&viewlocale=&id=HOWTO83950)
PCI DSS Standard (http://en.wikipedia.org/wiki/Payment_Card_Industry_Data_Security_Standard)
CIS Security Configuration Benchmark For Microsoft IIS 7 (https://benchmarks.cisecurity.org/tools2/iis/CIS_Microsoft_IIS_7_Benchmark_v1.4.0.pdf)

Steps To Reproduce

Please use "Process Monitor" tool to reproduce this with oratrack.exe to connect to a single database instance.
This will show all of the class registry keys accessed.

You will see Result ' PATH_NOT_FOUND' on Process Name "oratrack.exe" , Operation (CreateFile)

Resolution

Workaround

Add file (msdaprst.dll) back C:\Program Files (x86)\Common Files\System\msadc\

Oracle Discovery Error 0x800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.Recordset".