How to repair the java objects in the MDSYS (Oracle Spatial) and ORDSYS (Oracle Multimedia) after a FULL_REMOVAL of the JVM Component
(Doc ID 2549822.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Multimedia - Version 10.1.0.3 to 10.1.0.3 [Release 10.1]
Information in this document applies to any platform.
The goal of this note is to provide steps to restore missing Java objects that were unintentionally removed from MDSYS and ORDSYS schemas when doing a JVM removal or reinstall. Generally speaking, when performing a JVM removal using the standard removal procedure rmjvm.run(FALSE), only the objects in SYS should be removed. However, there are 3 methods (rmjvm.sql, rmjvm.run(TRUE), or using initjvm.sql to reinstall on a, existing bad JVM installation) that will do a FULL_REMOVAL and remove all java from the database, including the Java in the MDSYS or ORDSYS schemas, as well as, the Java objects in customer installed schemas. If these schemas were not backed up prior, then this note is provided in order to repair the ORDSYS and MDSYS schemas. It does not provide steps to reinstall other JVM dependent components or products such as OLAP or Oracle EBS (APPS).
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