dsenv is not pointing properly

rameshDHL · Post by **rameshDHL** » Wed Sep 09, 2009 4:10 am

Hi ,

We have installed Information Server 8.1.I have configured the dsenv properly for ORACLE settings.

But when I run the job ,the job is not the taking the ORACLE SETTINGS which i have entered in the dsenv file .Rest of the entries it takes .
Due to this i am getting error "unable to intialize plugin"

I have searched all the postings and iam sure the oracle entries are right,only thing the entered values are not reflecting when i run the job .

OS is Solaris 10

Pleas help me

ArndW · Post by **ArndW** » Wed Sep 09, 2009 5:08 am

Have you restarted DataStage since making those changes? They won't take effect until you do so.

chulett · Post by **chulett** » Wed Sep 09, 2009 5:15 am

If you still need help after that, post your dsenv.

rameshDHL · Post by **rameshDHL** » Wed Sep 09, 2009 5:25 am

Thanks for your replies .

ORACLE_HOME=/oracle/app/oracle/product/10204S64DB1_PAR;export ORACLE_HOME

PATH=$ORACLE_HOME/bin:$PATH;export PATH
LD_LIBRARY_PATH=$ASBHOME/apps/jre/lib/sparcv9/server:$ASBHOME/apps/jre/lib/sparcv9:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/sunos-all-sparc_64:`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:`dirname $DSHOME`/PXEngine/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

FYI we have installed Information server in another server with the same dsenv setting but works fine

Only other server its giving a problem.I have restarted the server many times
I developed a oracle job even though it gives me an error ,but afer the job got aborted i checked the environmental setting in the job log.The oracle settings is not refelected

chulett · Post by **chulett** » Wed Sep 09, 2009 5:29 am

Make sure that LD_LIBRARY_PATH= line is one continuous line, sometimes copy/paste will insert hard returns. One way you can check is with :set list in vi and see where the $ EOL markers are.

rameshDHL · Post by **rameshDHL** » Wed Sep 09, 2009 5:47 am

Hi ,

$
^IORACLE_HOME=/oracle/app/oracle/product/10204S64DB1_PAR;export ORACLE_HOME$
$
PATH=$ORACLE_HOME/bin:$PATH;export PATH$
^I$
^I#LANG="<langdef>";export LANG$
^I#LC_ALL="<langdef>";export LC_ALL$
^I#LC_CTYPE="<langdef>";export LC_CTYPE$
^I#LC_COLLATE="<langdef>";export LC_COLLATE$
^I#LC_MONETARY="<langdef>";export LC_MONETARY$
^I#LC_NUMERIC="<langdef>";export LC_NUMERIC$
^I#LC_TIME="<langdef>";export LC_TIME$
^I#LC_MESSAGES="<langdef>"; export LC_MESSAGES$
^I$
^ILD_LIBRARY_PATH=$ASBHOME/apps/jre/lib/sparcv9/server:$ASBHOME/apps/jre/lib/sparcv9:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp
/sunos-all-sparc_64:`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:
$DSHOME/lib:$DSHOME/uvdlls:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:`dirname $DSHOME`/PXEngine/lib:$LD_LIBRARY_PATH$
^Iexport LD_LIBRARY_PATH$
$
$
:set list

Thats the output i got

chulett · Post by **chulett** » Wed Sep 09, 2009 5:59 am

OK, that looks fine, return-wise. Can you post the LD_LIBRARY_PATH value from the log entry that lists them all? Just that one line, not the whole darn thing.

rameshDHL · Post by **rameshDHL** » Wed Sep 09, 2009 6:02 am

LD_LIBRARY_PATH=/local/apps/DRS_dstage/prod/infosphere81/Project/RT_BP7.O:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/Server/DSComponents/lib:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/Server/DSComponents/bin:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/Server/DSParallel:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/Server/PXEngine/user_lib:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/Server/PXEngine/lib:/local/apps/DRS_dstage/prod/infosphere81/Project/buildop:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/Server/DSEngine/uvdlls:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/Server/DSEngine/lib:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/ASBNode/lib/cpp:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/ASBNode/apps/jre/lib/sparcv9:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/ASBNode/apps/jre/lib/sparcv9/server:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/ASBNode/apps/proxy/cpp/sunos-all-sparc_64:/local/apps/DRS_dstage/prod/infosphere81/IBM/InformationServer/ASBNode/apps/proxy/cpp/sunos-all-sparc:/usr/lib:/usr/css/lib:/lib

chulett · Post by **chulett** » Wed Sep 09, 2009 6:16 am

You are missing much more than simply the ORACLE_HOME and what little is there is in a different order. Seems like something else is overriding that LD_LIBARY_PATH setting.

rameshDHL · Post by **rameshDHL** » Wed Sep 09, 2009 6:27 am

Can you please help me gurus?

I am confused

chulett · Post by **chulett** » Wed Sep 09, 2009 6:37 am

What, now you're not being helped?

Check the running user's .profile and see if that is the culprit.

rameshDHL · Post by **rameshDHL** » Wed Sep 09, 2009 7:14 am

Hi Gurus ,

you are helping me lot ,there is no doubt in that .
Thanks for helping me

In other where datastage works fine i could see the below in job logs

Environment variable settings:

_=./uv
APT_COMPILEOPT=-dalign -O -PIC -library=iostream -c -xarch=v9
APT_COMPILER=/opt/SUNWspro/bin/CC

but thats not shown in the job of the failing datastage server

any idea of the symbol _=./uv

ray.wurlod · Post by **ray.wurlod** » Wed Sep 09, 2009 8:44 pm

$_ is a standard shell variable - the command you are executing at the command prompt.

It's in a family with others such as $$ (current process ID) and $? (exit status of prior command).

Read the man page on sh or any reasonably UNIX beginner's book.

chulett · Post by **chulett** » Wed Sep 09, 2009 8:49 pm

But that really isn't involved with your problem. Still seems to me you need to find where your 'shared library' path environment variable is getting reset.