Home » Server Options » Replication » No records were replicated (oracle 11gr2,)
No records were replicated [message #646785] Fri, 08 January 2016 13:03
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

hi,
I am replicating data from mysql to oracle 11g using Golden Gate, Initial data load is performing successfully, extract process is working fine but changes are not applied by replicate process , below are the steps which i have performed, kindly guide me where i am going wrong.
Thanks

[/Code/]

vi /etc/odbc.ini
*****************
[smpp6]
Driver = /usr/lib/libmyodbc3.so
Description = Connector/ODBC 3.51 Driver DSN
Server =10.168.20.104
Port =14420
User ="kannel"
Password ="****"
Database ="smpp6"
Option = 3
Socket = /tmp/mysql.sock


My.cnf
******


[client]
user = msandbox
password = msandbox
port = 14420
socket = /tmp/mysql.sock


[mysqld]
user = root
port = 14420
socket = /tmp/mysql.sock
basedir = /usr/src/5.5.19
datadir = /root/sandboxes/multi_msb_5_5_19/node1/data
pid-file = /root/sandboxes/multi_msb_5_5_19/node1/data/mysql_sandbox14420.pid
#log-slow-queries = /root/sandboxes/multi_msb_5_5_19/node1/data/msandbox-slow.log
#log = /root/sandboxes/multi_msb_5_5_19/node1/data/msandbox.log
#
# additional options passed through 'my_clause'
#
server-id=101
log-bin=/root/sandboxes/multi_msb_5_5_19/node1/data/mysql-bin
log-error=msandbox.err
binlog-do-db = smpp6
binlog_format=row


Defgen.prm
**********


DEFSFILE ./dirdef/source.def,PURGE
SOURCEDB smpp6@10.168.20.104:14420, userid kannel,password kannel
TABLE "smpp6.sent_sms2";




Initial Load Extract (e_s1.prm )
********************


SOURCEISTABLE
DBOPTIONS HOST 10.168.20.104, CONNECTIONPORT 14420
SOURCEDB smpp6@10.168.20.104:14420, USERID "****l", PASSWORD "kannel"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTFILE ./dirdat/G4,MEGABYTES 2, PURGE
TABLE smpp6.sent_sms2;




Initial Load Replicat
*********************
SPECIALRUN
END RUNTIME
USERID ggs_owner, PASSWORD *****
EXTFILE ./dirdat/G4
SOURCEDEFS ./dirdef/source.def
MAP "smpp6.sent_sms2", TARGET MYSQL_SMPP6.sent_sms2, COLMAP (usedefaults,COMPRESS_=compress,SERVICE=@STRCAT(service,"_sms"));


Extract Group
*************
dblogin SOURCEDB smpp6@10.168.20.104:14420, USERID "kannel", PASSWORD "kannel"


add extract e_smpp6, tranlog, begin now


edit e_smpp6
************


EXTRACT e_smpp6
DBOPTIONS HOST 10.168.20.104, CONNECTIONPORT 14420
SOURCEDB smpp6@10.168.20.104:14420, USERID "kannel", PASSWORD "*****"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTTRAIL ./dirdat/G9
TRANLOGOPTIONS ALTLOGDEST /root/sandboxes/multi_msb_5_5_19/node1/data/mysql-bin.index
TABLE "smpp6.sent_sms2";




add rmttrail ./dirdat/G9 , extract e_smpp6, megabytes 10




info rmttrail *


Extract Trail: ./dirdat/G9
Extract: E_SMPP6
Seqno: 0
RBA: 0
File Size: 10M




GGSCI> start extract e_smpp6




Sending START request to MANAGER ...
EXTRACT E_SMPP6 starting




GGSCI> info extract e_smpp6, detail


EXTRACT E_SMPP6 Last Started 2016-01-08 18:52 Status RUNNING
Checkpoint Lag 00:08:51 (updated 00:00:02 ago)
VAM Read Checkpoint 2016-01-08 18:44:12.183037



Target Extract Trails:


Remote Trail Name Seqno RBA Max MB


./dirdat/G9 0 950 10


Extract Source Begin End


Not Available 2016-01-08 18:44 2016-01-08 18:44
Not Available * Initialized * 2016-01-08 18:44






GGSCI (ets-psql-db.etisalcom.private) 20> view report e_smpp6




***********************************************************************
Oracle GoldenGate Capture for MySQL
Version 11.1.1.1.1 OGGCORE_11.1.1.1.1_PLATFORMS_110729.1700
Linux, x86, 32bit (optimized), MySQL Enterprise on Jul 29 2011 22:59:29

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.




Starting at 2016-01-08 18:52:58
***********************************************************************


Operating System Version:
Linux
Version #1 SMP Thu Sep 26 15:48:34 EDT 2013, Release 2.6.18-348.18.1.el5PAE
Node: ets-psql-db.etisalcom.private
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited


Process id: 17605


Description:


***********************************************************************
** Running with the following parameters **
***********************************************************************
EXTRACT e_smpp6
DBOPTIONS HOST 10.168.20.104, CONNECTIONPORT 14420
SOURCEDB smpp6@10.168.20.104:14420, USERID "kannel", PASSWORD "******"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTTRAIL ./dirdat/G9
TRANLOGOPTIONS ALTLOGDEST /root/sandboxes/multi_msb_5_5_19/node1/data/mysql-bin.index
TABLE "smpp6.sent_sms2";


CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 2G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 2.90G
CACHESIZEMAX (strict force to disk): 2.66G


Database Version:
MySQL
Server Version: 5.5.19-enterprise-commercial-advanced-log
Client Version: 6.0.0
Host Connection: 10.168.20.104 via TCP/IP
Protocol Version: 10


2016-01-08 18:53:03 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).


