Java EE (Java Enterprise Edition) General Discussion

Try to restart the replicate from different session other than the prompt where you have created checkpoint table. Certain time newly added table is not resolved and get the error. Also try below given options.

Thanks for the suggestion, i have tried doing it but it Still throws the same error

       Try the below given options.

•            dblogin userid OGG, password OGG

                 Delete  CHECKPOINTTABLE GGS_OWNER.CHKPTAB

                 ADD CHECKPOINTTABLE GGS_OWNER.CHKPTAB                 Restart the mgr and replicat process from other session

•          Check you have configured correct checkoint table in ./GOBAL parameter file .
•          Use the parameter NODBCHECKPOINT in replicat which will tells replicate to ignore checkpint table.  Note checkpint table       is optional.

• Verify also the table does exist in ogg schema with DESC TABLE_NAME command

Steps for recreating checkpoint table are

To create a new checkpoint table:

ggsci> dblogin userid "user id"  PASSWORD "password"

ggsci> add checkpointtable "checkpoint table name"

ggsci> info "replicat"  (Make a note of the trail file sequence number and RBA )

ggsci> delete "replicat"!

ggsci> add rep "replicat" , exttrail  "trail file"  extseqno ###, extrba ####, checkpointtable "checkpoint table name"  ( Use the extseqno and extrba from the INFO command)

ggsci> start rep "replicat"

To use checkpoint table on replicat DB instance:

Set ORACLE_SID and ORACLE_HOME environment variables

Recycle manager process

ggsci>stop mgr

ggsci> start mgr

ggsci> start rep "replicat"

=========================

OR

Before doing theses steps, please stop the replicat:

1- Delete the checkpoint

2- recreate the checkpoint:

GGSCI>add checkpointtable SYS.GGS_CHECKPOINT

make sure to make the change in the GLOBALS to reflect the schema

3-

record the checkpoints (from GGSCI>info ,showch) for each object, delete it and re-add it specifying the checkpoint table

GGSCI>add replicat XXXX, exttrail , checkpointtable SYS.GGS_CHECKPOINT

What is the userid parameter in the replicat, is it

userid ogg_user, password xxxxxx

If not use this, I expect

sqlplus ogg_user/password

> desc ogg_user.checkpointtable

works?

Cheers

Kee Gan

Hi ,

Could you please provide the steps which you have followed to recreate the checkpointtable?

Whenever you make the changes to the ./GLOBALS, you need to exit and relogin to the ggsci prompt.

Steps to add the checkpoint table

1. Add the checkpoint table in the ./GLOBALS parameter

2. Exit from the ggsci prompt

3. open a new session and login to ggsci prompt

4. issue the below command

add checkpointtable

this should automatically take the checkpointtable

5. add the replicat process. but do not specify any checkpointtable here.

6. Start the replicat process

Regards,

Veera