Troubleshooting
Problem
When using the IBM Transformation Extender database adapter for Oracle Client, the following error may occur when Oracle 12c (12.1) or higher is installed:
Error: could not load library libclntsh.so.11.1: cannot open shared object file: No such file or directory.
Error: could not load library libclntsh.so.11.1: cannot open shared object file: No such file or directory.
Cause
The IBM Transformation Extender V9.0 and V10.0 Oracle adapter (libm4ora.so) references the Oracle 11g library name (libclntsh.so.11.1). The library name being called is static.
Resolving The Problem
ITX Oracle libm4ora.so adapter will work with newer Oracle client versions. See Detailed System Requirements for Transformation Extender for a complete listing.
A symbolic link can be created to reference the newer Oracle client library.
For example, the ITX Oracle adapter has a dependency for the libclntsh.so.11.1 library, but in the Oracle 12.1 client the library name is libclntsh.so.12.1. The solution is to create a link with the 11.1 name that points to the 12.1 library.
First change directory to the Oracle client directory containing the library to be linked (example libclntsh.so.12.1 for Oracle 12c).
Then use the following command to create the symbolic link:
ln -s libclntsh.so.12.1 libclntsh.so.11.1
As another example, if using libclntsh.so.18.1 for Oracle 18c, then instead use the following command to create the symbolic link:
ln -s libclntsh.so.18.1 libclntsh.so.11.1
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"ARM Category":[{"code":"a8m0z000000bmXsAAI","label":"Adapters->Oracle"}],"ARM Case Number":"TS003675589","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"}],"Version":"10.0.0;9.0.0","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
08 May 2020
UID
ibm16207932