ORA-04045 Errors And ORA-01031 While Running Utlrp.Sql
Kiran 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.