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
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
# 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.
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.
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.
ReplyDeleteThank You,
Website Development Company in Delhi NCR