Install Oracle GoldenGate [2]

c. Melengkapi Oracle GoldenGate di SID source [orcl10]
1. server dalam keadaan mode archivelog
[oracle@orcl10 ~]$ sqlplus / as sysdba
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;

SQL> alter system set recyclebin=off scope=spfile;
SQL> shutdown abort;
SQL> startup;

2. supplemental logging
SQL> alter database add supplemental log data;

3. Create schema untuk ddl support replication
SQL> create user ggate identified by 123456 default tablespace users temporary tablespace temp;
SQL> grant connect,resource,unlimited tablespace to ggate;
SQL> grant execute on utl_file to ggate;
SQL> grant select any dictionary, select any table to ggate;
SQL> grant create table to ggate;
SQL> grant flashback any table to ggate;
SQL> grant execute on dbms_flashback to ggate;
SQL> grant execute on utl_file to ggate;

SQL> @marker_setup.sql
SQL> @ddl_setup.sql
SQL> @role_setup.sql
SQL> grant GGS_GGSUSER_ROLE to ggate;
SQL> @ddl_enable.sql

SQL> exit

4. testing login
[oracle@orcl10 /]$ cd $GGATE
[oracle@orcl10 gg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x64, 64bit (optimized), Oracle 10 on Sep 22 2009 14:18:08
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.

GGSCI (orcl10) 1> DBLOGIN USERID ggate, PASSWORD 123456
Successfully logged into database.

5. startup manager & edit paramater
GGSCI (orcl10) 2> info manager
Manager is DOWN!

GGSCI (orcl10) 3> start manager
ERROR: Parameter file /u01/app/oracle/product/gg/dirprm/mgr.prm does not exist.

GGSCI (orcl10) 4> EDIT PARAMS MGR
PORT 7809
USERID ggate, PASSWORD 123456
PURGEOLDEXTRACTS /u01/app/oracle/product/gg, USECHECKPOINTS

GGSCI (orcl10) 5> start manager
Manager started.

GGSCI (orcl10) 6> info manager
Manager is running (IP port orcl10.7809).

GGSCI (orcl10) 7> exit
[oracle@orcl10 gg]$

6. Create test user source untuk replication
[oracle@orcl10 ~]$ sqlplus / as sysdba
SQL> create user orcl10 identified by 123456 default tablespace users temporary tablespace temp;
SQL> grant connect,resource,unlimited tablespace to orcl10;
SQL> exit

d. Melengkapi Oracle GoldenGate di SID target [orcl3]
1. server dalam keadaan mode archivelog
[oracle@orcl3 ~]$ sqlplus / as sysdba
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;

SQL> alter system set recyclebin=off scope=spfile;
SQL> shutdown abort;
SQL> startup;

2. supplemental logging
SQL> alter database add supplemental log data;

3. Create schema untuk ddl support replication
SQL> create user ggate identified by 123456 default tablespace users temporary tablespace temp;
SQL> grant connect,resource,unlimited tablespace to ggate;
SQL> grant execute on utl_file to ggate;
SQL> grant select any dictionary, select any table to ggate;
SQL> grant create table to ggate;
SQL> grant flashback any table to ggate;
SQL> grant execute on dbms_flashback to ggate;
SQL> grant execute on utl_file to ggate;

SQL> @marker_setup.sql
SQL> @ddl_setup.sql
SQL> @role_setup.sql
SQL> grant GGS_GGSUSER_ROLE to ggate;
SQL> @ddl_enable.sql

SQL> exit

4. testing login
[oracle@orcl3 ~]$ cd $GGATE
[oracle@orcl3 gg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x64, 64bit (optimized), Oracle 10 on Sep 22 2009 14:18:08
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.

GGSCI (orcl3) 1> DBLOGIN USERID ggate, PASSWORD 123456
Successfully logged into database.

5. startup manager & edit paramater
GGSCI (orcl3) 2> info manager
Manager is DOWN!

GGSCI (orcl3) 3> start manager
ERROR: Parameter file /u01/app/oracle/product/gg/dirprm/mgr.prm does not exist.

GGSCI (orcl3) 4> EDIT PARAMS MGR
GGSCI (orcl3) 5> start manager
Manager started.

GGSCI (orcl3) 6> info manager
Manager is running (IP port orcl3.7809).

GGSCI (orcl3) 7> exit

6. Create test user source untuk replication
[oracle@orcl3 ~]$ sqlplus / as sysdba
SQL> create user orcl3 identified by 123456 default tablespace users temporary tablespace temp;
SQL> grant connect,resource,unlimited tablespace to orcl3;
SQL> exit

referensi :
http://www.pythian.com/news/7959/oracle-goldengate-installation-part-1/
http://gavinsoorma.com/2010/02/08/goldengate-concepts-and-architecture/
http://gavinsoorma.com/2010/02/09/goldengate-installation-oracle-11g-on-red-hat-linux/
http://gavinsoorma.com/2010/02/11/goldengate-tutorial-3-configuring-the-manager-process/
http://gavinsoorma.com/2010/02/15/oracle-goldengate-tutorial-4-performing-initial-data-load/

1. Oracle Golden Gate

2. install-oracle-goldengate 1

3. install-oracle-goldengate 2

4. install-oracle-goldengate 3