ORA-06598 Insufficient INHERIT PRIVILEGES Privilege on Upgrade from 11.2.0.3 to 12.1.0.2 (Doc ID 1953959.1)

Last updated on APRIL 12, 2022

Applies to:

Symptoms

The following error is reported in the alert log during a database upgrade from 11.2.0.3 to 12.1.0.2:

Errors in file /u01/app/oracle/diag/rdbms/xxxxxx/xxxxx/trace/TEST_ora_23150.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


The trace file shows the following:

ERROR in qm_init_sga_pass1 [604]

----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "XDB.DBMS_CSX_INT", line 1

----- Current SQL Statement for this session (sql_id=6k7tvcrar8hch) -----
CREATE TABLE registry$sqlpatch (
 patch_id           NUMBER,             -- Patch ID
 action              VARCHAR2(15),    -- APPLY or ROLLBACK
 action_time      TIMESTAMP,         -- Time of action
 description       VARCHAR2(100),  -- Patch description
 logfile              VARCHAR2(500),  -- Location of logfile
 status              VARCHAR2(15),   -- BEGIN, END, SUCCESS, WITH ERRORS
 version            VARCHAR2(20),   -- First 4 digits of version
 patch_uid         NUMBER,             -- Patch UID
 flags                VARCHAR2(10),   -- Flags for this patch
 bundle_series   VARCHAR2(30),   -- PSU, EXA, WINBUNDLE, etc.
 bundle_id         NUMBER,             -- Bundle ID being installed
 bundle_data     XMLType,            -- Bundledata associated with this install
 CONSTRAINT registry$sqlpatch_pk
   PRIMARY KEY (patch_id, patch_uid, version, action, action_time)
)

---Call Stack Trace ---
qm_init_uga_helper <- qm_run_as_ksys <- qm_init_uga <- qmxtcInitGlobals <- qmxtcProcessXMLTypeCol <- kkbopopq <- kkbopabn

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.