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
otn.oracle.com.Unzip 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 ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip 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

            ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip 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

            .profile_source:

            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

            .profile_target:

            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.

            Source:

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

            Target:

            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 *