SQL Job Error Message: java.lang.UnsatisfiedLinkError: ocijdbc11 (Not found in java.library.path)

Discussion created by Daniel_Hausdorf_6982 on Dec 15, 2016
Latest reply on Jul 13, 2018 by Michael_Lowry
You're running an SQL Job which unfortunately fails. When checking the logfile you see the following :

20161019/132830.244 - U02012035 Start Agent query with RunID '******'.
20161019/132830.246 - U02012041 Query a table without waiting for a database. RunID: '******'
20161019/132830.248 - U02012046 RunID '******': Failed to create a database connection: 'java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path'
20161019/132830.250 - U02012037 Query with RunID '******' ended abnormally.

This means that the path in the Enviroment Variable (LD_LIBRARY_PATH) to the Oracle Client is missing or not set. 

Please add the following in .profile:

LD_LIBRARY_PATH=/ora_app/product/; export LD_LIBRARY_PATH