Symptoms

While trying to register an Oracle service instance, we saw the following error: 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. Source : mscorlib
 

Diagnoses

This error message normally indicated that the wrong "version" of the ODAC components has been installed. You have to install the 32bit ODAC components on a 32bit OS and the 64bit ODAC components for a 64bit OS.
 

Resolution

After installing the 64bit ODAC components (Instead of the 32bit ODAC components), the service instance was registered without issue.