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

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\
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Jun 02, 2018 01:02 PM
Updated by: