Replication

May 2 2020

Migrate on-premises Oracle 12c running in Windows to AWS EC2 Linux using Oracle Data Guard and SSH tunel

In this post I will walk you trough the steps to migrate a database Oracle 12.1.0.2.0 running in Windows 7 to AWS EC2 running Linux CentOS release 6.9 using Oracle Data Guard 12c The below diagram shows a Dataguard architecture of replication sending the redo streams trough a SSH Tunnel from the Primary Database (source db) to the Standby Database (target db) in AWS EC2. Current Environment SOURCE TARGET Operating System Microsoft Windows 7 Enterprise Edition 64 bits CentOS release Read More

By • Amazon Web Services (AWS), Cloud, Data Guard, Databases, Migration, Oracle, Replication • 0

Apr 23 2020

Replication between SQL Server 2012 CDC and Oracle 12c using GoldenGate 19c

In this post I will walk you trough the steps to configure Oracle GoldeGate 19 to replicate transactions between Microsoft SQL Server 2012 using CDC Capture replication and Oracle 12c. We are going to build a simple unidirectional replication of the table ORG.DEPT between two heterogeneous databases. The below diagram shows the GoldenGate architecture of a replication unidirectional from SQL Server database to Oracle database. Operating System Database Database Name GoldenGate version Oracle GoldenGateHome GoldenGate installer IP Database Server Manager Read More

By • Databases, Golden Gate, Oracle, Replication, SQL Server • 0

Apr 21 2020

Install Oracle GoldenGate 12c for PostgresSQL 12.2 in AWS EC2 RHEL 8

In this post I will install GoldenGate 12c for PostgreSQL 12.2 in AWS EC2 in Red Hat Linux 8. I going to install Oracle GoldenGate 12c with the below specifications: Operating System: Red Hat Enterprise Linux release 8.0 (Ootpa) Database: Postgress 12.2 GoldenGate version: 12.2.0.2.2 GoldeGate installer: 122022_ggs_Linux_x64_PostgreSQL_64bit.zip 1. Create the GoldenGate Home directory and setup the environment variable ($GGH) 2. Download Oracle GoldenGate 10.1.0.0.4 for Oracle (64 bits) 122022_ggs_Linux_x64_PostgreSQL_64bit.zip from Oracle website. 3. Transfer the zip file 122022_ggs_Linux_x64_PostgreSQL_64bit.zip to Read More

By • Amazon Web Services (AWS), Cloud, Databases, PostgreSQL, Replication • 0

Apr 18 2020

Install Oracle Goldengate 19c for Oracle Linux.

In this post I will install GoldenGate 19c for Oracle 12c in Linux 7.1, this will be the start point for the next post that replicate data from SQL Server 2012 to Oracle 12c. I going to install Oracle GoldenGate in the below environment: Operating System: Oracle Linux Server 7.1 Database: Oracle 12c (12.1.0.2.0) GoldenGate version: 19.1.0.0.4 GoldenGate installer: 191004_fbo_ggs_Linux_x64_shiphome.zip 1. Download Oracle GoldenGate 10.1.0.0.4 for Oracle (64 bits) 191004_fbo_ggs_Linux_x64_shiphome.zip from Oracle website. 2. Transfer the zip 91004_fbo_ggs_Linux_x64_shiphome.zip to a Read More

By • Databases, Oracle, Replication • 0

Apr 15 2020

Install Oracle Goldengate 19c for Microsoft SQL Server.

In this post I will guide you trough the steps to install and configure Goldengate 19c for Microsoft SQL Server 2012, this will be the start point for the next post that replicate data from SQL Server 2012 to Oracle 12c. I going to install Oracle GoldenGate in the below environment: Operating System: Windows 7 Professional Database: SQL Server 2012 Enterprise Edition GoldenGate version: 19.1.0.0.3 GoldenGate installer: 191003_ggs_Windows_x64_MSSQL_64bit_CDC.zip. 1. Prerequiste According to Oracle documentation using the Microsoft SQL Server Native Read More

By • Databases, Replication, SQL Server • 0