11gR2ASMGoldenGateHAOracle

ERROR: No checkpoint table specified for ADD REPLICAT – Oracle GoldenGate

This is just a quick note for myself to remember and reference for in case someone comes across this error while setting up Oracle GoldenGate.
While configuring the online synchronization replication, a default checkpoint table is created.The table’s name is mentioned in file named GLOBALS.

GGSCI (anand-lab) 29> EDIT PARAMS ./GLOBALS
GGSCHEMA GG_OWNER
CHECKPOINTTABLE GG_OWNER.CKPTAB
GGSCI (anand-lab) 31> DBLOGIN USERID gg_owner,PASSWORD gg123
Successfully logged into database.
GGSCI (anand-lab) 33> ADD CHECKPOINTTABLE CKPTAB
Successfully created checkpoint table CKPTAB.

Now, when you try to create the Replicat group, the ADD REPLICAT command might produces an error

GGSCI (anand-lab) 41> ADD REPLICAT rep1, EXTTRAIL /media/sf_database/gg/dirdat/rt
ERROR: No checkpoint table specified for ADD REPLICAT.

The solution is simply to exit that GGSCI session and then start another one before issuing ADD REPLICAT.The ADD REPLICATE command fails if issued from the session where the GLOBALS file using the GGSCI command “EDIT PARAMS ./GLOBALS” was created.This is because the name of the checkpoint table is read from GLOBALS by GGSCI. The session in which the GLOBALS was created cannot read the file.
Reference – MOS 965256.1

4 thoughts on “ERROR: No checkpoint table specified for ADD REPLICAT – Oracle GoldenGate

Leave a Reply