Oracle to MySQL Heterogeneous Unidirectional Replication Hello Readers, In this article we will see how to make Heterogeneous Unidirectional Replication between Oracle and MySQL. Source : Oracle DB(12.1.0) Target : MySQL(5.7) Download Goldengate Binaries Download GoldenGate binaries from Oracle.com using below link(Oracle) https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Make sure that you… Read More
Dear Readers, In this article we will see the sub-directories of Oracle GoldenGate we have totally 11 subdirs available in Oracle GoldenGate. List of directories : dirdat –> Extract data files dirchk –> Checkpoint file dirtmp –> Temporary files dirrpt –> Report file dirdef –>… Read More
Dear Readers, In this article we will see how to replicate only particular columns to the target table On Source database : Take Dept table and add two more columns
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON SQL> alter table dept add Mobile number(10); Table altered. SQL> alter table dept add Pin number(6); Table altered. SQL> select * from dept; DEPTNO DNAME LOC MOBILE PIN ---------- -------------- ------------- ---------- ---------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON |
Now on source dept have 5 columns(DEPTNO,DNAME,LOC,MOBILE,PIN) On Target database we should add same… Read More
MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log In this article we will see MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log First setup Master -slave replication between two mysql servers. Use below link to setup Master-slave Replication MySQL… Read More
Dear Readers, In this article we will see how to disable DDL Replication in Oracle GoldeGate 12c. On Source database : check processes
|
1 2 3 4 5 |
GGSCI (gg.orcl.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING DPINT 00:00:00 00:00:04 EXTRACT RUNNING EXTINT 00:00:10 00:00:08 |
On Target database : Check processes
|
1 2 3 4 |
GGSCI (gg2.orcl.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REPINT 00:00:00 00:00:03 |
To Disable DDL replication in 12c we need to add DDL include all param inside… Read More
Dear Readers, In this article we will see how to enable DDL Replication in Oracle GoldeGate 12c. On Source database : check processes
|
1 2 3 4 5 |
GGSCI (gg.orcl.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING DPINT 00:00:00 00:00:04 EXTRACT RUNNING EXTINT 00:00:10 00:00:08 |
On Target database :
|
1 2 3 4 |
GGSCI (gg2.orcl.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REPINT 00:00:00 00:00:03 |
To Enable DDl replication in 12c we need to add DDL include all param inside extract… Read More
Dear Readers, In this article we will see how to add new table to existing GoldenGate Oracle to Oracle replication. Please check below link for GG installation for Oracle to Oracle GoldenGate: Oracle to Oracle GoldenGate Unidirectional Replication Now we will add new table to… Read More
MySQL to Oracle Heterogeneous GoldenGate Unidirectional Replication In this article we will see MySQL to Oracle GoldenGate Unidirectional Replication. Prerequisites for Replication: 1.Create two VM’s on your machine 2.Install MySQL on Source Sever. 3.Install Oracle Software and Create database on target. 4.Make sure two Vm’s are… Read More
Dear Readers, In this article we will see Oracle to Oracle GoldenGate Unidirectional Replication. Prerequisites for Replication: 1.Create two Vm/s on your machine 2.Install Oracle Software and Create databases. 3.Make sure two Vm’s are pining each other Node Details : GG1 (SOURCE) 192.168.0.51 gg1.orcl.com gg1… Read More
Dear Readers, In this article we will see How to install Oracle software and creation of database. on RAC Environment . Please check the below link : How to install Oracle software on RAC Environment To Install Oracle software we need download Oracle binaries for… Read More
