Oracle Connector stage issue

[DS_Riks]

Hi,

I recently installed DataStage 8.7 on Solaris platform. When I tried to run job using oracle connector I am getting below error.

Error loading connector library libccora10g.so. ld.so.1: osh: fatal: libclntsh.so.10.1: open failed: No such file or directory (CC_LoadedConnector::loadLibrary, file CC_ConnectorFactory.cpp, line 1525)

If anybody come across this kind of issue please help.

Thanks,

[DS_Riks]

Hi,

Solved the problem. Somehow LD_LIBRARY_PATH was not recognizing by DataStage and not pointing correctly.

Now able to run the job using oracle connector stage but not able to view the data and test the connection.

Error loading connector library libccora11g.so. ld.so.1:java fatal: relocation error: file /server/DSComponents/bin/libccora11g.so: symbol __1cH__rwstdPrwse_outOfrange_: reference symbol not found

Any suggestion?

[chulett]

You may have included the 64bit libraries when it should have been the 32bit ones... or vice versa. What is your LD_LIBRARY_PATH?

[DS_Riks]

LD_LIBRARY_PATH is

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/lib/sparcv9/server:$ASBHOME/apps/jre/lib/sparcv9:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/sunos-all-sparc_64:$ORACLE_HOME/lib:$ORACLE_HOME/bin:$LD_LIBRARY_PATH

Thanks