So... it works when you use dsadm but not under another userid?fk4u wrote:I can connect to database from dsadm user which is owner of datastage installation.
oracle error
Moderators: chulett, rschirm, roy
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.
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.
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.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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
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.