Replicat is abending - 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 

Is there RAC on AIX ? 

Can you do VIEW REPORT <replicat name> and post the content here so we can see the exact error in that report file.
Thanks. 

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 

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 

I think you may create unique constraint on the table in the target side to avoid this error. 

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

Related

Golgen Gate 11g, Error mapping

Hi to everyone
I have a problem with Golden Gate, I am configuring online change synchronization, can you help me please ? to find out the problem
This is my configuration:
—-Target—
VMware Fedora 16
Oracle 11g R2
2012-04-27 10:03:56 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 started.
2012-04-27 10:03:58 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rep1.prm: Aborted grouped transaction on ‘SH.PRUEBA_GOLDENGATE’, Database error 1403 ().
2012-04-27 10:03:58 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep1.prm: Repositioning to rba 16669 in seqno 0.
2012-04-27 10:03:58 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rep1.prm: SQL error 1403 mapping SCOTT.PRUEBA_GOLDENGATE to SH.PRUEBA_GOLDENGATE.
2012-04-27 10:03:58 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep1.prm: Repositioning to rba 16669 in seqno 0.
2012-04-27 10:03:58 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, rep1.prm: Error mapping from SCOTT.PRUEBA_GOLDENGATE to SH.PRUEBA_GOLDENGATE.
2012-04-27 10:03:58 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
REPLICAT rep1
ASSUMETARGETDEFS
USERID goldengate, PASSWORD oracle1
MAP scott.prueba_goldengate, TARGET SH.prueba_goldengate;
GGSCI (infected) 2> info replicat rep1
REPLICAT REP1 Last Started 2012-04-27 10:03 Status ABENDED
Checkpoint Lag 15:53:33 (updated 00:14:58 ago)
Log Read Checkpoint File /u01/app/goldenGate/dirdat/rt000000
2012-04-26 18:10:25.013655 RBA 16669
GGSCI (infected) 3>
Prompt Table PRUEBA_GOLDENGATE;
CREATE TABLE SH.PRUEBA_GOLDENGATE
(
ID NUMBER,
NOMBRE VARCHAR2(20 BYTE),
DES VARCHAR2(20 BYTE)
)
TABLESPACE TBS_DBA_DAT_TRX
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
Prompt Index PRUEBA_GOLDENGATE_PK;
CREATE UNIQUE INDEX SH.PRUEBA_GOLDENGATE_PK ON SH.PRUEBA_GOLDENGATE
(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
Prompt Non-Foreign Key Constraints on Table PRUEBA_GOLDENGATE;
ALTER TABLE SH.PRUEBA_GOLDENGATE ADD (
CONSTRAINT PRUEBA_GOLDENGATE_PK
PRIMARY KEY
(ID));
COUNT(*)
0
—— SOURCE ———-
VMware Fedora 16
Oracle 11g R2
EXTRACT ext1
USERID goldengate, PASSWORD oracle1
RMTHOST 192.168.239.139, MGRPORT 7809
RMTTRAIL /u01/app/goldenGate/dirdat/rt
TABLE scott.prueba_goldengate;
GGSCI (infected) 38> info extract ext1
EXTRACT EXT1 Last Started 2012-04-27 10:03 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint Oracle Redo Logs
2012-04-27 10:19:33 Seqno 28, RBA 25782272
GGSCI (infected) 39>
2012-04-27 10:03:32 INFO OGG-01055 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery initialization completed for target file /u01/app/goldenGate/dirdat/rt000005, at RBA 32405.
2012-04-27 10:03:32 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file /u01/app/goldenGate/dirdat/rt is using format RELEASE 10.4/11.1.
2012-04-27 10:03:32 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ext1.prm: Rolling over remote file /u01/app/goldenGate/dirdat/rt000006.
2012-04-27 10:03:32 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for target file /u01/app/goldenGate/dirdat/rt000006, at RBA 989.
2012-04-27 10:03:32 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for all targets.
2012-04-27 10:03:32 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext1.prm: Position of first record processed Sequence 28, RBA 25070608, SCN 0.1219399, Apr 27, 2012 10:00:31 AM.
2012-04-27 10:19:33 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): EDIT PARAMS ext1.
CREATE TABLE SCOTT.PRUEBA_GOLDENGATE
(
ID NUMBER,
NOMBRE VARCHAR2(20 BYTE),
DES VARCHAR2(20 BYTE)
)
TABLESPACE TBS_DBA_DAT_TRX
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
Prompt Index PRUEBA_GOLDENGATE_PK;
CREATE UNIQUE INDEX SCOTT.PRUEBA_GOLDENGATE_PK ON SCOTT.PRUEBA_GOLDENGATE
(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
Prompt Non-Foreign Key Constraints on Table PRUEBA_GOLDENGATE;
ALTER TABLE SCOTT.PRUEBA_GOLDENGATE ADD (
CONSTRAINT PRUEBA_GOLDENGATE_PK
PRIMARY KEY
(ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
));
COUNT(*)
100 
SQL Error 1403 is ROW NOT FOUND
What is the DML you are trying to do?
Check that 
1403() simply means that the row on which you are trying to do DML upon is not there in the target database. You haven't used any discard file. Include the parameter for discard file in the replicat param file and restart it. It will dump the rejected row in the discard file. Then you can investigate further. 
amardeep.sidhu wrote:
1403() simply means that the row on which you are trying to do DML upon is not there in the target database. You haven't used any discard file. Include the parameter for discard file in the replicat param file and restart it. It will dump the rejected row in the discard file. Then you can investigate further.Else you can use logdump ;) 
Else you can use logdump ;)Haha...discard file is simple...ASCII stuff ;) 
HI everyone
Thank you for your help, I am going to try discard file
Before I execute some inserts, update and truncate.
I will let you know the result
Kind regars ! 
Hi everyone
I try this:
------ 1.- Discarfile
-- Rep Params
REPLICAT rep1
ASSUMETARGETDEFS
USERID goldengate, PASSWORD oracle1
DISCARDFILE discartFileReplicatRep1.err, append
MAP scott.prueba_goldengate, TARGET SH.prueba_goldengate;
--- DiscardFIle
Aborting transaction on /u01/app/goldenGate/dirdat/rt beginning at seqno 0 rba 17008
error at seqno 0 rba 17008
Problem replicating SCOTT.PRUEBA_GOLDENGATE to SH.PRUEBA_GOLDENGATE
Record not found
Mapping problem with compressed key update record (target format)...
*
ID = 99
ID = 8000
NOMBRE = NULL
DES = NULL
*
----------- 2.- Use ./logdump to skip 4 transactions
--- After Skip
GGSCI (infected) 33> info replicat rep1
REPLICAT REP1 Last Started 2012-04-27 16:25 Status ABENDED
Checkpoint Lag 22:11:28 (updated 00:00:19 ago)
Log Read Checkpoint File /u01/app/goldenGate/dirdat/rt000000
2012-04-26 18:14:14.013577 RBA 17008
Logdump 8 >open /u01/app/goldenGate/dirdat/rt000000
Current LogTrail is /u01/app/goldenGate/dirdat/rt000000
Logdump 9 >position 17008
Reading forward from RBA 17008
Logdump 10 >next
2012/04/26 18:14:14.013.577 GGSPKUpdate Len 56 RBA 17008
Name: SCOTT.PRUEBA_GOLDENGATE
After Image: Partition 4 G e
001a 0000 0006 0000 0002 3939 0001 0004 ffff 0000 | ..........99........
0002 0004 ffff 0000 0000 0008 0000 0004 3830 3030 | ................8000
0001 0004 ffff 0000 0002 0004 ffff 0000 | ................
Logdump 11 >next
Logdump 12 >next
Logdump 13 >next
Logdump 14 >exit
---------------- 3.- Restart Replicat, Extract and Both managers
I found a new problem:
OCI Error ORA-00001: unique constraint (SH.PRUEBA_GOLDENGATE_PK) violated (status = 1), SQL <UPDATE "SH"."PRUEBA_GOLDENGATE" SET "ID" = :a1,"NOMBRE" = :a2,"DES" = :a3 WHERE "ID" = :b0>
Aborting transaction on /u01/app/goldenGate/dirdat/rt beginning at seqno 0 rba 17008
error at seqno 0 rba 17008
Problem replicating SCOTT.PRUEBA_GOLDENGATE to SH.PRUEBA_GOLDENGATE
Mapping problem with compressed key update record (target format)...
*
ID = 99
ID = 8000
NOMBRE = NULL
DES = NULL
--- Source
COUNT(*)
101
---- target
Manually I insert this two rows
ID,NOMBRE,DES
8000,8000 Hola Mundo,8000 Oracle Oracle
99,99Hola Mundo,99Oracle Oracle
What do you think, what is the best solution ?? can i skipp all transactions ?? or should I start from scratch ??
Kind regards !!
Edited by: user11237143 on 27/04/2012 03:15 PM 
Can you post the SQL? Is replication working both ways?
Since this is a test, clean both tables , alter all the processes to begin from now onwards have everything up and running and try it once. See how that goes 
Hi
Honestly I don’t have de SQL, when I finish the configuration I execute some insert, update and truncate, to test the synchronization, after that I found the first problem.
The replication is only one way.
aah ok, i wil try this, clean tables and alter process. Sorry how can I alter the process to begin from now onwards ??
thank you !
kind regars 
If this is the first time u run into 1403 in your configured GG environment that has been running for a while, you can try to manually fix it by looking at the data from discard file/trail file. You can also try INSERTMISSINGUPDATES but there are a couple of cavets you need to pay attention.
If you just set this up and bumped into this error, then most likely you didnt have a clean target database to begin with. Might as well just re-instantiate the target and re-try the trail files. 
Just to mention that skipping transactions means loosing data. I hope you area already aware of that.
The most likely reason for such errors is improper initial load. Use SCN method to do the initial load and avoid the use of HANDLECOLLISIONS. You will hit the minimum number of errors. 
From GGSCI prompt you do:
ALTER <PROCESS_NAME> BEGIN NOW;Edited by: N K on 30-abr-2012 5:42 
Hi to Everyone
Thank you for your help, I am going to try to alter the process and I will tell you later what happen
Kind regards 
Hi NK
I did what you tell me, I clean both tables and start from Now, and now everything it is ok
I am going to keep working with GG
Thank you to everyone
Kind Regards 
user11237143 wrote:
Hi NK
I did what you tell me, I clean both tables and start from Now, and now everything it is ok
I am going to keep working with GG
Thank you to everyone
Kind RegardsGlad to hear, it clearly was data issue!

