Skip to main content
Nintex Community Menu Bar
Solved

Oracle Service Instance Error


Forum|alt.badge.img+6

Team,

 

I am trying to create an "Oracle Service Instance" through "SmartObject Service Tester". As soon as I right click on Oracle Service and click on "Register ServiceInstance" the attached error appears.

 

ODAC has been installed (ODAC 64bits as the server is Windows Server 2012 Standard 64bits) but error message still appearing.

 

TNS_ADMIN variable is configured.

 

Through ODBC I can get access to Oracle databases.

 

What else should I check in order to troubleshoot this error?

 

Thanks,

 

Will


12151iA04BFC86BCE681F5.png

Best answer by LDWill

Restarting the server did the trick.

View original
Translate
Did this topic help you find an answer to your question?

Forum|alt.badge.img+6
  • June 22, 2016

 Also, I am using Oracle 11g Enterprise Edition, instead of Express Edition as mentioned on the following link: http://community.k2.com/t5/K2-blackpearl/Creating-and-Configuring-an-Oracle-Service-Instance/ta-p/72362

 

Is it really necessary to have Express Edition?

Translate

Forum|alt.badge.img+10

A couple Ideas... 

 

1) Do you have the Oracle Client installed ?

2) Can you connect using the Oracle SQL Developer directly instead of ODBC ?

3) Nah... Oracle Express Edition is not required is the same as the Professional is just your Client setup.

 

That should get you some troubleshooting pointers...

 

Dino.

Translate

Forum|alt.badge.img+6
  • June 22, 2016

Oracle Client: Oracle 11g Enterprise Edition

I can connect through SQL Plus, already installed on the server.

 

I have all the pre requisites mentioned here: http://community.k2.com/t5/K2-blackpearl/Creating-and-Configuring-an-Oracle-Service-Instance/ta-p/72362

but still can't create the Oracle Service Instance.

 

What I dont have are the services shown at that link because the Oracle data base is on another server, so no need to have those services here too.

Translate

Forum|alt.badge.img+18
  • June 22, 2016

1.  I assume the 'SourceCode.SmartObjects.Services.Oracle.dll' assembly, also exists in the 'C:Program Files(x86)K2 blackpearlServiceBroker' directory.


2.  Please right click on this file, and check its 'Properties" if there happens to be an 'Unblock' option, please do so and retest.


3.  I assume the odac was intalled with:


"install.bat all c:oracle odac"


4.  Was the server also restarted after installing the ODAC?

Translate

Forum|alt.badge.img+6
  • June 24, 2016

Restarting the server did the trick.

Translate

Hi LDWill,

I am not able to open the link

http://community.k2.com/t5/K2-blackpearl/Creating-and-Configuring-an-Oracle-Service-Instance/ta-p/72362

Access denied i am getting can you please help me on this.

 

Thanks,

kaleswar.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings