Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Spread and Prevalence of Java Technical in China

843833Sep 26 2001 — edited Sep 27 2001
Hi All,
I am a lover of Java.
I reside at TianJin City of china.
The city have eight hundred million people,
and a lot of people have be very interest at Java Technical and obtained Professional Certification of java.
But their study is no convenience & want for infomation of Technical.
The Status affect the speed of Prevalence Java Technical far too.
So,I want that create a Trainning Center at "Financial Affairs & Economy Univercity" in TianJin City.
The purpose is Spread and Prevalence of Java Technical in China.
Now I have several problem below:
1. What deparment of sun to contact?
2. or Who can help us?
Please reply me or email to I ( dong3_@hotmail.com )

Best Regards,

David Zheng

Comments

sachinDBA

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.

3203172

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

sachinDBA

       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

K.Gan

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

ORASCN

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

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 25 2001
Added on Sep 26 2001
3 comments
73 views