My Oracle Support Banner

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 NOVEMBER 11, 2019

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.

Goal

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).

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.