ORA-06598: insufficient INHERIT PRIVILEGES privilege

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 12.1.0.2.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=12.1.0.2.0, timestamp=2016-10-25 06:13:17
Tue Oct 25 06:14:21 2016
XDB installed.
XDB initialized.

Workaround – (Re)create the table and view after the upgrade is complete.

SQL> sqlplus / as sysdba
SQL> drop table REGISTRY$SQLPATCH;
Table dropped.
SQL> @/u01/product/12.1.0.2/database/rdbms/admin/catsqlreg.sql
Session altered.
Table created.
View created.
Synonym created.
Grant succeeded.
PL/SQL procedure successfully completed.
Grant succeeded.
Synonym created.
Session altered.

Post table recreation, validate using datapatch -verbose.

db01:orcl01:/u01/product/12.1.0.2/database/OPatch>./datapatch -verbose
SQL Patching tool version 12.2.0.0.0 on Mon Oct 24 08:48:19 2016
Copyright (c) 2014, Oracle. All rights reserved.
Connecting to database…OK
catcon: ALL catcon-related output will be written to /tmp/sqlpatch_catcon__catcon_7799494.lst
catcon: See /tmp/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See /tmp/sqlpatch_catcon__*.lst files for spool files, if any
Bootstrapping registry and package to current versions…done
Determining current state…done
Current state of SQL patches:
Adding patches to installation queue and performing prereq checks…
Installation queue:
Nothing to roll back
Nothing to apply
SQL Patching tool complete on Mon Oct 24 08:49:12 2016
Advertisements
This entry was posted in 12c Upgrade issues, Oracle Bugs and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s