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 220.127.116.11, Culture=neutral, PublicKeyToken=null or one of its dependencies. The System cannot find the file specified"
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=18.104.22.168 assembly and its dependencies in the GAC to load successfully when attempting to register a service instance.
The ODAC can be installed in two ways:
- Universal Installer (setup.exe)
- 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.
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.