ORA-04020: Deadlock On SYSTEM.AQ$_QUEUE_UPGRADE_TMP
(Doc ID 2406493.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When performing Manual Upgrade from 12.1.0.2 to 12.2.0.1 the below error is seen ,The Database Upgrade is failing when the below script is executing
$ORACLE_HOME/rdbms/admin/cataqalt121.sql and there are no Invalid Objects under the SYS and SYSTEM Schema.
In 12.1.0.2 database:
SQL> desc sys.aq$_agent;
Name Null? Type
----------------------------------------- --------
----------------------------
NAME VARCHAR2(30)
ADDRESS VARCHAR2(1024)
PROTOCOL NUMBER
In 12.2 database :
SQL> desc sys.aq$_agent;
Name Null? Type
----------------------------------------- --------
----------------------------
NAME VARCHAR2(512)
ADDRESS VARCHAR2(1024)
PROTOCOL NUMBER
Changes
Error:
======
SQL> alter type sys.aq$_agent modify attribute (name varchar2(512)) CASCADE;
alter type sys.aq$_agent modify attribute (name varchar2(512)) CASCADE
*
ERROR at line 1:
ORA-22324: altered type has compilation errors
ORA-22332: a dependent object in schema "SYSTEM" has errors.
ORA-04020: deadlock detected while trying to lock object
SYSTEM.AQ$_QUEUE_UPGRADE_TMP
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 |