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\