Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle10g & Java
"Can" <no_at_spam.net> wrote in message
news:Yu6_c.196827$vG5.163320_at_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?
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=