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.
Feedback
thumb_up
Yes
thumb_down
No