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 laterOracle 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 |