Upgrading 11.2.0.3 to 12.2 but ALTER DATABASE OPEN RESETLOGS UPGRADE fails with ORA-4023 on package STANDARD and ORA-3113
(Doc ID 2309603.1)
Last updated on MAY 17, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Restored an 11.2.0.3 database backup using 12.1.0.2 RMAN binaries, recovered and opened the database upgrade. Tried to execute catupgrd.sql in sqlplus.
This disconnected from the session. The restore and recover completed successfully.
RMAN> alter database open resetlogs upgrade;
using target database control file instead of recovery catalog
Statement processed
RMAN-06900: warning: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: warning: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-04023: Object SYS.STANDARD could not be validated or authorized
PSDRPC returns significant error 3113.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12005: error during channel cleanup
ORA-03113: end-of-file on communication channel
Changes
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 |
References |