DataStage not starting when oracle path is provided in dsenv

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajngt
Participant
Posts: 32
Joined: Wed Jan 04, 2006 6:22 am

DataStage not starting when oracle path is provided in dsenv

Post 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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yes, of course... you need to append the Oracle information to the existing path, not completely replace it with just that information.
-craig

"You can never have too many knives" -- Logan Nine Fingers
anakumar
Participant
Posts: 8
Joined: Wed Oct 21, 2009 11:49 am

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

Post 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
Apanandha
rajngt
Participant
Posts: 32
Joined: Wed Jan 04, 2006 6:22 am

Post by rajngt »

Thanks anakumar and Chulett. Now the DataStage is working
Post Reply