"Cannot find NT Oracle Server DLL <OCI.DLL>. DS c

dataservices administration
1

Hello
I am getting the following error when trying to connect Database through datastore from Designer.

“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.”

  1. DS is on Windows
  2. DS repo is sql server
  3. Source is Oracle 10g db, target is Sql server db.
  4. Oracle 32 bit full client is installed on the job server (10.2.0.1.0).

I have set Path to PATH.
Restarted DS services.

Pending thing System restart.

Could anyone help me out What the error is?

Thanks
Kumar

itsvsk :india: (BOB member since 2011-05-04)

2

What does the PATH environment variable contain?
Can you find the OCI.DLL file in any of the Oracle Client directories, usually the bin directory?

Werner Daehn :de: (BOB member since 2004-12-17)

3

Yes, I can see OCI.DLL in the Oracle Client BIN directory.

I am able to connect to Oracle Database form SQL PLUS. When I try to connect from DS I can see the above Error.

I have restarted DS services on Windows 2003 server.

itsvsk :india: (BOB member since 2011-05-04)

4

SQL*Plus is not using OCI.DLL, so that’s no valid test.

Does the PATH environment variable contain the directory where the oci.dll is located?
And most important, assuming you are not using DS 4.0, DS is a 32bit application. So the Oracle Client for 32bit has to be installed as well and its bin directory needs to be the first in the PATH to pick the proper oci.dll.

Werner Daehn :de: (BOB member since 2004-12-17)

5

Thanks for response,

I am using Oracle 32 Bit Client and Environment Variables Path I can see is it starts with Oracle Client BIN that holds OCI.DLL.

Only Thing i found is the system I am using is 64 Bit Itanium.
Is this the only thing causing problems?

DS version is 3.2

I have done the following changes :
Moved
c:\Program files (x86)\Business Objects PATH to other drive
N:\Program Files\Business Objects
Changed Path to PATH

:hb: :hb: :hb:
:flush:
Anyone please help me…

thanks
Kumar

itsvsk :india: (BOB member since 2011-05-04)

6

there are some issues with certain version of oracle and if the oracle client is installed in a location that contains “(” or “)”

the workaround is to install oracle in a location that doesn’t contain “(” and “)” like C:\Oracle and also install the application that use OCI in location that doesn’t contain “(” or “)” in the path, install DS on C:\Apps\BusinessObjects\Data Services

or try installing oracle 10.2.0.4 or higher

manoj_d (BOB member since 2009-01-02)

7

No Luck Manoj
I did installing DS3.2 in C:\Aps\BusinessObjects
With Oracle Client 11 32bit version.
I have cross checked the Environment Variable PATH. It points to correct OCI.LL. I do not know where it is going wrong.

Does DS 3.2 32 bit go with OS IA64 bit Process?

Thanks
Kumar.

itsvsk :india: (BOB member since 2011-05-04)

8

Hi All,

Today I got the solution. :+1: :+1:
I have installed DS and did not reboot the machine.

Main problem was with Oracle client 10.X I have upgraded it to 11.
Oracle DB 10G and Client 11 :slight_smile: . But still this works.

Thanks Manoj and Werner for all the support.

Regards.

itsvsk :india: (BOB member since 2011-05-04)