Golgen Gate 11g, Error mapping
J.A.Apr 27 2012 — edited May 3 2012Hi 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