Install Oracle GoldenGate in 1 instance database [2]

b. Melengkapi Oracle GoldenGate untuk source
1. server dalam keadaan mode archivelog
[oracle@orcl10 ~]$ sqlplus / as sysdba
SQL> alter system set recyclebin=off scope=spfile;
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;

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
Enter GoldenGate schema name:ggate

SQL> @ddl_setup.sql
Enter GoldenGate schema name:ggate
Enter mode of installation:INITIALSETUP
Enter yes or no:yes

SQL> @role_setup.sql
Enter GoldenGate schema name:ggate

SQL> grant GGS_GGSUSER_ROLE to ggate;

SQL> @ddl_enable.sql

SQL> exit

4. testing login
[oracle@orcl10 ~]$ export GGATE=/u01/app/oracle/product/gg
[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 sumber identified by 123456 default tablespace users temporary tablespace temp;
SQL> grant connect,resource,unlimited tablespace to sumber;
SQL> exit

c. Melengkapi Oracle GoldenGate untuk target

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

1. install oracle goldengate in 1 instance database-1

2. install oracle goldengate in 1 instance database-2

3. install oracle goldengate in 1 instance database-3