My Oracle Support Banner

How to Replicate Data Between Oracle and MySQL Database? (Doc ID 1605674.1)

Last updated on JANUARY 19, 2020

Applies to:

Oracle GoldenGate - Version 10.4.0.0 and later
Information in this document applies to any platform.

Goal

 This note describes a set up of a GoldenGate replication between Oracle and MySQL

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
 1. Pre-requisites
 2. GoldenGate Manager
 3. GoldenGate demo tables
 
3.1 The demo tables for the Oracle database
 3.2 Creating the MySQL demo tables
 4. Oracle database pre-requisites
 4.1 Verify Oracle DB connection
 4.2 Add the TRANDATA
 5. GoldenGate initial load (no data pump process configured to keep it simple)
   


6. The SOURCEDEFS file
 6.1 DEFGEN parameter file
 6.2 Defgen command
 6.3 COPY DEFGEN file
   

7. MySQL initial load replicat process
   


8. Start Initial Load Extract process
 9. GoldenGate Extract for the Oracle database
 9.1 GoldenGate extract parameter file
   
9.2 Add GoldenGate extract
 9.3 start GoldenGate extract
 9.4 Status extract
   


-----------------------------------------------------------------------------------------
10 MySQL replicat
 10.1 MySQl replicat parameter file
 10.2 add and start MySQL REPLICAT process
   

10.3 REPLICAT status
   


11. Verify the replication
 11.1 Update Oracle table content
   
11.2 check replicat statistics


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.