ORACLE GOLDENGATE
1) GoldenGate Setup & Configuration On Source & Target Hosts Perform the Following On Source: Unzip the GG Software and Perform the installation & Configuration [oracle@targethost]/data # unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip [oracle@targethost]/data # tar -xvf ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip [oracle@sourcehost]/data/ggate # ./ggsci GGSCI (targethost) 1> create subdirs 1. Ensure The database is in archive log mode 2. Create Necessary tablespace and goldengate user in database SQL> create tablespace ggs_data datafile '/data/GGS/Base/ggs_data01.dbf' size 200m; SQL> create user ggs_owner identified by ggs_owner default tablespace ggs_data temporary tablespace temp; SQL> grant connect,resource to ggs_owner; SQL> grant select any dictionary, select any table to ggs_owner; SQL> grant create table to ggs_owner; SQL> grant flashback any table to ggs_owner; SQL> grant execute on dbms_flashback to