SAP Knowledge Base Article - Preview

3077599 - Oracle XML Database or XDB is INVALID - NetWeaver

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

SAP NetWeaver 7.5

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.