Recently I created new database instance on my Linux oracle 11gr2 existing server(see here: http://chandu208.blogspot.com/2012/07/add-another-database-on-existing-server.html ),
after creating it I ran below oracle scripts
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
And bounced the database
Then I query for invalid objects:
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jul 13 14:21:34 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
45
SQL> SELECT comp_id, version, status FROM dba_registry;
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
OWB 11.2.0.2.0 VALID
APEX 3.2.1.00.12 VALID
EM 11.2.0.2.0 VALID
AMD 11.2.0.2.0 VALID
SDO 11.2.0.2.0 VALID
ORDIM 11.2.0.2.0 VALID
XDB 11.2.0.2.0 VALID
CONTEXT 11.2.0.2.0 VALID
EXF 11.2.0.2.0 VALID
RUL 11.2.0.2.0 VALID
OWM 11.2.0.2.0 VALID
COMP_ID VERSION STATUS
-------------------------- ------------------------------ -----------
CATALOG 11.2.0.2.0 VALID
CATPROC 11.2.0.2.0 INVALID
JAVAVM 11.2.0.2.0 VALID
XML 11.2.0.2.0 VALID
CATJAVA 11.2.0.2.0 VALID
APS 11.2.0.2.0 VALID
XOQ 11.2.0.2.0 VALID
18 rows selected.
In the above we see my CATPROC is invalid, then ran utlrp.sql script to validate objects
$ORACLE_HOME/rdbms/admin/utlrp.sql
But still same then i did some research and found the solution
SQL> exec DBMS_REGISTRY_SYS.VALIDATE_CATPROC;
PL/SQL procedure successfully completed.
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> SELECT comp_id, version, status FROM dba_registry;
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
OWB 11.2.0.2.0 VALID
APEX 3.2.1.00.12 VALID
EM 11.2.0.2.0 VALID
AMD 11.2.0.2.0 VALID
SDO 11.2.0.2.0 VALID
ORDIM 11.2.0.2.0 VALID
XDB 11.2.0.2.0 VALID
CONTEXT 11.2.0.2.0 VALID
EXF 11.2.0.2.0 VALID
RUL 11.2.0.2.0 VALID
OWM 11.2.0.2.0 VALID
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
CATALOG 11.2.0.2.0 VALID
CATPROC 11.2.0.2.0 VALID
JAVAVM 11.2.0.2.0 VALID
XML 11.2.0.2.0 VALID
CATJAVA 11.2.0.2.0 VALID
APS 11.2.0.2.0 VALID
XOQ 11.2.0.2.0 VALID
18 rows selected.
No comments:
Post a Comment