My Oracle Support Banner

Wrong Version in DBA_REGISTRY after applying Patchset (Doc ID 313537.1)

Last updated on JANUARY 30, 2022

Applies to:

Operating System Dependent Interface - Version and later
IBM z/OS on System z


During upgrade from V9205 to V9206 versions of components in dba_registry are not upgraded after execution of catpatch script.
Query  select comp_name,version,status from dba_registry shows components versions and status for each component:

COMP_NAME                      VERSION                        STATUS
------------------------------ ------------------------------ -----------
Oracle9i Catalog Views                      VALID
Oracle9i Packages and Types                      INVALID
JServer JAVA Virtual Machine                      VALID

Oracle9i Java Packages                      VALID
Oracle XDK for Java                        VALID
Spatial                                    VALID
Oracle Text                                VALID

Also the following errors are displayed in catpacth execution spool:

BEGIN dbms_registry_sys.validate_components; END;

ERROR at line 1:
ORA-06550: line 1, column 25:
PLS-00302: component 'VALIDATE_COMPONENTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.