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