ORA-24344 during upgrade of XDB from 12c to 18c or to 19c
(Doc ID 2633398.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and laterInformation 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]
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 |