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

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Application Adapters - Version 10.4.0.0 and later
Information in this document applies to any platform.
Extract abends with OGG-00425 No DB login established to retrieve a definition for table schema_name.table_name

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

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