In upgrade0.log can see the repeating error as :
begin
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_SQLTUNE
ORA-21700: object does not exist or is marked for delete
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SQLTUNE"
ORA-06512: at line 10
QL> show errors
Errors for PACKAGE BODY DBMS_COMPARISON:
LINE/COL ERROR
-------- -----------------------------------------------------------------
835/15 PL/SQL: SQL Statement ignored
835/51 PL/SQL: ORA-04045: errors during recompilation/revalidation of
SYS.DBMS_XPLAN
ORA-21700: object does not exist or is marked for delete
836/7 PL/SQL: Statement ignored
836/30 PLS-00364: loop index variable 'R' use is invalid
SQL> SELECT OBJECT_NAME,OBJECT_TYPE,OWNER,STATUS FROM DBA_OBJECTS WHERE OBJECT_NAME='DBMS_SQLTUNE';
OBJECT_NAME OBJECT_TYPE OWNER STATUS
-------------------- --------------- --------------- -------
DBMS_SQLTUNE PACKAGE BODY SYS INVALID
DBMS_SQLTUNE PACKAGE SYS VALID
DBMS_SQLTUNE SYNONYM PUBLIC INVALID
SQL> SELECT OBJECT_NAME,OBJECT_TYPE,OWNER,STATUS FROM DBA_OBJECTS WHERE OBJECT_NAME='DBMS_SPM_INTERNAL';
OBJECT_NAME OBJECT_TYPE OWNER STATUS
-------------------- --------------- --------------- -------
DBMS_SPM_INTERNAL PACKAGE BODY SYS INVALIDy
Tried to manually recompile the package body but did not work
Running utlrp a few times didn't resolve the invalid status so we performed the other steps:
SQL> drop public synonym XMLCONCAT;
Synonym dropped.
SQL> alter package DBMS_SQLTUNE_INTERNAL compile body;
alter package DBMS_SQLTUNE_INTERNAL compile body
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_XPLAN
ORA-21700: object does not exist or is marked for delete
SQL> alter package DBMS_SPM compile body;
Package body altered
As the recompilation of DBMS_SQLTUNE_INTERNAL failed I've not run the catrequtlmg.sql script yet.
Please advise how you'd like us to proceed.