Master in Oracle Golden Gate | Join us for the demo session on 22nd November 2025 at 6:00 PM IST

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!

Let's Talk

Find your desired career path with us!

Let's Talk

Find your desired career path with us!