My Oracle Support Banner

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

Last updated on JANUARY 28, 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, 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.