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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s