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
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 DBA_JAF • Databases, Golden Gate, Oracle, Replication, SQL Server • 0