Forum Stats

  • 3,873,344 Users
  • 2,266,537 Discussions
  • 7,911,514 Comments

Discussions

Replication OGG Oracle to MySQL error

820117
820117 Member Posts: 8
edited Feb 23, 2011 3:39AM in GoldenGate
hello,,

could you help me to resolv this error,,because i'm a newbie in OGG,,
and i want to try replication from oracle to mysql..

this is parameter on source and target :

extract eora
userid orgg, password orgg
rmthost 10.1.10.102, mgrport 7810
rmttrail ./dirdat/rt
table orgg.test;

replicat rora
ASSUMETARGETDEFS
SOURCEDB telkom, userid mygg, password mygg
MAP orgg.test, TARGET telkom.test;

and this is the message error :

GGS ERROR 500 Retrieving table information (checkpoint: 'TELKOM.GGS_CHECKPOINT').
Access denied for user 'mygg'@'localhost' to database 'TELKOM'.

2011-02-23 14:27:17 GGS ERROR 190 PROCESS ABENDING.


what should i do ??anyone can help me,,

i try to dblogin in ggsci earlier..

GGSCI (mysqlgg) 18> dblogin sourcedb telkom, userid mygg, password mygg
Successfully logged into database.


regards,
Tagged:

Answers

  • stevencallan
    stevencallan Member Posts: 3,459
    Why are you using different users for GoldenGate? The extract has orgg and the replicat has mygg. And what's up with the checkpoint table name? What was wrong with the default name (ggschkpt)? And use targetdb in the replicat parameter file instead of sourcedb?
This discussion has been closed.