[Translated from mos] If SCHEMATRANDATA is used in OGG (Oracle GoldenGate), additional db patches are required,

[Translated from mos] If SCHEMATRANDATA is used in OGG (Oracle GoldenGate), additional db patches are required,

When SCHEMATRANDATA is used in OGG (Oracle GoldenGate), additional db patches are required.

Reference Original:
Patches needed to support SCHEMATRANDATA in OGG (Oracle GoldenGate) (Doc ID 1426440.1)

Applicable:
Oracle GoldenGate-Version 11.1.1.1.1 and later
Information in this document applies to any platform.

Symptom 1:
DB Version is 11.2.0.2.0 and add schematrandata fails with following error:

GGSCI (host) 13> dblogin userid ggat password abcd
Successfully logged into database.

GGSCI (host) 14> add schematrandata scott

15:11:42 ERROR OGG-01783 Cannot verify existence of table function that is required to enable schema level supplemental logging, failed to find function.

Symptom 2:
DB Version is 11.2.0.3, using SCHEMATRANDATA. add schematrandata works fine. Table has multiple unique indexes, no primary key.
Extract captures NULL for the unique index columns that aren't supposed to have NULL value.
-- The extraction process captures the NULL value of the unique index column, but these unique indexes do not have null values.

Cause:
In order for SCHEMATRANDATA to work properly, rdbms requires related patches.

Solution:
-Bug 10271153 added support for ALLKEYS_ON specifically to support Golden Gate.
-A code bug was identified on the change in 10271153 and was fixed in bug 10271153
-Fix in bug 10271153 was later enhanced and superseded by bug 13794550

To use SCHEMATRANDATA, please apply the fix in bug 13794550