My Oracle Support Banner

ORA-06598: Insufficient INHERIT PRIVILEGES Privilege ORA-06512: At "XDB.DBMS_CSX_INT" (Doc ID 2382437.1)

Last updated on NOVEMBER 18, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.4 version, XML Database

ORA-06598: insufficient INHERIT PRIVILEGES privilege ORA-06512: at "XDB.DBMS_CSX_INT"

ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "XDB.DBMS_CSX_INT"

while upgrade

 

ERROR
-----------------------


ORA-06598: insufficient INHERIT PRIVILEGES privilege ORA-06512: at "XDB.DBMS_CSX_INT"

ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "XDB.DBMS_CSX_INT"

Changes

ERRORS FOUND: during upgrade CATCTL ERROR COUNT=4
------------------------------------------------------
Identifier CATPROC 18-03-29 02:20:00 Script = /netapp_oradata/oracle/app/oracle/produc
ERROR = [ORA-04045: errors during recompilation/revalidation of SDE.DB_EV_ALTER_ST_METADATA
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_UTILITY", line 1279
ORA-06512: at line 20
]

SELECT dbms_registry_sys.time_stamp('POSTUP_BGN') as timestamp from dual;
SELECT dbms_registry_sys.time_stamp('POSTUP_BGN') as timestamp from dual
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SYS
ORA-01031: insufficient privileges

drop table addm$dbv;
drop table addm$dbv
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.XDB_PI_TRIG
ORA-01031: insufficient privileges

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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