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.
0 comments:
Post a Comment