ORA-06598: insufficient INHERIT PRIVILEGES privilege error during upgrade from 11.2.0.2 to 12.1 using DBUA

(Doc ID 1911119.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.
***** Checked for Relevance on 28-Dec-2015 *****

Goal

Issue: During upgrade from 11.2.0.2 to 12.1 using DBUA, the error "ORA-06598: insufficient INHERIT PRIVILEGES privilege" is reported, however the upgrade is successful.

Information:

-- Pre-upgrade log shows all installed components are valid:

Database Components to be Upgraded

Database Components Version Status
Oracle Server 11.2.0.2.0 VALID
JServer JAVA Virtual Machine 11.2.0.2.0 VALID
Oracle XDK for Java 11.2.0.2.0 VALID
Oracle Text 11.2.0.2.0 VALID
Oracle XML Database 11.2.0.2.0 VALID
Oracle Java Packages 11.2.0.2.0 VALID
Oracle Multimedia 11.2.0.2.0 VALID
Oracle Spatial 11.2.0.2.0 VALID
Oracle Workspace Manager 11.2.0.2.0 VALID
Data Mining 11.2.0.2.0 VALID


-- Error during upgrade:

SQL> -- Java Sanity check for installation
SQL> -- Define package dbms_java
SQL> @@initjvm2
SQL> -- subscript for initjvm.sql and ilk
SQL>
SQL> -- Java Sanity check for installation
SQL> -- If the following query returns 0, then the Java installation
SQL> -- did not succeed
SQL> select count(*) from all_objects where object_type like 'JAVA%';
select count(*) from all_objects where object_type like 'JAVA%'
  *
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "SYS.XML_SCHEMA_NAME_PRESENT", line 17

SQL>

-- Post upgrade:

Oracle Database 12.1 Post-Upgrade Status Tool 07-10-2014 18:37:12
.
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
.
Oracle Server
. UPGRADED 12.1.0.1.0 00:31:46
JServer JAVA Virtual Machine
. ORA-06598: insufficient INHERIT PRIVILEGES privilege
. ORA-06512: at "SYS.XML_SCHEMA_NAME_PRESENT", line 17
. VALID 12.1.0.1.0 00:20:54
Oracle Workspace Manager
. VALID 12.1.0.1.0 00:03:32
Oracle XDK
. VALID 12.1.0.1.0 00:01:53
Oracle Text
. VALID 12.1.0.1.0 00:01:53
Oracle XML Database
. VALID 12.1.0.1.0 00:11:40
Oracle Database Java Packages
. VALID 12.1.0.1.0 00:00:37
Oracle Multimedia
. VALID 12.1.0.1.0 00:05:22
Spatial
. VALID 12.1.0.1.0 00:12:20
Final Actions
. 00:04:32
Total Upgrade Time: 01:35:13

PL/SQL procedure successfully completed.

-- Post upgrade components are upgraded and VALID at 12.1.0.1.0, with the exception of ODM which was not upgraded:

SQL> select comp_name, comp_id, status, version from dba_registry;

COMP_NAME COMP_ID STATUS VERSION
----------------------------------- ------------ ---------- ------------
Oracle Data Mining ODM VALID 11.2.0.2.0
Oracle XML Database XDB VALID 12.1.0.1.0
Oracle Text CONTEXT VALID 12.1.0.1.0
Spatial SDO VALID 12.1.0.1.0
Oracle Multimedia ORDIM VALID 12.1.0.1.0
Oracle Workspace Manager OWM VALID 12.1.0.1.0
Oracle Database Catalog Views CATALOG VALID 12.1.0.1.0
Oracle Database Packages and Types CATPROC VALID 12.1.0.1.0
JServer JAVA Virtual Machine JAVAVM VALID 12.1.0.1.0
Oracle XDK XML VALID 12.1.0.1.0
Oracle Database Java Packages CATJAVA VALID 12.1.0.1.0

11 rows selected.

-- There are no invalid objects:

SQL> SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
 2 FROM DBA_OBJECTS
 3 WHERE STATUS = 'INVALID'
 4 ORDER BY OWNER, OBJECT_NAME, OBJECT_TYPE;

no rows selected

What is the reason for the error?
Is it something to be concerned with or can it be ignored?
 

Solution

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