Skip to Main Content

GOLDEN GATE:Extract is not running and hold with ABENDED MODE

user8900216Feb 22 2011 — edited Mar 30 2011
Hi,
I am trying to simple initial load from oracle to oracle on Linux machin for 11g

the extract porcess is showing abended message when i try to start it


GGSCI (illin198) 2> info extract load1

EXTRACT LOAD1 Last Started 2011-02-22 16:45 Status ABENDED
Checkpoint Lag Not Available
Log Read Checkpoint Table SCOTT.EXTRACT_EMP
2011-02-22 16:45:02 Record 1
Task SOURCEISTABLE

my source prm is :
EXTRACT load1
USERID ggs_owner, PASSWORD ggs_owner
RMTHOST illin390, MGRPORT 7809
RMTTASK replicat, GROUP load2
TABLE scott.extract_emp;

The target prm is :

REPLICAT load2
USERID ggs_owner, PASSWORD ggs_owner
ASSUMETARGETDEFS
MAP scott.extract_emp,TARGET scott.extract_emp;



@ the target ,the replication is showing following messages.
GGSCI (illin390) 11> INFO REPLICAT load2,DETAIL

REPLICAT LOAD2 Initialized 2011-02-22 15:51 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:59:36 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN

Extract Source Begin End

Not Available * Initialized * First Record


Current directory /oravl01/oracle/ggs

Report file /oravl01/oracle/ggs/dirrpt/LOAD2.rpt
Parameter file /oravl01/oracle/ggs/dirprm/load2.prm
Checkpoint file /oravl01/oracle/ggs/dirchk/LOAD2.cpr
Process file /oravl01/oracle/ggs/dirpcs/LOAD2.pcr
Stdout file /oravl01/oracle/ggs/dirout/LOAD2.out
Error log /oravl01/oracle/ggs/ggserr.log



Please let me know , when do we use sourcedb and targetdb in the parameter files of replication and extract?
And how to resolve the above extract error?

Thanks,
Surbhi
Comments
Post Details
Added on Feb 22 2011
7 comments
6,461 views