One-way replication from Oracle to MySQL through GoldenGate

Environment: I use the VBOX virtual machine, a host that has installed the Oracle database and GOLDENDGATE. The other one only installs the ORACLE database.
Configure the database environment, goldengate users, and install GoldenGate. For more information, see configure OGG between two Oracle databases-synchronization DDL is not configured.

1. Install MYSQL to install the MYSQL database client:

[Root @ bys2 ~] # Mount/dev/cdrom/mnt/cdrom/
Mount: block device/dev/cdrom is write-protected, mounting read-only
[Root @ bys2 ~] # Rpm-qa mysql
[Root @ bys2 ~] # Cd/mnt/cdrom/
[Root @ bys2 cdrom] # yum-y install mysql
Install the server
[Root @ bys2 cdrom] # yum-y install mysql-server
[Root @ bys2 cdrom] # rpm-qa mysql *
Mysql-5.0.77-4.el5_6.6
Mysql-server-5.0.77-4.el5_6.6
##########################
Start MYSQL
[Root @ bys2 cdrom] # service mysqld status
Mysqld is stopped
[Root @ bys2 cdrom] # service mysqld start
Starting MySQL: [OK]

Create users and tables for synchronization

[Oracle @ bys2 ~] $ Mysql-u root
Mysql> show databases;
+ -------------------- +
| Database |
+ -------------------- +
| Information_schema |
| Mysql |
| Test |
+ -------------------- +
3 rows in set (0.00 sec)
Mysql> create database oggtest;
Query OK, 1 row affected (0.00 sec)
Mysql> use oggtest;
Database changed
Mysql> grant all privileges on *. * to 'root' @ '% 'identified by '123 ';
Query OK, 0 rows affected (0.01 sec)
Mysql> grant all privileges on *. * to 'ogn' @ '% 'identified by 'ogn ';
Query OK, 0 rows affected (0.00 sec)
Mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
Mysql> use oggtest
Database changed
Mysql> show tables;
Empty set (0.00 sec)
Mysql> create table test5 (aa int primary key) engine = innodb;
Query OK, 0 rows affected (0.02 sec)
Mysql> show tables;
+ ------------------- +
| Tables_in_oggtest |
+ ------------------- +
| Test5 |
+ ------------------- +
1 row in set (0.00 sec)
Mysql> select * from test5;
Empty set (0.01 sec)
After exiting, use [oracle @ bys2 mysqlogg] $ mysql-u root-p for the login test. Then, confirm that you can log on using the root user and password.
If you cannot log on, you can refer to: http://blog.csdn.net/q947817003/article/details/13295099
######################################## ###
2. Install OGG-FOR-MYSQL
[Oracle @ bys2 ~] $ Tar-xvf ggs_Linux_x86_MySQL_32bit.tar-C/u01/mysqlogg/
[Oracle @ bys2 mysqlogg] $ pwd
/U01/mysqlogg
[Oracle @ bys2 mysqlogg] $./ggsci
Oracle GoldenGate Command Interpreter for MySQL
Version 11.2.1.0.1 oggcore_11.2.1.0.20.platforms_120423.0230
Linux, 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 (bys2.oel.com) 1> create subdirs
Creating subdirectories under current directory/u01/mysqlogg
Parameter files/u01/mysqlogg/dirprm: already exists
Report files/u01/mysqlogg/dirrpt: created
Checkpoint files/u01/mysqlogg/dirchk: created
Process status files/u01/mysqlogg/dirpcs: created
SQL script files/u01/mysqlogg/dirsql: created
Database definitions files/u01/mysqlogg/dirdef: created
Extract data files/u01/mysqlogg/dirdat: created
Temporary files/u01/mysqlogg/dirtmp: created
Stdout files/u01/mysqlogg/dirout: created

For more details, please continue to read the highlights on the next page:

Management OGG-HA in RAC Environment

Configure OGG synchronization in RAC Environment

GoldenGate unidirectional table DML Synchronization

Oracle GoldenGate series: restoration principles of Extract processes

Oracle GoldenGate installation Configuration

OGG-01004 OGG-1296 error for Oracle goldengate

1 2 3 4 Next Page