oraenv and LD_LIBRARY_PATH

Environment: UNIX

After using oraenv to set the Oracle environment variables, you get the following error when creating a database by running scripts:

create or replace java system

begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then

*

ERROR at line 1:

ORA-29516: Aurora assertion failure: Assertion failure at eox.c:317

Uncaught exception Root of all Java exceptions: java.lang.UnsatisfiedLinkError

oracle.aurora.rdbms.Schema.lookupNumber

ORA-06512: at "SYS.INITJVMAUX", line 23

ORA-06512: at line 5

A probable reason is that you hit a bug in oraenv: oraenv sets ORACLE_HOME and ORACLE_SID, but does not set the LD_LIBRARY_PATH.

The solution is to add the following to oraenv file before “Put new ORACLE_HOME in path ...”:

case "$LD_LIBRARY_PATH" in

*$OLDHOME/lib*) LD_LIBRARY_PATH=`echo $LD_LIBRARY_PATH | \

sed "s;$OLDHOME/lib;$ORACLE_HOME/lib;g"` ;;

*$ORACLE_HOME/lib*) ;;

"") LD_LIBRARY_PATH=$ORACLE_HOME/lib ;;

*) LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH ;;

esac

export LD_LIBRARY_PATH

More Oracle DBA tips, please visit Oracle DBA Tips