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@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

**** Post for FREE via your newsreader at post.usenet.com ****


"Can" <no@spam.net> wrote in message
news: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@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?

Hi

My initialization script, based on files generated with DBCA, contains the
following statements for JServer.

connect SYS/&&sysPassword as SYSDBA
set echo on
spool /u00/app/oracle/admin/A1010/create/log/JServer.log
@/u00/app/oracle/product/10.1.0/javavm/install/initjvm.sql;
@/u00/app/oracle/product/10.1.0/xdk/admin/initxml.sql;
@/u00/app/oracle/product/10.1.0/xdk/admin/xmlja.sql;
@/u00/app/oracle/product/10.1.0/rdbms/admin/catjava.sql;
@/u00/app/oracle/product/10.1.0/rdbms/admin/catexf.sql;
spool off


HTH
Chris



-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

>
> My initialization script, based on files generated with DBCA, contains the
> following statements for JServer.
>
> connect SYS/&&sysPassword as SYSDBA
> set echo on
> spool /u00/app/oracle/admin/A1010/create/log/JServer.log
> @/u00/app/oracle/product/10.1.0/javavm/install/initjvm.sql;
> @/u00/app/oracle/product/10.1.0/xdk/admin/initxml.sql;
> @/u00/app/oracle/product/10.1.0/xdk/admin/xmlja.sql;
> @/u00/app/oracle/product/10.1.0/rdbms/admin/catjava.sql;
> @/u00/app/oracle/product/10.1.0/rdbms/admin/catexf.sql;
> spool off


Thanks for posting. I was almost convinced it would work, but alas java is
still causing troubles.
I've executed every mentioned script, but still I can't access loaded java
sources...


Can Özdemir