CON -120402 Oracle Error

dataservices job design
1

With refernce to CON -120402 Oracle 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 seen this link

Able to connect using SQLplus…
Able to create and import table using Data Services Datastores for Oracle 10g

Checked Already:-

  1. Checked path @ control panel → system → Advanced → Environment Variables → PATH forOracle\bin directory, Orale_Home, OCI.dll
  2. Checked OCI.dll at the location
  3. Restarted windows Data Services Service

Pls suggest

sjain :india: (BOB member since 2009-04-17)

2

where are you getting this error ? when executing a job ?
the link that you have provided points to a discussion on LOV in Universe Designer, it has nothing to do with DS Designer or DataServices

if you are able to create Datastore and import tables, then there should be no problem executing the jobs on the same machine

check under what user DataServices Service is running ? try changing to same user as you are currently logged in are able to work in Datastore in Designer

manoj_d (BOB member since 2009-01-02)

3

Updated the link in previous post.

Yes we have successfully configured Datastore for Oracle 10g and imported tables as well.

How ever when we go for execution it shows the error.

We are running under the Super User which we have used to install Data Services and Oracle Client.

Reference:–

Some versions of Oracle Clients are affected by Oracle Bug 3807408.
These versions are: 9.2.0.5, 9.2.0.7, 10.1.0.5, 10.2.0.2
The issue is fixed in the following versions: 9.2.0.8 (Server Patch Set), 10.2.0.3 (Server Patch Set), 11.1.0.6 (Base Release).

Pls suggest if that is the reason.

sjain :india: (BOB member since 2009-04-17)

4

My current Details

  1. SAP BOBJ Data Services Server(32 bit) Version = XI 3.2 SP3

  2. Source1 - Oracle Server 10g version = 10.2.0.1.0
    Oracle Client (32bit)version installed on Data Services Server = 10.1.0.2

sjain :india: (BOB member since 2009-04-17)

5

Issue got resolved.

We have upgraded Oracle client to version 10.2.0.3 from 10.1.0.2 on Data Services Server.

sjain :india: (BOB member since 2009-04-17)