Tuesday, September 11, 2012

Golden Gate (GG) 112101 Installation on AIX 5.3

$ oslevel -g
Fileset                                 Actual Level        Maintenance Level

Accept the License Agreement and download following file

2.  Create Installation Directory

$ mkdir -p /u40/oracle/ggs

3.  FTP GG Media to above folder with filezilla or any other ftp software

$ cd /u40/oracle/ggs
$ ls -tlr
total 97592
-rw-r-----    1 oracle   oinstall   49963147 Sep 10 10:46 ogg112101_ggs_AIX_ppc_ora11g_64bit.zip

4.  Unzip the media
$ unzip ogg112101_ggs_AIX_ppc_ora11g_64bit.zip

5.  Untar the tar file
$ tar -xvof ggs_AIX_ppc_ora11g_64bit.tar

6.  Add installation directory and database library path to environment. Better to add in profile.

export PATH=$PATH:/u40/oracle/ggs
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u40/oracle/ggs
7.  Make sure Oracle Home and SID are set as GG owner will connect to this database by default.
$ echo $ORACLE_SID

8.  Start the GG Command Interpreter
$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version OGGCORE_11.
AIX 5L, ppc, 64bit (optimized), Oracle 11g on Apr 23 2012 05:03:51

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

9.  GGSCI (nmcretek02) 1>CREATE SUBDIRS

Creating subdirectories under current directory /u40/oracle/ggs

Parameter files                /u40/oracle/ggs/dirprm: already exists
Report files                   /u40/oracle/ggs/dirrpt: created
Checkpoint files               /u40/oracle/ggs/dirchk: created
Process status files           /u40/oracle/ggs/dirpcs: created
SQL script files               /u40/oracle/ggs/dirsql: created
Database definitions files     /u40/oracle/ggs/dirdef: created
Extract data files             /u40/oracle/ggs/dirdat: created
Temporary files                /u40/oracle/ggs/dirtmp: created
Stdout files                   /u40/oracle/ggs/dirout: created

10.     GGSCI (nmcretek02) 2> exit

11.     Now we have to create the GG Admin or owner user and its default tablespace

$ sqlplus / as sysdba
select instance_name from v$instance;
select NAME from v$datafile;
create tablespace ggs_data datafile '/u40/oracle/PRODM/db/apps_st/data/ggs_data01.dbf' size 200M;
create user ggs_owner identified by ggs_owner  default tablespace ggs_data temporary tablespace temp;
grant connect,resource to ggs_owner;
grant select any dictionary, select any table to ggs_owner;
grant create table to ggs_owner;
grant flashback any table to ggs_owner;
grant execute on dbms_flashback to ggs_owner;
grant execute on utl_file to ggs_owner;

12.     To confirm that the GoldenGate user we created is able to connect to the Oracle database

$ ggsci
> DBLOGIN USERID ggs_owner, PASSWORD ggs_owner
> exit
13.     Enable supplemental logging at the database level otherwise we will get this error when we try to start the Extract process
sqlplus / as sysdba

14.     Please go through following documentation for more details

Oracle® GoldenGate
Oracle Installation and Setup Guide 11g Release 2 (

Oracle® GoldenGate
Windows and UNIX Administrator’s Guide 11g Release 2 (

No comments:

Post a Comment