RE: initjvm.sql
Are you sure its hanging. Documents have said it can take up to an hour and its that statement that tends to take the longest. I have seen quite the variation in time depending on the system I am on. -Original Message-From: Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent: Sunday, November 11, 2001 11:25 PMTo: Multiple recipients of list ORACLE-LSubject: 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.
RE: initjvm.sql
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 PMTo: Multiple recipients of list ORACLE-LSubject: 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.
RE: initjvm.sql
Does your alert log have any errors? When perfoming this, I had to increase the java_pool to a larger number and make sure that the OS limits allowed the amount of resource I was allocating in the sga (e.g. unlimited across the board on ulimits in Unix). I have also found that following the migration guide for 8.1.7 worked much better than the "patch notes" approach. HTH -Ron- -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saravana KumarSent: Monday, November 12, 2001 1:25 AMTo: Multiple recipients of list ORACLE-LSubject: 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.