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