Daniel_Hausdorf_6982

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 Apr 28, 2017 by Harriet_Kim_1764
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/11.2.0.2/client_1/lib; export LD_LIBRARY_PATH


Outcomes