Invalid CATALOG and CATAPROC after after upgradation to 10g

HI ,

We upgraded our 9i database to 10g and after that our CATALOG & CATALOG got Invalid ..


SQL> select comp_name, version, status,comp_id from dba_registry;

COMP_NAME VERSION STATUS COMP_ID
--------------------------------------------- ------------------------------ ----------- -----------
Oracle Database Catalog Views 10.2.0.3.0 INVALID CATALOG
Oracle Database Packages and Types 10.2.0.3.0 INVALID CATPROC
Oracle Real Application Clusters 10.2.0.3.0 INVALID RAC
JServer JAVA Virtual Machine 10.2.0.3.0 VALID JAVAVM
Oracle XDK 10.2.0.3.0 VALID XML
Oracle Database Java Packages 10.2.0.3.0 VALID CATJAVA
Oracle interMedia 10.2.0.3.0 VALID ORDIM
Spatial 10.2.0.3.0 VALID SDO
Oracle Text 10.2.0.3.0 VALID CONTEXT
OLAP Analytic Workspace 10.2.0.3.0 INVALID APS
Oracle OLAP API 10.2.0.3.0 VALID XOQ
OLAP Catalog 10.2.0.3.0 VALID AMD

Solution :

$sqlplus "/as sysdba"
SQL> startup upgrade
-- Use 'startup migrate' if database version is lower than 9.2.
SQL > @?/rdbms/admin/catalog.sql
SQL > @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql

SQL> select comp_name, version, status,comp_id from dba_registry;

COMP_NAME VERSION STATUS COMP_ID
--------------------------------------------- ------------------------------ ----------- ---------
Oracle Database Catalog Views 10.2.0.3.0 VALID CATALOG
Oracle Database Packages and Types 10.2.0.3.0 INVALID CATPROC
Oracle Real Application Clusters 10.2.0.3.0 INVALID RAC
JServer JAVA Virtual Machine 10.2.0.3.0 VALID JAVAVM
Oracle XDK 10.2.0.3.0 VALID XML
Oracle Database Java Packages 10.2.0.3.0 VALID CATJAVA
Oracle interMedia 10.2.0.3.0 VALID ORDIM
Spatial 10.2.0.3.0 VALID SDO
Oracle Text 10.2.0.3.0 VALID CONTEXT
OLAP Analytic Workspace 10.2.0.3.0 INVALID APS
Oracle OLAP API 10.2.0.3.0 VALID XOQ
OLAP Catalog 10.2.0.3.0 VALID AMD


CATALOG is valid now . But CATAPROC is still invalid . To valid the same ...

SQL> exec DBMS_REGISTRY.valid('CATPROC');

COMP_NAME VERSION STATUS COMP_ID
------------------------- ---------------------------- ----------- ------------------------------
Oracle Database Catalog Views 10.2.0.3.0 VALID CATALOG
Oracle Database Packages and Types 10.2.0.3.0 VALID CATPROC
Oracle Real Application Clusters 10.2.0.3.0 INVALID
RAC JServer JAVA Virtual Machine 10.2.0.3.0 VALID
JAVAVM Oracle XDK 10.2.0.3.0 VALID XML
Oracle Database Java Packages 10.2.0.3.0 VALID CATJAVA
Oracle interMedia 10.2.0.3.0 VALID ORDIM Spatial 10.2.0.3.0 VALID
SDO Oracle Text 10.2.0.3.0 VALID CONTEXT
OLAP Analytic Workspace 10.2.0.3.0 INVALID APS
Oracle OLAP API 10.2.0.3.0 VALID XOQ OLAP Catalog 10.2.0.3.0 VALID AMD

For more information refer to the docs 457861.1