WPs and CPs do not start: U00029120 UCUDB: Function LoadLibrary failed. Library 'ucuoci.so' error 'libclntsh.so.11.1: cannot open shared object file: No such file or directory'.

Document ID : KB000084495
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
U00029120 UCUDB: Function LoadLibrary failed. Library 'ucuoci.so' error 'libclntsh.so.11.1: cannot open shared object file: No such file or directory'.

Server processes WP and CP fail to start.
 
20171030/093841.305 - U00029120 UCUDB: Function LoadLibrary failed. Library 'ucuoci.so' error 'libclntsh.so.11.1: cannot open shared object file: No such file or directory'.
20171030/093841.305 - U00003611 DB OPEN executed. Return Code = '0000003531'
20171030/093841.398 - U00003620 Routine 'UCMAIN_R' forces trace because of error.
20171030/093841.398 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20171030/093841.479 - U00003449 Output to the TRACE file is finished.
20171030/093841.481 - U00003450 The TRACE file was opened with the switches '0000000000000000'.
20171030/093841.481 - U00003380 Server 'V121#WP' version '12.1.0+build.1336' (Runtime '0/00:00:00', Log# '1', Trc# '1').
20171030/093841.481 - U00003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.
20171030/093841.481 - U00003375 Server usage of the last minute '0%', the last 10 minutes '0%' and the last hour '0%'.
20171030/093841.482 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20171030/093841.483 - U00003410 Server 'V121#WP' version '12.1.0+build.1336' ended abnormally.

ldd on ucuoci.so shows:
 
ldd ucuoci.so
        linux-vdso.so.1 =>  (0x00007fff6c5fe000)
        libsysapi.so => ./libsysapi.so (0x00007f2d60f03000)
        libzu00132.so => ./libzu00132.so (0x00007f2d60cd1000)
        libuc001.so => ./libuc001.so (0x00007f2d60acc000)
        libclntsh.so.11.1 => not found
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f2d608b3000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f2d60697000)
        libstdc++.so.6 => ./libstdc++.so.6 (0x00007f2d604a7000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f2d601a4000)
        libgcc_s.so.1 => ./libgcc_s.so.1 (0x00007f2d60097000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f2d5fcd8000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f2d5facf000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f2d6131c000)
Environment:
OS: Linux
OS Version: N/A
Cause:
Cause type:
Configuration
Root Cause: This is caused by $ORACLE_HOME/lib missing in the LD_LIBRARY_PATH on Linux/Solaris/zLinux, LIBPATH on AIX or SHLIB_PATH on HP-UX.
Or caused by the automation engine's /bin directory missing in the LD_LIBRARY_PATH.
Resolution:
Once the LD_LIBRARY_PATH is set. i.e.: LD_LIBRARY_PATH=$ORACLE_HOME/lib:$AE_HOME:$LD_LIBRARY_PATH:$SAP_HOME;export LD_LIBRARY_PATH

Example file of how to set the environment:

ORACLE_HOME=/oracle/product/12.1.0/db_1;export ORACLE_HOME
SMGR_HOME=/opt/automic/v121u/ServiceManager/bin;export SMGR_HOME
AE_HOME=/opt/automic/v121u/AutomationEngine/bin;export AE_HOME
UTIL_HOME=/opt/automic/v121u/Utility/bin;export UTIL_HOME
SAP_HOME=/opt/automic/v121u/Agents/vwaf1lnx01_sap_ecc/bin;export SAP_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$AE_HOME:$LD_LIBRARY_PATH:$SAP_HOME;export LD_LIBRARY_PATH

This can be set in the .bash_profile of the user that starts the ServiceManager or the server processes.

ldd on ucuoci.so now shows:

 
ldd ucuoci.so
        linux-vdso.so.1 =>  (0x00007fffe28d0000)
        libsysapi.so => ./libsysapi.so (0x00007fda7180e000)
        libzu00132.so => ./libzu00132.so (0x00007fda715dc000)
        libuc001.so => ./libuc001.so (0x00007fda713d7000)
        libclntsh.so.11.1 => /oracle/product/12.1.0/db_1/lib/libclntsh.so.11.1 (0x00007fda6e418000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007fda6e1ff000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fda6dfe3000)
        libstdc++.so.6 => ./libstdc++.so.6 (0x00007fda6ddf3000)
        libm.so.6 => /lib64/libm.so.6 (0x00007fda6daf0000)
        libgcc_s.so.1 => ./libgcc_s.so.1 (0x00007fda6d9e3000)
        libc.so.6 => /lib64/libc.so.6 (0x00007fda6d624000)
        librt.so.1 => /lib64/librt.so.1 (0x00007fda6d41b000)
        libmql1.so => /oracle/product/12.1.0/db_1/lib/libmql1.so (0x00007fda6d1a5000)
        libipc1.so => /oracle/product/12.1.0/db_1/lib/libipc1.so (0x00007fda6ce26000)
        libnnz12.so => /oracle/product/12.1.0/db_1/lib/libnnz12.so (0x00007fda6c71c000)
        libons.so => /oracle/product/12.1.0/db_1/lib/libons.so (0x00007fda6c4d7000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fda6c2be000)
        /lib64/ld-linux-x86-64.so.2 (0x00007fda71c27000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007fda6c0bb000)
        libclntshcore.so.12.1 => /oracle/product/12.1.0/db_1/lib/libclntshcore.so.12.1 (0x00007fda6bb48000)

If you are using a different Oracle client version, you must create a SYM LINK  like ln -s libclntsh.so.xx.x libclntsh.so.11.1, where xx.x is your Oracle client version.

Alternatively, if the automation engine's bin directory is missing from the LD_LIBRARY_PATH, then a Unix admin needs to ensure the user's .profile has it included.

Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A