DSXchange

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

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.

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.

$ 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

Because you looked for

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

instead of

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

Regards,

Thanks for correcting me.

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

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)
$

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

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.

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?