My Oracle Support Banner

12.2 UPGRADE FAILS WITH ERROR ORA-04063: VIEW “SYS.DBA_REGISTRY_SQLPATCH” ON PDBS (Doc ID 2569408.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

 When upgrading database from 12.1.0.2 to 12.2.0.1, the upgrade fails for the PDBs with below error.

SQL> GRANT SELECT ON dba_registry_sqlpatch TO SELECT_CATALOG_ROLE;
GRANT SELECT ON dba_registry_sqlpatch TO SELECT_CATALOG_ROLE
*
ERROR at line 1:
ORA-04063: view “SYS.DBA_REGISTRY_SQLPATCH” has errors

SQL>
SQL> execute CDBView.create_cdbview(false,’SYS’,’dba_registry_sqlpatch’,’CDB_registry_sqlpatch’);
BEGIN CDBView.create_cdbview(false,’SYS’,’dba_registry_sqlpatch’,’CDB_registry_sqlpatch’); END;

*
ERROR at line 1:
ORA-04063: view “SYS.DBA_REGISTRY_SQLPATCH” has errors
ORA-06512: at “SYS.CDBVIEW_INTERNAL”, line 89
ORA-06512: at “SYS.CDBVIEW”, line 6
ORA-06512: at line 1

SQL> grant select on SYS.CDB_registry_sqlpatch to select_catalog_role
2 /
grant select on SYS.CDB_registry_sqlpatch to select_catalog_role
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDB_REGISTRY_SQLPATCH
ORA-04063: view “SYS.DBA_REGISTRY_SQLPATCH” has errors

 

Changes

 Upgrading to 12.2

Cause

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
Symptoms
Changes
Cause
Solution


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