Oracle Golden Gate 12.1.2.1.0 Installation on Windows Server 2012 R2

Overview:

Oracle Golden Gate provides very fast replication of data by reading transaction logs and writing the changes to one or more target databases in a homogeneous and heterogeneous environment. It is useful for High Availability Architectures and especially for Data Warehouse and Decision Support Systems. Thus, the variety of techniques and methods spreads from unidirectional environments for query offloading/reporting to bidirectional or Peer-to-Peer architectures in an active-active fashion.

Environment Details

 

Hostname	PROD-DB1
Ip Address	10.78.101.3
Operating system	Windows server 2012 R2
Environment	production
Oracle Home	D:\oracle\11204\product\11.2.0\dbhome_1
Golden Gate stage	D:\oracle\gg_stage
Golden Gate Home	D:\oracle\gg_home\product\12.1.2.1\ggfor11
OGG Processes	e_shl01s,p_shl01s

Steps to Install Oracle GoldenGate Software

 1. Create Oracle Golden Gate staging directory and home directory.

D:\>cd oracle

D:\oracle>md gg_stage gg_home

D:\oracle>cd gg_home

D:\oracle\gg_home>md product

D:\oracle\gg_home>cd product

D:\oracle\gg_home\product>md 12.1.2.1

D:\oracle\gg_home\product>cd 12.1.2.1

D:\oracle\gg_home\product\12.1.2.1>md oggfor11

2.      Copy the media files to the Server.

3.      Download and Install Microsoft visual c++

 4.      Unzip the Golden Gate media and click on setup.exe file to initiate installation.

5.      Choose on which database version you installing golden gate.

6.      Provide Oracle Golden Gate Home and Oracle Database Home location and port number.

7.      Verify Summary and click on Install. 

Progress Window

 

8.      Installation successful then click close.

9.      Once Installation done, login to Golden gate from gg home and check the version.

Conclusion: 

In this Article we have performed Oracle Golden Gate Installation on Windows operating system. We have seen Installing Oracle Golden Gate Software on Windows is very simple and straight forward using Graphical Interface.

About Author

Name: Mirza Hidayathullah Baig
Designation: Senior Database Engineer
Organization: NetSoftMate IT Solutions.