My Oracle Support Banner

Upgrade to 12.2.0.1 fails with Error - ORA-01436: CONNECT BY loop in user data (Doc ID 2601675.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

Upgrading to 12.2.0.1 fails with the below error

Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at <12.2 DB HOME>/rdbms/admin/catctl.pl line 7822.
at <12.2 DB HOME>/rdbms/admin/catctl.pl line 7822.
main::catctlDie("\x{a}Unexpected error encountered in catconExec; exiting\x{a} No such"...) called at <12.2 DB HOME>/rdbms/admin/catctl.pl line 4556
main::catctlExecutePhaseFiles(0, 1, undef, undef, undef) called at <12.2 DB HOME>/rdbms/admin/catctl.pl line 1862
main::catctlRunPhase(0, 1, undef, undef, undef) called at <12.2 DB HOME>/rdbms/admin/catctl.pl line 2006
main::catctlRunPhases(0, 116, 116, undef, undef, undef) called at <12.2 DB HOME>/rdbms/admin/catctl.pl line 2171
main::catctlRunMainPhases() called at <12.2 DB HOME>/rdbms/admin/catctl.pl line 1341
main::catctlMain() called at <12.2 DB HOME>/rdbms/admin/catctl.pl line 1256
eval {...} called at <12.2 DB HOME>/rdbms/admin/catctl.pl line 1254

Checking catupgrd0.log,

10:24:57 SQL> SELECT TO_NUMBER('NONUPGRADED_TABLEDATA') FROM SYS.V$INSTANCE
10:24:57   2  WHERE
10:24:57   3      (version <> (select version from registry$ where cid = 'CATALOG'))
10:24:57   4      AND
10:24:57   5      EXISTS
10:24:57   6      (SELECT o.obj#
10:24:57   7       FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t
10:24:57   8       WHERE o.OBJ# = t.OBJ# AND c.OBJ# = t.OBJ# AND c.COL# = t.COL#
10:24:57   9         AND t.INTCOL# = c.INTCOL# AND BITAND(t.FLAGS, 256) = 256
10:24:57  10         AND o.TYPE# = 2 AND o.OBJ# IN
10:24:57  11    (SELECT d_obj# -- A dependent of an Oracle-Maintained type
10:24:57  12     FROM dependency$
10:24:57  13     START WITH p_obj# IN
10:24:57  14       (SELECT obj# from obj$
10:24:57  15        WHERE type#=13
10:24:57  16          AND owner# IN
10:24:57  17     (SELECT schema# FROM sys.registry$ WHERE namespace='SERVER'
10:24:57  18      UNION
10:24:57  19      SELECT schema# FROM sys.registry$schemas
10:24:57  20      WHERE namespace='SERVER')
10:24:57  21      UNION
10:24:57  22      SELECT user# FROM user$ WHERE type#=1
10:24:57  23         AND bitand(spare1,256)=256)
10:24:57  24     CONNECT BY PRIOR d_obj# = p_obj#));
AND o.TYPE# = 2 AND o.OBJ# IN
               *
ERROR at line 10:
ORA-01436: CONNECT BY loop in user data



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.