OCI Problem with IIS v8.1 on Redhat Linux 4 64bit

chenany · Post by **chenany** » Thu May 14, 2009 8:21 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu May 14, 2009 9:33 pm

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.

chulett · Post by **chulett** » Thu May 14, 2009 10:29 pm

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.