My Oracle Support Banner

Schematrandata Reporting "Error OGG-06522 Cannot verify existence of table function that is required to ADD schema level supplemental logging, failed to find function " (Doc ID 2870546.1)

Last updated on MAY 20, 2022

Applies to:

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

Symptoms

In running OGG configuration, ADD SCHEMATRANDATA gives below error:

GGSCI (dsat012-ax2311) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING


GGSCI (ABC) 2> dblogin useridalias oggadm
Successfully logged into database.

GGSCI (ABC) 3> info schematrandata AST1

2021-11-08 11:46:40 ERROR OGG-06522 Cannot verify existence of table function that is required to INFO schema level supplemental logging, failed to find function.

GGSCI (ABC) 4> add schematrandata AST1, allcols preparecsn

2021-11-08 11:47:24 ERROR OGG-06522 Cannot verify existence of table function that is required to ADD schema level supplemental logging, failed to find function.

GGSCI (ABC) 5>

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.