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.