DB Upgrade to 19c hung while running "alter role "PUBLIC" enable editions for synonym;" inside catupstr.sql
(Doc ID 2914824.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Upgrade to 19c hangs while running catupstr.sql & running below highlighted statement -
22:50:42 SQL> -- bug 12915774: Set noneditionable bit for builtin schema objects
22:50:42 SQL> update obj$ set flags = (flags - bitand(flags, 1048576) + 1048576)
22:50:42 2 where owner# in (select u.user# from registry$ r, user$ u
22:50:42 3 where r.status in (0,1,3,5)
22:50:42 4 and r.namespace = 'SERVER'
22:50:42 5 and r.schema# = u.user#
22:50:42 6 union all
22:50:42 7 select u.user#
22:50:42 8 from registry$ r, registry$schemas s, user$ u
22:50:42 9 where r.status in (0,1,3,5)
22:50:42 10 and r.namespace = 'SERVER'
22:50:42 11 and r.cid = s.cid
22:50:42 12 and s.schema# = u.user#)
22:50:42 13 and type# in (4,5,7,8,9,11,12,13,14,22,114);
10927 rows updated.
Elapsed: 00:00:00.40
22:50:43 SQL> commit;
Commit complete.
Elapsed: 00:00:00.01
22:50:43 SQL> alter role "PUBLIC" enable editions for synonym; <<<<<<<<<<<<<<<< hung here
Start of Trace Message
------------------------------------------------------
Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at <19c OH>/rdbms/admin/catctl.pl line 9258.
at <19c OH>/rdbms/admin/catctl.pl line 9258.
main::catctlDie("\x{a}Unexpected error encountered in catconExec; exiting\x{a} No such"...) called at <19c OH>/rdbms/admin/catctl.pl line 5713
main::catctlExecutePhaseFiles(0, 1, undef, undef, undef) called at <19c OH>/rdbms/admin/catctl.pl line 2085
main::catctlRunPhase(0, 1, undef, undef, undef) called at <19c OH>/rdbms/admin/catctl.pl line 2249
main::catctlRunPhases(0, 108, 108, undef, undef, undef) called at <19c OH>/rdbms/admin/catctl.pl line 2868
main::catctlRunMainPhases() called at <19c OH>/rdbms/admin/catctl.pl line 1497
main::catctlMain() called at <19c OH>/rdbms/admin/catctl.pl line 1404
eval {...} called at <19c OH>/rdbms/admin/catctl.pl line 1402
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 |