GoldenGate Installation : 11.2

Golden Gate Software:

GG Software:        Oracle Golden Gate v11.2.1.0.20 or Higher
Oracle Database:    Oracle 11gR2
Operating System:   Linux x86_64

 Source database Pre-request : 

ARCHIVE LOG LIST -- Database must be archive log mode
ADD SUPPLEMENTAL LOG DATA -- Enable supplement logging
RECYCLEBIN=OFF – Keep recycle bin off
ENABLE_GOLDENGATE_REPLICATION = TRUE -- Enable GG parameter

Installation of GG binaries: Source and Target  :

Setup environment:
export GG_HOME=/opt/oracle/ggs
export PATH=$PATH:/opt/oracle/ggs
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/oracle/ggs

Download Golden Gate software from Oracle.com
cd $GG_HOME
unzip p18322848_1121020_Linux-x86-64.zip
tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar
cd $GG_HOME

./ggsci
  GGSCI (nydevdb01) 1> create subdirs
  Creating subdirectories under current directory /opt/oracle/ggs
  Parameter files                /opt/oracle/ggs/dirprm: already exists
  Report files                   /opt/oracle/ggs/dirrpt: created
  Checkpoint files               /opt/oracle/ggs/dirchk: created
  Process status files           /opt/oracle/ggs/dirpcs: created
  SQL script files               /opt/oracle/ggs/dirsql: created
  Database definitions files     /opt/oracle/ggs/dirdef: created
  Extract data files             /opt/oracle/ggs/dirdat: created
  Temporary files                /opt/oracle/ggs/dirtmp: created
  Stdout files                   /opt/oracle/ggs/dirout: created
  GGSCI (nydevdb01) 2>exit
  mkdir discard
  Golden Gate software has been successfully installed.

Create Golden Gate Users: Source and Target:

 Source User Name: GGS_EXT
Target User Name: GGS_REP

Create a Table space GG_DATA – 2G Size –AUTOEXTEND ON
CREATE USER GGS_EXT IDENTIFIED BY GG_USER
DEFAULT TABLESPACE GG_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;

GRANT CONNECT, RESOURCE TO GG_USER;
GRANT SELECT ANY DICTIONARY, SELECT ANY TABLE TO GG_USER;
GRANT SELECT ANY TRANSACTION TO GG_USER;
GRANT FLASHBACK ANY TABLE TO GG_USER;
GRANT EXCUTE ON DBMS_FLASHBACK TO GG_USER;
GRANT EXECUTE ON UTL_FILE TO GG_USER;
GRANT CREATE ANY TABLE TO GG_USER;
GRANT INSERT ANY TABLE TO GG_USER;
GRANT UPDATE ANY TABLE TO GG_USER;
GRANT DELETE ANY TABLE TO GG_USER;
GRANT DROP ANY TABLE TO GG_USER;
GRANT UNLIMITED TABLESPACE TO GG_USER;
EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('GG_USER');

 GG Installation Verification: 

./ggsci
GGSCI> START MGR
GGSCI> INFO ALL
GGSCI>DBLOGIN USERID GGS_EXT, PASSWORD *****  
Successfully logged into database.

If need DDL Replication, run following Golden Gate scripts at Source database : 

 sqlplus / as sysdba
@marker_setup.sql  Enter Oracle GoldenGate schema name:GG_USER
@ddl_setup.sql     Enter Oracle GoldenGate schema name:GG_USER
@role_setup.sql    Enter Oracle GoldenGate schema name:GG_USER
grant ggs_ggsuser_role to GG_USER;
@ddl_enable;
--@ddl_pin GGATE; (optional)
--@sequence (optional)