My Oracle Support Banner

ORA-04020: Deadlock On SYSTEM.AQ$_QUEUE_UPGRADE_TMP (Doc ID 2406493.1)

Last updated on AUGUST 04, 2018

Applies to:

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


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