How to Diagnose Components with NON VALID Status in DBA_REGISTRY after an Upgrade
(Doc ID 753041.1)
Last updated on JUNE 21, 2023
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 188.8.131.52.0 [Release 10.2 to 18] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata 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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!