Thinking Out Loud

February 21, 2012

My Bi-directional Replication Using GoldenGate Adventure, Ep4

Filed under: 11g,GoldenGate,oracle — mdinh @ 4:20 am

The above link contains all the configurations for GoldenGate.

The parameter files (*.prm) should reside at GG_HOME/dirprm

The macro file (macrolib.mac) should reside at GG_HOME/dirmac

Don’t forget to execute ADD TRANDATA or ADD SCHEMATRANDATA before starting the manager, extract, datapump extract, replicat.

Next step, create tables and test data.

Stay tuned and I will share with you the stored procedure used to create PK sequences to avoid collisions.


1 Comment »

  1. nice post

    Comment by Dell Loggis — February 21, 2012 @ 3:07 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a free website or blog at

%d bloggers like this: