My Oracle Support Banner

19c : INVALID SPATIAL in the registry due to INVALID JAVA Objects Owned By MDSYS (Doc ID 2658253.1)

Last updated on DECEMBER 31, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.5.0.0.0 to 19.6.0.0.0 [Release 19]
Information in this document applies to any platform.

Symptoms

A newly created 19.6 database shows invalid objects owned by MDSYS.

SQL> select owner, object_type, count(object_type) from dba_objects where status='INVALID' group by owner, object_type order by 1,2;

OWNER OBJECT_TYPE COUNT(OBJECT_TYPE)
------------------------------ ----------------------- ------------------
MDSYS JAVA CLASS 128
PUBLIC SYNONYM 128

 utlrp.sql was used to re-compile the objects but that did not work--the objects are still invalid.

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
References


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