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. 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.