Unable to connect to Oracle Connector

[ketfos]

Hi,
I am able to connect to Oracle uisng Oracle OCI stage.
When I try to configure Oracle Connector stage, I get the error message
Error loading connector library libccora10g.so libclntsh.so.10.1:
below is the entry in dsenv file
---------------
LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/linux-all-x86_64:$LD_LIBRARY_PATH



export LD_LIBRARY_PATH


fi

#
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/client_1
export ORACLE_HOME

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib;
export LD_LIBRARY_PATH

[priyadarshikunal]

Does it work when you set the variant to 11 in oracle connector stage?

also is oracle library path, check if you have a soft link created as libclntsh.so.10.1 pointing to libclntsh.so in the same directory and datastage mapped user has access to the link as well as the actual file.

[prasson_ibm]

Hi,
Add oracle cilent lib path and bin path,ORACLE_HOME and ORACLE_SID to dsenv.

Then login as dsadm user to unix env.
. ./dsenv

ldd /opt/IBM/InformationServer/DSComponents/bin/libccora10g.so

This should provide with the list of libreries that are required by the oracle 10/ connector.if the list is without errors,then you need to restart dsengine and asb node agent.

[ketfos]

$ locate libccora10g.so
/opt/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so
/opt/IBM/InformationServer/Server/StagingArea/Installed/OracleConnector/Server/linux/libccora10g.so

$ ldd /opt/IBM/InformationServer/DSComponents/bin/libccora10g.so

ldd: /opt/IBM/InformationServer/DSComponents/bin/libccora10g.so: No such file or directory

Why it is not able to find the file?

Thanks
Ketfos

[jwiles]

Because you looked for

/opt/IBM/InformationServer/DSComponents/bin/libccora10g.so

instead of

/opt/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so

Regards,

[ketfos]

Thanks for correcting me.

What else I need to look into to resolve the issue?

ketfos

[ketfos]

Here is the output

$ ldd /opt/IBM/InformationServer/Server/DSComponents/bin/libccora11g.so
linux-vdso.so.1 => (0x00007fff5abff000)
libicuio.so.32 => /opt/IBM/InformationServer/Server/DSComponents/lib/libicuio.so.32 (0x00007fab8140e000)
libicuuc.so.32 => /opt/IBM/InformationServer/Server/DSComponents/lib/libicuuc.so.32 (0x00007fab81221000)
libicui18n.so.32 => /opt/IBM/InformationServer/Server/DSComponents/lib/libicui18n.so.32 (0x00007fab81003000)
libfcl.so => /opt/IBM/InformationServer/Server/DSEngine/lib/libfcl.so (0x00007fab80d00000)
libclntsh.so.11.1 => /u00/app/oracle/product/11.2.0.3/client_1/lib/libclntsh.so.11.1 (0x00007fab7e374000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007fab7e05f000)
libm.so.6 => /lib64/libm.so.6 (0x00007fab7ddda000)
libc.so.6 => /lib64/libc.so.6 (0x00007fab7da47000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fab7d831000)
libicudata.so.32 => /opt/IBM/InformationServer/Server/DSComponents/lib/libicudata.so.32 (0x00007fab7caa1000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fab7c884000)
libicutu.so.32 => /opt/IBM/InformationServer/Server/DSComponents/lib/libicutu.so.32 (0x00007fab7c774000)
libxml4c.so.56 => /opt/IBM/InformationServer/Server/DSComponents/lib/libxml4c.so.56 (0x00007fab7c2d7000)
libdsplugin.so => /opt/IBM/InformationServer/Server/DSEngine/lib/libdsplugin.so (0x00007fab7bfed000)
libIISCrypto.so => /opt/IBM/InformationServer/ASBNode/lib/cpp/libIISCrypto.so (0x00007fab7bece000)
libnnz11.so => /u00/app/oracle/product/11.2.0.3/client_1/lib/libnnz11.so (0x00007fab7bb02000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fab7b8fe000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fab7b6e4000)
libaio.so.1 => /lib64/libaio.so.1 (0x00007fab7b4e3000)
/lib64/ld-linux-x86-64.so.2 (0x0000003c21000000)
librt.so.1 => /lib64/librt.so.1 (0x00007fab7b2da000)
$

[lstsaur]

Your error message is "Error loading connector library libccora10g.so"; why you checking into "libccora11g.so" stuff?

[MrBlack]

Did you ever figure this out? I'm in a similar situation but my error message is about the 11g, and I do have the connector toggled for 11g. I can do a view and that works, but when I go to run the job is when it breaks.

[priyadarshikunal]

Can you post exact error message in question?

And then a couple of questions.
Did you install oracle client after datastage? did it ever work on that system?