GoldenGate For MySQL Not Capturing From Source When Using MariaDB (Doc ID 2241356.1)

Last updated on MAY 01, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.1 to 12.2.0.1.0 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Using version 12.2.0.1.0 for MySQL database, running on a RHEL6 Linux x86_64 bit platform, changes to a MariaDB  database resulted with these errors 


00770 Oracle GoldenGate Capture for MySQL, ext1.prm: Failed to connect to MySQL database engine for HOST localhost, DATABASE , USER ggadmin, PORT 4001.
2017-02-21 10:43:56 ERROR OGG-01668 Oracle GoldenGate Capture for MySQL, ext1.prm: PROCESS ABENDING.

 


2017-02-21 10:52:31 ERROR OGG-00146 Oracle GoldenGate Capture for MySQL, ext1.prm: Call to VAMRead returned with error status 600: VAM Client Report WHEN FAILED : While initializing binary log subsystem
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.

 



2017-02-21 12:24:44 ERROR OGG-00146 Oracle GoldenGate Capture for MySQL, ext1.prm: Call to VAMRead returned with error status 600: VAM Client Report WHEN FAILED : While reading log event from binary log
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.
2017-02-21 12:24:44 ERROR OGG-01668 Oracle GoldenGate Capture for MySQL, ext1.prm: PROCESS ABENDING.


2017-02-21 15:52:03 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (oracle): alter extract ext1 begin now.
2017-02-21 15:52:07 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (oracle): info all.
2017-02-21 15:52:12 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (oracle): start extract ext1.



Changes to the MariaDB  table never get replicated to the target database.
 
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms