Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.7 JVM install

Re: Oracle 8.1.7 JVM install

From: Van Messner <vmessner_at_bestweb.net>
Date: Thu, 6 Nov 2003 18:24:21 -0500
Message-ID: <vqlm7iq8n27ua0@corp.supernews.com>


These are the steps I follow to add Java to 8i (You didn't mention a version).

Script 18 xxx_setup2a.sql - Call Oracle scripts for Java pieces  This script, script 18, calls a number of Oracle-supplied scripts to set up the Java objects Oracle needs when users want to use Oracle's Java capabilities
Run this in svrmgrl
connect internal
-- set the default tablespace for system back to normal
alter user system default tablespace SYSTEM;
-- Load the initial set of Java classes necessary to support Java, the SQLJ
compiler, JDBC runtime,
-- CORBA, ORB, EJB, the package DBMS_Java and load classes in the SYS
schema. Make
-- synonyms for the classes and define database startup and shutdown
triggers.
-- This step can take 30 minutes.

"AK" <ak_at_ak.org> wrote in message
news:QBzqb.679$_z4.50336_at_news.optus.net.au...

> Hi,
>
> I've recently had to take over responsibility for a number of Oracle
> databases, and armed with a week of training from a certain member of
> this list :) I'm embarking on solving my first little problematic issue...
>
> I need to set up the local JVM in Oracle.  Currently, the databases I
> manage have a 'half baked' installation, done by my predecessor (who was
> way overworked and probably just didnt have time to fix it).  To start
> with a clean slate, I ran rmjvm.sql as the sys user (connect sys) from
> svrmgrl.  This was after reading articles 105472.1 on Metalink and also
> reading through some of Tom Kyte's website.  The rmjvm.sql script seems
> to have done its thing, in removing all java objects, so I ran the
> initjvm.sql script.  This init script threw the following error:
>
> ORA-29541: class SYS.oracle/aurora/rdbms/security/PolicyTableManager
> could not be resolved
>
> So, if the script cannot find a class, does this mean that the CLASSPATH
>   environment variable is not set up right?  I'm unsure how to work what
> this CLASSPATH ought to be.
>
> All docs I have read simply say to run initjvm.sql and then go home.  I
> did that, and it didnt work... so I logged a TAR on Metalink and went to
> the pub.  Its been a while since then, and I haven't heard back from a
> Metalink analyst.
>
> Some help would be greatly appreciated.
>
> -Abhinav
>
Received on Thu Nov 06 2003 - 17:24:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US