HI All,
I'm having troubles with configuring Golden Gate replication. changes made on sample schema on source DB are not applying on target DB.
please verify if this setup is correct.
DB 11g EE r11.2.0.2.0 on Oracle Linux (test environment for learning purposes)
1. source machine
MGR
PORT 7809
lagreportminutes 5
laginfominutes 1
lagcriticalminutes 2
purgeoldextracts /GG_INSTALL/t*,minkeepdays 2,usecheckpoints
Exctract
extract ext1
userid ggate, password qwerty
discardfile /GG_INSTALL/discard
reportcount every 15 minutes, rate
RMTHOST db2.local, MGRPORT 7809
RMTTRAIL /GG_INSTALL/t1
DDL include ALL
exttrail /GG_INSTALL/t1
table TEST_SCHEMA.*;
Pump
extract dpe1
passthru
rmthost db2.local, mgrport 7809
rmttrail /GG_INSTALL/t1
table TEST_SCHEMA.*;
STATUSES:
GGSCI (db1.local) 46> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPE1 00:00:00 00:00:01
EXTRACT RUNNING EXT1 00:00:00 00:00:04
2. Target machine
MGR
PORT 7809
dynamicportlist 7900-7950
lagreportminutes 5
laginfominutes 1
lagcriticalminutes 2
purgeoldextracts /GG_INSTALL/t*, minkeepdays 2, usecheckpoints
Replicat
replicat rep1
userid ggate, password qwerty
discardfile /GG_INSTALL/discard/rep1.dsc, purge
assumetargetdefs
reportcount every 15 minutes, rate
batchsql
deferapplyinterval 5 mins
ddl include mapped
map TEST_SCHEMA.*, target TEST_SCHEMA.*;
STATUSES:
GGSCI (db2.local) 79> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:09
List table command from GGSCI shows my test tables under test schema. no errors in logs on both side. Tran files are successfully transmuting to target machine, but any update or insert on source is not reflecting on target. any tips? thanks in advance.