Unable to recompile trigger during upgrade

@utlprp

Hi All,

I'm testing an upgrade from 10.2.0.5.0 to 11.2.0.4.0.

I'm getting the below error when the upgrade script tried to compile triggers.

ERROR at line 1:

ORA-04045: errors during recompilation/revalidation of SYSTEM.AUDIT_DDL_TRG

ORA-01031: insufficient privileges

ORA-06512: at "SYS.DBMS_UTILITY", line 1279

ORA-06512: at line 20

I tried to run ultrp & utlprp script but it's failing as well.

SQL> @utlprp
SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SYS
ORA-01031: insufficient privileges

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid