I’m hoping someone from this board can help with a quick resolution of my issue. I will be creating a SAP message as well but I thought I’d try here also…
When attempting to test/save an Oracle datastore in DS 3.1 on a new server with the Oracle 10g client installed, I get the following error message:
“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. (BODI-1111341)”
Troubleshooting Steps Already Tried:
I have verified the Oracle PATH is correct on the server.
I can connect to the DB using SQL Plus on the server.
I verified the TNSNAMES.ORA file on the server.
Did you install the 32bit Oracle Client? Oracle does not support 32bit applications to load the 64bit driver. Also, make sure the directory where the correct oci.dll is actually is the first in the PATH environment variable.
Thanks for the response. I confirmed the PATH was correct but we may have installed the 64 bit client. We are going to deinstall the client and reinstall the 32 bit version explicitly and I will update my posting with the results.
if your OS is windows 64 bit and after installing 32-bit oracle if you still run into connectivity issue then try installing Oracle and DS on path which does not contain “(” or “)” symbol in it
by deault on Windows 64-bit 32-bit Application will have default location C:\Program File(x86) which would create problem when using Oracle as DS repo or source or target
I had the same problem creating a Datastore. After help from SAP Support team I learned that 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).
We have DS 3.1 and we had the 10.2.0.2 wich we upgraded to 10.2.0.3.
(BOB member since 2002-09-05)
(BOB member since 2004-12-17)
(BOB member since 2009-10-26)