I have a strange problem, most likely, caused by some environment property that I do not know.
We are trying to switch from DB2 to Oracle 11g. We configured dsenv to use a Oracle Client 10 and Oracle Connector Stage variant 10 and it worked and returned ORA messages in the director log as expected. However we faced a few other issues due to the incompatibility so we installed a new Oracle Client 11 on our red hat linux server and switched the dsenv paths to match the new installation, then we changed the jobs so they used Variant 11 in the Oracle Connectors. Now we do not receive ORA messages anymore.
Has anyone faced this issue before? Any suggestions/solutions?
Thanks
This is the dsenv entries;
#Oracle
export ORACLE_HOME=/app/oracle/ora11g/product/11.2.0/client_1
export NLS_LANG=AMERICAN_AMERICA.UTF8
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:`dirname $DSHOME`/../branded_odbc/lib:$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:/app/IBM/db2/V9.7/lib64:/lib:/usr/lib
export LD_LIBRARY_PATH