My Oracle Support Banner

11.2.0.3 to 11.2.0.4 SE Oracle Locator upgrade fails on Linux X86-84 (Doc ID 1908389.1)

Last updated on MARCH 12, 2019

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Linux x86-64

Symptoms

On a Standard Edition (SE) Oracle database upgrade from 11.2.0.3 to 11.2.0.4 in which Oracle Locator is installed as part of Oracle Multimedia, an application using Locator that worked prior to the upgrade now fails:

Internal Exception: java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine
ORA-13209: internal error while reading SDO_INDEX_METADATA table
ORA-29400: data cartridge error
ORA-00904: "SDO_NUM_BLKS": invalid identifier
ORA-13236: internal error in R-tree processing: [Failed to execute query (13236) [mdimdLibCacheReadInt]]
ORA-00904: ORA-00904: "SDO_NUM_BLKS": invalid identifier : invalid identifier
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 482

This type of error may be generated when attempting to rebuild an index

ALTER INDEX FENCE_SPTL_IDX1 REBUILD
*
ERROR at line 1:
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-29400: data cartridge error
ORA-01403: no data found
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13209: internal error while reading SDO_INDEX_METADATA table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 313

Changes

 

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.