GoldenGate

Hi,


I have run the required ddl replication script but when i give the DDL incude option in my extract it tries to Link with some other DB and i get this error.

2011-11-14 14:15:00 INFO OGG-00733 Oracle GoldenGate Capture for Oracle, pocs.prm: Marker table GGPOC.GGS_MARKER not found.
2011-11-14 14:15:00 ERROR OGG-00529 Oracle GoldenGate Capture for Oracle, pocs.prm: DDL Replication is enabled but table GGPOC.GGS_DDL_HIST is not found. Please check DDL installation in the database.

The " GGPOC " was the db I was using earlier for golden gate replication. That DB has been dropped .

Now i am connected to a new db (POC1) and schema(FCUBSGG) . I have run the repliation script for this Schema .
But the extract process abbends with the above error when i give " DDL INCLUDE ALL" else the other mechanism e.g insert works fine .

edit params mgr
------------------------------
PORT 7809
USERID FCUBSGG@POC1, PASSWORD FCUBSGG
PURGEOLDEXTRACTS /oraint1/ora11g22/ggsoftware/dirdat/*,USECHECKPOINTS,MINKEEPDAYS 2

-------------------------------------------------


edit params pocs ( extract )

----------------------------------

extract POCS
setenv (ORACLE_SID = "POC1")
USERID FCUBSGG@POC1, PASSWORD FCUBSGG
RMTHOST 10.184.74.187, MGRPORT 7809
RMTTRAIL /oraint1/ora11g22/ggsoftware/dirdat/yy,purge
TABLE FCUBSGG.*;

-----------------------------------------------------------------

edit params npocd (replicat)

REPLICAT npocd
ASSUMETARGETDEFS
USERID FC1131DEV, PASSWORD FC1131DEV
DBOPTIONS SHOWINFOMESSAGES SUPPRESSTRIGGER
REPERROR (-1, IGNORE)
MAP FCUBSGG.*, TARGET FC1131DEV.*;
HANDLECOLLISIONS
APPLYNOOPUPDATES
DISCARDFILE /oraint1/ora11g22/ggsoftware/dirrpt/pktest.dsc,purge
MAP FCUBSGG.*, TARGET FC1131DEV.*;


--------------


My work is pending because of the DDL issue. Please help/suggest in this regard.



Thanks in advance.

Edited by: Anu on Nov 14, 2011 2:38 AM

Edited by: Anu on Nov 14, 2011 2:39 AM