Page 1 of 1

DataStage not starting when oracle path is provided in dsenv

Posted: Fri Oct 23, 2009 7:16 am
by rajngt
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.

Posted: Fri Oct 23, 2009 7:21 am
by chulett
Yes, of course... you need to append the Oracle information to the existing path, not completely replace it with just that information.

Re: DataStage not starting when oracle path is provided in d

Posted: Fri Oct 23, 2009 9:05 am
by anakumar
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

Posted: Mon Oct 26, 2009 4:00 am
by rajngt
Thanks anakumar and Chulett. Now the DataStage is working