Oracle Connectivity issue with BODS 4.2 when execiting a job

dataservices administration
1

HI,

I’m running into a strange problem with my BODS connectivity:

I have all my repositories and source/target databases on MS SQL server and there are all working fine.

We have now a new data source based on oracle 11g2

I have installed oracle client 11g2 and I was able to create a datastore on top of it and I was also able to import tables and view their content.

However When I want to run a jod using tables from that datastore as source I got the following error:
Cannot find NT Oracle Server DLL <OCI.DLL>. Please make sure that Oracle has been installed and the PATH variable points to the correct lib directories.

I have uninstalled my oracle client and installed verion 12.102
but it didn’t help.

Any idea what further steps I should take?

My configuration
OS: windows server 2008 R2
BODS: 4.2 SP3 (64 bits)
oracle client 11g2/12.102 (64 bits)
data sourec: oracle server 11g2

Thx in adavance

spartaks (BOB member since 2015-02-01)

2

It sounds like you installed the Oracle client on your desktop where you run Designer. The client needs to be installed on the job server’s O/S also.

Be sure that your TNSNames.ora file on your client is sync’d up with the on on the server.

eganjp :us: (BOB member since 2007-09-12)

3

Hi,

Thx for your prompt answer.

No I was running the designer on the server itself.

The issue was that the account that was running the service on which data services was running didn’t have the oracle home defined in its PATH. Now it has and everything works just fine.

Problem solved

Thx for your help

spartaks (BOB member since 2015-02-01)