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.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21472671