The Utility DB Load on Linux fails

Products

• CA Automic Workload Automation - Automation Engine

Issue/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). 

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.

Environment

Release:
Component: AAUTEN

Resolution

Please make sure that the environment variables are defined correctly as explained in the documentation-

https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Installation_Manual/AE/InstalltheUtilities_UNIX.htm?Highlight=LD_LIBRARY_PATH
https://docs.automic.com/documentation/WEBHELP/English/all/components/DOCU/21.0/Automic%20Automation%20Guides/Content/Installation_Manual/AE/InstalltheUtilities_UNIX.htm 

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


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.