SOLVED

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

Asked by OracleDba••14 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
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!
OracleDba•

Post Your Solution