How to Diagnose Components with NON VALID Status in DBA_REGISTRY after an Upgrade
(Doc ID 753041.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 19.5.0.0.0 [Release 10.2 to 19] Oracle Database Cloud Schema Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Information in this document applies to any platform.
Goal
To provide the steps and tools to diagnose components in the DBA_REGISTRY which are showing status INVALID, LOADED, UPGRADED, NO SCRIPT, OPTION OFF, etc. after an upgrade and provide possible solutions to resolve these status's.
Note: If the status is shown as REMOVED then this means component is successfully removed. In case of UPGRADE, the component was not upgraded because it was removed from the database.
For Example:
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!