Re: oracle/aurora classes not loaded

set _SYSTEM_TRIG_ENABLED=FALSE in init.ora and bounce the instance before reloading the Java classes or recreating the Java System (with create or replace java system) or running *any* catalog scripts in SYS - see MetaLink note 149948.1 for more details on this. Be sure to reset it back to TRUE or comment it out and bounce the instance again to put it in normal mode. I would recommend performing these steps to be sure Java is correctly installed:

1. _system_trig_enabled = false followed by bounce
2. connect / as sysdba
3. create or replace java system /
4. @?/oracore/admin/initxml.sql
5. @?/rdbms/admin/catxsu.sql
6. @?/javavm/install/load_jis.sql
7. @?/javavm/install/jisja.sql with optional (if you intend to use internal JSP facility)
8. @?/javavm/install/initjsp.sql
9. @?/javavm/install/jsp_ja.sql

then re-enable the system triggers and bounce the instance again. This should put the Java system in operational state.

hth.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"andrea" <andrea_at_andreajohnson.net> wrote in message
news:22bafb76.0203251141.5e8c757a_at_posting.google.com...


> 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