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

Symptoms

After installing PSU 33290750 upgrade catalog fails with message

Recovery Manager: Release 12.2.0.1.0 - 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 12.02.00.01

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 12.02.00.01
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'

 

Changes

 Installed PSU 33290750

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.