Monday 13 May 2019

ERROR OGG-10144 Oracle GoldenGate Delivery for Oracle | Parameter ALLOWDUPTARGETMAP is not valid for this configuration.

if you are using 12.2.0 0r 12.3.0 version of Goldengate and your target is Oracle Database. 
for which you want to use Integrated Replicate and facing below issue while starting replicate

ERROR OGG-10144 Oracle GoldenGate Delivery for Oracle, repl.prm: (repl.prm) line 7: Parameter [ALLOWDUPTARGETMAP] is not valid for this configuration.

This issue is due to bug (Bug 25317245 - IR abends ORA-23666 when using insertmissingupdates)

Check you must be using parameter ALLOWDUPTARGETMAP in your old classic replicate PARAM file which you are migrating now to Integrated replicate. 

ALLOWDUPTARGETMAP Parameter is used to MAP same table more then once in same PARAM files. 

unfortunately ALLOWDUPTARGETMAP Perameter is not yet supported by Integrated replicate configuration. 


To Resolve the issue you need to do adopt one of below process according to your preference

1. Use Classic , Coordinate or Parallel replicate 
2. Remove ALLOWDUPTARGETMAP and duplicate MAP statement of same table if want to user Integrated Replicate


Environment Details:
Goldengate Version : 12.3.0, 12.2.0
Oracle Database Version : 11.2.0.4 


Note: Before implementing above solution in to production please do testing of your requirement by your own in non production ENV . above solution is based on my requirement and experience. 

No comments:

Post a Comment