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

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 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!