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.
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:oracle11204product11.2.0dbhome_1
|
|
Golden Gate stage
|
D:oraclegg_stage
|
|
Golden Gate Home
|
D:oraclegg_homeproduct12.1.2.1ggfor11
|
|
OGG Processes
|
e_shl01s,p_shl01s
|
Steps to Install Oracle GoldenGate Software
1. Create
Oracle Golden Gate staging directory and home directory.
Oracle Golden Gate staging directory and home directory.
D:>cd oracle
D:oracle>md gg_stage gg_home
D:oracle>cd gg_home
D:oraclegg_home>md product
D:oraclegg_home>cd product
D:oraclegg_homeproduct>md 12.1.2.1
D:oraclegg_homeproduct>cd 12.1.2.1
D:oraclegg_homeproduct12.1.2.1>md oggfor11
2.
Copy the media files to the Server.
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.
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.