"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 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

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
DBA_REGISTRY_DATABASE          INVALID
DBA_REGISTRY_DATABASE          INVALID

 

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

 

Cause

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