Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golgen Gate 11g, Error mapping

J.A.Apr 27 2012 — edited May 3 2012
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
This post has been answered by User11957149-Oracle on Apr 27 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2012
Added on Apr 27 2012
14 comments
3,012 views