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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.