Running utlrp.sql Script in 184.108.40.206 Raises ORA-04045 on XDB.XDB_PI_TRIG
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.1]
Information in this document applies to any platform.
After applying any of the following patches
- the Windows bundle patch #53 for Oracle 22.214.171.124 and onwards
- Database PSU 126.96.36.199.16 and onwards
running the utlrp.sql script, as requested by the post installation steps, may raise below errors
ORA-04045: errors during recompilation/revalidation of XDB.XDB_PI_TRIG
ORA-01031: insufficient privileges
ORA-06512: at "SYS.UTL_RECOMP", line 760
Starting with PSU 188.8.131.52.16 as well as Windows bundle patch #53 the XDB_PI_TRIG trigger has been moved to SYS's schema.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms