"

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

Last review: Nov 11, 2017
https://kb.netwrix.com/1096
Copy Article URL Copied

Netwrix Auditor(server) installed on Windows Server 2012 R2 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 event log:
Netwrix Auditor was unable to process the item: Could not load file or assembly…


The issue is caused by inconsistent version of the Oracle Data Access (12.1 and 12.2) and the .NET Framework 4.0.


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.config Netwrix.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.1 Example 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.

In order to add the .Net Framework 3.5 feature and register .Net assembly, please follow the steps below:

  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

Go Up