OracleGoldenGate learning-heterogeneous platform synchronization (from Mysql to Oracle)

OracleGoldenGate learning-heterogeneous platform synchronization (from Mysql to Oracle): The Source uses the Mysql database, the target uses the Oracle database 1, OGG installation configuration (source) 1, OGG downloads edelivery. o

Oracle goldengate learning-heterogeneous platform synchronization (Mysql to Oracle): The Source uses Mysql database, the target uses Oracle database 1, OGG installation configuration (source) 1, OGG download https://edelivery.o

Oracle GoldenGate learning-heterogeneous platform synchronization (from Mysql to Oracle)

: The Source uses the Mysql database and the target uses the Oracle database.

1. install and configure OGG (source)

1. Download OGG

Https://edelivery.oracle.com/EPD/Download/get_form? Egroup_aru_number = 14841438

Https://edelivery.oracle.com/EPD/Download/get_form? Egroup_aru_number = 14841440

[Oracle @ ogg ogg_ms] $ uname-

Linux ogg 2.6.32-71. el6.i686 #1 SMP Wed Sep 1 01:26:34 EDT 2010 i686 i686 i386 GNU/Linux

[Oracle @ ogg ~] $ Cd/u01/ogg_ms/[oracle @ ogg ogg_ms] $ lsggs_Linux_x86_MySQL_32bit.tar [oracle @ ogg ogg_ms] $ tar xvf ggs_Linux_x86_MySQL_32bit.tar

[Oracle @ ogg ogg_ms] $. /ggsciOracle GoldenGate Command Interpreter for MySQLVersion 11.2.1.0.1 oggcore_11.2.1.0.20.platforms_120423.0230linux, x86, 32bit (optimized), MySQL Enterprise on Apr 23 2012 04: 29: 30 Copyright (C) 1995,201 2, oracle and/or its affiliates. all rights reserved. GGSCI (ogg) 1> create subdirsCreating subdirectories under current directory/u01/ogg_msParameter files/u01/ogg_ms/dirprm: already existsReport files/u01/ogg_ms/dirrpt: createdCheckpoint files/u01/ogg_ms/tasks: createdProcess status files/u01/ogg_ms/dirpcs: createdSQL script files/u01/ogg_ms/dirsql: createdDatabase definitions files/u01/ogg_ms/dirdef: createdExtract data files/u01/ogg_ms/dirdat: createdTemporary files/u01/ogg_ms/dirtmp: createdStdout files/u01/ogg_ms/dirout: created

Ii. Database Configuration

Source: mysql Database Configuration

Database Configuration File: [root @ ogg ~] # Cat/etc/my. cnf # Replication Master Server (default) # binary logging is required for replicationlog-bin = mysql-bin # binary logging format-mixed recommended # binlog_format = mixed binlog_format = row start Database Service [root @ ogg ~] # Service mysql startstartstarting MySQL Connection database [OK] [root @ ogg ~] # Mysql-h localhost-u mysql-pEnter password: Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 1 Server version: 5.6.4-m7-log Source distributionCopyright (c) 2000,201 0, Oracle and/or its affiliates. all rights reserved. this software comes with absolutely no warranty. this is free software, and you are welcome to modify and redistribute it under the GPL v2 licenseType 'help; 'or' \ H' for help. type '\ C' to clear the current input statement. mysql> show databases; + -------------------- + | Database | + -------------------- + | information_schema | mysql | performance_schema | test | + -------------------- + 4 rows in set (0.00 sec) mysql> use test; Database changedmysql> show tables; Empty set (0.00 sec) create a test table (the storage engine uses innodb) mysql> create table test2 (id int, name char (10 )) engine = innodb; Query OK, 0 rows affected (0.02 sec) mysql> show tables; + ---------------- + | Tables_in_test | + ------------------ + | test2 | + ---------------- + 1 row in set (0.00 sec) mysql> select * from test2; Empty set (0.00 sec)