Oracle10g & Java

From: Can <no_at_spam.net>
Date: Fri, 03 Sep 2004 22:46:16 GMT
Message-ID: <Yu6_c.196827$vG5.163320@news.chello.at>

Following scenario:
I've executed @$ORACLE_HOME/javavm/install/rmjvm.sql to remove the java-specific elements from an Oracle installation. And then restarted the DB, and re-ran initjvm.sql, and catjvm.sql. It's a manual oracle installation. But Java is not working properly: I've loaded a java class file by executing "loadjava -user me/pass_at_theserver:1521:thesid -verbose -force -resolve -thin /home/oracle/java/Levenshtein.java"
When trying to access the java source through Oracle Enterprise Manager (by clicking on the name of the Java Source), I get a "java.sql.SQLException: Closed Connection"-error.
When trying to access the Java Class, I get a "java.sql.SQLException: OALL8 is in an inconsistent state."-error. This can't be normal...

What else do I have to do except running initjvm.sql and catjvm.sql (as user "sys") in order to get java to work under oracle?

environment:
Oracle 10g
Fedora Core 2
large pool size = 48M
java pool size = 52M

Thanks,
Can Oezdemir Received on Fri Sep 03 2004 - 17:46:16 CDT