Page 2 of 2
Posted: Wed Feb 07, 2007 11:23 pm
by chulett
fk4u wrote:I can connect to database from dsadm user which is owner of datastage installation.
So... it
works when you use
dsadm but not under another userid?
Posted: Wed Feb 07, 2007 11:29 pm
by fk4u
I said Oracle client runs fine on datastage server from any account. This shows that we dont have problem with oracle environmental variables.
Problem is only with Plug-ins in Dstage.
Posted: Thu Feb 08, 2007 1:48 am
by fk4u
Now I have tried all the possibilities like using LD_LIBRARY_PATH and SHLIB_PATH and LIBPATH and LIBRARY_PATH i faced error on all except LD_LIBRARY_PATH.
So only LD_LIBRARY_PATH is the correct one and i have deleted all other paramters like SHLIB_PATH.
So now we have to concentrate on some other posibilities also.
Posted: Thu Feb 08, 2007 8:13 am
by chulett
fk4u wrote:I said Oracle client runs fine on datastage server from any account. This shows that we dont have problem with oracle environmental variables.
Problem is only with Plug-ins in Dstage.
Then what you have in your dsenv is incorrect. Post the latest version. Since all you need is $ORACLE_HOME and $LD_LIBRARY_PATH to get this to work, the settings for one or both must be triple-checked.
Posted: Fri Feb 09, 2007 2:20 am
by fk4u
Hi Chulett
I have solved the problem now.
I have changed three two things.
1. Changed the dsenv file like this
--------------------------------------------------------
#!/bin/sh
# PLATFORM SPECIFIC SECTION
ORACLE_HOME=/u01/app/oracle/product/10gR2/db_1
export ORACLE_HOME
DSHOME=/home/dsadm/Ascential/DataStage/DSEngine
export DSHOME
LD_LIBRARY_PATH=$DSHOME/lib:$DSHOME/uvdlls:$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
-------------------------------------------------------------------
2. I assigned the Dstage users the same group as oracle users were assigned. i.e i assigned oinstall osgroup to dstage users.
Thanks a lot for the support you provided me.
Posted: Fri Feb 09, 2007 8:05 am
by chulett
Glad you were able to work this out. It can be hard to do this 'remotely', about all we can do is nudge you in the right direction.
I'd ask you to mark this as 'Resolved' but... it's not your thread.