Hello Friends,
Can you please help me to set up the connection with BODS and ORACLE and BI. I am getting error saying “Cannot find NT Oracle Server DLL >OCI.dll>.”
shameer38in (BOB member since 2008-01-18)
[Moderator Note: Moved from General Discussion to Data Integrator -> DI: Installation, Administration, and Connectivities]
Marek Chladny 
(BOB member since 2003-11-27)
Are you using the correct version of the Oracle client? 64 bit vs 32 bit.
A while back I had a similar connection issue and I copied the OCI.dll file from the Oracle install directory to the DS bin directory. I would only do this as a last-chance solution.
eganjp 
(BOB member since 2007-09-12)
Hello,
Thanks for replying. It’s 64 bit. Can you please guide me how to fix this issue.
Thanks!
Regards,
Syed
shameer38in (BOB member since 2008-01-18)
Are you using a 64 bit version of Data Services?
eganjp (BOB member since 2007-09-12)
We were getting the error ‘Cannot find NT Oracle Server DLL <OCI.DLL>’ with SAP DS 14.2.6.1113. We had a similar error for Teradata sources. All the database middleware had been installed after the SAP DS was installed as we are using SQL Server for the repositories. This means the PATH had been updated since SAP DS had been last restarted. We could view data from Designer for all the sources but the jobs would fail. 
We restarted the SAP DS service which must have reloaded the PATH for the SAP DS process and all was good. 
dlaplant 
(BOB member since 2006-03-27)