WCC 12.0.01 - Forecast command fails CAUAJM_E_18409 Unable to load Oracle client libraries <libclntsh.so>

book

Article ID: 223798

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

Running WCC 12.0.01 (installed on RHEL7) , using oracle 19c DB.

When we try to run the Forecast command  from WCC ECLI (forecast -J Job% -F "09/29/2021 08:45" -T "09/30/2021 10:00") , below error is observed.

CAUAJM_E_18409 Unable to load Oracle client libraries <libclntsh.so: cannot open shared object file: No such file or directory>

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Resolution

Web Server component didn't had the oracle client lib in his LD_LIBRARY_PATH statement.

Add in /etc/profile.CA at the end of the file following line (replace <hostname> with correct value and eventual location if default isn't been used) :

. /opt/CA/WorkloadAutomationAE/autouser.ACE/autosys.bash.<hostname>

Stopped/started the web server and checked with "strings /proc/<webserver_pid> environ | grep LD". It does have now the "/apps/oracle/product/client_64/19c/client/lib" included in LD_LIBRARY_PATH

Tested the "forecast" command thru ECLI and it works properly.