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. 

OGG-00870 Database error 23666 (ORA-23666: Default column group in use by DML conflict handler)

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-00870 Database error 23666 (ORA-23666: Default column group in use by DML conflict handler). 

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. 

OGG-00662 OCI Error allocating error handle (status = -2)

If you are using 12.3.0 Goldengate on Linux environment you may face below error while starting your replicate. 

ERROR OGG-00662 OCI Error allocating error handle (status = -2). 


By Looking at the issue I first felt there is some issue with your ENV variables. 
I keep setting $ORACLE_HOME and $LD_LIBRARY_PATH but this was not the case. 

You won't find any specific solution for this on MOS as the massage in the report file of the replicate and error log file of oracle Goldengate is not clear enough to understand the real issue. 


The issue is mostly related to the Privileges of Goldengate user in target Database.


GG user required below privilege in Target database for both types of replicate Integrated or Classic. 


EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE(grantee => 'GGADMIN', privilege_type => 'APPLY',  grant_select_privileges=> true, do_grants => TRUE);

GRANT SELECT ON V_$DATABASE TO GGADMIN;


Try Starting replicate again. :) 

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.