Install Oracle GoldenGate [2]

27 Mar

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

One Response to “Install Oracle GoldenGate [2]”

  1. Vladimir Grigorian October 26, 2011 at 1:24 am #

    I have a question about Flashback Data Archive tables in Goldengate replication. Are these tables usually excluded in an extract like “TABLEEXCLUDE .SYS_FBA_*”?
    What is the approach for replicating and initial load of Flash Back Data Archive tables?
    Here is my problem. I exported a user schema using Oracle DataPump, imported into destination database. GoldenGate abended saying some tables dont exist on dest. I checked tables and there were about 200 tables that were not exported because they are FBDA tables and DataPump just ignores them. So, I recreated them on source with scripts.
    So, how is this done? Source and destination have their own FBDA and these tables should not be neither recreated with scripts on dest or replicated? Or they have to be replicated with contents?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: