oracle/aurora classes not loaded

From: andrea <andrea_at_andreajohnson.net>
Date: 25 Mar 2002 11:41:22 -0800
Message-ID: <22bafb76.0203251141.5e8c757a@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 Received on Mon Mar 25 2002 - 13:41:22 CST