"DBA_REGISTRY_DATABASE","DBMS_REGISTRY" Object Invalid After Running Pre-upgrade Utility in 10gR2 Database

(Doc ID 2105459.1)

Last updated on FEBRUARY 15, 2016

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


While Upgrading database from 10.2 to 11.2, After executing pre-upgrade tool or running DBUA following objects may shows in 10.2 database as invalid

SQL>  select object_name,status from all_objects where status='INVALID';

OBJECT_NAME                    STATUS
------------------------------ -------
DBMS_REGISTRY                  INVALID


You will see the similar objects invalid while trying to run pre-upgrade tool (preupgrd.sql ) for 12c database.



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms