| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Deinstalling JServer
Cherie - see the post below from sunilshivappa - 12/11/01 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;
Regards,
sunil s.
+++++++++++++++++++
Cherie,
I'm not entirely sure, as I've never done this before - but there is a package in ORACLE_HOME/RDBMS/ADMIN called utljavarm.sql, which seems to do the kind of thing you want. Maybe there is another that fits your needs better, as this one has a warning note about only using it to upgrade/downgrade to 8.1.5..
Rem
Rem $Header: utljavarm.sql 12-jan-99.17:10:39 rshaikh Exp $
Rem
Rem utljavarm.sql
Rem
Rem Copyright (c) Oracle Corporation 1999. All Rights Reserved.
Rem
Rem NAME
Rem utljavarm.sql - Remove all java objects
Rem
Rem DESCRIPTION
Rem This removes all the java objects from the data dictionary.
Rem
Rem NOTES Rem WARNING: This script is highly destructive. It should Rem only be run if you upgrading to or downgrading Rem from 8.1.5. Once this script is run all of your Rem java objects will be gone unless you have a backup!!!Rem
Hopefully the list can point to one that fits your needs more precisely.
Regards
Mark
-----Original Message-----
Cherie_Machler_at_gelco.com
Sent: 17 December 2001 14:20
To: Multiple recipients of list ORACLE-L
Does anyone know how to deinstall JServer? I accidentally installed it
and I don't
see anywhere in the documentation where it talks about how to remove the
objects
from the database. This is for Sun Solaris 2.6 Oracle version 8.1.7.2.
Please reply directly to Cherie_Machler_at_gelco.com
Thanks,
Cherie
Oracle DBA
Gelco Information Network
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Cherie_Machler_at_gelco.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Dec 17 2001 - 11:10:41 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: mark_at_cool-tools.co.uk 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: ListGuru_at_fatcity.com (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.
=========================================================
 |
 |