XDB Component Is Invalid With Any Attempt to Validate Its Objects Ending in ORA-00942 (Doc ID 2966646.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

XDB component in invalid state.

COMP_NAME VERSION STATUS
----------------------------------- ---------- ----------
Oracle Workspace Manager 12.1.0.2.0 VALID
Oracle XML Database 12.1.0.2.0 INVALID  <<<<<<<<<<
Oracle Database Catalog Views 12.1.0.2.0 VALID
Oracle Database Packages and Types 12.1.0.2.0 VALID


SQL> select owner,object_name,object_type,status from dba_objects where status='INVALID';

OWNER OBJECT_NAME          OBJECT_TYPE     STATUS
------------------------------ ------------------------------ 
XDB      DBMS_XDBZ0           PACKAGE BODY INVALID
XDB      DBMS_XDBZ             PACKAGE BODY INVALID
XDB      DBMS_XDB               PACKAGE BODY INVALID
XDB      DBMS_XDBUTIL_INT  PACKAGE BODY INVALID
XDB      DBMS_XDB_CONFIG  PACKAGE BODY INVALID

Any attempt to validate these XDB owned objects, end up with "ORA-00942: table or view does not exist".    

Tracing ORA-00942 will not reveal the failing SQL statement but there will be clues, such as:

"about to signal 942
Name: DUAL"

The objects are wrapped so you won`t be able to see at which line the package body is failing, using the line number from the actual error.

Changes

 None

Cause

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