2016-01-08 18:53:03 INFO OGG-01052 No recovery is required for target file ./dirdat/G9000000, at RBA 0 (file not opened).


2016-01-08 18:53:03 INFO OGG-01478 Output file ./dirdat/G9 is using format RELEASE 10.4/11.1.


2016-01-08 18:53:03 INFO OGG-00182 VAM API running in single-threaded mode.


2016-01-08 18:53:03 INFO OGG-01515 Positioning to begin time Jan 8, 2016 6:44:12 PM.


***********************************************************************
** Run Time Messages **
***********************************************************************
Starting initial load Extract
*****************************


extract paramfile ./dirprm/e_s1.prm reportfile ./dirrpt/e_s1.rpt


Output to ./dirdat/G4:


From Table smpp6.sent_sms2:
# inserts: 1
# updates: 0
# deletes: 0
# discards: 0




Starting Initial Load replicat
*******************************




** Run Time Statistics ** *
***********************************************************************


Last record for the last committed transaction is the following:
___________________________________________________________________
Trail name : ./dirdat/G4
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 498 (x01f2) IO Time : 2016-01-08 20:22:30.127118
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 0 AuditPos : 0
Continued : N (x00) RecCount : 1 (x01)


2016-01-08 20:22:30.127118 Insert Len 498 RBA 912
Name: smpp6.sent_sms2
___________________________________________________________________


Reading ./dirdat/G4, current RBA 1476, 1 records


Report at 2016-01-08 20:44:06 (activity since 2016-01-08 20:44:06)


From Table smpp6.sent_sms2 to MYSQL_SMPP6.SENT_SMS2:
# inserts: 1
# updates: 0
# deletes: 0
# discards: 0




Last log location read:
FILE: ./dirdat/G4
RBA: 1476
TIMESTAMP: 2016-01-08 20:22:30.127118
EOF: NO
READERR: 400




Start replicat Group
********************

GGSCI (racnode1) 2> add replicat r_smpp6, exttrail ./dirdat/G9 , checkpointtable ggs_owner.checkpoint


REPLICAT added.




GGSCI) start replicat r_smpp6


GGSCI) info replicat r_smpp6


REPLICAT R_SMPP6 Last Started 2016-01-08 20:51 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint File ./dirdat/G9000000
2016-01-08 20:53:38.791659 RBA 2827


GGSCI) send extract e_smpp6, report


Sending REPORT request to EXTRACT E_SMPP6 ...
Request processed.




GGSCI) 2> view report e_smpp6




***********************************************************************
Oracle GoldenGate Capture for MySQL
Version 11.1.1.1.1 OGGCORE_11.1.1.1.1_PLATFORMS_110729.1700
Linux, x86, 32bit (optimized), MySQL Enterprise on Jul 29 2011 22:59:29

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.




Starting at 2016-01-08 18:52:58
***********************************************************************


Operating System Version:
Linux
Version #1 SMP Thu Sep 26 15:48:34 EDT 2013, Release 2.6.18-348.18.1.el5PAE
Node: ets-psql-db.etisalcom.private
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited


Process id: 17605


Description:


