Viswamitra's blog

Today , I am creating 12c database manually. After creating database I executed catalog.sql and cataproc.sql. After that I checked the component status

SQL> select COMP_NAME,COMP_ID,VERSION,STATUS from dba_registry;

COMP_NAME                               COMP_ID         VERSION    STATUS
———————————— ————— ———- ———-
Oracle XML Database                     XDB             12.1.0.1.0 VALID
Oracle Database Catalog Views           CATALOG         12.1.0.1.0 INVALID

Oracle Database Packages and Types      CATPROC         12.1.0.1.0 INVALID


SQL> SQL> select count(*) from dba_objects where status=’INVALID’;

  COUNT(*)
———-
       100


1 row selected.


After executing the “@?/rdbms/admin/utlrp.sql” script the components became valid.