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.
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;
