Spatial is INVALID In DBA_REGISTRY after applying patches
Issue :
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.
Solution :
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
