Oracle GoldenGate Command Interpreter for MySQL
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
Linux, x64, 64bit (optimized), MySQL Enterprise on Dec 11 2015 16:23:51
When Starting Extract on MySQL, when extract gets to the last binlog, it abends.
Here is my extract settings (very simple one table).
2016-07-21 17:28:21 ERROR OGG-00146 Oracle GoldenGate Capture for MySQL, ext01.prm: Call to VAMInitialize returned with error status 600: VAM Client Report <CAUSE OF FAILURE : Failed to open binary log for /home/ggs/logs//webcart03-bin.063615
WHEN FAILED : While initializing binary log subsystem
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.
2016-07-21 17:28:21 ERROR OGG-01668 Oracle GoldenGate Capture for MySQL, ext01.prm: PROCESS ABENDING.
2016-07-21 17:36:22 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (ggs): edit params ext01.
2016-07-21 18:32:40 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (ggs): edit params ext01.
2016-07-21 18:33:21 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (ggs): edit params ext01.
-- Identify the Extract group:
EXTRACT EXT01
-- Specify database login information as needed for the database:
DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306
SOURCEDB wp_441_dba@127.0.0.1, USERID root, PASSWORD k55p0ut
-- Log all scheduling columns if using integrated Replicat
-- LOGALLSUPCOLS
-- Specify the local trail that this Extract writes to
-- and the encryption algorithm:
-- ENCRYPTTRAIL algorithm
TRANLOGOPTIONS ALTLOGDEST /home/ggs/logs/webcart03-bin.index
EXTTRAIL /home/ggs/dirdat/et
-- Specify tables and sequences to be captured:
-- SEQUENCE [container.|catalog.]owner.sequence;
TABLE wp_441_dba.wp_users;