My Oracle Support Banner

Rman Catalog Upgrade Fails with ORA-1720:grant option does not exist for 'SYS.DUAL' (Doc ID 2849598.1)

Last updated on APRIL 17, 2023

Applies to:

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


After installing PSU 33290750 upgrade catalog fails with message

Recovery Manager: Release - Production on Mon Feb 14 11:23:09 2022
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

connected to target database: CATALOG
connected to recovery catalog database
recovery catalog is partially upgraded to

RMAN> upgrade catalog;

ORACLE error from recovery catalog database: ORA-06550: line 1, column 41:
PLS-00201: identifier 'DBMS_RCVMAN.GETPACKAGEVERSION' must be declared
ORA-06550: line 1, column 34:
PL/SQL: Statement ignored

RMAN-06435: recovery catalog owner is RMAN
RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN> upgrade catalog;
RMAN-06898: recovery catalog is partially upgraded to
RMAN-06444: error creating create_rci_avm_upstream_database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-01720: grant option does not exist for 'SYS.DUAL'



 Installed PSU 33290750


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.