Issue

When attempting to register an Oracle Service Instance, the following error appears:

"SmartObject Server Exception: Could not load file or assembly 'SourceCode.SmartObjects.Services.Oracle', Version 4.0.0.0, Culture=neutral, PublicKeyToken=null or one of its dependencies. The System cannot find the file specified"

Symptoms

This error usually appears if the ODAC has not yet been installed from (http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html).

However, the ODAC was installed using the 'Universal Installer (setup.exe)' and the server was restarted.

The 'SourceCode.SmartObjects.Services.Oracle' broker requires the 'Oracle.DataAccess' Version=2.112.2.0 assembly and its dependencies in the GAC to load successfully when attempting to register a service instance.

Image

The ODAC can be installed in two ways:

  1. Universal Installer (setup.exe)
  2. Xcopy installer (install.bat)

If using the Universal Installer, the 'ODP.NET (Oracle Data Provider for .NET) > 'Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level' option needs to be checked during the installation for the needed assemblies to get added to the GAC.

Resolution

Re-install the ODAC using the Universal Installer with the 'ODP.NET (Oracle Data Provider for .NET) > 'Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level' option checked.  Restart the K2 Blackpearl server and retest.

Image