My Oracle Support Banner

19c :Upgrade or postupgrade_fixups.sql fails with error "ORA-04023" (Doc ID 2650211.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.