Hello,
This is a new setup of Goldengate 11.2 for 10g DB (source), and 12.1.2 GG for the 12c DB (target). I followed the following documents :
11.2 GG:
MOS Doc ID 1484793.1 : How to Setup Oracle GoldenGate - Oracle to Oracle Extract and Replicat (step by step Classic Extract & Replicat setup)...
12.1 GG:
Document ID 1960719.1 : Oracle GoldenGate 12c Tutorial Oracle to Oracle Replication with Oracle Multitenant Version 12.1
The extract is successful, but replication is not working due to the following errors :
----------------------------------------------------
repora.dsc:
Oracle GoldenGate Delivery for Oracle process started, group REPORA discard file opened: 2016-01-27 13:54:30.022266
Key column NAME (1) is missing from delete on table ORAHR.TEST.TCUSTMER
Key column CITY (2) is missing from delete on table ORAHR.TEST.TCUSTMER
Key column STATE (3) is missing from delete on table ORAHR.TEST.TCUSTMER
Missing 3 key columns in delete for table ORAHR.TEST.TCUSTMER.
Current time: 2016-01-27 13:54:40
Discarded record from action ABEND on error 0
Aborting transaction on ./dirdat/rt beginning at seqno 0 rba 1191
error at seqno 0 rba 1191
Problem replicating SOURCE.TCUSTMER to ORAHR.TEST.TCUSTMER
Mapping problem with delete record (target format)...
*
CUST_CODE = JANE
000000: 4a 41 4e 45 |JANE |
*
Process Abending : 2016-01-27 13:54:47
----------------------------------------------------
I added the NOCOMPRESSDELETES parameter in the extract parameter file, and forced a new extract, but still not working. Any suggestions ?
Thanks for your help.
Regards,
Mahmoud