oracle error

[chulett]

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?

[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.

[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.

[chulett]

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.

[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.

[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.