Unable to initialize plug-in

[chulett]

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.

[RAI ROUSES]

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

[chulett]

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.

[RAI ROUSES]

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

[chulett]

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

[RAI ROUSES]

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

[chulett]

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

[sonnycapra]

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

[ray.wurlod]

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

[RAI ROUSES]

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

[ray.wurlod]

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.

[RAI ROUSES]

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

[chulett]

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

[RAI ROUSES]

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

[chulett]

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

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

Code: Select all

-rw-rw----   1 dsadm       dstage     <all files>
drwxrws---   2 dsadm       dstage     <all folders>