Oracle Goldengate – unable to start integrated replicat – OGG-00446

For one of our projects, we upgraded Goldengate version to 12.2.0.1. After upgrading to newer version, I am able to successfully add new replicats. But when I tried starting the replicat, I encountered the following error:


2016-09-04 11:50:58 ERROR OGG-00446 Supplemental checkpoint table does not exist. Create a supplemental checkpoint table with the UPGRADE CHECKPOINTTABLE command in GGSCI if you have upgraded from release 11.2.1.0.0 or earlier.


As per recommendation provided in the error message, I did run the following command successfully:


GGSCI> UPGRADE CHECKPOINTTABLE


I was hoping the above command resolves the issues. When I tried attempting to restart replicat, unfortunately I encountered the same error with the same recommendation – UPGRADE CHECKPOINTTABLE. At this stage, I decided to Delete and Add checkpoint table. Luckily, deleting and adding check point table resolved the issue and I was able to start the replicat process.


GGSCI> DELETE CHECKPOINTTABLE
GGSCI> ADD CHECKPOINTTABLE


Above command uses the CHECKPOINTTABLE name given in GLOBALS.