Leave a Comment:
3 comments
Can we use ODI – Oracle Data Integrator
in Oracle Apps for migrations of one module from one instance to other.
Regards
Sanjeev
Hi Atul,
We are getting the following error while creating the entities in Oracle Data Profiling & Quality:
Authentication failed. couldn’t load file “/opt/oracle/odi/oracled
q/metabase_server/metabase/lib/pkgOracleAdapter/pkgOracleAdap
ter.so”: ld.so.1: server.bin: fatal: /opt/oracle/11.2.0/client/lib/libc
lntsh.so.10.1: wrong ELF class: ELFCLASS64
Also we already added the required entries in .TSDiscovery file.
$ cat .TSDiscovery
ORACLE_HOME=/opt/oracle/11.2.0/client
export ORACLE_HOME
LD_LIBRARY_PATH=/opt/oracle/odi/oracledq/quality_server/tsq11r5s/S
oftware/bin:/opt/oracle/11.2.0/client/lib:/opt/oracle/odi/oracledq/m
etabase_server/metabase/lib
export LD_LIBRARY_PATH
TS_QUALITY=/opt/oracle/odi/oracledq/quality_server/tsq11r5s/Software
export TS_QUALITY
Here is the ldd
$ ldd pkgOracleAdapter.so
libclntsh.so.10.1 => /opt/oracle/11.2.0/client/lib/lib
clntsh.so#.10.1 – wrong ELF class: ELFCLASS64
libdb-3.3.so => /opt/oracle/odi/oracledq/metabase
_server/metabase/lib/libdb-3.3.so
libicuuc.so.36 => /opt/oracle/odi/oracledq/metabase_
server/metabase/lib/libicuuc.so.36
libicui18n.so.36 => /opt/oracle/odi/oracledq/metabase_server/metabase/lib/libicui18n.so.36
libintl.so.3 => /opt/oracle/odi/oracledq/metabase_server/metabase/lib/libintl.so.3
libpthread.so.1 => /usr/lib/libpthread.so.1
libCrun.so.1 => /usr/lib/libCrun.so.1
libc.so.1 => /lib/libc.so.1
libicudata.so.36 => /opt/oracle/odi/oracledq/metabase_server
/metabase/lib/libicudata.so.36
libm.so.1 => /usr/lib/libm.so.1
libm.so.2 => /lib/libm.so.2
/platform/SUNW,SPARC-Enterprise/lib/libc_psr.so.1
Thanks,
Prakash.
@ Prakash,
wrong ELF class: ELFCLASS64 means wrong bit (32 or 64) for library file.
libclntsh.so.10.1 => /opt/oracle/11.2.0/client/lib/libclntsh.so.10.1 – wrong ELF class: ELFCLASS64
Change /opt/oracle/11.2.0/client/lib/libclntsh.so.10 to /opt/oracle/11.2.0/client/lib32/libclntsh.so.10
i.e. LD_LIBRARY_PATH
and see is that fixes issue
Reply