Home » Server Options » Replication » Golden gate Oracle to MYSQL replication not happening (Oracle GoldenGate Delivery for MySQL Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230 Linux, x86, 32bit (optimized))
Golden gate Oracle to MYSQL replication not happening [message #645619] Thu, 10 December 2015 00:21
S007
Messages: 1
Registered: December 2015
Location: Chennai
Junior Member
Hi all,

I am trying to setup golden gate replication with oracle database 11.2.0.1.0 (Source) to Mysql (target).My initial data load is happening successful and records getting populated to target db but real time change replication is not happening.That is when I insert or update any record in source db (oracle DB) its not be replicated in target database(mysql).I dont find any errors in ggserr.log.

EXTRACT PARAMETER FILE AT SOURCE
=====================================

--extract group ---
extract ext_ora
--connection to database--
userid ggate,password ggate
SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8MSWIN1252")
--hostname and port for trail--
rmthost 192.168.32.148,mgrport 7809
--trail
rmttrail /u01/golden_gate/dirdat/lt
tranlogoptions asmuser sys@asm,asmpassword oracle
--include tables--
table ggate.emp;

REPLICAT PARAMETER FILE AT TARGET
==================================

replicat rep_msql
targetdb test@mysql.test,userid root,password mysql
HANDLECOLLISIONS
sourcedefs ./dirdef/source.def
discardfile ./dirrpt/rep_msql.dsc,PURGE
MAP ggate.emp, target test.emp;

I am also able to see trial file generating at target server in the mentioned location.

GGSERR.log file content at target server (MYSQL)
======================================

2015-12-01 22:49:50 INFO OGG-00996 Oracle GoldenGate Delivery for MySQL, re
p_msql.prm: REPLICAT REP_MSQL started.
2015-12-01 22:50:15 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, mgr
.prm: Command received from EXTRACT on host 192.168.32.145 (START SERVER CPU -1
PRI -1 TIMEOUT 300 PARAMS ).
2015-12-01 22:50:15 INFO OGG-01677 Oracle GoldenGate Collector for MySQL:
Waiting for connection (started dynamically).
2015-12-01 22:50:15 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, mgr
.prm: Command received from SERVER on host mysql.oracle.com (REPORT 5579 7819).
2015-12-01 22:50:15 INFO OGG-00974 Oracle GoldenGate Manager for MySQL, mgr
.prm: Manager started collector process (Port 7819).
2015-12-01 22:50:15 INFO OGG-01228 Oracle GoldenGate Collector for MySQL:
Timeout in 300 seconds.
2015-12-01 22:50:30 INFO OGG-01229 Oracle GoldenGate Collector for MySQL:
Connected to :31951.
2015-12-01 22:50:30 INFO OGG-01669 Oracle GoldenGate Collector for MySQL:
Opening /u01/golden_gate/dirdat/lt000021 (byte -1, current EOF 2108).
2015-12-01 22:50:30 INFO OGG-01670 Oracle GoldenGate Collector for MySQL:
Closing /u01/golden_gate/dirdat/lt000021.
2015-12-01 22:50:30 INFO OGG-01669 Oracle GoldenGate Collector for MySQL:
Opening /u01/golden_gate/dirdat/lt000021 (byte 2108, current EOF 2108).
2015-12-01 22:50:30 INFO OGG-01735 Oracle GoldenGate Collector for MySQL:
Synchronizing /u01/golden_gate/dirdat/lt000021 to disk.
2015-12-01 22:50:30 INFO OGG-01735 Oracle GoldenGate Collector for MySQL:
Synchronizing /u01/golden_gate/dirdat/lt000021 to disk.
2015-12-01 22:50:30 INFO OGG-01670 Oracle GoldenGate Collector for MySQL:
Closing /u01/golden_gate/dirdat/lt000021.
2015-12-01 22:50:30 INFO OGG-01669 Oracle GoldenGate Collector for MySQL:
Opening /u01/golden_gate/dirdat/lt000022 (byte -1, current EOF 0).

Kindly let me know whether i am missing anything to add in parameter files or any other configurations need to be checked.

Regards,
S007
Previous Topic: Bi-directional Replication is not working only unidirectional working
Next Topic: error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found
Goto Forum:
  


Current Time: Thu Mar 28 18:18:43 CDT 2024