19c :Upgrade or postupgrade_fixups.sql fails with error "ORA-04023"
(Doc ID 2650211.1)
Last updated on DECEMBER 12, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Symptoms
19c Upgrade fails as below:
catupgrd0.log shows:
Identifier CATPROC 22-11-02 07:12:37
SCRIPT = [/u01/app/oracle/product/19.3.0.0/db_3/rdbms/admin/depssvrm.sql]
ERROR = [ORA-04023: Object SELECT /*CROSSCON*/ /* */ /*"K"*/ /* ID */ * FROM "SYS"."DBA_AUTOTASK_TASK" could not be validated or authorized
ORA-06512: at "SYS.CDBVIEW_INTERNAL", line 93
ORA-06512: at "SYS.CDBVIEW", line 6
ORA-06512: at line 1
]
STATEMENT = [BEGIN CDBView.create_cdbview(false,'SYS','DBA_AUTOTASK_TASK','CDB_AUTOTASK_TASK'); END;
]
..
Or
Executing postupgrade_fixups.sql fails with error:
SQL> @postupgrade_fixups.sql
..
..
Package body created.
No errors.
DECLARE
*
ERROR at line 1:
ORA-04023: Object with
segments as (select tablespace_name, inuse from(
select ds.tablespace_name,
row_number() over (partition by tablespace_name order by 1) rn,
round(nvl(sum(ds.bytes) over (partition by ds.tablespace_name),0)/:a,2) as inuse
from sys.dba_segments ds) where rn =1 ),
ts_qresult as (
SELECT /*+ MATERIALIZE */
dt.tablespace_name as name,
dt.contents could not be validated or authorized
ORA-06512: at "SYS.DBMS_PREUP", line 4086
ORA-06512: at "SYS.DBMS_PREUP", line 10540
ORA-06512: at line 11
Session altered.
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 |
Cause |
Solution |
References |