DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Thursday, April 5, 2018

Oracle : Spatial is INVALID In DBA_REGISTRY after applying patches

Oracle : Spatial is INVALID In DBA_REGISTRY after applying patches
Spatial is INVALID In DBA_REGISTRY after applying patches

Issue :
COMP_ID        COMP_NAME                            VERSION      STATUS
-------------- ------------------------------------ ------------ --------
AMD            OLAP Catalog                  VALID
SDO            Spatial                       INVALID  <--- Invalid
ORDIM          Oracle Multimedia             VALID
XDB            Oracle XML Database           VALID
CONTEXT        Oracle Text                   VALID
EXF            Oracle Expression Filter      VALID
RUL            Oracle Rules Manager          VALID
CATALOG        Oracle Database Catalog Views   VALID
CATPROC        Oracle Database Packages and Types   VALID
JAVAVM         JServer JAVA Virtual Machine   VALID
XML            Oracle XDK                    VALID
CATJAVA        Oracle Database Java Packages   VALID
APS            OLAP Analytic Workspace       VALID
XOQ            Oracle OLAP API               VALID
RAC            Oracle Real Application Clusters   VALID

15 rows selected.

Solution :

connect / as sysdba
alter session set current_schema="MDSYS";

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';
---------  ----------------------  ------------------
Spatial              VALID

Hope this solution works for you..

No comments: