CATPROC - Packages and Types Invalid in Dba_registry-457861.1
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
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
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> 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> spool fix_cat_logfile.txt
SQL> startup migrate
SQL> @?/rdbms/admin/catpatch.sql
SQL> spool off
SQL> spool off
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-763464/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Types of SAP Support PackagesPackage
- Invalid MDSYS Objects Types: SDO_GEO_ADDR after DB Upgrade-1294577.1Object
- EF Core – Owned Entity Types & Complex Types
- TypeScript @typesTypeScript
- stock Types
- Types of Locks (340)
- ORA-13516: AWR Operation failed: CATPROC not validAI
- python modules and packagesPythonPackage
- Linux Packages SearchLinuxPackage
- 譯|There Are No Reference Types in GoGo
- TypeScript 之 Object TypesTypeScriptObject
- Two Types of Error in JAVAErrorJava
- Understanding Service Types
- Scala的Abstract Types
- types of undo segments(ZT)
- Behind RabbitMQ Exchange TypesMQ
- Trusted Types APIRustAPI
- 每日一個 Golang PackagesGolangPackage
- nuget packages batch installPackageBAT
- Session State and Referenced Packages (246)SessionPackage
- DataTransfer.types 屬性
- TypeScript 之 Indexed Access TypesTypeScriptIndex
- TypeScript 之 Conditional TypesTypeScript
- birkenstock sandals spec Younger types
- Types of Processes (108)
- PL/SQL Packages DBMS_STATSSQLPackage
- 【譯】 Types are moving to the right
- SAP MM Stock Tables and Stock Types
- npm publish gives “unscoped packages cannot be private”NPMPackage
- revoke EXECUTE privileges on powerful packages from PUBLICPackage
- Software Packages in `experimental' - 安裝方法(轉)Package
- PostgreSQL DBA(80) - Object Identifier TypesSQLObjectIDE
- Go 迷思之 Named 和 Unnamed TypesGo
- This page provides the following types of documentationIDE
- Scala的Infix Type與Self Types
- Types of Oracle Database Users : Database Users (6)OracleDatabase
- different testing types ( by quqi99 )
- 每日一個 Golang Packages 06/11 syncGolangPackage