SQL Jobs on Oracle DB fail with ocijdbc11 error
search cancel

SQL Jobs on Oracle DB fail with ocijdbc11 error

book

Article ID: 88227

calendar_today

Updated On:

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.