DSXchange

This issue happened for Information Server v8.1 on Red Hat Linux 4.

Code:
Sequential file -----------------------> Oracle_OCI


The job is very simple. But when Oracle OCI Stage was used as target,the job just abort with warning.

warning:Abnormal termination of stage test1..Oracle_OCI_0.IDENT1 detected

Abnormal termination of DataStage.
Fault type is 6. Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.Open at address 574.

os level:Linux version 2.6.18-53.el5 (brewbuilder@hs20-bc17.build.redhat.com) (gcc version 4.1.2 20070626 (Red Hat 4.1.2-14))

oracle client:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Thanks

Welcome aboard.

Usually the fastest way to get an answer is to Search DSXchange. In this case an exact search on "Fault occurred in BASIC program DSP.Open" might be a good start point.

You need to use the 32bit Oracle libraries in "lib32" with DataStage rather than the default 64bit ones. And by "use" I mean reference in your "shared library" environment variable in the dsenv file.