CATPROC - Packages and Types Invalid in Dba_registry-457861.1

rongshiyuan發表於2013-06-07
CATPROC - Packages and Types Invalid in Dba_registry [ID 457861.1]
 

In this Document


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Goal

Checked for relevance on 31-Oct-2011

Dba_registry shows 'Packages and Types' as invalid. How it can be validated.

SQL> select comp_name, version, status from dba_registry;

COMP_NAME VERSION STATUS
---------------------------------------- ---------- ----------
Oracle XML Database 10.2.0.1.0 VALID
Oracle Database Catalog Views 10.2.0.1.0 VALID
Oracle Database Packages and Types 10.2.0.1.0 INVALID
JServer JAVA Virtual Machine 10.2.0.1.0 VALID
Oracle XDK 10.2.0.1.0 VALID
Oracle Database Java Packages 10.2.0.1.0 VALID



Fix

'Packages and Types' can usually be validated by running catalog and catproc scripts:

$sqlplus "/as sysdba"
SQL> spool fix_cat_logfile.txt
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> spool off


However, from 9.0.1.4 and later, it is not recommended to run catalog and catproc if XDB is installed and used. If XDB is installed:


For 10G +
$sqlplus "/as sysdba"
SQL> spool fix_cat_logfile.txt
SQL> startup upgrade
SQL> @?/rdbms/admin/catupgrd.sql
SQL> spool off

For 9i
$sqlplus "/as sysdba"
SQL> spool fix_cat_logfile.txt
SQL> startup migrate
SQL> @?/rdbms/admin/catpatch.sql
SQL> spool off






來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-763464/,如需轉載,請註明出處,否則將追究法律責任。

相關文章