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 NOVEMBER 15, 2018

Applies to:

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

Symptoms

This issue involves a Standard Edition (SE) Oracle database upgrade from 11.2.0.3 to 11.2.0.4 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

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

 

 

 

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


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.