Symptom
Following SQL commands show Oracle XML Database or XDB is invalid.
SQL> select comp_name, version, status from dba_registry;
----------------------------------------------------------
|COMP_NAME |VERSION |STATUS |
----------------------------------------------------------
|Oracle Database Catalog Views |19.0.0.0.0|VALID |
|Oracle Database Packages and Types|19.0.0.0.0|VALID |
|Oracle Real Application Clusters |19.0.0.0.0|OPTION OFF|
|Oracle XML Database |19.0.0.0.0|INVALID |
----------------------------------------------------------
SQL> select comp_id, nvl( version, 'NONE' ), nvl( version_full, 'NONE' ), nvl( status, 'NONE' ), nvl( modified, 'NONE' ) from dba_registry order by comp_id;
-------------------------------------------------------------------------------
|COMP_ID|NVLVERSIONNONE|NVLVERSION_FULLNONE|NVLSTATUSNONE|NVLMODIFIEDNONE |
-------------------------------------------------------------------------------
|CATALOG|19.0.0.0.0 |19.10.0.0.0 |VALID |21-APR-2021 09:24:32|
|CATPROC|19.0.0.0.0 |19.10.0.0.0 |VALID |21-APR-2021 09:24:32|
|RAC |19.0.0.0.0 |19.10.0.0.0 |OPTION OFF |05-MAR-2021 13:17:52|
|XDB |19.0.0.0.0 |19.10.0.0.0 |INVALID |21-APR-2021 09:24:33|
-------------------------------------------------------------------------------
Read more...
Environment
Oracle 19c.
Product
Keywords
Oracle XML Database, XDB, INVALID, invalid object , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.