Invalid MDSYS Objects Types: SDO_GEO_ADDR and SDO_NETWORK_MANAGER_I after DB Upgrade (Doc ID 1294577.1)

Last updated on DECEMBER 24, 2013

Applies to:

Oracle Spatial and Graph - Version 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

After upgrading the database from 10.2.0.4.0 to 10.2.0.5.0, the STATUS of Spatial in DBA_REGISTRY is INVALID and there are 2 INVALID Types owned by MDSYS:

SQL> select owner, object_name, object_type, status
  from dba_objects
  where owner = 'MDSYS'
  and status != 'VALID'
  order by 2,3;

OWNER      OBJECT_NAME             OBJECT_TYPE      STATUS
---------- ----------------------- ---------------- -----------
MDSYS      SDO_GEO_ADDR            TYPE             INVALID
MDSYS      SDO_NETWORK_MANAGER_I   TYPE             INVALID

 

SQL> select comp_name, version, status
  from dba_registry
  order by 1;

COMP_NAME                           VERSION         STATUS
----------------------------------- --------------- ----------
JServer JAVA Virtual Machine        10.2.0.5.0      VALID
OLAP Analytic Workspace             10.2.0.5.0      VALID
OLAP Catalog                        10.2.0.5.0      VALID
Oracle Data Mining                  10.2.0.5.0      VALID
Oracle Database Catalog Views       10.2.0.5.0      VALID
Oracle Database Java Packages       10.2.0.5.0      VALID
Oracle Database Packages and Types  10.2.0.5.0      VALID
Oracle Expression Filter            10.2.0.5.0      VALID
Oracle OLAP API                     10.2.0.5.0      VALID
Oracle Rule Manager                 10.2.0.5.0      VALID
Oracle Text                         10.2.0.5.0      VALID
Oracle XDK                          10.2.0.5.0      VALID
Oracle XML Database                 10.2.0.5.0      VALID
Oracle interMedia                   10.2.0.5.0      VALID
Spatial                             10.2.0.5.0      INVALID

Changes

Upgraded database from 10.2.0.4 to 10.2.0.5.

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