Oracle, uncaught Java exception: java.lang.UnsatisfiedLinkError
This is very common error in java environment. In most cases the problem will be in LD_LIBRARY_PATH variable which is not set properly. Lets show how we can perform diagnostics:
- Check trace for more info. The trace can be found in udump directory
- Check LD_LIBRARY_PATH set properly i.e. set to $ORACLE_HOME/lib
- Check how LD_LIBRARY_PATH variable set inside java
- Check that you library actually located in $OH/lib and has proper access rights
- Check that your lib bit szie compares to bit size of oracle db. If oracle db is 64 bit than lib must be 64 as well.
create or replace function get_java_property(p_property varchar2) return varchar2
as language java name ‘java.lang.System.getProperty(java.lang.String) return java.lang.String’;
select get_java_property(‘java.library.path’) from dual;
Advertisement