| Data not getting replicated on target during online synchronization [message #606572] |
Mon, 27 January 2014 02:37  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
Hi,
I am testing for online data synchronization using Golden Gate between oracle databases in Linux (x86_64) and Windows 7. I tested initial load extract method and it was working fine. But when I try to test for online data synchronization, its ending up with below error message in replicat process side on target database.
Quote:2014-01-27 11:51:19 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, REP1.prm: REPLICAT REP1 started.
2014-01-27 11:51:19 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, REP1.prm: NLS_LANG character set WE8MSWIN1252 on the target is different from the source database character set AL32UTF8. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2014-01-27 11:51:19 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, REP1.prm: Aborted grouped transaction on 'TEST.CT1', Database error 1403 (OCI Error ORA-01403: no data found, SQL <UPDATE "TEST"."CT1" SET "OBJECT_NAME" = :a1 WHERE "RNO" = :b0>).
2014-01-27 11:51:19 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1216 in seqno 2.
2014-01-27 11:51:19 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, REP1.prm: SQL error 1403 mapping CTEST.CT1 to TEST.CT1 OCI Error ORA-01403: no data found, SQL <UPDATE "TEST"."CT1" SET "OBJECT_NAME" = :a1 WHERE "RNO" = :b0>.
2014-01-27 11:51:19 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1216 in seqno 2.
2014-01-27 11:51:19 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP1.prm: Error mapping from CTEST.CT1 to TEST.CT1.
2014-01-27 11:51:19 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP1.prm: PROCESS ABENDING.
2014-01-27 11:53:08 INFO OGG-01014 Oracle GoldenGate Delivery for Oracle, REP1.prm: Positioning with begin time: Jan 27, 2014 10:53:02 AM, starting record time: Jan 27, 2014 10:51:44 AM at extseqno 3, extrba 1219.
2014-01-27 11:53:08 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, REP1.prm: REPLICAT REP1 started.
2014-01-27 11:55:33 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, REP1.prm: Aborted grouped transaction on 'TEST.CT1', Database error 1403 (OCI Error ORA-01403: no data found, SQL <DELETE FROM "TEST"."CT1" WHERE "RNO" = :b0>).
2014-01-27 11:55:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1219 in seqno 3.
2014-01-27 11:55:33 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, REP1.prm: SQL error 1403 mapping CTEST.CT1 to TEST.CT1 OCI Error ORA-01403: no data found, SQL <DELETE FROM "TEST"."CT1" WHERE "RNO" = :b0>.
2014-01-27 11:55:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1219 in seqno 3.
2014-01-27 11:55:33 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP1.prm: Error mapping from CTEST.CT1 to TEST.CT1.
2014-01-27 11:55:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP1.prm: PROCESS ABENDING.
The data in both SOURCE and TARGET are same in the database and there is no mismatch. Even the definitions of the table are same.
Parameters of Extract and Replicat process are given below
Quote:
EXTRACT ext1
userid gg_admin,password gg_admin
TRANLOGOPTIONS asmuser sys@ASM asmpassword sysasm
rmthost 172.27.5.212,MGRPORT 7809
rmttrail E:\oracle\gg\dirdat\rt
table ctest.ct1;
REPLICAT rep1
assumetargetdefs
userid gg_admin,password gg_admin
MAP ctest.ct1,TARGET test.ct1;
I again went with below option thinking there may be some checkpoint lag as I am using checkpoint table for replicat process.
alter replicat process rep1, begin now
Kindly advise, what could be the problem.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
