IBM Support

DataStage job with Oracle EE stage fails with error, Could not load orchoracle

Troubleshooting


Problem

Message: main_program: Error loading "orchoracle": Could not load "orchoracle": /opt/oracle/product/10.2.0/db_1/lib32/libclntsh.so.10.1: undefined symbol: nnftboot.

Symptom

DataStage job with Oracle Enterprise stage fails with error:


Message: main_program: Error loading "orchoracle": Could not load "orchoracle": /opt/oracle/product/10.2.0/db_1/lib32/libclntsh.so.10.1: undefined symbol: nnftboot.

Cause

The 32bit client is not installed correctly due to the error /opt/oracle/product/10.2.0/db_1/lib32/libclntsh.so.10.1: undefined symbol: nnftboot error.

Diagnosing The Problem

Change directory (cd) into the Oracle client library directory, e.g. $ORACLE_HOME/lib32 or $ORACLE_HOME/lib, and execute:

ldd -r libclntsh.so

For example:
cd /opt/oracle/product/10.2.0/db_1/lib32
ldd -r libclntsh.so
linux-gate.so.1 => (0xffffe000)
libnnz10.so =>
/opt/app/oracle/oracle/product/10.2.0/db_1//lib32/libnnz10.so
(0xf7017000)
libdl.so.2 => /lib/libdl.so.2 (0xf7006000)
libm.so.6 => /lib/libm.so.6 (0xf6fde000)
libpthread.so.0 => /lib/libpthread.so.0 (0xf6fc7000)
libnsl.so.1 => /lib/libnsl.so.1 (0xf6fb0000)
libc.so.6 => /lib/libc.so.6 (0xf6e6c000)
/lib/ld-linux.so.2 (0x00b4c000)
undefined symbol: nnftboot (./libclntsh.so)
undefined symbol: nnfhboot (./libclntsh.so)
undefined symbol: nnflboot (./libclntsh.so)
undefined symbol: nttini (./libclntsh.so)
undefined symbol: ntusini (./libclntsh.so)
undefined symbol: ntpini (./libclntsh.so)
undefined symbol: ntzini (./libclntsh.so)
undefined symbol: nttsdpini (./libclntsh.so)
undefined symbol: nnflgapc (./libclntsh.so)
undefined symbol: nnflrne (./libclntsh.so)
undefined symbol: nnflfrm (./libclntsh.so)
undefined symbol: nnflgav (./libclntsh.so)

Resolving The Problem

Reinstall Oracle Client.

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"}],"Version":"8.1;8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21472671