My Oracle Support Banner

Database Upgrade to 12.2.0.1 & later,Fails with Error:'ORA-04020: Deadlock encountered while attempting to object' (Doc ID 2526432.1)

Last updated on FEBRUARY 20, 2020

Applies to:

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

Symptoms

Database Upgrade to 12.2.0.1 fails with following errors, when upgrade executes the catodci.sql &  c1201000.sql scripts.

catupgrd0.log shows:

SQL> Rem c1201000.sql

SQL> DROP TYPE ODCIARGDESC FORCE;
DROP TYPE ODCIARGDESC FORCE
*
ERROR in line 1:
ORA-00604: Error at recursive SQL level 1
ORA-04020: Deadlock encountered while attempting to object
30x0CEB6AFE80x0CF41E6980x0D97C1458 to lock
..
..
SQL> DROP TYPE ODCICOLINFOLIST FORCE;
DROP TYPE ODCICOLINFOLIST FORCE
*
ERROR in line 1:
ORA-00604: Error at recursive SQL level 1
ORA-04020: Deadlock encountered while attempting to object
30x0CBB6CD680x0CF41E6980x0D97C1458 to lock

..
..

SQL> DROP TYPE ODCIQUERYINFO FORCE;
DROP TYPE ODCIQUERYINFO FORCE
*
ERROR in line 1:
ORA-00604: Error at recursive SQL level 1
ORA-04020: Deadlock encountered while attempting to object
30x0CF116A900x0CF41E6980x0D9932518 to lock

SQL> @@catodci.sql

SQL> CREATE OR REPLACE TYPE ODCICost FORCE AS OBJECT
  2  (
  3   CPUcost NUMBER,
  4   IOcost NUMBER,
  5   NetworkCost NUMBER,
  6   IndexCostInfo VARCHAR2(255)
  7  );
8  /
CREATE OR REPLACE TYPE ODCICost FORCE AS OBJECT
*
ERROR in line 1:
ORA-00604: Error at recursive SQL level 1
ORA-04020: Deadlock encountered while attempting to object
30x07EE1EF800x0CF41E6980x0D98A8AA8 to lock


SQL> CREATE OR REPLACE TYPE ODCIStatsOptions FORCE AS OBJECT
  2  (
  3   Sample NUMBER,
  4   Options NUMBER,
  5   Flags NUMBER
  6  );
 7  /
CREATE OR REPLACE TYPE ODCIStatsOptions FORCE AS OBJECT
*
ERROR in line 1:
ORA-00604: Error at recursive SQL level 1
ORA-04020: Deadlock encountered while attempting to object
30x07EE1D5200x0CF41E6980x0D9904300 to lock

SQL> CREATE OR REPLACE TYPE ODCIEnv FORCE AS OBJECT
   2  (
   3   EnvFlags     NUMBER,
   4   CallProperty NUMBER,
   5   DebugLevel   NUMBER,
   6   CursorNum    NUMBER
   7  );
8  /
CREATE OR REPLACE TYPE ODCIEnv FORCE AS OBJECT
*
ERROR in line 1:
ORA-00604: Error at recursive SQL level 1
ORA-04020: Deadlock encountered while attempting to object
30x07EE1D3F80x0CF41E6980x0D9905AB0 to lock

Note: Oracle Spatial component is not been used/installed here.Instead used ESRI 10.6 (third party)  which has type ST_GEOMETRY in this database. ESRI as  locater functionality .And also  ESRI 10.6 is certified on Oracle Database 12.2

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
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.