GoldenGate Running with no error but no replication.How to Troubleshoot?
VIRUJan 12 2012 — edited Jan 17 2012Hi,
I am using 2 servers
OS DB
Server 1 - IBM AIX ORACLE 11g - Source Machine.
Server 2 - Oracle Linux 5 ORACLE 11g - Target Machine.
I am trying to apply goldengate to replicate data as well as DDL modifications from Server 1 to Server 2.
Details of Server 1 :-
Manager is running.
Parameter file for Extract IUT01
EXTRACT IUT01
USERID ggs_owner, PASSWORD ggs_owner
RMTHOST OFSMUG-VM-87.i-flex.com, MGRPORT 7809
RMTTRAIL /oracle/GoldenGate/Setup/dirdat/rt
TABLE NGPIUT01.*;
Parameter file for Extract IUT01DP - Data pump Extract
EXTRACT IUT01DP
USERID ggs_owner, PASSWORD ggs_owner
EXTTRAIL /data01/oradata/GoldenGate/dirdat/dpump/lt
TABLE IUT01.*;
GGSCI (FIFLX595) 56> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING IUT01 00:00:00 00:00:05
EXTRACT RUNNING IUT01DP 00:00:00 00:00:09
Details of Server 2 :-
Manager is running.
Parameter file for Replicat NGPIUT01
REPLICAT NGPIUT01
ASSUMETARGETDEFS
USERID ggs_owner, PASSWORD ggs_owner
MAP NGPIUT01.*, TARGET IUT01.*;
GGSCI (OFSMUG-VM-87.i-flex.com) 42> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING NGPIUT01 00:00:00 00:00:08
But I can't see the changes happening in the Source db getting reflected in the Target db .
Please guide me how should i troubleshoot here???? I am not getting any error but no effect of replication as well.
Thanks in advance!