Database Upgrade to 19c Fails when it executes utlmmigtbls.sql, with Error: "ORA-01422" for KU$% Objects. (Doc ID 2978946.1)

SQL> /*****************************************************************************/
SQL> /*
SQL>  * Step 1 - Create the new bootstrap objects and recreate related views.
SQL>  */
SQL> /*****************************************************************************/
SQL> @@utlmmigtbls.sql
..
..
SQL> -- FAMILY "EDITION OBJ" - Objects annotated with edition information.
SQL> -- These views are based on "_CURRENT_EDITION_OBJ" in cdcore.sql, and
SQL> -- are intended for internal use only. The difference from cdcore is
SQL> -- that the edition name may be taken from a filter, rather than session
SQL> -- context.
SQL> --
SQL> -- ku$_edition_obj_view - used in place of obj$, when edition semantics
SQL> --  are required.
..
..
SQL> declare
  2      use_new_cols       boolean;
  3      type_name_len       number;
  4      success_with_error exception;
  5      objcom           varchar2(10000);
  6      soobj_tail       varchar2(10000);
  7      edobj_tail       varchar2(10000);
  8      pragma exception_init(success_with_error, -24344);
  9      procedure cre_view(vname VARCHAR2, tname VARCHAR2, tail VARCHAR2) as
 10        begin
..
..
 22  begin
 23      select length into type_name_len from DBA_TYPE_ATTRS where
 24        TYPE_NAME='KU$_SCHEMAOBJ_T' and
 25        ATTR_NAME='TYPE_NAME';
 26      use_new_cols := ku$$column_exists('OBJ$','DFLCOLLID') or ku$$mig_final;
 27  
 28      objcom    :=  q'!
..
..
155         where o.owner# = u.user# !';
156  
157      cre_view('ku$_schemaobj_view',          'schemaobj_t', objcom || soobj_tail);
158      cre_view('ku$_edition_schemaobj_view','schemaobj_t', objcom || edobj_tail);
159  end;
160  /
declare
*
ERROR at line 1:Database Upgrade to 19c Fails when it executes utlmmigtbls.sql, with Error: "ORA-01422" for KU$% Objects.
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 23

 

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.18.0.0.0

..

*******************   Migration   ******************
Serial   Phase #:99   [ORCL] Files:1
Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at catctl.pl line 9261.
 at catctl.pl line 9261.
    main::catctlDie("\x{a}Unexpected error encountered in catconExec; exiting\x{a} No such"...) called at catctl.pl line 5716
    main::catctlExecutePhaseFiles(99, 1, undef, undef, undef) called at catctl.pl line 2088
    main::catctlRunPhase(99, 1, undef, undef, undef) called at catctl.pl line 2252
    main::catctlRunPhases(0, 108, 108, undef, undef, undef) called at catctl.pl line 2871
    main::catctlRunMainPhases() called at catctl.pl line 1500
    main::catctlMain() called at catctl.pl line 1407
    eval {...} called at catctl.pl line 1405