When running the utility DB Load on the UNIX/Linux server, it will fail with the following error message in the DB load log:
20180513/154121.311 - U00029120 UCUDB: Function LoadLibrary failed. Library 'ucuoci.so' error 'libclntsh.so.11.1: cannot open shared object file: No such file or directory'.
20180513/154121.311 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
The library libclntsh.so.11.1 is an Oracle application library and it is typically located in /usr/lib directory. This library is used to when connecting to the target Oracle database.
Please Make sure that the LD_LIBRARY_PATH is defined correctly as explained in the following KB.
If the issue persists, please do the following:
-Execute the command below and make sure the library is present.
ls -l /usr/lib/libclntsh.so.11.1
Now, it is also possible that even if the library is present, it has a softlink as shown below:
libclntsh.so.11.1 -> /home/oracle/product/12.1.0/client/lib/libclntsh.so
Please make sure that the path and file /home/oracle/product/12.1.0/client/lib/libclntsh.so . You can verify it by using the command below:
ls -l /home/oracle/product/12.1.0/client/lib/libclntsh.so
If the returns "No such file or directory", then you need to check with the System Administrator to make sure that the path or the file exists.