Thursday, July 25, 2013

Installation and configuration of Golden Gate

To install Golden gate on both the Source and Target database server you need to download the GG software from the following location.
http://download.oracle.com/otn/goldengate/112101/ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip?AuthParam=1374732728_ade41ebbc2342d3fce1f03b19aaa8810
Once downloaded, unzip the software using linux 'unzip' command.
# unzip ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip

It will create file 'fbo_ggs_Linux_x86_ora11g_32bit.tar'

Now create a Golden Gate home directory and extract that tar file over there.
In my case I have created '/u01/app/GG' as a GG home and extract that file using 'tar' over there.
mkdir -p /u01/app/GG/
tar -xvf fbo_ggs_Linux_x86_ora11g_32bit.tar

# cd /u01/app/GG

now login through the Golden gate command prompt.
#./ggsci

Create the required subdirectories for Golden Gate using following command.
GGSCI (source) 1> create subdirs
Creating subdirectories under current directory /u01/app/GG

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

Now create the Golden Gate database user schema and grant all the necessary privilege to that user.

SQL> create user gger identified by gger
  2  default tablespace ggate
  3  temporary tablespace temp;
User created.

SQL> grant connect,resource to gger;
Grant succeeded.

SQL> grant select any dictionary to gger;
Grant succeeded.

SQL> grant select any table to gger;
Grant succeeded.

SQL> grant execute on utl_file to gger;
Grant succeeded.

SQL> grant execute on dbms_flashback to gger;
Grant succeeded.

SQL> grant create any table to gger;

Grant succeeded.

SQL> grant insert any table to gger;

Grant succeeded.

SQL> grant update any table to gger;

Grant succeeded.

SQL> grant delete any table to gger;

Grant succeeded.

SQL> grant drop any table to gger;

Grant succeeded.

SQL> grant execute on dbms_flashback to gger;

Grant succeeded.

SQL> grant flashback any table to gger;

Grant succeeded.

SQL> alter database add supplemental log data;
Database altered.

GGSCI (source.cybage.com) 1> dblogin userid gger, password gger
Successfully logged into database.

Perform the above steps over target database server.

1 comment:

  1. Its very interesting blog and there are very useful information. I study your complete blog and I Find some important points which are very useful for us.
    Thank You,
    Website Development Company in Delhi NCR

    ReplyDelete