Forum Stats

  • 3,872,084 Users
  • 2,266,378 Discussions
  • 7,911,045 Comments

Discussions

Replicat is abending

user12004979
user12004979 Member Posts: 20 Blue Ribbon
edited Jan 4, 2011 10:27AM in GoldenGate
This is what i have on source and target:

Source db: oracle 10.2.0.4 block size 8K
target :db: oracle 10.2.0.4 block size 32K

Souce configuration:

MGR.prm
PORT 7820
USERID ggs_user, PASSWORD ggs_user
PURGEOLDEXTRACTS /u01/oracle/ggs/dirdat/ex, USECHECKPOINTS

extract load1.prm
EXTRACT load1
USERID ggs_user, PASSWORD ggs_user
RMTHOST targetserver , MGRPORT 7820
rmttrail /u01/oracle/ggs/dirdat/lt
--RMTTASK replicat, GROUP load2
TABLE usachclic.username_test;


enabled supplemental logging.
logged in as gss user and ran add trandata usachclic.username_test.

On TARGET

mgr.prm
PORT 7820
USERID ggs_user, PASSWORD ggs_user

load2.prm
REPLICAT load2
ASSUMETARGETDEFS
USERID ggs_user, PASSWORD ggs_user
discardfile /u01/oracle/ggs/discard/rep1_discard.txt, append, megabytes 10
MAP usachclic.username_test, TARGET usachclic.username_test;

./GLOBAL
GGSCHEMA ggs_user
CHECKPOINTTABLE ggs_user.checkpoint


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

When i start intial load every thing looks goon on extarct load1
This is the snapshot of GGSEVT
2010-12-30 14:59:38 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT LOAD1 starting.
2010-12-30 14:59:38 GGS INFO 310 Oracle GoldenGate Capture for Oracle, load1.prm: EXTRACT LOAD1 starting.
2010-12-30 14:59:38 GGS WARNING Z1-078 Oracle GoldenGate Capture for Oracle, load1.prm: No valid default archive log destination directory found for thre
ad 1.
2010-12-30 14:59:38 GGS INFO 310 Oracle GoldenGate Capture for Oracle, load1.prm: EXTRACT LOAD1 started.
2010-12-30 14:59:43 GGS INFO 406 Oracle GoldenGate Capture for Oracle, load1.prm: Socket buffer size set to 27985 (flush size 27985).
2010-12-30 14:59:43 GGS INFO 112 Oracle GoldenGate Capture for Oracle, load1.prm: Recovery initialization completed for target file /u01/oracle/ggs
/dirdat/lt000002, at RBA 1682.
2010-12-30 14:59:43 GGS INFO Z0-05M Oracle GoldenGate Capture for Oracle, load1.prm: Output file /u01/oracle/ggs/dirdat/lt is using format RELEASE 10.
4.
2010-12-30 14:59:43 GGS INFO 224 Oracle GoldenGate Capture for Oracle, load1.prm: Rolling over remote file /u01/oracle/ggs/dirdat/lt000003.
2010-12-30 14:59:43 GGS INFO 112 Oracle GoldenGate Capture for Oracle, load1.prm: Recovery completed for target file /u01/oracle/ggs/dirdat/lt00000
3, at RBA 969.
2010-12-30 14:59:43 GGS INFO 112 Oracle GoldenGate Capture for Oracle, load1.prm: Recovery completed for all targets.


But on target when i run:
infol all command
I get mamager is running and replicat load2 is abending.

when i do info replicat load2 i get this

REPLICAT LOAD2 Last Started 2010-12-30 14:36 Status ABENDED
Checkpoint Lag 23:28:32 (updated 01:16:18 ago)
Log Read Checkpoint File /u01/oracle/ggs/dirdat/lt000000
2010-12-29 15:08:21.059469 RBA 969


This is the snapshop of GGSEVT on target.

2010-12-30 14:36:53 GGS ERROR 190 Oracle GoldenGate Delivery for Oracle, load2.prm: PROCESS ABENDING.
2010-12-30 14:46:26 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params mgr.
2010-12-30 14:46:48 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ./GLOBAL.
2010-12-30 14:47:17 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params load2.
2010-12-30 14:49:10 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params load2.
2010-12-30 14:58:22 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): stop replicat load2.
2010-12-30 14:59:09 GGS INFO 371 Oracle GoldenGate Collector, port 7840: Closing /u01/oracle/ggs/dirdat/lt000002.
2010-12-30 14:59:09 GGS INFO 372 Oracle GoldenGate Collector, port 7840: Terminating after client disconnect.
2010-12-30 14:59:26 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 172.30.130.31 (START SERVER C
PU -1 PRI -1 PARAMS ).
2010-12-30 14:59:26 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7840).
2010-12-30 14:59:26 GGS INFO 373 Oracle GoldenGate Collector, port 7840: Waiting for connection (started dynamically).
2010-12-30 14:59:31 GGS INFO 373 Oracle GoldenGate Collector: Connected to hcli-stag1101.hcli.usac.loc:55726.
2010-12-30 14:59:31 GGS INFO 370 Oracle GoldenGate Collector, port 7840: Opening /u01/oracle/ggs/dirdat/lt000002 (byte 1682, current EOF 1682).
2010-12-30 14:59:31 GGS INFO 371 Oracle GoldenGate Collector, port 7840: Closing /u01/oracle/ggs/dirdat/lt000002.
2010-12-30 14:59:31 GGS INFO 370 Oracle GoldenGate Collector, port 7840: Opening /u01/oracle/ggs/dirdat/lt000003 (byte -1, current EOF 0).
2010-12-30 15:26:27 GGS ERROR 190 Oracle GoldenGate Command Interpreter for Oracle: Received signal: Program interrupt (2).
2010-12-30 15:26:27 GGS ERROR 190 Oracle GoldenGate Command Interpreter for Oracle: PROCESS ABENDING.
2010-12-30 15:46:06 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params mgr.
2010-12-30 15:47:40 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params load2.
2010-12-30 15:48:24 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ./GLOBAL.
2010-12-30 15:53:22 GGS ERROR 190 Oracle GoldenGate Command Interpreter for Oracle: Received signal: Program interrupt (2).
2010-12-30 15:53:22 GGS ERROR 190 Oracle GoldenGate Command Interpreter for Oracle: PROCESS ABENDING.


Please HELP

