My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.