SQL Jobs on Oracle DB fail with ocijdbc11 error

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Any SQL Job fails with error message
 

java.lang.UnsatisfiedLinkError: ocijdbc11 (Not found in java.library.path)

in the agent log-file.

Environment

Affects only Unix-based operating systems (Linux, Solaris, AIX, ...) using Oracle Databases.

Cause

This is an configuration issue

Resolution

Add the path to Oracle client installation to the LD_LIBRARY_PATH variable. E.g. add the following line to the file ~/.bshrc or ~/.bach_profile:
 

LD_LIBRARY_PATH=/ora_app/product/11.2.0.2/client_1/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH

Please consult your Linux-Administrator if needed.