My Oracle Support Banner

Rolling Spatial Patching From 19.17 To 19.20 Results in Spatial Queries returning ORA-03113 (Doc ID 2983299.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

After a rolling patch upgrade from 19.17 to 19.20, spatial queries can fail with internal errors.

Specifically, rolling back the Spatial Bundle Patch for 19.17, applying the 19.20 DBRU and then applying the Spatial Bundle Patch for 19.20.

In one case, a query using sdo_geom.sdo_intersection returns:

*

ERROR at line 1:

ORA-03113: end-of-file on communication channel

Process ID: 356817

Session ID: 1086 Serial number: 48972

but use of other spatial operators and functions could also lead to errors.

Changes

 Rolling upgrade from 19.17 to 19.20 after rolling back 19.17 Spatial Bundle Patch 35416994.

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