XDS Invalid Objects Like ALL_XDS_ATTRIBUTE_SECS And ALL_XDS_INSTANCE_SETS After Deinstalling XDB
(Doc ID 1273520.1)
Last updated on APRIL 06, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database - Enterprise Edition - Version 9.2.0.3 to 11.1.0.7 [Release 9.2 to 11.1]
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
After running catnoqm.sql to de-install XDB by following Note 1292089.1 <Primary Note for Oracle XML Database (XDB) Installation> the following XDB objects are invalid:
OWNER OBJECT_TYPE OBJECT_NAME
-------------------------------------------------------------------
PUBLIC SYNONYM ALL_XDS_ATTRIBUTE_SECS
PUBLIC SYNONYM ALL_XDS_INSTANCE_SETS
PUBLIC SYNONYM ALL_XSC_AGGREGATE_PRIVILEGE
PUBLIC SYNONYM ALL_XSC_PRIVILEGE
PUBLIC SYNONYM ALL_XSC_SECURITY_CLASS
PUBLIC SYNONYM ALL_XSC_SECURITY_CLASS_DEP
PUBLIC SYNONYM DBA_NETWORK_ACL_PRIVILEGES
PUBLIC SYNONYM DBA_NETWORK_ACLS
PUBLIC SYNONYM DBA_XDS_ATTRIBUTE_SECS
PUBLIC SYNONYM DBA_XDS_INSTANCE_SETS
PUBLIC SYNONYM DBMS_NETWORK_ACL_ADMIN
PUBLIC SYNONYM DOCUMENT_LINKS2
PUBLIC SYNONYM USER_NETWORK_ACL_PRIVILEGES
PUBLIC SYNONYM USER_XDS_ATTRIBUTE_SECS
PUBLIC SYNONYM USER_XDS_INSTANCE_SETS
PUBLIC SYNONYM XS$CACHE_ACTIONS
PUBLIC SYNONYM XS$CACHE_DELETE
SYS PACKAGE DBMS_NETWORK_ACL_ADMIN
SYS PACKAGE DBMS_XS_DATA_SECURITY_EVENTS
SYS PACKAGE DBMS_XS_PRINCIPAL_EVENTS_INT
SYS PACKAGE DBMS_XS_ROLESET_EVENTS_INT
SYS PACKAGE DBMS_XS_SECCLASS_EVENTS
SYS PACKAGE BODY DBMS_NETWORK_ACL_ADMIN
SYS PACKAGE BODY DBMS_NETWORK_ACL_UTILITY
SYS PACKAGE BODY DBMS_XS_DATA_SECURITY_EVENTS
SYS PACKAGE BODY DBMS_XS_MTCACHE
SYS PACKAGE BODY DBMS_XS_PRINCIPAL_EVENTS_INT
SYS PACKAGE BODY DBMS_XS_ROLESET_EVENTS_INT
SYS PACKAGE BODY DBMS_XS_SECCLASS_EVENTS
SYS VIEW ALL_XDS_ATTRIBUTE_SECS
SYS VIEW ALL_XDS_INSTANCE_SETS
SYS VIEW ALL_XSC_AGGREGATE_PRIVILEGE
SYS VIEW ALL_XSC_PRIVILEGE
SYS VIEW ALL_XSC_SECURITY_CLASS
SYS VIEW ALL_XSC_SECURITY_CLASS_DEP
SYS VIEW DBA_NETWORK_ACL_PRIVILEGES
SYS VIEW DBA_NETWORK_ACLS
SYS VIEW DBA_XDS_ATTRIBUTE_SECS
SYS VIEW DBA_XDS_INSTANCE_SETS
SYS VIEW USER_NETWORK_ACL_PRIVILEGES
SYS VIEW USER_XDS_ATTRIBUTE_SECS
SYS VIEW USER_XDS_INSTANCE_SETS
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 |
| Cause |
| Solution |
| References |