We have installed DataStage 7.5.3 and using Oracle 9i as client. In the dsenv file whenever we put LD_LIBRARY_PATH with appropriate path, we are not able to start datastage.
DataStage is working when the LD_LIBRARY_PATH is commented in dsenv file and start DataStage.
##Oracle related parameter in dsenv file
ORACLE_HOME=/app/oracle; export ORACLE_HOME
TNS_ADMIN=/app/oracle/network/admin; export TNS_ADMIN
LD_LIBRARY_PATH=/app/oracle/lib; export LD_LIBRARY_PATH
PATH=/usr/bin:/app/oracle/bin; export PATH
Can you suggest anything i have missed in Oracle connection.
DataStage not starting when oracle path is provided in dsenv
Moderators: chulett, rschirm, roy
Re: DataStage not starting when oracle path is provided in d
Make sure you have
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/.dslibs:$dshome/lib:$ODBCHOME:$ODBCHOME/lib:$ORACLE_HOME/lib32:/usr/lib/lwp; export LD_LIBRARY_PATH
and
PATH=$PATH:$dshome/bin:$ODBCHOME:$ODBCHOME/bin:$ORACLE_HOME/bin; export PATH
with the relevant ODBCHOME,ORACLE_HOME,dshome,ODBCINI already set in the dsenv file
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/.dslibs:$dshome/lib:$ODBCHOME:$ODBCHOME/lib:$ORACLE_HOME/lib32:/usr/lib/lwp; export LD_LIBRARY_PATH
and
PATH=$PATH:$dshome/bin:$ODBCHOME:$ODBCHOME/bin:$ORACLE_HOME/bin; export PATH
with the relevant ODBCHOME,ORACLE_HOME,dshome,ODBCINI already set in the dsenv file
Apanandha