The Utility DB Load on Linux fails

Document ID : KB000096534
Last Modified Date : 12/06/2018
Show Technical Document Details
Introduction:
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). 


 
Background:
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.
Instructions:
Please Make sure that the LD_LIBRARY_PATH is defined correctly as explained in the following KB.

https://comm.support.ca.com/kb/Error-while-running-utility-U0029120-UCUDB-Function-LoadLibrary-failed-KB0532567/KB000090231


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.