Perth, Australia
+ (61) 417713124

Oracle GoldenGate Tutorial 5 – configuring online change synchronization

  • Posted by Gavin Soorma
  • On February 17, 2010
  • change synchronization, GoldenGate, online extract, online replicat

In our earlier tutorial, we examined how to create a GoldenGate environment for initial data capture and load.

In this tutorial, we will see how by using GoldenGate change synchronization, changes that occur on the source (Oracle 11g on Linux) are applied near real time on the target (Oracle 11g

You need to be logged in to see this part of the content. Please Login to access.


  • Apr 5 2010
Can we extract from physical standy, to avoid load on primary server?
  • Jun 3 2010
Hi Gavin, When i start a replicat process for online synchronisation it abends with the following error GGS ERROR 101 Oracle GoldenGate Delivery for Oracle, EMP_REP.prm: Invalid option for MAP: . I am trying to synchronize two tables(with same structure) of same database(Oracle) but different schemas. Some you please solve this for me. Thanks, Kamal
  • Jun 3 2010
Hi, Solved the problem. The error was due to a space missing between the comma (,) and TARGET (keyword) in the Replicat params file. eg: my params had MAP sourcetable,TARGET targettable; instead of MAP sourcetable, TARGET targettable; Thanks, Kamal
Gavin Soorma
  • Jun 27 2010
Hi Philip - I think what you can do is that you can create a materialized view based on the records you want from the source table 1 and table 2 and use this MV to push records to table 3 in the target database - GGate allows column transformations and column mapping, but I think the mapping is from one source table to one target table - not sure if you can do mapping where you say I want column a and b from table 1 and column c and d from table 2 to become 4 columns in target table 3 ....
  • Sep 2 2010
Hi gavin , i was trying to install Goldengate 10.4 on IBM AIX 5.3 powerssytem after tar ing the files when i try to run ggsci i get below errors Could not load program ggsci: Symbol resolution failed for ggsci because: Symbol _GetCatName__FiPCc (number 159) is not exported from dependent module /usr/lib/libC.a[ansi_64.o]. Symbol __ct__Q2_3std8_LocinfoFPCci (number 184) is not exported from dependent module /usr/lib/libC.a[ansi_64.o]. Examine .loader section symbols with the 'dump -Tv' command. please let me know solutions if you have come across this kind of problem
Gavin Soorma
  • Sep 22 2010
Before launching ggsci, check your environment - LD_LIBRARY_PATH and LIBPATH - it should point to $ORACLE_HOME/lib
  • Oct 28 2010
Hi Gavin, Your explanation are really good. I have a small confusion that we can implement the Golden Gate other than Oracle Databases. Then how can it recognize the transactions of someother db. I have read that trail file will be i UDF(Universal Data Fomat). How this really works. If possible can u please post the sample trail file Thanks in advance for ur suggestions Raghu
Gavin Soorma
  • Oct 29 2010
Hi Raghu - the Golden Gate extract process writes to a trail file which is stored on the OS file system in proprietory format which can be read only by Goldengate - the trail file is the same as far as Golden Gate is concerned whether the source database is 9i or 10g or 11g or even some other RDBMS like DB2 or Sybase. The same trail file is then read by the GoldenGate replicat process and it does not matter to it what was the source database from where the trail file came from - it just reads the trail file. I am not sure what your doubt is - but Goldengate is available for most main RDBMS types other than just Oracle
  • Jan 29 2011
Gavin..i was working on this tool for 5-6 various capacities as tech support/consulting etc etc...after reading the tutorials ...i can say you did an excellant job...and you have a great heart to share the knowledge and help others ...i salute that spirit -Antony
  • Feb 9 2011
Hi, Is there any way to specify timewise asynchronize replication. Like 15 mins/hour replication? Thanks
Terry Alexander
  • Mar 8 2011
Gavin, Your a star. Your examples are very good. I have been trying to follow the examples in a book I bought. There have been a few problems with the examples in the book. But your's are spot on thanks Gavin. Cheers, Terry
  • Mar 11 2011
Hi I have a Primary environment which is a 2 node rac environment and secondary environment which is a single node environment I have successfully tested replication of SCHEMA from Production environment to Secondary environment However the following scenario is where i would request your expert advise and guidance if we have to do any testing , we shut down the primary server , then perform the testing on the seconary server ( which is in sync due to the goldengate replication ) after we have verified that the testing is successfully we know want to replicate this back on the primary environment Under this circumstance the one option is that after the testing is complete , copy the secndary database to prmary server nd recreate the rac enviroment and release to the users however doing this is very time consuming for us in our environment under this scenario is there an easier option in which we can configure goldengate to sync up the changes from secondary back to primary after the testing is complete Thanks a lot , looking forward to your comments
Arun Upadhyay
  • Apr 7 2017
Thank you !!!

Leave Reply

Your email address will not be published. Required fields are marked *