MDSYS Invalid Objects After Upgrade From 11.2.0.2 To 11.2.0.4 (Doc ID 1673812.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.
***** Checked for Relevance on 21-Oct-2015 *****

Symptoms

Spatial is VALID but some MDSYS owned objects are invalid:

From file db_upg_diag_WEBPROD_10_May_2014_1146.log:

======================================================
Count of Invalids by Schema
======================================================
...
MDSYS INDEXTYPE 2
MDSYS JAVA CLASS 1
MDSYS OPERATOR 25
MDSYS PACKAGE BODY 13
MDSYS TYPE BODY 1
...
...
CTXSYS INDEXTYPE 2
CTXSYS OPERATOR 3
CTXSYS PACKAGE 3
CTXSYS PACKAGE BODY 1
CTXSYS TYPE 1
CTXSYS TYPE BODY 1
...
...
SYS FUNCTION 1
SYS PACKAGE 16
SYS PACKAGE BODY 71
SYS PROCEDURE 3
SYS TYPE 13
SYS TYPE BODY 14
SYS VIEW 30
XDB OPERATOR 2
XDB PACKAGE BODY 1


================
Component Status
================

Comp ID Component Status Version Org_Version Prv_Version
------- ---------------------------------- --------- -------------- -------------- --------------
AMD OLAP Catalog VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
APEX Oracle Application Express VALID 3.2.1.00.12
APS OLAP Analytic Workspace INVALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
CATALOG Oracle Database Catalog Views VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
CATJAVA Oracle Database Java Packages VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
CATPROC Oracle Database Packages and Types VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
CONTEXT Oracle Text VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
EM Oracle Enterprise Manager VALID 11.2.0.4.0 11.2.0.2.0
EXF Oracle Expression Filter VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
JAVAVM JServer JAVA Virtual Machine VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
ORDIM Oracle Multimedia VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
OWB OWB VALID 11.2.0.2.0
OWM Oracle Workspace Manager VALID 11.2.0.4.0 11.2.0.2.0
RUL Oracle Rules Manager VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
SDO Spatial VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
XDB Oracle XML Database VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
XML Oracle XDK VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0
XOQ Oracle OLAP API VALID 11.2.0.4.0 11.2.0.2.0 11.2.0.2.0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms