Extract abends with No DB login established to retrieve a definition for table schema_name.table_name (Doc ID 1980678.1)

Last updated on MAY 11, 2022

Applies to:

Goal

The extract is abending with the below error reading the remote trails generated by the extract with the below parameters being used:

EXTRACT xxxx
SOURCEDEFS <path>/source.def
CUSEREXIT /path/flatfilewriter.so CUSEREXIT PASSTHRU INCLUDEUPDATEBEFORES, PARAMS "/path/dirprm/ffkl.properties"
TABLE schema_name.*;
TABLE schema_name2.*;

ERROR OGG-00425 Oracle GoldenGate Capture for Oracle, xxx.prm: No DB login established to retrieve a definition for table schema_name.table_name

Solution

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