Installing goldengate is very easy.  We are using V11.2.1.0.3 for Oracle 11g on Linux x86-64 for this Tutorial. Below steps need to be done on both source and targer side, i.e on extract side and replicate side.

If you are new to golden gate Read Introduction to golden gate and its architecture

 

1. Download the goldengate software:

 

Navigate tohttp://edelivery.oracle.com and select the product as oracle goldengate

 

2.unzip the downloaded goldengate file and set the path

 

 

3. create subdirs

 

 

 

4.Create tablespace on both Source and Target Databases

 

5. Database user for Oracle GoldenGate processes

                   Create a database user that is dedicated to Oracle GoldenGate Manager, Extract, Replicat processes. It can be the same user for all of the Oracle GoldenGate processes that must connect to a database. In our case the user is “GGATE”

6 . Enable archivelog mode for the database:

Make sure the database is in archive log mode: – How to enable archive mode 

6.Enable supplemental logging at database level:

              Usually insert and delete statement involves complete row change. But update can be done on a particular set of columns.  So Redo logs don’t capture sufficient information for update statements , i.e oracle logs only changed columns for update operation in redo. Without sufficient info , goldengate can’t find which row to be updated. So supplemental logging enables in capturing additional information for update operations in redo logs.

 Below command will enable minimum level of supplemental logging at database level.

 

 

Enable force_logging for the database:

 

Check the gg login

 

 

SEE ALSO:

How to configure manager process in oracle goldengate: