Recently while upgrading 11204 database to 12102, got following error.
XDB SGA reset to NULL.
Tue Oct 25 05:37:34 2016
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl01/trace/orcl01_ora_5898844.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at “XDB.DBMS_CSX_INT”, line 1
This problem is caused due to BUG 19315691: CHANGE XMLTYPE DATATYPE TO CLOB FOR BUNDLE_DATA COLUMN IN REGISTRY$PATCH.
Not much details available on the bug, but as per oracle it’s fixed in Oracle 22.214.171.124.4 Proactive BP. INHERIT PRIVILEGE error is thrown because XMLTYPE datatype is not available to be used as a column datatype until AFTER XDB has been upgraded.
As we can see XML component is upgraded after ( Oct 25 06:13:17 2016) this error was thrown (Oct 25 05:37:34 2016).
Tue Oct 25 06:13:17 2016
SERVER COMPONENT id=XML: status=VALID, version=126.96.36.199.0, timestamp=2016-10-25 06:13:17
Tue Oct 25 06:14:21 2016
Workaround – (Re)create the table and view after the upgrade is complete.
SQL> sqlplus / as sysdba
SQL> drop table REGISTRY$SQLPATCH;
PL/SQL procedure successfully completed.
Post table recreation, validate using datapatch -verbose.