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.
+++++++++++++++++++
-----Original Message-----
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: 17 December 2001 15:13
To: Multiple recipients of list ORACLE-L
Subject: RE: Deinstalling JServer
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
Rem This script requires a significant amount of rollback
Rem to execute.
Rem
Rem MODIFIED (MM/DD/YY)
Rem rshaikh 01/12/99 - Created (for mjungerm)
Rem
Hopefully the list can point to one that fits your needs more precisely.
Regards
Mark
-----Original Message-----
[EMAIL PROTECTED]
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 [EMAIL PROTECTED]
Thanks,
Cherie
Oracle DBA
Gelco Information Network
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
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.
=========================================================
