Extract gets ABENDED without any error in log file and info
Dear All,
I am working on replication from MySQL (source) database to Oracle (target) using Golden Gate.
Both systems are Linux based.
MySQL Version : Server version: 5.5.19-enterprise-commercial-advanced-log MySQL Enterprise Server
Oracle Version : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Golden Gate is installed and manager is running on source and target systems.
On the MySQL side I added a extract using the following commands:
GGSCI>add extract MSEXT11, tranlogs, begin now
GGSCI>add exttrail /root/sandboxes/GG/dirdat/m1, extract MSEXT11
GGSCI>edit params MSEXT11
EXTRACT MSEXT11
DBOPTIONS HOST x.x.x.x, CONNECTIONPORT 3307
SOURCEDB kannel, USERID ****, PASSWORD ****
EXTTRAIL /root/sandboxes/GG/dirdat/m1
TRANLOGOPTIONS ALTLOGDEST /root/sandboxes/multi_msb_5_5_19/node3/data
TABLE "contactgroups";
TABLE "contacts";
TABLE "dlr";
Now when I start this extract:
GGSCI>start MSEXT11
Immediately the process gets ABENDED
Here are the last lines from view report MSEXT11
*2012-08-13 10:46:38 INFO OGG-01055 Recovery initialization completed for target file /root/sandboxes/GG/dirdat/m1000002, at RBA 1010.*
*2012-08-13 10:46:38 INFO OGG-01478 Output file /root/sandboxes/GG/dirdat/m1 is using format RELEASE 10.4/11.1.*
*2012-08-13 10:46:38 INFO OGG-01026 Rolling over remote file /root/sandboxes/GG/dirdat/m1000002.*
*2012-08-13 10:46:38 INFO OGG-01053 Recovery completed for target file /root/sandboxes/GG/dirdat/m1000003, at RBA 1010.*
*2012-08-13 10:46:38 INFO OGG-01057 Recovery completed for all targets.*
*2012-08-13 10:46:38 INFO OGG-00182 VAM API running in single-threaded mode.*
*2012-08-13 10:46:38 INFO OGG-01515 Positioning to begin time Aug 13, 2012 10:19:10 AM.*
No error here, similarly no error shown in the error log file.
Kindly help how to trace and rectify this error.
Thanks, Imran