Symptoms

Unable to Register Oracle Service Broker or create Oracle Service Instance - K2 4.6.9
 

Diagnoses

I'm using K2 4.6.9. I wanted to register and create a service instance for creating a Oracle DB SmartObject.

I get a error message "SourceCode.SmartObjects.Services.Oracle" could not load when I try to register the oracle service broker.
 

Resolution

Was the ODAC also installed on the K2 Server and the Server restarted prior to attempting to register the service instance? As per:
http://help.k2.com/onlinehelp/k2blackpearl/UserGuide/4.6.10/webframe.html_The_K2_Oracle_Service.html

There is a hyperlink in that documentation to the Oracle ODAC component:
http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

Please download and install the ODAC version that matches your Oracle version and OS architecture(x64/x32). The Oracle Data Access Components (ODAC) is an oracle component that allow applications oracle access. Oracle versions that are supported by K2 can be found at:
http://help.k2.com/blackpearl/support-matrix_Oracle

When attempting to register an oracle service instance, a TNS connect time out error occurs. Please try registering the oracle service instance with the connection string in this format:

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dlx.denallix.com)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))User Id=k2demoPassword=k2pass

As per:
http://help.k2.com/onlinehelp/k2blackpearl/UserGuide/4.6.10/webframe.html_Oracle_Service_Instance_Configuration.html

Specify the appropriate "Host", "Port", "Service_name", "UserID", and "Password" values in the connection string.

Please also see post below regarding some relevant information:
http://community.k2.com/t5/K2-blackpearl/Creating-and-Configuring-an-Oracle-Service-Instance/ta-p/72362

Customer was able to register and create an Oracle Smartobject successfully using the connection string above.