Extract abending with No DB login established to retrieve a definition for table (Doc ID 1980817.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle GoldenGate Application Adapters - Version 10.4.0.0 and later
Information in this document applies to any platform.

Symptoms

 

Extract with the below parameters is abending:

EXTRACT FFKL
SOURCEDEFS /oraclegg/dirdef/udr_krl.def
CUSEREXIT /oraclegg/dirflt/flatfilewriter.so CUSEREXIT PASSTHRU INCLUDEUPDATEBEFORES, PARAMS "/oraclegg/dirprm/ffkl.properties"
TABLE SYSADM.UDR_*JAN_15;
TABLE SYSADM.UDR_*FEB_15;

 

2015-02-14 11:14:40 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT FFKL starting.

2015-02-14 11:14:40 WARNING OGG-01532 Oracle GoldenGate Capture for Oracle: Cannot locate XML configuration file, 'gglog-FFKL.xml'.
2015-02-14 11:14:40 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ffkl.prm: EXTRACT FFKL starting.
2015-02-14 11:14:40 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ffkl.prm: EXTRACT FFKL started.
2015-02-14 11:14:40 ERROR OGG-00425 Oracle GoldenGate Capture for Oracle, ffkl.prm: No DB login established to retrieve a definition for table SYSADM.UDR_14_FEB_15.
2015-02-14 11:14:40 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ffkl.prm: PROCESS ABENDING.

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