Data Dictionary Objects Invalid after Running catalog.sql, catproc.sql, utlrp.sql or catpatch.sql
(Doc ID 752783.1)
Last updated on NOVEMBER 18, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.0 and laterInformation in this document applies to any platform.
Purpose
You systematically encounter invalid objects in the data dictionary. Running catalog.sql, catproc.sql, utlrp.sql or similar scripts do not resolve the problem. The data dictionary or database registry (dba_registry) indicates several invalid components.
This article outlines what to verify and what can be causing this.
Refer the Primary Note 1506140.1 Primary Note: Troubleshooting Oracle Data Dictionary
Scope
This document is intended for Database Administrators and requires database administrator privileges
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Purpose |
Scope |
Details |
Most common causes |
Further Diagnostics and Analyses |
References |