Unable to connect to Oracle Connector
Moderators: chulett, rschirm, roy
Unable to connect to Oracle Connector
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
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
ketfos
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.
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.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
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.
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.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
$ 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
/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
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)
$
$ 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)
$
ketfos
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI