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

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: