My Oracle Support Banner

ORA-24344 during upgrade of XDB from 12c to 18c or to 19c (Doc ID 2633398.1)

Last updated on OCTOBER 22, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

During the database upgrade from 12.1 to 18c or 19c, errors were generated while XDB was being upgraded:

...
19:49:32 SQL> @&xrdfile
19:49:32 SQL> Rem
19:49:32 SQL> Rem $Header: rdbms/admin/xrdud121.sql /st_rdbms_18.0/1 2017/12/05 20:25:20 atomar Exp $
19:49:32 SQL> Rem
19:49:32 SQL> Rem xrdud121.sql
19:49:32 SQL> Rem
19:49:32 SQL> Rem Copyright (c) 2014, 2017, Oracle and/or its affiliates.
19:49:32 SQL> Rem All rights reserved.
...
...
...
*** WARNING: ERRORS FOUND DURING UPGRADE ***

 1. Evaluate the errors found in the upgrade logs
    and determine the proper action.
 2. Rerun the upgrade when the problem is resolved

REASON:
      ERRORS FOUND: During Upgrade
         FILENAME: /u01/app/oracle/cfgtoollogs/dbua/upgrade2020-01-19_06-32-47PM/ORCL/catupgrd0.log AT LINE NUMBER: 1045829
------------------------------------------------------
Identifier XDB 20-01-19 07:49:35
SCRIPT      = [/u01/app/oracle/product/18c/dbhome_RU9/rdbms/admin/xrdud121.sql]
ERROR      = [ORA-24344: success with compilation error ORA-06512: at line 35
ORA-06512: at "SYS.DBMS_PRVTAQIM", line 526
ORA-06512: at "SYS.DBMS_AQADM_INV", line 134
ORA-06512: at "SYS.DBMS_AQADM_INV", line 123
ORA-06512: at "SYS.DBMS_PRVTAQIM", line 1228
ORA-06512: at "SYS.DBMS_PRVTAQIM", line 522
ORA-06512: at line 24
ORA-06512: at line 24
]
STATEMENT = [as above]

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


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