Install Oracle GoldenGate in 1 instance database [2]

30 Mar

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

One Response to “Install Oracle GoldenGate in 1 instance database [2]”

  1. Vladimir Grigorian October 26, 2011 at 1:16 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: