Re: oracle/aurora classes not loaded

Andrea;

As SYS user, do you get any errors from DESCRIBE DBMS_JAVA ??? If no errors, did you follow the java install procedure to the letter ??? It is rather time consuming....about 14 steps I believe... If you have, are there any invalid java classes ??? If not, you need to execute rmjvm.sql & re-install.. If there are, you need to resolve them.. In case you are not familiar w/ the syntax..

alter java class dbms_java.longname('object_name') resolve;

object_name ,of course, refers to sys.dba_objects

If nothing helps, you can blame Oracle... I had similary intractable problem with JVM on 64-bit 8.1.7.3 on HP-UX a while back
and it turned out that Oracle finally admitted this was a bug with no patch yet ..:-( ..

HTH

--
Zongk Tu

Oracle Apps DBA/Unix SA

andrea wrote:



> 8i   8.1.7 (patchset 8172)

> RedHat linux 7.1

>

> I've been fighting with this one for days...

>

> SELECT Count(1)

> FROM dba_objects

> WHERE object_type Like '%JAVA%';

>

>   COUNT(1)

> ----------

>       7086

>

> classes suspiciously lacking are:

>

> /oracle/aurora/mts   namespace   and deploy  classes (I don't know

> what else might be missing)

>

> Pool sizes are:

> shared_pool_size = 136314880  (130M)

> java_pool_size = 90177520  (85M)

> large_pool_size = 52428800  (50M)

>

> Using TOAD as an admin tool, user SYS has _nothing_ under the tree

> from 'Java Sources', but does have 'Java Classes' and 'Java

> Properties'

>

> JDK version on the linux box is 1.2.2 in /usr/local/java

>

> running load_jis.sql results in errors relating to the

> /oracle/aurora/mts classes

>

> profile environmental variables are:

>

> ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE;

> ORACLE_HOME=$ORACLE_BASE/product/8.1.7; export ORACLE_HOME;

> ORACLE_SID=fdev; export ORACLE_SID;

> LD_ASSUME_KERNEL=2.2.5; export LD_ASSUME_KERNEL;

> GCC_EXEC_PREFIX=/usr/i386-glibc21-linux/lib/gcc-lib; export

> GCC_EXEC_PREFIX;

> JAVA_HOME=/usr/local/java; export JAVA_HOME;

> CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip:

>    $ORACLE_HOME/JRE:$ORACLE_HOME/jlib:

>    $ORACLE_HOME/rdbms/jlib:

>    $ORACLE_HOME/network/jlib; export CLASSPATH;

> LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:

>    /usr/lib:/usr/local/lib; export LD_LIBRARY_PATH;

> PATH=$ORACLE_HOME/bin:/usr/bin:/bin:/usr/local/bin:/usr/local/java/bin:

>     /usr/X11R6/bin:/sbin:/usr/sbin; export PATH;

>

> I believe the absense of classes is causing the application to fail.

>

> Can anybody help here?  What more can I report here for somebody to

> figure this issue out for me?

>

> (this is an updated re-write from a thread I had under somebody elses

> original thread)

>

> -andrea


--
Zongk Tu

Oracle Apps DBA/Unix SA