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
