Cannot find NT Oracle Server DLL <OCI.DLL>. Ensure that Oracle has been installed and the PATH variable points to the correct

[Former Member]

Hi,

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 11g db, target is Sql server db.

when i execute the job getting this error 

Could anyone help me out What the error is?

Thanks

[DayaJha]

Hi Mahi,

Please refer the below image for ORACLE Instant Client Configuration in Developer Machine.

• Oracle Client Installation (For example In your environment if  SAP Business Objects Data Services 64-bit then the Oracle client should also be 64 bit and likewise for 32-bit)

Extract Software

Copy the instant client to your PC and extract the file. This will create a subdirectory called instantclient_10_2/instantclient_11_2

Here i am Using "Instantclient-basic-win32-10.2.0.4.zip file" For explanation of Oracle Home Setting. You ac use the latest as per your Oracle Setup.

Select the file instantclient-basic-win32-10.2.0.4.zip file

Press the “Extract” button

Select the C: Drive and then press the extract button.

Result:

• Set environment Variables

Open System properties

Control Panel > System > Select Advanced Tab > Press the Environment Variable button

Add a new system variable for TNS_ADMIN and amend the PATH variable.

Select the New button to create New variables or Edit to amend/change existing variables.

Edit the Path Variable and add the instantclient directory to the Path.

• Tnsnames file

Copy the tnsnames.ora file below into the instantclient_10_2 directory

Note: The tnsnames.ora must reside in the directory as set for the variable TNS_ADMIN

Hope this will help you as well.

Thanks,

Daya

[Former Member]

Hi,

Things to verify  are in place before you execute:

1. On your DS Client (designer) machine, make sure  the oracle client  installed and matches DS bit architecture. For example if you have DS 64bit then the Oracle client should also be 64 bit and likewise for 32bit.
2. If you have DS job server on a different machine, then you need to have Oracle client 64bit installed
3. Define/Add the Environment Variable ORACLE_HOME to point to the correct path
4. Correct/Check/Add the  Environment Variable "PATH"  with ORACLE_HOME/bin

thanks

Nawfal