【gg notes】config gg for windows x86 32bit ,two node

Let's improve the single node configuration sample to two nodes of win x86 32-bit

In fact, we are still in the same machine, but we have two gg manager, one for source and the other for target.

The paths on my windows XP system are:

Source:

D:\ggs

Target:

D:\ggt

 

1, Prepare the install environment

OS: windows XP(x86-32-bit)

DB: Oracle11R2

GG: ggs_Windows_x86_ora11g_32bit

Network: single node test

 

2, Download GG for windows x86-32-bit-edition, just for test

This is the web link:

http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

 

3, Extract file to your path

Different from 1 node sample, there are two paths:

d:\ggs

d:\ggt

 

4, Alter database archivelog

Oracle GG need database running on archive mode

Need perform. these commands:

Shutdown immediate;

Startup mount;

Alter database archivelog;

Alter database open;

 

5, Create test user and tables

Create user ggs identified by ggs;

Create user ggt identified by ggt;

Grant dba to ggs;

Grant dba to ggt;

 

Conn ggs/ggs

Create table test1(

Stu_id number(6),

Stu_name varchar2(20),

Stu_pass varchar2(20)

);

 

Conn ggt/ggt;

Create table test1(

Stu_id number(6),

Stu_name varchar2(20),

Stu_pass varchar2(20)

);

 

6, Config golden gate for source

1)       Create file path

Access path d:\ggs

Execute ggsci.exe

In ggsci command,execute:

Create subdirs    ---only for the first config operation

 

2)       Add service for source mgr

Edit the ./GLOBALS:

Edit params ./GLOBALS

Content:

MGRSERVNAME GGMGRS

Under gg path ,execute follow command to add GGMGRS service:

Install addservice

 

3)       Modify params for manager process(mgr)

Edit param mgr

Content:

Port 7500   --set the manager running port

Dynamicportlist 7501-7505

Autorestart extract *,waitminutes 2,retries 5

 

Can use command:

Start mgr

To start the mgr process

Can use command :

Info all

To see the status of mgr running

 

 

4)       Add supplemental logging for source table

 

5)       Add and edit params for extract progress

Command:

Add extract eora,tranlog,begin now

Edit param eora

 

Param Contents:

extract eora

dynamicresolution

userid ggs,password ggs

exttrail d:\ggs\dirdat\et

table ggs.test1;

 

Add remote list

Add rmttrail d:\ggt\dirdat\r1,extract eora,megabyte 100

 

Use command:

Start eora

To start extract eora progress

 

6)       Add and edit pump process param

Add extract pump_so,exttrailsource d:\ggs\dirdat\et

Add remote trail file to extract pump_so:

Add rmttrail d:\ggt\dirdat\et,extract pump_so

Edit param pump_so

pump_so.prm contents:

extract pump_so

Dynamicresolution

Userid ggs,password ggs

rmthost 127.0.0.1, mgrport 7500   --rmthost is remote host’s ip addr

--Setenv(ORACLE_SID=ORCL)

rmttrail d:\ggt\dirdat\et

Table ggs.test1;

 

7)       Start progress

Start extract progress:

Start eora

Start pump progress

Start pump_so

Check the progress running

Info all

 

7, Config golden gate for target:

1)       Create file path

Access path d:\ggt

Execute ggsci.exe

In ggsci command,execute:

Create subdirs    ---only for the first config operation

 

2)       Add service for source mgr

Edit the ./GLOBALS:

Edit params ./GLOBALS

Content:

MGRSERVNAME GGMGRT

Under gg path ,execute follow command to add GGMGRT service:

Install addservice

 

3)       Modify params for manager process(mgr)

Edit param mgr

Content:

port 7600

dynamicportlist 7601-7605

autostart er *

autorestart extract *,waitminutes 2,retries 5

lagreporthours 1

laginfominutes 3

lagcriticalminutes 5

purgeoldextracts d:\ggt\dirdat\et*,usecheckpoints,minkeepdays 3

 

Can use command:

Start mgr

To start the mgr process

Can use command :

Info all

To see the status of mgr running

 

 

4)       Add supplemental logging for target table

 

5)       Add and edit params for replicat progress

Command:

add replicat repl,exttrail d:\ggt\dirdat\et,checkpointtable ggt.checkpoint

Edit param rep1

 

Param Contents:

replicat rep1

ASSUMETARGETDEFS

userid ggt,password ggt

discardfile ./dirrpt/rep1.dsc, append, megabytes 50

--HANDLECOLLISIONS

Dynamicresolution

map ggs.test1, target ggt.test1;

 

6)       Start progress

Start replicat progress

Start rep1

Check the progress running

Info all

 

8, Test

        

Conn ggs/ggs

Insert into test1 select 1,’aa’,’pass1’ from dual;

Insert into test1 select 2,’bb’,’pass2’ from dual;

Commit;

 

few seconds later:

conn ggt/ggt

select * from test1;