My Oracle Support Banner

Oracle Spatial Invalid / Invalid Objects in MDSYS Schema (Doc ID 1417738.1)

Last updated on JANUARY 15, 2020

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

When upgrading or reinstalling the java classes for Spatial are failing to load because they depend on java clases from Multimedia. The Multimedia java classes are failing to load with this error:

BEGIN dbms_java.loadjava('-r -g PUBLIC -synonym -schema ORDSYS ord/jlib/ordimdcm.jar'); END;

*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
oracle.aurora.server.tools.loadjava.ToolsError:
Error during loadjava: Failures occurred during processing.
Check trace file for details
ORA-06512: at "SYS.DBMS_JAVA", line 655
ORA-06512: at line 1


The trace file shows the following:

*** 2012-02-15 15:29:55.800
joez_load_machine_code: defer loading of java/math/BigDecimal.setScale; hotload circularity
joez_load_machine_code: defer loading of java/math/BigDecimal.<clinit>; hotload circularity

*** 2012-02-15 15:29:56.465
errors : class ORDSYS.oracle/ord/dicom/attr/DicomAttrAction
ORA-29534: referenced object ORDSYS.oracle/ord/dicom/attr/DicomAttrValue could not be resolved

 

Cause

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
Symptoms
Cause
Solution


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