ORA-06598: Insufficient INHERIT PRIVILEGES Privilege after upgrade from 11.2.0.3 to 12.1.0.1 (Doc ID 2160386.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

After database upgrade from 11.2.0.3 to 12.1.0.1 , XDB Component is INVALID and below error was reported

ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "XDB.DBMS_CSX_INT", line 1
ORA-06512: at line 39

After running utlrp.sql script, XDB was still INVALID and below objects were reported as INVALID


SQL> select OWNER, NAME, TYPE, LINE, TEXT from dba_errors
2 where OWNER in ('PUBLIC','SYS','SYSTEM','XDB','ORDSYS','ORDPLUGINS','ORDDATA','MDSYS','CTXSYS')
3 ORDER BY OWNER;

OWNER NAME TYPE LINE
-------------------- -------------------------------------------------- ------------ ----------
TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------
SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 64
PLS-00201: identifier 'DBMS_XS_PRINCIPALS_INT.CHECK_SECURITY_CREATE' must be declared

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 158
PL/SQL: Statement ignored

SYS DBMS_XS_SECCLASS_EVENTS PACKAGE BODY 54
PL/SQL: Statement ignored

SYS DBMS_XS_SECCLASS_EVENTS PACKAGE BODY 54
PLS-00302: component 'SECCLS_DELETE' must be declared

SYS DBMS_XS_SECCLASS_EVENTS PACKAGE BODY 25
PL/SQL: Statement ignored

SYS DBMS_XS_SECCLASS_EVENTS PACKAGE BODY 25
PLS-00302: component 'SECCLS_UPDATE' must be declared

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 464
PL/SQL: Statement ignored

SYS USER_XDS_INSTANCE_SETS VIEW 0
ORA-06512: at "XDB.DBMS_CSX_INT", line 1

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 12
PLS-00201: identifier 'UTL_XS_LIB' must be declared

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 4
PL/SQL: Item ignored

SYS ALL_XDS_INSTANCE_SETS VIEW 0
ORA-04045: errors during recompilation/revalidation of SYS.DBA_XDS_INSTANCE_SETS

SYS ALL_XDS_INSTANCE_SETS VIEW 0
ORA-06598: insufficient INHERIT PRIVILEGES privilege

SYS ALL_XDS_INSTANCE_SETS VIEW 0
ORA-06512: at "XDB.DBMS_CSX_INT", line 1

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 64
PL/SQL: Statement ignored

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 69
PLS-00201: identifier 'DBMS_XS_PRINCIPALS_INT.CHECK_SECURITY_CREATE' must be declared

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 69
PL/SQL: Statement ignored

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 202
PL/SQL: ORA-00604: error occurred at recursive SQL level 3
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "XDB.DBMS_CSX_INT", line 1

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 201
PL/SQL: SQL Statement ignored

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 210
PL/SQL: ORA-00604: error occurred at recursive SQL level 3
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "XDB.DBMS_CSX_INT", line 1

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 209
PL/SQL: SQL Statement ignored

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 312
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 312
PL/SQL: Statement ignored

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 324
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 324
PL/SQL: Statement ignored

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 368
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 368
PL/SQL: Statement ignored

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 378
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 378
PL/SQL: Statement ignored

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 443
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 443
PL/SQL: Statement ignored

SYS DBMS_XS_PRINCIPAL_EVENTS_INT PACKAGE BODY 464
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS USER_XDS_INSTANCE_SETS VIEW 0
ORA-04045: errors during recompilation/revalidation of SYS.DBA_XDS_INSTANCE_SETS

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 58
PLS-00201: identifier 'DBMS_XS_PRINCIPALS_INT.CHECK_SECURITY_CREATE_RS' must be declared

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 58
PL/SQL: Statement ignored

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 72
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 72
PL/SQL: Statement ignored

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 85
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 85
PL/SQL: Statement ignored

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 104
PLS-00201: identifier 'DBMS_XS_PRINCIPALS_INT.CHECK_SECURITY_UPDATE_RS' must be declared

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 104
PL/SQL: Statement ignored

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 107
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 107
PL/SQL: Statement ignored

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 142
PLS-00201: identifier 'DBMS_XS_PRINCIPALS_INT.CHECK_SECURITY_DELETE_RS' must be declared

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 142
PL/SQL: Statement ignored

SYS DBMS_XS_ROLESET_EVENTS_INT PACKAGE BODY 158
PLS-00201: identifier 'SYS.DBMS_XS_PRINCIPALS_INT' must be declared

SYS USER_XDS_INSTANCE_SETS VIEW 0
ORA-06598: insufficient INHERIT PRIVILEGES privilege

XDB DOCUMENT_LINKS VIEW 0
ORA-06598: insufficient INHERIT PRIVILEGES privilege

XDB DBMS_XDB_ADMIN PACKAGE BODY 948
PL/SQL: Statement ignored

XDB DBMS_XDB_ADMIN PACKAGE BODY 948
PLS-00201: identifier 'DBMS_PDB_EXEC_SQL' must be declared

XDB DBMS_XDB_ADMIN PACKAGE BODY 290
PL/SQL: Statement ignored

XDB DBMS_XDB_ADMIN PACKAGE BODY 290
PLS-00201: identifier 'DBMS_PDB_EXEC_SQL' must be declared

XDB DOCUMENT_LINKS VIEW 0
ORA-06512: at "XDB.DBMS_CSX_INT", line 1

XDB DBMS_XDB_ADMIN PACKAGE BODY 264
PLS-00201: identifier 'DBMS_PDB_EXEC_SQL' must be declared

XDB DBMS_XDB_ADMIN PACKAGE BODY 264
PL/SQL: Statement ignored

 

Cause

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