Answers

  • alienman
    alienman Member Posts: 6
    Is there RAC on AIX ?
  • User152973
    User152973 Member Posts: 148
    Can you do VIEW REPORT <replicat name> and post the content here so we can see the exact error in that report file.

    Thanks.
  • user12004979
    user12004979 Member Posts: 20 Blue Ribbon
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
    PL/SQL Release 10.2.0.4.0 - Production
    CORE 10.2.0.4.0 Production
    TNS for Linux: Version 10.2.0.4.0 - Production
    NLSRTL Version 10.2.0.4.0 - Production

    Database Language and Character Set:
    NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
    NLS_LANGUAGE = "AMERICAN"
    NLS_TERRITORY = "AMERICA"
    NLS_CHARACTERSET = "WE8ISO8859P1"

    Warning: NLS_LANG is not set. Please refer to user manual for more information.

    ***********************************************************************
    ** Run Time Messages **
    ***********************************************************************

    Opened trail file /u01/oracle/ggs/dirdat/lt000002 at 2010-12-30 19:16:19

    MAP resolved (entry USACHCLIC.USERNAME_TEST):
    MAP USACHCLIC.USERNAME_TEST, TARGET usachclic.username_test;
    Using following columns in default map by name:
    USERNAMEID, USERNAME, PASSWORD, FIRSTNAME, LASTNAME, EMAIL,
    DISABLEDFLAG, USERID, CREATIONDATE, LASTEDITDATE

    Using the following key columns for target table USACHCLIC.USERNAME_TEST: USERNAMEID.


    Switching to next trail file /u01/oracle/ggs/dirdat/lt000003 at 2010-12-30 19:16:19 due to EOF, with current RBA 1682
    Opened trail file /u01/oracle/ggs/dirdat/lt000003 at 2010-12-30 19:16:19

    Processed extract process graceful restart record at seq 3, rba 969.

    Switching to next trail file /u01/oracle/ggs/dirdat/lt000004 at 2010-12-30 19:16:19 due to EOF, with current RBA 1362
    Opened trail file /u01/oracle/ggs/dirdat/lt000004 at 2010-12-30 19:16:19

    Processed extract process graceful restart record at seq 4, rba 969.

    Switching to next trail file /u01/oracle/ggs/dirdat/lt000005 at 2010-12-30 19:16:19 due to EOF, with current RBA 1167
    Opened trail file /u01/oracle/ggs/dirdat/lt000005 at 2010-12-30 19:16:19

    Processed extract process graceful restart record at seq 5, rba 969.

    Switching to next trail file /u01/oracle/ggs/dirdat/lt000006 at 2010-12-30 19:16:19 due to EOF, with current RBA 1029
    Opened trail file /u01/oracle/ggs/dirdat/lt000006 at 2010-12-30 19:16:19

    Processed extract process graceful restart record at seq 6, rba 969.

    2010-12-30 19:16:19 GGS WARNING 218 Aborted grouped transaction on 'USACHCLIC.USERNAME_TEST', Database error 1 (ORA-00001: unique constraint (USACHCLIC
    .SYS_C0036809) violated).

    2010-12-30 19:16:19 GGS WARNING 218 Repositioning to rba 1345 in seqno 2.
    Opened trail file /u01/oracle/ggs/dirdat/lt000002 at 2010-12-30 19:16:19

    Switching to next trail file /u01/oracle/ggs/dirdat/lt000003 at 2010-12-30 19:16:19 due to EOF, with current RBA 1682
    Opened trail file /u01/oracle/ggs/dirdat/lt000003 at 2010-12-30 19:16:19

    Processed extract process graceful restart record at seq 3, rba 969.

    Switching to next trail file /u01/oracle/ggs/dirdat/lt000004 at 2010-12-30 19:16:19 due to EOF, with current RBA 1362
    Opened trail file /u01/oracle/ggs/dirdat/lt000004 at 2010-12-30 19:16:19

    Processed extract process graceful restart record at seq 4, rba 969.

    Switching to next trail file /u01/oracle/ggs/dirdat/lt000005 at 2010-12-30 19:16:19 due to EOF, with current RBA 1167
    Opened trail file /u01/oracle/ggs/dirdat/lt000005 at 2010-12-30 19:16:19

    Processed extract process graceful restart record at seq 5, rba 969.

    Switching to next trail file /u01/oracle/ggs/dirdat/lt000006 at 2010-12-30 19:16:19 due to EOF, with current RBA 1029
    Opened trail file /u01/oracle/ggs/dirdat/lt000006 at 2010-12-30 19:16:19

    Processed extract process graceful restart record at seq 6, rba 969.

    2010-12-30 19:16:19 GGS WARNING 218 SQL error 1 mapping USACHCLIC.USERNAME_TEST to USACHCLIC.USERNAME_TEST OCI Error ORA-00001: unique constraint (USAC
    HCLIC.SYS_C0036809) violated (status = 1), SQL <INSERT INTO "USACHCLIC"."USERNAME_TEST" ("USERNAMEID","USERNAME","PASSWORD","FIRSTNAME","LASTNAME","EMAIL","D
    ISABLEDFLAG","USERID","CREATIONDATE","LASTEDITDATE") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a>.

    2010-12-30 19:16:19 GGS WARNING 218 Repositioning to rba 1029 in seqno 6.

    Source Context :
    SourceModule : [er.main]
    SourceID : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/rep.c#19 $]
    SourceFunction : [take_rep_err_action]
    SourceLine : [14904]
    ThreadBacktrace : [7] elements
    : [u01/oracle/ggs/replicat(_ZN15CMessageContext16AddThreadContextEv+0x26) [0x5b1b46]]
    : [u01/oracle/ggs/replicat(_ZN15CMessageFactory13CreateMessageEP14CSourceContextjz+0x383) [0x5aa483]]
    : [u01/oracle/ggs/replicat [0x4ba31d]]
    : [u01/oracle/ggs/replicat [0x4c1687]]
    : [u01/oracle/ggs/replicat(main+0x4ee) [0x4d337e]]
    : [lib64/libc.so.6(__libc_start_main+0xf4) [0x3f18e1d994]]
    : [u01/oracle/ggs/replicat(__gxx_personality_v0+0x172) [0x45adea]]

    2010-12-30 19:16:19 GGS ERROR 218 Error mapping from USACHCLIC.USERNAME_TEST to USACHCLIC.USERNAME_TEST.

    ***********************************************************************
    * ** Run Time Statistics ** *
    ***********************************************************************

    Last record for the last committed transaction is the following:
    ___________________________________________________________________
    Trail name : /u01/oracle/ggs/dirdat/lt000004
    Hdr-Ind : E (x45) Partition : . (x04)
    UndoFlag : . (x00) BeforeAfter: B (x42)
    RecLength : 9 (x0009) IO Time : 2010-12-30 18:44:52.031077
    IOType : 3 (x03) OrigNode : 255 (xff)
    TransInd : . (x03) FormatType : R (x52)
    SyskeyLen : 0 (x00) Incomplete : . (x00)
    AuditRBA : 181 AuditPos : 126247440
    Continued : N (x00) RecCount : 1 (x01)

    2010-12-30 18:44:52.031077 Delete Len 9 RBA 1029
    Name: USACHCLIC.USERNAME_TEST
    ___________________________________________________________________

    Reading /u01/oracle/ggs/dirdat/lt000006, current RBA 1029, 3 records

    Report at 2010-12-30 19:16:19 (activity since 2010-12-30 19:16:19)

    From Table USACHCLIC.USERNAME_TEST to USACHCLIC.USERNAME_TEST:
    # inserts: 2
    # updates: 0
    # deletes: 1
    # discards: 1


    Last log location read:
    FILE: /u01/oracle/ggs/dirdat/lt000006
    SEQNO: 6
    RBA: 1029
    TIMESTAMP: 2010-12-30 19:09:24.032634
    EOF: NO
    READERR: 0


    CACHE OBJECT MANAGER statistics

    CACHE MANAGER VM USAGE
    vm current = 0 vm cached = 0
    vm anon = 0 vm file = 0
    vm used max = 0 ==> CACHE BALANCED

    CACHE CONFIGURATION
    cache size = 512M cache force paging = 881M
    buffer min = 64K buffer highwater = 4M
    pageout eligible size = 4M

    CACHE Transaction Stats
    trans active = 0 max concurrent = 0
    non-zero total = 0 trans total = 0

    CACHE File Caching
    disk current = 0 disk total = 0
    disk caching = 0 file cached = 0
    file retrieves = 0

    CACHE MANAGEMENT
    buffer links = 0 anon gets = 0
    forced unmaps = 0 cnnbl try = 0
    cached out = 0 force out = 0

    Allocation Request Distribution
    < 128B: 0
    128B: 0 0 | 512B: 0 0
    2K: 0 0 | 8K: 0 0
    32K: 0 0 | 128K: 0 0
    512K: 0 0 | 2M: 0 0
    8M: 0 0 | 32M: 0 0
    128M: 0 0 | 512M: 0 0
    2G: 0 0 | 8G: 0

    Cached Transaction Size Distribution
    0: 0
    < 4K: 0
    4K: 0 0 | 16K: 0 0
    64K: 0 0 | 256K: 0 0
    1M: 0 0 | 4M: 0 0
    16M: 0 0 | 64M: 0 0
    256M: 0 0 | 1G: 0 0
    4G: 0 0 | 16G: 0 0
    64G: 0 0 | 256G: 0 0
    1T: 0 0 | 4T: 0 0
    16T: 0 0 | 64T: 0 0
    256T: 0 0 |1024T: 0 0


    QUEUE Statistics:
    num queues = 15 default index = 0
    cur len = 0 max len = 0
    q vm current = 0 vm max = 0
    q hits = 0 q misses = 0

    queue size q hits curlen maxlen cannibalized
    0 64K 0 0 0 0
    1 128K 0 0 0 0
    2 256K 0 0 0 0
    3 512K 0 0 0 0
    4 1M 0 0 0 0
    5 2M 0 0 0 0
    6 4M 0 0 0 0
    7 8M 0 0 0 0
    8 16M 0 0 0 0
    9 32M 0 0 0 0
    10 64M 0 0 0 0
    11 128M 0 0 0 0
    12 256M 0 0 0 0
    13 512M 0 0 0 0
    14 1G 0 0 0 0

    ================================================================================
    CACHE POOL #0
    POOL INFO group: load2 id: p344_BLOB
    trans active = 0 trans concurrent (max) = 0
    trans total = 0 (0 )
    flag = 0x00000003
    highestCSN = (wrap=0, base=0) valid = 0
    last error = (0=<none>)

    Allocation Request Distribution
    < 128B: 0
    128B: 0 0 | 512B: 0 0
    2K: 0 0 | 8K: 0 0
    32K: 0 0 | 128K: 0 0
    512K: 0 0 | 2M: 0 0
    8M: 0 0 | 32M: 0 0
    128M: 0 0 | 512M: 0 0
    2G: 0 0 | 8G: 0
  • Bouch
    Bouch Member Posts: 422
    there is an error in the log
    "2010-12-30 19:16:19 GGS WARNING 218 Aborted grouped transaction on 'USACHCLIC.USERNAME_TEST', Database error 1 (ORA-00001: unique constraint (USACHCLIC.SYS_C0036809) violated)."
    you are inserting twice the same record, may be you shuold test with option like "OVERRIDEDUPS"
    in your replicat process
  • User152973
    User152973 Member Posts: 148
    I think you may create unique constraint on the table in the target side to avoid this error.
  • user12004979
    user12004979 Member Posts: 20 Blue Ribbon
    edited Jan 4, 2011 10:27AM
    Thanks Guys, i had two issues:
    On target i did not have ./GLOBAL instead of ./GLOBALS.
    And resolved the duplicate issues too

    Will keep you posted if i get any issues...

    Edited by: user12004979 on Jan 4, 2011 7:27 AM
This discussion has been closed.