Running utlrp.sql Script in 22.214.171.124 Raises ORA-04045 on XDB.XDB_PI_TRIG
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [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 184.108.40.206 and onwards
- Database PSU 220.127.116.11.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 18.104.22.168.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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms