Oracle 11g GoldenGate Installation

Steps for Installation of GoldenGate Software on Source and Target Server & Creation of Manager Process.


1. Install the Oracle software on the box. The software from can be found on and install it.

2. Create folders for GG software binaries for both source & target.

            Source: /d01/app/oracle/product/11.2.0/GG1 – Source
            Target: /d01/app/oracle/product/11.2.0/GG2 – Target

3. Copy the software on both Source and Target location respectively

            Source : /d01/app/oracle/product/11.2.0/GG1(Source)
            Target : /d01/app/oracle/product/11.2.0/GG2(Target)

4. Unzip the software files. Unzip

   on both source and Target

5. After unzip , run untar command for extract the files.

             tar –xf fbo_ggs_Linux_x64_ora11g_64bit.tar

6.Create .profile_source & .profile_target under user home director (/home/oragg) for both Source and Target


            Export ORACLE_SID=source
            export ORACLE_HOME=/d01/app/oracle/product/11.2.0/dbhome_1
            export PATH=$ORACLE_HOME/bin:$PATH
            export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/d01/app/oracle/product/11.2.0/GG1


            export ORACLE_SID=target
            export ORACLE_HOME=/d01/app/oracle/product/11.2.0/dbhome_1
            export PATH=$ORACLE_HOME/bin:$PATH
            export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/d01/app/oracle/product/11.2.0/GG2

7.Go to the source machine, location : /d01/app/oracle/product/11.2.0/GG1 and run the below command.

            $ ./ggsci

            GGSCI(source)1>create subdirs
            (Note : Need to run on both Source & Target)

8.Enable Minimal logging only on Source database.

            Sql> alter database add supplemental log data;

9.Create a user ggate and run the below commands

            SQL> grant connect,resource,unlimited Tablespace to ggate;
            SQL> grant execute on utl_file to ggate;

10.Run the below scripts before start DDL replication.

            (Note: Connect SQL session from GoldenGate Install director, i.e.,
            /d01/app/oracle/product/11.2.0/GG1 & GG2)

            SQL> @marker_setup.sql
            SQL> @ddl_setup.sql
            SQL> @role_setup.sql
            SQL> grant GGS_GGSUSER_ROLE to ggate;
            SQL> @ddl_enable.sql

11.Create a Manager process on Source and Target.


            GGSCI> info mgr
            GGSCI> edit params mgr
            Port 7809
            GGSCI> start mgr


            GGSCI> info params mgr
            GGSCI> edit params mgr
            Port 7810
            GGSCI> start mgr

12.Create a user Sender on Source database and Receiver on Target database for replication. ( This is for Replication Testing Tables)

No Comments

Leave a Reply

Your email address will not be published. Required fields are marked *