Princeton IT ServicesResources / Blogs
Oracle Goldengate – unable to start integrated replicat – OGG-00446
Recently upgraded Oracle Goldengate version to 12.2.0.1. After that, I was able to successfully add new replicats. But when I tried starting the replicat.
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 CHECKPOINTTABLEGGSCI> ADD CHECKPOINTTABLE
Above command uses the CHECKPOINTTABLE name given in GLOBALS.
30 TB moved with zero downtime
