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.

Leave a Reply

Your email address will not be published. Required fields are marked *