SQL Jobs on Oracle DB fail with ocijdbc11 error

Document ID : KB000088227
Last Modified Date : 22/05/2018
Show Technical Document Details
Issue:
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.