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

Last updated on FEBRUARY 08, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms