Mark,
Here are a couple of notes I saved on the subject
John
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;
.
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 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;
-----Original Message-----
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2002 11:08
To: Multiple recipients of list ORACLE-L
Subject: RE: Woopeee and TWO ORA-600's!
Ahh well!
I have another question following this:
I am also getting the following error on startup:
Fri Feb 22 09:33:04 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC:
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
pool","unknown object","joxs heap init","ioc_allocate_pal")
Fri Feb 22 09:33:10 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
pool","unknown object","joxs heap init","ioc_allocate_pal")
ORA-06512: at "SYS.DBMS_JAVA", line 216
ORA-06512: at line 2
Completed: alter database open
This is because I set the java_pool to 0 in my init file (we don't use
anything java related against our databases). Does anybody know how to
disable or de-install java from the database? I've taken a look at the
jvmrm.sql in RDBMS/Admin:
-- Remove some portion of the Java related data dictionary objects
-- This script must be run as a subscript of a script which sets the
-- variable jvmrmaction.
-- Possible values are
-- FULL_REMOVAL: remove all java related objects
But can't find anything of a script that will call this? Anyone have any
ideas?
Cheers
Mark (Why do I bother?) Leith
-----Original Message-----
Sent: 22 February 2002 10:18
To: Multiple recipients of list ORACLE-L
Mark
The ora600 lookup tool on Metalink states that there is no description for
this code
John
-----Original Message-----
Sent: 22 February 2002 09:34
To: Multiple recipients of list ORACLE-L
Hi Ladies and Gents,
I installed 9.0.1 on to my Win2K machine yesterday, and whilst installing an
un-named monitoring tool against it this morning, the instance crashed with
a bunch of ORA-600's in the alert log. Below are the two that appeared,
though the first turned up about 10 times concurrently:
Fri Feb 22 09:22:28 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [],
[], []
Fri Feb 22 09:22:34 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC:
ORA-00600: internal error code, arguments: [150], [], [], [], [], [], [], []
Anyone ever seen these before? I'm not going to call support as this is only
a sandbox database, so please don't tell me to call them or log a tar.. I
have enough to do today already! :(
Any feedback on these is, however, much appreciated!
Thanks
Mark
===================================================
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===================================================
http://www.cool-tools.co.uk
Maximising throughput & performance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
=========================================================
This electronic message contains information from the mmO2 plc Group
which may be privileged or confidential. The information is intended to be
for the use of the individual(s) or entity named above. If you are not the
intended recipient be aware that any disclosure, copying, distribution or
use of the contents of this information is prohibited. If you have received
this electronic message in error, please notify us by telephone or email
(to the numbers or address above) immediately.
=========================================================
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
=========================================================
This electronic message contains information from the mmO2 plc Group
which may be privileged or confidential. The information is intended to be
for the use of the individual(s) or entity named above. If you are not the
intended recipient be aware that any disclosure, copying, distribution or
use of the contents of this information is prohibited. If you have received
this electronic message in error, please notify us by telephone or email
(to the numbers or address above) immediately.
=========================================================
