DB Patches Needed to Support SCHEMATRANDATA in OGG (Oracle GoldenGate) (Doc ID 1426440.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

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

2012-02-17 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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms