DSXchange

True. good point. If you have a version of Oracle that support both and see both a "lib" and a "lib32" directory out there, use the lib32 one unless you are one of the few peoples running a 64bit version of DataStage.

Aditional

I did a small job, that do a select from one table, using OCI stage, and put the result in a file.
When i try to executed the job, it return the error :
Test_01..Transformer_10: C Stage PlugIn function "Get" required

When i try to do a view, onr the oci stage, it return the message :
ds_loadlibrary: error in dlopen

Accept all sugestions to correct this problem

merci
Rai

Seems it is way past time to involve your official support provider. Getting nothing back when you echo $DSHOME or $LIBPATH after sourcing dsenv makes zero sense. You need professional help... so to speak.

We have a problem in the .profile, now after i type ". ./dsenv" i can see the values
$ echo $DSHOME
/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine
$
$ echo $LIBPATH
/opt/IBM/InfoSphere/Ascential/DataStage/branded_odbc/lib:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/lib:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/uvdlls:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/java/jre/bin/classic:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/java/jre/bin:


But i still unable to acess to Oracle.
Any sugestions ?

merci
Rai

What problem? And where are the Oracle libraries in your LIBPATH?

Ok,
I had put the $ORACLE_BASE, $ORACLE_HOME and the $TNS_ADMIN in the LIBPATH

-- bash-3.00$ echo $LIBPATH
/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/bin:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/branded_odbc/lib:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/lib:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/uvdlls:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/java/jre/bin/classic:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/java/jre/bin:/opt/oracle/dappora/10g:/opt/oracle/dappora/10g/10.2.0:/opt/oracle/dappora/10g/10.2.0/network/admin

Stop and start the uv, but I can still access to the Oracle.

When I try to the preview in the oracle stage, it return an error in the access to the ds_loadlibrary, where is defined this library?


merci
Rai

[sigh]

None of those belong in your LIBPATH. Remove them and replace them with either $ORACLE_HOME/lib32 (just that, no "base", no "tns", just that) if that exists on your system or $ORACLE_HOME/lib if the other doesn't exist.

Then restart DataStage again and let us know.

Hello,

Could you please also post the value of your variable $PATH ?

I remember getting the same error because the vac (C compiler) was not set in the PATH variable. (same error if the version is not the good one)

I hope this will help.


Sonny

You can use uvsh or dssh instead of uv to gain interactive access.

I'm not sure if it's important, but

Datastage as been installed with dsadm user, that bellong to dstage group.

The client user, ptbxxxx bellong also to dstage group.

In $DSHOME the permission is rwxr-xr--
So the ptbxxxx user dosen't have permission to write in $DSHOME


merci
Rai

Ah, the old "make sure your umask is 002 before installing" trick! There is a script within DataStage (I can't recall where) for resetting vital permissions; anything else you can use appropriate operating system commands.

Ray,
you said :
"there is a script within DataStage (I can't recall where) for resetting vital permissions"

What script is that ?could you send to me or indicated where i can get it ?

merci
Rai

There's a scripts directory under $DSHOME, check there - the name should be pretty obvious.

Tks chulett,

the script is $DSHOME/scripts/DSEsetperms.sh

But it requires that must been called by DSEnable_multiuse.sh
I can't find thsi scripts ? Where is it ?

merci
Rai

No idea, perhaps not something us mere mortals should be doing.

FWIW, here are the permissions I see in my DSEnging directory: