GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

unique constraint (SGPM.PK_C_METER) violated

edited Oct 6, 2014 10:00AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

Dear :

      I have a problem.

      AIX 6100, oracle database version :11.2.0.3 ,goldengate version :11.2.1.0.4

    

[oracle@ndyxora]:/goldengate/dirprm>cat mgr.prm

PORT 7839

USERID goldengate, PASSWORD AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC,BLOWFISH ENCRYPTKEY DEFAULT

DYNAMICPORTLIST 7840-7914

PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 3

LAGREPORTHOURS 1

LAGINFOMINUTES 30

LAGCRITICALMINUTES 45

[oracle@ndyxora]:/goldengate/dirprm>cat repyo.prm

REPLICAT repyo

SETENV (NLS_LANG = "AMERICAN_AMERICA.UTF8")

SETENV (oracle_sid = "ndyxdb")

USERID goldengate, PASSWORD AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC,BLOWFISH ENCRYPTKEY DEFAULT

REPORT AT 06:00

REPORTCOUNT EVERY 30 MINUTES, RATE

REPERROR DEFAULT, ABEND

ASSUMETARGETDEFS

DISCARDFILE ./dirrpt/repyo.dsc, APPEND, MEGABYTES 1024

DISCARDROLLOVER AT 02:30

ALLOWNOOPUPDATES

GETTRUNCATES

DBOPTIONS DEFERREFCONST

MAP SGPM.D_METER_ERR,           TARGET SGPM.D_METER_ERR;                

MAP SGPM.D_METER,               TARGET SGPM.D_METER;                  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center