Re: oracle/aurora classes not loaded

Hi there and thanks for responding yet again to me.

With your lead on the Metalink note I also found some additional notes. And yes, there are scripts to be run that I was not manually running. (I was only running the additional sql from the 8172 patchset readme.)

Question though: I don't have catxsu.sql anywhere on my server??? Do you have a linux install where you could send me that file?

Many thanks.
--andrea

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<a7qfks$jl4$1_at_babylon.agtel.net>...
> 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
Received on Wed Mar 27 2002 - 06:45:16 CST