***********************************************************************
** Running with the following parameters **
***********************************************************************
EXTRACT e_smpp6
DBOPTIONS HOST 10.168.20.104, CONNECTIONPORT 14420
SOURCEDB smpp6@10.168.20.104:14420, USERID "kannel", PASSWORD "******"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTTRAIL ./dirdat/G9
TRANLOGOPTIONS ALTLOGDEST /root/sandboxes/multi_msb_5_5_19/node1/data/mysql-bin.index
TABLE "smpp6.sent_sms2";


CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 2G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 2.90G
CACHESIZEMAX (strict force to disk): 2.66G


Database Version:
MySQL
Server Version: 5.5.19-enterprise-commercial-advanced-log
Client Version: 6.0.0
Host Connection: 10.168.20.104 via TCP/IP
Protocol Version: 10


2016-01-08 18:53:03 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).


2016-01-08 18:53:03 INFO OGG-01052 No recovery is required for target file ./dirdat/G9000000, at RBA 0 (file not opened).


2016-01-08 18:53:03 INFO OGG-01478 Output file ./dirdat/G9 is using format RELEASE 10.4/11.1.


2016-01-08 18:53:03 INFO OGG-00182 VAM API running in single-threaded mode.


2016-01-08 18:53:03 INFO OGG-01515 Positioning to begin time Jan 8, 2016 6:44:12 PM.


***********************************************************************
** Run Time Messages **
***********************************************************************




2016-01-08 20:09:18 INFO OGG-01516 Positioned to Log Number: 15
Record Offset: 3418, Jan 8, 2016 8:09:17 PM.


2016-01-08 20:09:18 INFO OGG-01517 Position of first record processed Log Number: 15
Record Offset: 3418, Jan 8, 2016 8:09:17 PM.
TABLE resolved (entry smpp6.sent_sms2):
TABLE smpp6.sent_sms2;


Using the following key columns for source table smpp6.sent_sms2: sql_id, momt, sender, receiver, time, smsc_id, service, account, id, sms_type, mcla
ss, mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo.


2016-01-08 20:54:53 INFO OGG-01021 Command received from GGSCI: REPORT.


***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************

Report at 2016-01-08 20:54:53 (activity since 2016-01-08 20:09:51)


Output to ./dirdat/G9:


From Table smpp6.sent_sms2:
# inserts: 3
# updates: 0
# deletes: 0
# discards: 0




***********************************************************************
** Run Time Warnings **
***********************************************************************




GGSCI (racnode1) 10> send replicat r_smpp6, report


Sending REPORT request to REPLICAT R_SMPP6 ...
Request processed.




GGSCI (racnode1) 11> view report r_smpp6




***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct 7 2011 05:44:59

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.




Starting at 2016-01-08 20:51:41
***********************************************************************


Operating System Version:
Linux
Version #1 SMP Fri Aug 26 19:08:58 EDT 2011, Release 2.6.18-274.3.1.el5xen
Node: racnode1
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited


Process id: 14163


Description:


***********************************************************************
** Running with the following parameters **
***********************************************************************
REPLICAT R_SMPP6
USERID ggs_owner, PASSWORD ******
HANDLECOLLISIONS
SOURCEDEFS ./dirdef/source.def
DISCARDFILE /u01/app/oracle/oradata/GG/dirrpt/r_smpp6.dsc, PURGE
MAP "smpp6.sent_sms", TARGET MYSQL_SMPP6.sent_sms2, COLMAP (usedefaults,COMPRESS
_=compress,SERVICE=@STRCAT(service,"_sms"));


CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 512M
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 1G
CACHESIZEMAX (strict force to disk): 881M


Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


Database Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will b
e used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7A
SCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"


Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.


***********************************************************************
** Run Time Messages **
***********************************************************************


Opened trail file ./dirdat/G9000000 at 2016-01-08 20:51:41


2016-01-08 20:57:09 INFO OGG-01021 Command received from GGSCI: REPORT.


***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************


Last record for the last committed transaction is the following:
___________________________________________________________________
Trail name : ./dirdat/G9000000
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 515 (x0203) IO Time : 2016-01-08 20:53:38.791659
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 2742 AuditPos : 16
Continued : N (x00) RecCount : 1 (x01)


2016-01-08 20:53:38.791659 Insert Len 515 RBA 2190
Name: smpp6.sent_sms2
___________________________________________________________________


Reading ./dirdat/G9000000, current RBA 2827, 0 records


Report at 2016-01-08 20:57:09 (activity since 2016-01-08 20:51:41)


No records were replicated.


***********************************************************************
** Run Time Warnings **
***********************************************************************
Previous Topic: Teradata Replication
Next Topic: Data Integrator
Goto Forum:
  


Current Time: Thu Mar 28 17:28:15 CDT 2024