How to Un-install JVM Components from Database
(Doc ID 3000161.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Goal
The goal of this note is to provide an action plan for full removal of OJVM whereas the other existing notes(mentioned below) are intended for removal and re-installation of OJVM.
Safe repair/reinstall of the JVM Component in 11.2 and up (Doc ID 2314363.1)
Repairing/Reinstalling JVM To A Multitenant Database (CDB and all PDBs) (Doc ID 2262919.1)
The form of removal that is advised in the above mentioned notes are not same as full removal. In particular, "rmjvm.run(FALSE)" is used in these notes rather than rmjvm.sql which among other things runs "rmjvm.run(TRUE)". The former removes only classes.bin objects and does not remove all the infrastructure associated with OJVM such as various packages and tables. The intent is to preserve any non-Oracle java so that they will be present even after the removal of OJVM. One might expect that if there was no non-Oracle java, there should have been no remaining classes. Though the existing notes makes some attempt to remove the Oracle java objects that do not belong to classes.bin, this has never been fully effective. That's because not only they do not account for some other components such as SDO and Intermedia that have java classes and may be present in some releases and installations, they also do not consider non-classes.bin classes loaded by base OJVM itself during the execution of initjvm.sql.
NOTE: Though the instructions mentioned below are supposed to work with all the OJVMRU releases for RDBMS version 19c, they have been tested for the following OJVMRUs only.
19c
----
19.17.0.0.221018 OJVMRU
19.21.0.0.231017 OJVMRU
For releases other than 19c, minor variations might be required on top of what is mentioned below, the lack of which would cause errors but those are probably easy to fix. This note would be updated periodically with all the tested combinations. However, the expectation here is that these instructions should be checked in house/lower environment before using it at Customer site/ Production environment that has an OJVM PSU/RU not on the list mentioned above and the outcome should be updated to this note by adding a comment to it.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |