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                         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
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

15 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

Hope this solution works for you..

No comments: