Install Oracle Goldengate on LINUX 11gr2

Here I’m going to install oracle Goldengate 11.2.1.0.3  on my oracle 11.2.0.2 database, Linux 64 bit

If it is a RAC, then install in a common location

Download Goldengate Software and move the ZIP file to Linux server

Copy software(ZIP file) to some directory in the database and unzip the file

$ Mkdir ggate

$ cd ggate

$ unzip V34339-01.zip

Archive:  V34339-01.zip

  inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar

  inflating: Oracle_GoldenGate_11.2.1.0.3_README.doc

  inflating: Oracle GoldenGate_11.2.1.0.3_README.txt

  inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.3.pdf

$  tar -xvof fbo_ggs_Linux_x64_ora11g_64bit.tar

$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

Create Sub directories using "CREATE SUBDIRS”, this will create all required sub directories for oracle goldengate.

GGSCI (oracledev.domain.com) 1> CREATE SUBDIRS

Creating subdirectories under current directory /opt/oracle/GG

Parameter files                /opt/oracle/GG/dirprm: already exists

Report files                   /opt/oracle/GG/dirrpt: created

Checkpoint files               /opt/oracle/GG/dirchk: created

Process status files           /opt/oracle/GG/dirpcs: created

SQL script files               /opt/oracle/GG/dirsql: created

Database definitions files     /opt/oracle/GG/dirdef: created

Extract data files             /opt/oracle/GG/dirdat: created

Temporary files                /opt/oracle/GG/dirtmp: created

Stdout files                   /opt/oracle/GG/dirout: created

GGSCI (oracledev.domain.com) 2>

Then we need to create a database user and tablespace on both Source and TARGET servers which will be used by the GoldenGate Manager, Extract and Replicat processes.

$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 14 20:59:57 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace ggs_data datafile '/opt/oracle/ggs_data01.dbf' size 100m autoextend on next 10m maxsize unlimited;

Tablespace created.

SQL> create user gguser identified by gguser default tablespace ggs_data temporary tablespace temp;

User created.

SOURCE grants:

SQL>  grant create session to gguser;

        grant connect,resource to gguser;

  GRANT ALTER ANY TABLE TO GGUSER;

  GRANT CREATE ANY TABLE TO GGUSER;

  GRANT CREATE TABLE TO GGUSER;

  GRANT DELETE ANY TABLE TO GGUSER;

  GRANT DROP ANY TABLE TO GGUSER;

  GRANT FLASHBACK ANY TABLE TO GGUSER;

  GRANT INSERT ANY TABLE TO GGUSER;

  GRANT SELECT ANY DICTIONARY TO GGUSER;

  GRANT SELECT ANY TABLE TO GGUSER;

  GRANT QUOTA UNLIMITED ON GGS_DATA TO GGUSER;

  GRANT UPDATE ANY TABLE TO GGUSER;

TARGET grants:

GRANT CREATE SESSION to gguser;

GRANT ALTER SESSION to gguser;

GRANT ALTER SYSTEM to gguser;

GRANT RESOURCE to gguser;

GRANT CONNECT to gguser;

GRANT SELECT ANY DICTIONARY to gguser;

GRANT SELECT ANY TABLE to gguser; 

GRANT INSERT,UPDATE, DELETE ON TARGET_SCHEMA.* to gguser;

GRANT CREATE TABLE to gguser;

NOTE:  Please refer below Oracle Goldengate installation Doc for the GGUSER grants on Source and Target side
  http://docs.oracle.com/cd/E35209_01/doc.1121/e35957.pdf