2.13.14 Oracle XML DB Known Bugs

These are known bugs for Oracle XML DB in Oracle Database 12c Release 2 (12.2).

2.13.14.1 Bug 25294856

When an Oracle Database 11g Release 2 (11.2.0.4) standby database without XDB installed is upgraded and supplemental logging is turned on, the upgrade to Oracle Database 12c fails. This is because, as part of the Oracle Database 12c upgrade, XDB is automatically installed. As part of the upgrade, some registerSchema procedures fail and then cause the XDB component to be invalid.

Workaround:

Set event="1399 trace name context forever, level 512" prior to upgrading the standby database. This event disables supplemental log generation for procedures.

2.13.14.2 Bug 23333562

Transportable tablespace based export and import involving XMLType columns along with XMLIndex can take long time.

Workaround:

Drop the index prior to running export and re-create the index after the import is complete. Alternatively, conventional export or import can be run.