My Oracle Support Banner

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

Last updated on OCTOBER 06, 2023

Applies to:

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

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

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
References


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