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:

  1. Check trace for more info. The trace can be found in udump directory
  2. Check LD_LIBRARY_PATH set properly i.e. set to $ORACLE_HOME/lib
  3. Check how LD_LIBRARY_PATH variable set inside java
  4. 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;

  5. Check that you library actually located in $OH/lib and has proper access rights
  6. 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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s