Warning: session_start(): open(/tmp/sess_c98sssmakae9b62ceqdk302ec3, O_RDWR) failed: No space left on device (28) in /razi/eraazi/darbari/mercy/index.php on line 15
EraAzi | ERROR: No checkpoint table specified for ADD REPLICAT ERROR: No checkpoint table specified for ADD REPLICAT
 

           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.

 

 

goldengate GOLDENGATETROUBLESHOOTING