RE: initjvm.sql

From: SUNILSHIVAPPA <SUNILSHIVAPPA_at_infy.com>
Date: Mon, 12 Nov 2001 04:49:52 -0800
Message-ID: <F001.003C22AF.20011112043021@fatcity.com>

<FONT face=Arial color=#0000ff

size=2>rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following.
<FONT face=Arial color=#0000ff

size=2> 

<SPAN

style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">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.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
<P class=MsoNormal

style="MARGIN-LEFT: 1in; TEXT-INDENT: -0.25in; mso-list: l0 level2 lfo9; tab-stops: list 1.0in"><SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">1.<SPAN 
style="FONT: 7pt 'Times New Roman'">     <SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">Restart 

the database.
<P class=MsoNormal

style="MARGIN-LEFT: 1in; TEXT-INDENT: -0.25in; mso-list: l0 level2 lfo9; tab-stops: list 1.0in"><SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">2.<SPAN 
style="FONT: 7pt 'Times New Roman'">     <SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">Start a 

different session other than the one that started the database.
<P class=MsoNormal

style="MARGIN-LEFT: 1in; TEXT-INDENT: -0.25in; mso-list: l0 level2 lfo9; tab-stops: list 1.0in"><SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">3.<SPAN 
style="FONT: 7pt 'Times New Roman'">     <SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">Run 

initjvmaux.sql
<P class=MsoNormal

style="MARGIN-LEFT: 1in; TEXT-INDENT: -0.25in; mso-list: l0 level2 lfo9; tab-stops: list 1.0in"><SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">4.<SPAN 
style="FONT: 7pt 'Times New Roman'">     <SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">Run 

rmjvm.sql
<P class=MsoNormal

style="MARGIN-LEFT: 1in; TEXT-INDENT: -0.25in; mso-list: l0 level2 lfo9; tab-stops: list 1.0in"><SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">5.<SPAN 
style="FONT: 7pt 'Times New Roman'">     <SPAN 
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">Run 

following SQL queries, LOG on as SYS.
<SPAN

style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">--The minimum action to remove JIS trigger is running the following sql.
<SPAN

style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">drop trigger JIS$ROLE_TRIGGER$;
<SPAN

style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">delete from ducs$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED';
<SPAN

style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">delete from aurora$startup$classes$ where
classname='oracle.aurora.mts.http.admin.RegisterService';
<SPAN

style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">delete from aurora$dyn$reg;
<SPAN

style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt"> 
<SPAN

style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt"><SPAN class=511502512-12112001>Regards,
<SPAN

style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt"><SPAN class=511502512-12112001>sunil s.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Saravana Kumar   [mailto:saravanakumar.kothandaraman_at_megasoft.com]Sent: Monday,   November 12, 2001 12:55 PMTo: Multiple recipients of list   ORACLE-LSubject: initjvm.sql
  Hi friends,
  <FONT face=Arial
  size=2>              
  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. Received on Mon Nov 12 2001 - 06:49:52 CST