Hi All,

I have planned to use Oracle Golden Gate for schema/selected tables replication. I done installation successful.
The manager, extraction & replication process get started. Before that my team, read major GG related docs.
After all installation, we started testing and found that updation to the tables replication does not work. While
testing DDL, Inserts, deletion worked fine (replication to other schema happened).


We have done setting on Linux & windows and to both db updation replication does not works. The setting is - one DB
having one schem as source and other schema as target. DLL/insert/deletion/trucation happens correctly but while update
follwoing error to ggserr.log

2010-05-27 10:43:52 GGS INFO 320 Oracle GoldenGate Delivery for Oracle, REP1.prm: REPLICAT REP1 starting.
2010-05-27 10:43:52 GGS INFO 320 Oracle GoldenGate Delivery for Oracle, REP1.prm: REPLICAT REP1 started.
2010-05-27 10:46:03 GGS INFO Z0-05E Oracle GoldenGate Delivery for Oracle, REP1.prm: Setting current schema for DDL operation to [RECEIVER].
2010-05-27 10:46:03 GGS INFO Z0-05F Oracle GoldenGate Delivery for Oracle,
REP1.prm: Restoring current schema for DDL operation to [GGATE].
2010-05-27 10:47:07 GGS WARNING 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: Aborted grouped transaction on 'RECEIVER.TEST_TAB_1', Database error 100 (retrieving bind info for query).
2010-05-27 10:47:07 GGS WARNING 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 2637 in seqno 0.
2010-05-27 10:47:07 GGS WARNING 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: SQL error 1403 mapping SENDER.TEST_TAB_1 to RECEIVER.TEST_TAB_1.
2010-05-27 10:47:07 GGS WARNING 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 2637 in seqno 0.
2010-05-27 10:47:07 GGS ERROR 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: Error mapping from SENDER.TEST_TAB_1 to RECEIVER.TEST_TAB_1.
2010-05-27 10:47:07 GGS ERROR 190 Oracle GoldenGate Delivery for Oracle,

Kindly help me to resolve above issue.


The following are the process setups:

--extract group--
extract ext1
--connection to database--
userid ggate, password qwerty
--hostname and port for trail--
rmthost 10.1.1.117, mgrport 7809
--path and name for trail--
rmttrail 'd:\ogg10g\dirdat\lt'
--DDL support
ddl include mapped objname sender.*;
--DML
table sender.*


--Replicat group --
replicat rep1
--source and target definitions
ASSUMETARGETDEFS
--target database login --
userid ggate, password ggate
--file for dicarded transaction --
discardfile d:\ogg10g\dirdat\rep1_discard.txt, append, megabytes 10
--ddl support
DDL
--Specify table mapping ---
map sender.*, target receiver.*;


create table sender.test_tab_1 (id number,rnd_str varchar2(12));

DECLARE
BEGIN
FOR i IN 1 .. 10 LOOP
INSERT INTO test_tab_1 VALUES (i, 'INDUS' );

END LOOP;
COMMIT;

END;
/

update test_tab_1
set rnd_str = ' RSYS'
where id = 5;