My Oracle Support Banner to SE Oracle Locator upgrade fails on Linux X86-84 (Doc ID 1908389.1)

Last updated on NOVEMBER 15, 2018

Applies to:

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


This issue involves a Standard Edition (SE) Oracle database upgrade from to in which Oracle Locator ( Multimedia ) is installed but Oracle Spatial is not.

A typical scenario would be where, in the environment above, a Spatial application worked fine prior to the upgrade and fails after the upgrade.

Application errors may be similar to this:

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

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





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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.