Zaaker's Oracle DBA Blog: Oracle : Spatial is INVALID In DBA

Saturday, December 30, 2017

Spatial is INVALID In DBA_REGISTRY after applying patches

COMP_ID COMP_NAME VERSION STATUS

-------------- ------------------------------------ ------------ --------

OWB OWB 11.2.0.4.0 VALID

APEX Oracle Application Express 3.2.1.00.12 VALID

EM Oracle Enterprise Manager 11.2.0.4.0 VALID

AMD OLAP Catalog 11.2.0.4.0 VALID

SDO Spatial 11.2.0.4.0 INVALID <--- Invalid

ORDIM Oracle Multimedia 11.2.0.4.0 VALID

XDB Oracle XML Database 11.2.0.4.0 VALID

CONTEXT Oracle Text 11.2.0.4.0 VALID

EXF Oracle Expression Filter 11.2.0.4.0 VALID

RUL Oracle Rules Manager 11.2.0.4.0 VALID

OWM Oracle Workspace Manager 11.2.0.4.0 VALID

CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID

CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID

JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID

XML Oracle XDK 11.2.0.4.0 VALID

CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID

APS OLAP Analytic Workspace 11.2.0.4.0 VALID

XOQ Oracle OLAP API 11.2.0.4.0 VALID

RAC Oracle Real Application Clusters 11.2.0.4.0 VALID

19 rows selected.

connect / as sysdba

alter session set current_schema="MDSYS";

@?/md/admin/sdogr.sql

@?/md/admin/prvtgr.plb

alter session set current_schema="SYS";

set serveroutput on

exec utl_recomp.recomp_serial('MDSYS');

exec sys.VALIDATE_SDO();

select comp_name, version, status from dba_registry where comp_id='SDO';

COMP_NAME VERSION STATUS

--------- ---------------------- ------------------

Spatial 11.2.0.4.0 VALID