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 JANUARY 11, 2023

Applies to:

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

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