While adding the replicate, you may get the below error.

GGSCI (db75-2) 2> add replicat LOYTSTR, exttrail /ggatebss/oradata/RC12C/R4

ERROR: No checkpoint table specified for ADD REPLICAT.

Solution:

 

Checkpoint table need to be created in the replication side.

1. Login to ggsci with dblogin

GGSCI (db75-2) 4> dblogin USERID TEST_GGATE, PASSWORD TEST_GGATE

Successfully logged into database.

2. Add checkpoint table

GGSCI (db75-2 as TEST_GGATE@TESTPROD1) 5> add checkpointtable TEST_ggate.TESTcheckpoint

Successfully created checkpoint table TEST_ggate.TESTcheckpoint.

3. Restart the manager

GGSCI (db75-2 as TEST_GGATE@TESTPROD1) 9> stop mgr

Manager process is required by other GGS processes.

Are you sure you want to stop it (y/n)?y

Sending STOP request to MANAGER …

Request processed.

Manager stopped.

GGSCI (db75-2 as TEST_GGATE@TESTPROD1) 10> start mgr

Manager started.

4. Now add the replicat by login to ggsci

GGSCI (db75-2) 4> dblogin USERID TEST_GGATE, PASSWORD TEST_GGATE

Successfully logged into database.

GGSCI (db75-2 as TEST_GGATE@TESTPROD1) 6> add replicat LOYTSTR, exttrail /ggatebss/oradata/RC12C/R4

REPLICAT added.