Rman Catalog Upgrade Fails with ORA-1720:grant option does not exist for 'SYS.DUAL'
(Doc ID 2849598.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation 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 |