My Oracle Support Banner

Spatial Invalid on Failed Datapatch Run Due to Invalid Semantic Objects (Doc ID 2949483.1)

Last updated on MAY 19, 2023

Applies to:

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

Symptoms

SDO is invalid prior to post-patch installation execution of datapatch which fails with below message .

ALM : SDO [INVALID]
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done

Patch 32876380 rollback: SUCCESS
  logfile: .....log (no errors)
Patch 33829175 apply: WITH ERRORS
  logfile: ....log (errors)
  -> Error at line 164941: script md/admin/catmdlocj.sql
  - 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
SDO Spatial INVALID 19.0.0.0.0 12.1.0.2.0 18.0.0.0.0

OWNER OBJECT_NAME OBJECT_TYPE
------------ ---------------------------------------- ----------------------------------------
MDSYS SDO_SEM_PERF PACKAGE BODY
MDSYS SDO_RDF_INTERNAL PACKAGE BODY

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.