Re: oracle/aurora classes not loaded

FINAL: thanks to Vladamir for pointing me in the right direction. The following Oracle Metalink Note:175472.1 aptly titled 'How to Cleanup the JVM in 8.1.7' is a definitive fix for a broken JVM. Note however that Oracle calls this note a 'draft' and it's being moderated. At this point I think it's fairly clear that the readme instructions for the Linux 8172 patchset were what broke the JVM to begin with--referencing those instructions with the windows instructions pretty much showed the error in the procedure for re-loading the java system.

I still don't know why catxsu.sql and also the scripts called from it were totally missing from my Oracle dirs...

I'm going to post the reference to the Metalink note under separate subject for those specifically looking for the fix.

--andrea

andrea_at_andreajohnson.net (andrea) wrote in message news:<22bafb76.0203270445.43045ca6_at_posting.google.com>...
> 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 Apr 03 2002 - 10:54:55 CST