Here we are 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