Golden Gate ERROR   OGG-02028  Failed to attach to logmining server Error code 3113, error message: ORA-03113: end-of-file on communication channel

Hi,I am trying to start up the golden gate extract group and am getting the following error: ERROR   OGG-02028  Failed to attach to logmining server Error code 3113, error message: ORA-03113: end-of-file on communication channel The following are the contents from my alert log:------------------------------------------------------------------------------------------------------------------------------------------Fri Feb 03 16:38:40 2017Thread 1 advanced to log sequence 3877 (LGWR switch)  Current log# 1 seq# 3877 mem# 0: /data02/oradata/FACSESMOC01/onlinelog/o1_mf_1_cr7m318b_.logArchived Log entry 392 added for thread 1 sequence 3876 ID 0x4cb65d61 dest 1:Fri Feb 03 16:38:40 2017Logminer Bld: Build startedALTER SYSTEM SWITCH ALL LOGFILE start (facses01)Thread 1 advanced to log sequence 3878 (LGWR switch)  Current log# 2 seq# 3878 mem# 0: /data02/oradata/FACSESMOC01/onlinelog/o1_mf_2_cr7m31bg_.logALTER SYSTEM SWITCH ALL LOGFILE complete (facses01)Fri Feb 03 16:38:40 2017Logminer Bld: Lockdown Complete.  DB_TXN_SCN is 0 16956239 LockdownSCN is 16956239Fri Feb 03 16:38:40 2017Archived Log entry 393 added for thread 1 sequence 3877 ID 0x4cb65d61 dest 1:ALTER SYSTEM ARCHIVE LOGThread 1 cannot allocate new log, sequence 3879Checkpoint not complete  Current log# 2 seq# 3878 mem# 0: /data02/oradata/FACSESMOC01/onlinelog/o1_mf_2_cr7m31bg_.logThread 1 advanced to log sequence 3879 (LGWR switch)  Current log# 3 seq# 3879 mem# 0: /data02/oradata/FACSESMOC01/onlinelog/o1_mf_3_cr7m31d6_.logArchived Log entry 394 added for thread 1 sequence 3878 ID 0x4cb65d61 dest 1:Fri Feb 03 16:38:44 2017Logminer Bld: DoneGoldenGate Capture: OGG$CAP_EXT1 CAPTURE CreatedCAPTURE OGG$CAP_EXT1: Start SCN: 16956239 (0x102bb4f.00000000)CAPTURE OGG$CAP_EXT1: First SCN: 16956239 (0x102bb4f.00000000)CAPTURE OGG$CAP_EXT1: Required Checkpoint SCN: 0 (0x0000.00000000)CAPTURE OGG$CAP_EXT1: Captured SCN: 0 (0x0000.00000000)CAPTURE OGG$CAP_EXT1: Applied SCN: 0 (0x0000.00000000)CAPTURE OGG$CAP_EXT1: Capture Type: LOCALCAPTURE OGG$CAP_EXT1: Logminer Id: 6CAPTURE OGG$CAP_EXT1: Source Database: FACSES01GoldenGate Apply: OGG$EXT1 APPLY CreatedAPPLY OGG$EXT1: Apply User: GG_ADMINAPPLY OGG$EXT1: Apply Tag: 00Setting XOUT_CLIENT_EXISTS to Y for Capture: OGG$CAP_EXT1Fri Feb 03 16:38:46 2017GoldenGate CAPTURE CP01 for OGG$CAP_EXT1 started with pid=69, OS id=8781CAPTURE OGG$CAP_EXT1: Start SCN: 16956239 (0x102bb4f.00000000)CAPTURE OGG$CAP_EXT1: First SCN: 16956239 (0x102bb4f.00000000)CAPTURE OGG$CAP_EXT1: Required Checkpoint SCN: 0 (0x0000.00000000)CAPTURE OGG$CAP_EXT1: Captured SCN: 0 (0x0000.00000000)CAPTURE OGG$CAP_EXT1: Applied SCN: 0 (0x0000.00000000)CAPTURE OGG$CAP_EXT1: Capture Type: LOCALCAPTURE OGG$CAP_EXT1: Logminer Id: 6CAPTURE OGG$CAP_EXT1: Source Database: FACSES01First applied SCN of the GoldenGate path from capture (OGG$CAP_EXT1) to propagation () to apply (OGG$EXT1) is set to SCN: 16956239 (0x102bb4f.00000000)GoldenGate CAPTURE CP01 for OGG$CAP_EXT1 with pid=69, OS id=8781 is in combined capture and apply mode.Capture OGG$CAP_EXT1 is handling 1 applies.  -- capture is running in apply-state checkpoint mode.Starting persistent Logminer Session with sid = 6 for GoldenGate Capture OGG$CAP_EXT1LOGMINER: Parameters summary for session# = 6LOGMINER: Number of processes = 0, Transaction Chunk Size = 1LOGMINER: Memory Size = 60M, Checkpoint interval = 1000MLOGMINER: SpillScn 0, ResetLogScn 1LOGMINER: summary for session# = 6LOGMINER: StartScn: 16957075 (0x0000.0102be93)LOGMINER: EndScn: 0LOGMINER: HighConsumedScn: 16956239 (0x0000.0102bb4f)LOGMINER: session_flag: 0xb0LOGMINER: DDL CKPT is on.LOGMINER: Read buffers: 64LOGMINER: Memory LWM: limit 10M, LWM 50M, 83%LOGMINER: Memory Release Limit: 1MLOGMINER: LowCkptScn: 0 (0x0000.00000000)LOGMINER: HighCkptScn: 0 (0x0000.00000000)LOGMINER: SkipScn: 16956239 (0x0000.0102bb4f)Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x97F111A, lnxsni()+1874] [flags: 0x0, count: 1]Errors in file /data01/app/oracle/diag/rdbms/facses01/facses01/trace/facses01_cp01_8781.trc  (incident=72565):ORA-07445: exception encountered: core dump [lnxsni()+1874] [SIGSEGV] [ADDR:0x0] [PC:0x97F111A] [Address not mapped to object] []ORA-01280: Fatal LogMiner error.Use ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.Fri Feb 03 16:38:53 2017Sweep [inc][72565]: completed--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Any idea as to why this error is occurring?
This Mosc might be relevant. Golden Gate Extract Unable To Start OGG-02028 Failed to attach to logmining server Error code 3113, error message: ORA-03113: end-of-file on communication channel (Doc ID 2227372.1
There was a server reboot after DB registration and stream pool size is 500M.  SQL> show sga  Total System Global Area 3741306880 bytesFixed Size                  2258800 bytesVariable Size            2130708624 bytesDatabase Buffers         1593835520 bytesRedo Buffers               14503936 bytes
Sorry,Forgot to mention the DB version:11.2.0.4 Thank you for the fast response.
Hi, After running the scripts suggested in the document, I am getting the invalid objects:SQL> SQL>select   owner       c1,   object_type c3,   object_name c2from   dba_objectswhere   status != 'VALID'order by   owner,   object_type;SQL>   2    3    4    5    6    7    8    9   10   11  C1                             C3------------------------------ -------------------C2--------------------------------------------------------------------------------SYS                            PACKAGE BODYDBMS_LOGMNR_SESSION  SYS                            PACKAGE BODYLOGMNR_DICT_CACHE  SQL> #prvtlms.plb  Warning: Package Body created with compilation errors.  Errors for PACKAGE BODY SYS.DBMS_LOGMNR_SESSION:  LINE/COL ERROR-------- -----------------------------------------------------------------589/2    PLS-00593: default value of parameter "BATCH_ROWS" in body must         match that of spec
Hi, Solved the issue, Needed to run the following scripts to fix the above errors:#$ORACLE_HOME/rdbms/admin/catalog.sql#$ORACLE_HOME/rdbms/admin/catproc.sql This helped with the invalid objects as well as log mining. I had to unregister and then register the DB through GGSCI again.

Binds not going trough...

Hi,
I have managed to do the initial load of the tables, but updates are not working.
Running inside same server with two 10.2.0.4 -instances with GG 11 on AIX.
Error message after starting replicat:
2010-08-26 18:37:33 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, erprep.prm: REPLICAT ERPREP starting.
2010-08-26 18:37:33 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, erprep.prm: REPLICAT ERPREP started.
2010-08-26 18:37:33 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, erprep.prm: Aborted grouped transaction on 'ERPLN6A.TTTPMC000000', Database error 100 (retrieving bi
nd info for query).
2010-08-26 18:37:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, erprep.prm: Repositioning to rba 988 in seqno 8.
2010-08-26 18:37:33 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, erprep.prm: SQL error 1403 mapping ERPLN6A.TTTPMC000000 to ERPLN6A.TTTPMC000000.
2010-08-26 18:37:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, erprep.prm: Repositioning to rba 988 in seqno 8.
2010-08-26 18:37:33 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, erprep.prm: Error mapping from ERPLN6A.TTTPMC000000 to ERPLN6A.TTTPMC000000.
2010-08-26 18:37:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, erprep.prm: PROCESS ABENDING.
It's exactly what message is saying...no binds found for update. Checked with trace level 12. First bind is empty, should be 1. Another one does not exist, because it's NVARCHAR2.
UPDATE "ERPLN6A"."TTTPMC000000" SET "T$PEXP" = :a1 WHERE "T$SERN" = :b0
END OF STMT
PARSE #4:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=66531500852162
BINDS #4:
kkscoacd
Bind#0
oacdty=01 mxl=2000(400) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=02 csi=2000 siz=2032 off=0
kxsbbbfp=1104905a8 bln=2000 avl=34 flg=05
value=""
Bind#1
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=21 fl2=1000000 frm=01 csi=873 siz=0 off=2000
kxsbbbfp=110490d78 bln=32 avl=00 flg=01
******
Grants and supplemental things looks ok. From where I can check that extract is doing it right?
Trails seem to be ok, because replicat is reading it. And when reading last extract trail -file, it shows changes there (binary stuff).
GGSCI (fihel3-x0002) 4> view params erpln6a
EXTRACT erpln6a
USERID ggate#erpln6a, PASSWORD xxx
RMTHOST localhost, MGRPORT 7809
rmttrail /temppi/erprep/ogg/target/dirdat/lt
TABLE ERPLN6A.TTTPMC000000;
GGSCI (fihel3-x0002) 5> view params erprep
replicat erprep
ASSUMETARGETDEFS
USERID ggate#erprep, password xxxx
MAP ERPLN6A.TTTPMC000000, TARGET ERPLN6A.TTTPMC000000 ;
******* 
Hey,
Did you try with HANDLECOLLISIONS in replicat params or with APPLYNOOPUPDATES
replicat erprep
ASSUMETARGETDEFS
USERID ggate#erprep, password xxxx
HANDLECOLLISIONS
APPLYNOOPUPDATES
MAP ERPLN6A.TTTPMC000000, TARGET ERPLN6A.TTTPMC000000 ;
Did you check if the triggers are dropped in the target table and also constraints. 
Thanks,
I thought not to try with these options, because I can't see any error messages anywhere about possible problems.
Table has only one row...
HANDLECOLLISIONS will allow updates, but I can't understand why it needs this. There are constraints in source -table. Is this illegal situation?
CREATE TABLE ERPLN6A.TTTPMC000000
(
T$SERN NUMBER NOT NULL,
T$PISD NVARCHAR2(200) NOT NULL,
T$PUND NVARCHAR2(200) NOT NULL,
T$WARN NUMBER NOT NULL,
T$IDNT NUMBER NOT NULL,
T$PEXP NVARCHAR2(200) NOT NULL,
T$PEXM NVARCHAR2(200) NOT NULL,
T$CPUB NUMBER NOT NULL,
T$PPUB NVARCHAR2(200) NOT NULL,
T$REFCNTD NUMBER NOT NULL,
T$REFCNTU NUMBER NOT NULL,
SUPPLEMENTAL LOG GROUP GGS_TTTPMC000000_938783 (T$SERN) ALWAYS
)
TABLESPACE C000DAT
PCTUSED 0
PCTFREE 10
INITRANS 3
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
CREATE UNIQUE INDEX ERPLN6A.TTTPMC000000$IDX1 ON ERPLN6A.TTTPMC000000
(T$SERN)
LOGGING
TABLESPACE C000IDX
PCTFREE 10
INITRANS 3
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL; 
Hi Cameron.
I just ran a quick test using a smaller version of your table using OGG 10.4 RedHat 5 and it worked. You might want to check the trail file using logdump found in the OGG installation directory. If it's not in the trail then something's up with your extract.
Here's what I did:
CREATE TABLE TTTPMC000000
(
T$SERN NUMBER NOT NULL,
T$PEXP NVARCHAR2(200) NOT NULL,
SUPPLEMENTAL LOG GROUP GGS_TTTPMC000000_938783 (T$SERN) ALWAYS
)
/
CREATE UNIQUE INDEX TTTPMC000000$IDX1 ON TTTPMC000000
(T$SERN)
/
SQL> desc TTTPMC000000
Name Null? Type
----------------------------------------- -------- ----------------------------
T$SERN NOT NULL NUMBER
T$PEXP NOT NULL NVARCHAR2(200)
SQL> insert into SOURCE.TTTPMC000000 values (1,'abc');
1 row created.
SQL> commit;
Commit complete.
SQL> update SOURCE.TTTPMC000000 set T$PEXP = 'def';
1 row updated.
SQL> commit;
Commit complete.
SQL> select * from SOURCE.TTTPMC000000;
T$SERN T$PEXP
---------- ------------
1 def
SQL> select * from TARGET.TTTPMC000000;
T$SERN T$PEXP
---------- ------------
1 def
cd $OGG_HOME
./logdump
Logdump 4266> cd dirdat/local
Logdump 4268> ghdr on
Logdump 4269> detail on
Logdump 4272> open ab000000
Logdump 4282 >pos 1110
Reading forward from RBA 1110
Logdump 4283 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 23 (x0017) IO Time : 2010/09/08 20:58:36.000.000
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 517 AuditPos : 14063120
Continued : N (x00) RecCount : 1 (x01)
2010/09/08 20:58:36.000.000 FieldComp Len 23 RBA 1110
Name: SOURCE.TTTPMC000000
After Image: Partition 4 G s
0000 0005 0000 0001 3100 0100 0a00 0000 0600 6400 | ........1.........d.
6500 66 | e.f
Column 0 (x0000), Len 5 (x0005)
Column 1 (x0001), Len 10 (x000a)
Hope this helps,
-joe 
info <<Extract Name>> , showch will show from
Startup Checkpoint / Recovery Checkpoint / Current Checkpoint .
Below example - Startup Checkpoint is from redolog.
Recovery Checkpoint / Current Checkpoint is reading from archivelog.
GGSCI (sglpdusab01a) 28> info ESGSPK1,showch
EXTRACT ESGSPK1 Last Started 2010-09-15 16:07 Status RUNNING
Checkpoint Lag 00:01:50 (updated 00:00:03 ago)
Log Read Checkpoint Oracle Redo Logs
2010-09-15 16:05:47 Seqno 1800, RBA 12113936
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Redo Log
Startup Checkpoint (starting position in the data source):
Sequence #: 1800
RBA: 12113936
Timestamp: 2010-09-15 16:05:47.000000
Redo File: /u02/oradata/UOSGTOYO/redo03.log
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Sequence #: 1800
RBA: 12113936
Timestamp: 2010-09-15 16:05:47.000000
Redo File: /ora_bkup/flash_recovery_area/UOSGTOYO/archivelog/2010_09_15/o1_mf_1_1800_690znz0x_.arc
Current Checkpoint (position of last record read in the data source):
Sequence #: 1800
RBA: 12113936
Timestamp: 2010-09-15 16:05:47.000000
Redo File: /ora_bkup/flash_recovery_area/UOSGTOYO/archivelog/2010_09_15/o1_mf_1_1800_690znz0x_.arc
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 4
RBA: 1008
Timestamp: 2010-09-15 16:07:37.377204
Extract Trail: /u02/ggsdata/out/cc
Header:
Version = 2
Record Source = A
Type = 4
# Input Checkpoints = 1
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2010-09-15 16:07:37
Last Update Time = 2010-09-15 16:07:37
Stop Status = A
Last Result = 0
GGSCI (sglpdusab01a) 29> 
User3726509,
My apologies for not seeing it, should it be obvious, but without at least a cursory set of verbs and nouns you make it rather difficult to dicerpher your meaning and intention. How does output from your extract "showch" assist in answering the current question?
Thanks,
-joe

lag replicat replicatename shows lag records

Hi, I saw this from lag replicat report:
4> lag replicat ractive7
Sending GETLAG request to REPLICAT RACTIVE7 ...
Last record lag: 80672 seconds.
At EOF, no more records to process.
The view report shows this:
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file ./dirdat/p7000000 at 2012-05-30 15:50:19
Processed extract process graceful restart record at seq 0, rba 1007.
2012-05-30 15:50:19 INFO OGG-01020 Processed extract process RESTART_ABEND record at seq 0, rba 1070 (aborted
0 records).
2012-05-30 15:50:19 INFO OGG-01020 Processed extract process RESTART_ABEND record at seq 0, rba 1133 (aborted
0 records).
2012-05-30 15:50:19 INFO OGG-01020 Processed extract process RESTART_ABEND record at seq 0, rba 1196 (aborted
0 records).
2012-05-30 15:50:19 INFO OGG-01020 Processed extract process RESTART_ABEND record at seq 0, rba 1259 (aborted
0 records).
2012-05-30 15:50:19 INFO OGG-01373 User requested start after CSN 84202736181.
2012-05-30 15:50:19 INFO OGG-01374 Transaction delivery commencing at position Seqno 0, RBA 1322, Transaction
ID 1.13.3310140, CSN 84205171099, 0 transaction(s) skipped.
2012-05-30 22:20:12 INFO OGG-01021 Command received from GGSCI: GETLAG.
2012-05-30 22:21:38 INFO OGG-01021 Command received from GGSCI: GETLAG.
2012-05-30 22:23:52 INFO OGG-01021 Command received from GGSCI: GETLAG.
What is the problem? seems no error message is given.
Thanks 
Could you post the output of info all from source and target sides ?
Seems there are no more trail files available for the Replicat to process.

goldengate from mysql to oracle

Hello evertbody:I tried goldengate to keep two databases synchronized,from mysql to oracle but met several errors.  Follows are my configuration and building process:---------------------------------environment---------------------------------source node :10.138.60.22mysql version : 5.6.15os user : oracledb user : mysyncdb name : sdbos version : centos 6.5goldengate uncompressed path : /usr/ogg  target node :10.100.12.12oracle version : 11.0.2.0.3os user : oracledb user: mysyncos version : centos 6.5goldengate uncompressed path : /usr/ogg  goldengate version :12.1.2.1---------------------------------environment---------------------------------  ---------------------------------installation---------------------------------1、install goldengate on both source and target node  [oracle#* ~]$ cd /usr/ogg/[oracle#* ogg]$ ./ggsciGGSCI (*) 1> create subdirs---------------------------------installation---------------------------------  ---------------------------------initial configration---------------------------------######source node######  1、configure mgr  GGSCI > dblogin sourcedb sdb#10.138.60.22:3306,userid mysync,password MySyncGGSCI > edit param mgrport 8899dynamicportlist 8910-8920, 8930AUTOSTART ER *AUTORESTART ER *, RETRIES 4, WAITMINUTES 4STARTUPVALIDATIONDELAY 5PURGEOLDEXTRACTS /usr/ogg/dirdat/*, USECHECKPOINTS, MINKEEPHOURS 2  2、configure initial extract  GGSCI > add extract extinit0, sourceistableGGSCI > edit param extinit0extract extinit0dboptions host 10.138.60.22, connectionport 3306sourcedb sdb#10.138.60.22:3306,userid mysync,password MySyncrmthost 10.100.12.12, mgrport 8899rmttask replicat, group repinit0table sdb.*;  3、configure defgen  GGSCI> edit params defgendefsfile ./dirdef/source.def, purgesourcedb sdb#10.138.60.22:3306,userid mysync,password MySyncsdb.t1;  4、build source.def file and transfer it from source node to target node[oracle#* ~]$ cd /usr/ogg/[oracle#* ogg]$ ./defgen paramfile ./dirprm/defgen.prm[oracle#* ogg]$ scp dirdef/source.def oracle#10.100.12.12:/usr/ogg/dirdef/sdb  ######source node######  $$$$$$target node$$$$  1、configure mgr  GGSCI> dblogin userid mysync,password mysync  GGSCI> edit params mgrport 8899dynamicportlist 8910-8920, 8930AUTOSTART ER *AUTORESTART ER *, RETRIES 4, WAITMINUTES 4STARTUPVALIDATIONDELAY 5PURGEOLDEXTRACTS /usr/ogg/dirdat/*, USECHECKPOINTS, MINKEEPHOURS 2  2、configure checkpointtable  GGSCI> add checkpointtable mysync.rep_checkpoint  3、configure initial replicat  GGSCI> add replicat repinit0, exttrail /usr/ogg/dirdat/e0, checkpointtable mysync.rep_checkpoint  GGSCI> edit param repinit0replicat repinit0userid mysync, password mysyncsourcedefs ./dirdef/sdb/source.defdiscardfile ./dirrpt/repinit0.dsc, purgemap sdb.t1, target mysync.t1;  $$$$$$target node$$$$---------------------------------initial configration---------------------------------  ---------------------------------synchronization configration---------------------------------######source node######  1、configure synchronization extractGGSCI> add extract v203app,tranlog,begin now  GGSCI> edit param v203appextract v203appdboptions host 10.138.60.22,connectionport 3306sourcedb sdb#10.138.60.22:3306,userid mysync,password MySyncrmthost 10.100.12.12,mgrport 8899rmttrail /usr/ogg/dirdat/e0tranlogoptions altlogdest /var/lib/mysql/binary-log.indextable sdb.*;  2、add remote trailGGSCI> add rmttrail /usr/ogg/dirdat/e0,extract v203app  ######source node######  $$$$$$target node$$$$  1、configure synchronization replicatGGSCI> add replicat r203papp, exttrail /usr/ogg/dirdat/e0, checkpointtable mysync.rep_checkpoint  GGSCI> edit param r203pappreplicat r203pappuserid mysync, password mysynchandlecollisionsassumetargetdefssourcedefs /usr/ogg/dirdef/sdb/source.defdiscardfile /usr/ogg/dirrpt/r203papp.dsc, purgemap sdb.t1, target mysync.t1;  $$$$$$target node$$$$---------------------------------synchronization configration---------------------------------  ---------------------------------start synchronization---------------------------------$$$$$$target node$$$$  GGSCI> start replicat r203papp  $$$$$$target node$$$$  ######source node######  GGSCI> start extract v203app  ######source node######---------------------------------start synchronization---------------------------------  ---------------------------------test synchronization---------------------------------  ######source node######  insert into t1 (c1,c2,c3,c4,c5,c6) values (1,'a',0,'a',now(),'a');commit;  ######source node######  $$$$$$target node$$$$ %%%%%%error message1%%%%%%in target ggserr.logerror   ogg-01163  oracle goldengate delivery for oracle, r203papp.prm:  bad column length (8) specified for column c3 in table sdb.t1, maximum allowable length is 4.  my action:modify table t1 definition on the target nodealter table t1 modify c3 varchar(20);  %%%%%%error message1%%%%%%  restarted replicat r203papp but met another error  %%%%%%error message2%%%%%%Sending START request to MANAGER ...  ERROR: Cannot create process '/usr/ogg/replicat'. Child process is no longer alive.  WARNING OGG-01742  Command sent to MGR MGR returned with an ERROR response.%%%%%%error message2%%%%%% $$$$$$target node$$$$ ---------------------------------test synchronization---------------------------------    ---------------------------------source tables definition---------------------------------  create table t1 (  c1 bigint(20) not null unique auto_increment,  c2 varchar(30) not null unique,  c3 int(20) default 0 not null ,  c4 varchar(11) not null unique,  c5 timestamp not null default now(),  c6 varchar(20) not null) engine=innodb default charset=utf8;  alter table t1 add constraint pk_t1_c1 primary key (c1);create index idx_t1_c3 on t1(c3);  ---------------------------------source tables definition---------------------------------  ---------------------------------target tables definition---------------------------------  create table t1 (  c1 number(20) not null unique,  c2 varchar(30) not null unique,  c3 number(20) default 0 not null ,  c4 varchar(11) not null unique,  c5 timestamp default sysdate not null,  c6 varchar(20) not null) ;  alter table t1 add constraint pk_t1_c1 primary key (c1);create index idx_t1_c3 on t1(c3);  ---------------------------------target tables definition--------------------------------- so,how to solve this issue?Pls help me!
Hi, remove assumetargetdefs from the Replicat parameter file and restart the Replicat and see if that works. When you have different source DBMS and target DBMS, or like to like but different table structures, you can't use assumetargetdefs. Also, handlecollisions is fine for testing, but do not use it in production.  Good luck
hi,after removed assumetargetdefs and handlecollisions from the replicat parameter file i tried to restart the replicat but met new errors  $$$$$$target node$$$$  ggsci > start replicat r203papp  sending start request to manager ...  error: cannot create process '/usr/ogg/replicat'. child process is no longer alive  2015-07-16 19:16:52  warning ogg-01742  command sent to mgr mgr returned with an error response.  and there was some error message in /usr/ogg/ggserr.log 2015-07-16 19:16:52  info    ogg-00996  oracle goldengate delivery for oracle, r203papp.prm:  replicat r203papp started.2015-07-16 19:16:52  info    ogg-03522  oracle goldengate delivery for oracle, r203papp.prm:  setting session time zone to source database time zone 'prc'.2015-07-16 19:16:52  info    ogg-03506  oracle goldengate delivery for oracle, r203papp.prm:  the source database character set, as determined from the trail file, is utf-8.2015-07-16 19:16:52  info    ogg-06505  oracle goldengate delivery for oracle, r203papp.prm:  map resolved (entry sdb.t1): map "sdb"."t1", target mysync.t1.2015-07-16 19:16:52  error  ogg-00423  oracle goldengate delivery for oracle, r203papp.prm:  could not find definition for sdb.t1.2015-07-16 19:16:52  error  ogg-01668  oracle goldengate delivery for oracle, r203papp.prm:  process abending.2015-07-16 19:16:52  info    ogg-00975  oracle goldengate manager for oracle, mgr.prm:  client_start_er_prog failed.2015-07-16 19:16:52  warning ogg-01742  oracle goldengate command interpreter for oracle:  command sent to mgr mgr returned with an error response.2015-07-16 19:16:55  info    ogg-01670  oracle goldengate collector for oracle:  closing /usr/ogg/dirdat/d2000006.2015-07-16 19:16:55  info    ogg-01676  oracle goldengate collector for oracle:  terminating after client disconnect.2015-07-16 19:16:56  info    ogg-01670  oracle goldengate collector for oracle:  closing /usr/ogg/dirdat/f0000002.2015-07-16 19:16:56  info    ogg-01676  oracle goldengate collector for oracle:  terminating after client disconnect. [...]# cat /usr/ogg/dirprm/r203papp.prmreplicat r203pappuserid mysync, password mysyncsourcedefs /usr/ogg/dirdef/sdb/source.def discardfile /usr/ogg/dirrpt/r203papp.dsc, purgemap sdb.t1, target mysync.t1; $$$$$$target node$$$$
Hi , Initially you have made some alters to the table. *2015-07-16 19:16:52  error  ogg-00423  oracle goldengate delivery fororacle, r203papp.prm:  could not find definition for sdb.t1.* *Please recreate the defgen file at source and copy it to the target. Thentry starting the replicat process.* Before starting the Replicat process, also check if your source and targetare in Sync. Regards,Veera
hi,i did configure source definition generator and transfer the source definition file to the target system,but why did i still met this error message:  ########source node########[root#source ~]# ll /usr/ogg/dirdef/source.def-rw-r----- 1 oracle oinstall 78693 Jun 23  2015 /usr/ogg/dirdef/source.def[root#source ~]# tail /usr/ogg/dirdef/source.def Definition for table sdb.t1Record length: 1546Syskey: 0Columns: 6c1  64    765        0  0  0 1 0    765    765      0 0 0 0 0 1    0 1  0  253      -1      0 0 0c2    64      1      770  0  0 1 0      1      1      0 0 0 0 0 1    0 0  4  16      -1      0 0 0c3  64    765      776  0  0 1 0    765    765      0 0 0 0 0 1    0 0  0  253      -1      0 0 0c4  64    765      776  0  0 1 0    765    765      0 0 0 0 0 1    0 0  0  253      -1      0 0 0c5  64    765      776  0  0 1 0    765    765      0 0 0 0 0 1    0 0  0  253      -1      0 0 0c6  64    765      776  0  0 1 0    765    765      0 0 0 0 0 1    0 0  0  253      -1      0 0 0End of definition########source node########  $$$$$$$$target node$$$$$$$$[root#target ~]# ll /usr/ogg/dirdef/sdb/source.def -rw-r-----. 1 oracle oinstall 78693 Jun 16 15:03 /usr/ogg/dirdef/sdb/source.def[root#target ~]# tail /usr/ogg/dirdef/sdb/source.def     Definition for table sdb.t1Record length: 1546Syskey: 0Columns: 6c1  64    765        0  0  0 1 0    765    765      0 0 0 0 0 1    0 1  0  253      -1      0 0 0c2    64      1      770  0  0 1 0      1      1      0 0 0 0 0 1    0 0  4  16      -1      0 0 0c3  64    765      776  0  0 1 0    765    765      0 0 0 0 0 1    0 0  0  253      -1      0 0 0c4  64    765      776  0  0 1 0    765    765      0 0 0 0 0 1    0 0  0  253      -1      0 0 0c5  64    765      776  0  0 1 0    765    765      0 0 0 0 0 1    0 0  0  253      -1      0 0 0c6  64    765      776  0  0 1 0    765    765      0 0 0 0 0 1    0 0  0  253      -1      0 0 0End of definition$$$$$$$$target node$$$$$$$$  ========error message========2015-07-16 19:16:52  info    ogg-00996  oracle goldengate delivery for oracle, r203papp.prm:  replicat r203papp started.2015-07-16 19:16:52  info    ogg-03522  oracle goldengate delivery for oracle, r203papp.prm:  setting session time zone to source database time zone 'prc'.2015-07-16 19:16:52  info    ogg-03506  oracle goldengate delivery for oracle, r203papp.prm:  the source database character set, as determined from the trail file, is utf-8.2015-07-16 19:16:52  info    ogg-06505  oracle goldengate delivery for oracle, r203papp.prm:  map resolved (entry sdb.t1): map "sdb"."t1", target mysync.t1.2015-07-16 19:16:52  error  ogg-00423  oracle goldengate delivery for oracle, r203papp.prm:  could not find definition for sdb.t1.2015-07-16 19:16:52  error  ogg-01668  oracle goldengate delivery for oracle, r203papp.prm:  process abending.2015-07-16 19:16:52  info    ogg-00975  oracle goldengate manager for oracle, mgr.prm:  client_start_er_prog failed.2015-07-16 19:16:52  warning ogg-01742  oracle goldengate command interpreter for oracle:  command sent to mgr mgr returned with an error response.2015-07-16 19:16:55  info    ogg-01670  oracle goldengate collector for oracle:  closing /usr/ogg/dirdat/d2000006.2015-07-16 19:16:55  info    ogg-01676  oracle goldengate collector for oracle:  terminating after client disconnect.2015-07-16 19:16:56  info    ogg-01670  oracle goldengate collector for oracle:  closing /usr/ogg/dirdat/f0000002.2015-07-16 19:16:56  info    ogg-01676  oracle goldengate collector for oracle:  terminating after client disconnect.========error message========
Hi , In your 3rd point, when creating the defgen file, there is a parameter error. You have missed the TABLE keyword before mentioning the tables in it. Please find the below correction.,  3、configure defgen  GGSCI> edit params defgendefsfile ./dirdef/source.def, purgesourcedb sdb#10.138.60.22:3306,userid mysync,password MySyncsdb.t1;  ---------> Change it to --------------> TABLE sdb.t1  Regards,Veera

Categories

Resources