ORA-04045 Errors And ORA-01031 While Running Utlrp.Sql - Learnomate Technologies

ANKUSH THAVALI
07 Dec, 2023
0 Comments
39 Secs Read

ORA-04045 Errors And ORA-01031 While Running Utlrp.Sql

There can be scenarios where you will get below error while running utlrpl.sql

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
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

Solution :

SQL> ALTER SYSTEM SET "_system_trig_enabled" = FALSE scope=both;
System altered.

Now run utlrp.sql again. It will work fine this time.

Hope it Helps!