in goldengate 12c, oracle introduced universal installed(OUI) for installation, which makes it simpler.The installation need to be done on both source and target hosts, where gg process will be running.

Lets see the steps.

         1. Download the goldengate software for the appropriate os platform.

Download the goldengate 12c software from edelivery.

       2.  unzip the V46695-01.zip and execute runInstaller[both SOURCE & TARGET ]

 You can select whether your database is 11g or 12c.

ggins1
 

Software Location – This will be the goldengate Home location

Database Location – This is your database Home location

Manager – If you select start manager and the specify the port, then once installation is done, manager process will be started automatically.

 ggins2

 

 

ggins3

 

 

ggins4

 

 

ggins5

 
 

 

 

3.Create tablespace on both Source and Target Databases

4. Create database user for goldengate on extract side [ SOURCE DB]

                   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_USER”

 5.Create database user for goldengate on replicat side [ TARGET DB]

6. Enable archivelog mode for the database:[SOURCE DB]

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

7.Enable supplemental logging at database level:[SOURCE DB]

              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 the 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 a minimum level of supplemental logging at the database level.

8.Enable force_logging for the database:[ SOURCE]

9.Check the gg login[SOURCE & TARGET]

10.Create checkpoint table on REPLICAT side[ TARGET]

11.Update ./GLOBALS file on REPLICATE side [ TARGET]

Where ALLOWOUTPUTDIR is the path in the replicate side, where trail files will be copied.

 

With this installation of goldengate with required basic configuration has been completed.