RE: initjvm.sql

[SUNILSHIVAPPA]

rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following.   If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql has to be run. Unfortunately it does not remove all the components. Following workaround has to be used to get over the bugs. 1.     Restart the database. 2.     Start a different session other than the one that started the database. 3.     Run initjvmaux.sql 4.     Run rmjvm.sql 5.     Run following SQL queries, LOG on as SYS. --The minimum action to remove JIS trigger is running the following sql. drop trigger JIS$ROLE_TRIGGER$; delete from ducs$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED'; delete from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService'; delete from aurora$dyn$reg;   Regards, sunil s. -----Original Message----- From: Saravana Kumar [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 12:55 PM To: Multiple recipients of list ORACLE-L Subject: initjvm.sql Hi friends,                I have problem during execution of initjvm.sql   The step's which i have followed.   1)Increased system tablespace 200 mb 2)increased the shared pool size 50mb 3)increased the java  pool size to 50mb 4)ran rmjvm.sql 5)initjvm.sql   While runnig initjvm.sql the script hangs while i get the statement create or replace java system;   What could be the reason.   Please reply as soon as possible Thanks in advance   Saravana.