Enabling Java support

From: Can <no_at_spam.net>
Date: Mon, 12 Jul 2004 13:10:08 GMT
Message-ID: <Q4wIc.53054$Q74.51458@news.chello.at>

Hi all,

Which scripts do I have to run, in order to get procedures in the dbms_java package to work?

I ran $ORACLE_HOME/javavm/install/initjvm.sql and $ORACLE_HOME/javavm/install/catjvm.sql, set java_pool_size to 24 MB, and set following env. variables:

export JAVA_HOME="$ORACLE_HOME/jre/1.4.2" export PATH="$PATH:$JAVA_HOME/bin"
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$JAVA_HOME/lib" export CLASSPATH="$CLASSPATH:$JAVA_HOME/lib"

But as soon as I call an oracle script that relies on dbms_java.loadjava (e.g. $ORACLE_HOME/xdk/admin/initxml.sql), the script throws the error ORA-03113 (End of file on communication channel).

So I guess I forgot to run a script, or change some configuration? Can anyone help?

Thanks in advance,

Can Oezdemir Received on Mon Jul 12 2004 - 08:10:08 CDT