Thursday, 22 December 2016

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

2 comments:

  1. Unable to log db using dblogin.getting error unable to initialize database connection because of error ora 12557 tns adapter not loadable

    ReplyDelete
  2. what is the use of pump process in goldengate ?

    ReplyDelete

Oracle Transparent Data Encryption (TDE) On Exadata

Oracle Transparent Data Encryption (TDE) enables the organizations to encrypt sensitive application data on storage media completely transp...