Error MySQL to Oracle Replication > ERROR OGG-00146 Failed to Query Meta
Hello Guys,
I have a configured replication between MySQL database and Oracle Database using Golden Gate.
Extract data from MySQL is replicated to Oracle.
MySQL is on Linux and version is 5.5
Oracle is 11gR2 RAC on Linux (I am using one node for replication)
When i start extract and replicat they works fine, but as soon as record is inserted in source database i.e MySQL extract ABENDED with this error in the log file:
*2013-04-11 16:24:40 ERROR OGG-00146 Oracle GoldenGate Capture for MySQL, smpp7.prm: VAM function VAMRead returned unexpected result: error 600 - VAM Client Report* *<CAUSE OF FAILURE : Failed to Query Metadata from Table : smpp7.sent_sms WHEN FAILED : While Sending Insert and Delete Record WHERE FAILED : MySQLBinLog Reader Module*
CONTEXT OF FAILURE : No Information Available!>.
*2013-04-11 16:24:40 ERROR OGG-01668 Oracle GoldenGate Capture for MySQL, smpp7.prm: PROCESS ABENDING*
This is my extract and replicat:
Extract
GGSCI>ADD EXTRACT SMPP7, TRANLOG, BEGIN NOW
GGSCI>EDIT PARAMS SMPP7
EXTRACT smpp7
DBOPTIONS HOST 10.168.20.253, CONNECTIONPORT 14422
SOURCEDB smpp7@10.168.20.253:14422, USERID "*******", PASSWORD "*******"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTTRAIL /u01/app/oracle/oradata/GG/dirdat/D2
TRANLOGOPTIONS ALTLOGDEST /mysql/node3/data/mysql-bin.index
TABLE smpp7.sent_sms;
GGSCI>ADD RMTTRAIL /u01/app/oracle/oradata/GG/dirdat/D2, EXTRACT SMPP7, MEGABYTES 5
GGSCI>INFO RMTTRAIL *
GGSCI>START EXTRACT SMPP7
Replicat
GGSCI>ADD REPLICAT smpp7, EXTTRAIL /u01/app/oracle/oradata/GG/dirdat/D2, checkpointtable ggs_owner.checkpoint
3) edit params smpp7
REPLICAT SMPP7
USERID *******, PASSWORD *******
ASSUMETARGETDEFS
HANDLECOLLISIONS
SOURCEDEFS /u01/app/oracle/oradata/GG/dirdef/smpp7.def
DISCARDFILE /u01/app/oracle/oradata/GG/dirrpt/smpp7.dsc, PURGE
MAP "smpp7.sent_sms", TARGET MYSQL_SMPP7.sent_sms, COLMAP (usedefaults,COMPRESS_=compress,SERVICE=@STRCAT(service,"_sms"));
GGSCI>START REPLICAT smpp7
I have given full rights to MySQL user:
GRANT ALL PRIVILEGES ON *.* TO '**********'@'localhost' IDENTIFIED BY 'kannel' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO '**********'@'10.168.20.253' IDENTIFIED BY 'kannel' WITH GRANT OPTION;
Can you please help me to get through this problem.
Regards, Imran