Netwrix Auditor was unable to process the item: Could not load file or assembly...

This article provides resolution for the Netwrix Auditor was unable to process the item: Could not load file or assembly... error in the Netwrix Auditor System Health log.
Email It to Me Print this Page
Symptoms The Netwrix Auditor Server installed on Windows Server 2012r2 or Windows Server 2016 with default .NET Framework version 4.0 or 4.5 and Oracle Data Access Components 12.1 or 12.2 installed. When you create a monitoring plan for auditing Oracle Database and launch data collection, you receive the following error in the Netwrix Auditor System Health log:
Netwrix Auditor was unable to process the item: Could not load file or assembly...
Cause Inconsistent version of the Oracle Data Access (12.1 and 12.2) and the .NET Framework 4.0.
Resolution You can resolve this issue in two ways:
  • Method 1: edit the Netwrix.OracleDataRetriever.exe.config​ and Netwrix.AuditCore.OracleVerifier.exe.config configuration files, and provide path to the Oracle.DataAccess.dll file.
  • Method 2: add the .NET Framework 3.5 feature and register .NET assembly.
To edit the configuration files:
  1. On the computer where Netwrix Auditor is installed, open registry editor and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient12Home1.
  2. Open the ORACLE_HOME registry key and copy path to the Oracle.DataAccess.dll file. For example: C:\app\client\administrator\product\12.1.0\client_1\
    Note: The ORACLE_HOME registry key contains incomplete path. Navigate to \odp.net\bin\2.x\ to access the .dll file. 
  3. Find and open the configuration files:
Netwrix.OracleDataRetriever.exe.configNetwrix.AuditCore.OracleVerifier.exe.config
  1. On the computer where Netwrix Auditor is installed, navigate to Netwrix Auditor installation folder (by default, C:\Program Files (x86)\Netwrix Auditor\) -> Oracle Auditing.
  2. Open the Netwrix.OracleDataRetriever.exe.config file with Notepad. 
  1. On the computer where Netwrix Auditor is installed, navigate to Netwrix Auditor installation folder (by default, C:\Program Files (x86)\Netwrix Auditor\) -> Audit Core.
  2. Open the Netwrix.AuditCore.OracleVerifier.exe.config file with Notepad. 
  1. Locate the <Configuration> node and add the following, depending on your Oracle Data Access Components version:
Example for ODAC 12.1Example for ODAC 12.2
<runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89B483F429C47342">
          <codeBase version="2.121.2.0" href=""FILE://path_to_Oracle.DataAccess.dll>
       </dependentAssembly>
     </assemblyBinding>
</runtime>

where FILE://​path_to_Oracle.DataAccess.dll is the path to the Oracle.DataAccess.dll file you copied on the step 2.
<runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89B483F429C47342"/>
        <bindingRedirect oldVersion="2.121.0.0-2.121.9999.9999" newVersion="2.122.1.0"/>
          <codeBase version="2.122.1.0"/>
href="FILE://path_to_Oracle.DataAccess.dll">
       </dependentAssembly>
     </assemblyBinding>
</runtime>

where FILE://​path_to_Oracle.DataAccess.dll is the path to the Oracle.DataAccess.dll file you copied on the step 2.
To add the .Net Framework 3.5 feature and register .Net assembly
  1. On the computer where Netwrix Auditor is installed, run Server Manager and add the .NET Framework 3.5 feature.
  2. Open registry editor and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient12Home1.
  3. Open the ORACLE_HOME registry key and copy path to the Oracle.DataAccess.dll file. For example: C:\app\client\administrator\product\12.1.0\client_1\
    Note: The ORACLE_HOME registry key contains incomplete path. Navigate to \odp.net\bin\2.x\ to access the .dll file. 
  4. Open a command prompt as an Administrator.
  5. Navigate to the directory where your ODAC resides.
  6. Execute the following command:
cd C:\app\client\administrator\product\12.1.0\client_1\odp.net\bin\2.x
OraProvCfg.exe /action:gac /providerpath:C:\app\client\administrator\product\12.1.0\client_1\odp.net\bin\2.x\Oracle.DataAccess.dll
Was this information helpful?