The Latest Technology Stack News Directly from EBS Development

Using Oracle GoldenGate with Oracle E-Business Suite

Steven Chan
Senior Director

[Nov. 8, 2016 update: We are no longer evaluating the use of Golden Gate for EBS upgrades or platform migrations]

Oracle GoldenGate provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous systems.   The GoldenGate Administrator's Guide shows six supported topologies for generic databases.  Oracle GoldenGate is certified for a subset of three those methods in Oracle E-Business Suite Release 11i and 12 environments:

  1. Unidirectional (Reporting Instance):  From the E-Business Suite to a reporting instance
  2. Broadcast (Data Distribution): From the E-Business Suite to multiple external databases
  3. Consolidation (Data Warehouse/Mart/Store): From multiple sources, including the E-Business Suite, into a single external database
Three supported GoldenGate topologies in E-Business Suite environments

Procedures for replicating information from the E-Business Suite using GoldenGate to a secondary system are documented in:

Unidirectional  reporting only

Unidirectional replication only for EBS

GoldenGate is an extremely powerful solution, and one of its most-interesting features is the ability to provide data replication in both directions.  In some scenarios, you can choose to make alterations to replicated data on the external instance and have those changes updated back in the source database.

That's an exceedingly-slick GoldenGate feature, but that's not supported in E-Business Suite environments.  You can use GoldenGate to replicate EBS data to an external database, but you cannot move that altered data back into the EBS database.  GoldenGate's ability to read data in EBS databases is certified, but it must not be used to write to EBS databases.

"How" But Not "What"

GoldenGate is akin to a scalpel.  You're free to use it, but you must learn how to perform open heart surgery yourself.

The document above describes how to use GoldenGate to replicate data from the E-Business Suite to another system.  It doesn't provide any guidance about which database objects to replicate.

The E-Business Suite data model is vast, as you'd expect of something that has supports the integrated functioning of over 200 functional product modules.  GoldenGate is a development tool, and like all development tools, requires an expert-level understanding of the E-Business Suite data model for successful use.  Here's a good EBS data model resource:

What's Not Certified Today

The use of GoldenGate is not certified for:

  • Upgrading E-Business Suite databases from one version to another
  • Migrating E-Business Suite databases from one operating system platform to another

Why not?  Oracle GoldenGate doesn't (yet) support the replication of all of the datatypes that are used by the E-Business Suite.  That means that attempting to use GoldenGate to migrate or upgrade an entire E-Business Suite database will require a combination of GoldenGate and other manual steps to preserve referential integrity.  Naturally, the work required to research, create, test, and document those steps will require a formal certification effort. 

This certification effort is under consideration but is not formally scheduled yet.

Your feedback is welcome

Our GoldenGate is eager to hear about your experiences with this newly-certified E-Business Suite configuration.  If you post any comments here or send me an email directly, I'll make sure that I pass it on to the GoldenGate team.

Related Articles

Join the discussion

Comments ( 36 )
  • Sujoy Bhattacharjee Tuesday, June 14, 2011

    Hi Steven,

    It seems that GoldenGate supports more data types Oracle Streams. I remember the time when we had issues with using Oracle Streams for replicating EBS data not just because of the previous point but also because some database parameters required for EBS conflicted with those for Oracle Streams, hope this is not the case with GoldenGate.

    Are there any documents available which compare GoldenGate, Oracle Streams and Data Guard with respect to data replication in an EBS environment?

  • Doug Reid Wednesday, June 15, 2011

    Oracle GoldenGate is the strategic replication solution for the Oracle database and for heterogeneous databases. Although Oracle Streams replication will continue to be supported, moving forward, engineering investments will focus on Oracle GoldenGate.

    In terms of configuring Oracle GoldenGate for operational reporting, please reference the knowledge document on MOS: 1112325.1. For those EBS tables used as part of a GoldenGate reporting solution, there are no unsupported datatypes. That's not to say that there are no data types in EBS that can cause GoldenGate issues, but those are typically part of internal advance queue tables which are irrelevant to a reporting solution.

    When comparing Active Data Guard to GoldenGate for operational reporting, the big difference is that you would be limited to read-only reports when using an ADG standby. Whereas a GoldenGate target is readable and writable, so reports that write to temporary tables could be executed, but those same reports could not be run on an ADG standby, again because it is read-only.

  • Sujoy Bhattacharjee Thursday, June 16, 2011

    Thanks for the info Doug...will look up the note you mentioned.

    (Time to bid farewell to Oracle Streams)

  • Arun Thursday, July 7, 2011

    A good write up.

    I have a hands on for active active replication. check out my blog


  • Abip Saturday, February 4, 2012


    I am going to migrate our EBS DB Tier from HP-UX to Exadata (, and Apps Tier to 5.10 SPARC 64-Bit

    The version of components as following:

    1. EBS: running on HP-UX 11.11

    2. DB: running on HP-UX 11.11

    To minimize the down time, I am thinking to use OGG.

    Kindly, please help to verify the method:

    1. Clone the DB to HP-UX 11.31 (direct upgrade is not supported)

    2. Start OGG Extract Process to capture the changes

    3. Upgrade the DB to on HP-UX 11.31 (staging server)

    4. Use oracle TTS to duplicate the DB from the staging server to Exadata DB.

    5. Start OGG Replicat Process to apply the changes.

    6. Once Lag is caught up, do cutover

  • Elke Phelps (Oracle Development) Monday, February 6, 2012


    Thanks for the inquiry.

    As per this blog article, Golden Gate is not currently certified for migrating Oracle E-Business Suite databases from one operating system platform to another; therefore, the method you have outlined is not certified.

    As an update to the article, I can state that certification process for using Golden Gate to migrate Oracle E-Business Suite databases from one operating system platform to another is underway. Due to Oracle's revenue recognition policy, I'm not at liberty to provide a time line for the certification.

    Good luck with your migration.



  • Dinesh Tuesday, August 14, 2012

    Hi . thanks for the good post.

    I had a query . If Golden gate is used to create a unidirectional Reporting instance . How will the upgrade scneario handled when the source is planned to be upgraded.

    Can you please give me some pointers in that approach. as well



  • Doug Reid Thursday, August 16, 2012

    There are a couple of options to consider when dealing with this type of deployment:

    1. have GoldenGate replicate the DDL from the source to the remote system. When the table structure is changed on the source, the same change is sent to the target.

    2. Manually apply the upgrade changes to the target.

    3. Reinitialize the target tables affected.

    Hope that helps,


  • guest Tuesday, October 23, 2012

    Steven/Elke, your statement as of February 2012, "As an update to the article, I can state that certification process for using Golden Gate to migrate Oracle E-Business Suite databases from one operating system platform to another is underway. Due to Oracle's revenue recognition policy, I'm not at liberty to provide a time line for the certification."

    Is it certified yet? Thank you. Nancy

  • Steven Chan Tuesday, October 23, 2012

    Hello, Nancy,

    We've been evaluating this but have halted our investigations. There are significant technical challenges, notably around the large number (over 10,000) of EBS tables lacking primary keys. It is currently not possible to use Golden Gate in these types of situations without making substantive changes to the E-Business Suite data model itself.

    At this point, we're concluding that it is not feasible to use Golden Gate to migrate Oracle E-Business Suite databases from one operating system platform to another.



  • Parvinder Thursday, December 6, 2012


    I need to sync with 3 data centers, is Golden Gate work for 3 Data Centers? Please share the configurations path

  • Max Arderius Friday, December 7, 2012

    Parvinter, There is no single answer for that. There are so many implications on transporting data between data centers that I would rather suggest you involve Oracle Consulting or Oracle Support for further recommendations.

  • guest Wednesday, September 18, 2013

    Steven/Elke - can you provide an update to your comments from previous years about the certification of Golden Gate for:

    Upgrading E-Business Suite databases from one version to another

    Migrating E-Business Suite databases from one operating system platform to another

    Has certification been achieved?

    Many Thanks

  • Steven Chan Friday, September 27, 2013

    Hello, Guest,

    We don't have a certified solution yet, but we can put you in touch with a Consulting organization that may be able to assist. Would you like me to pass on your email to them?



  • Chenthil Tuesday, January 28, 2014

    Can we use golden gate for real time clones.

  • Elke Phelps (Oracle Development) Wednesday, January 29, 2014


    Thanks for the inquiry. Performing real time Oracle E-Business Suite clones with GoldenGate is not currently certified. As per this blog article, Oracle E-Business Suite has objects with datatypes that are GoldenGate currently cannot replicate. Migrating these objects will require a combination of GoldenGate and other manual steps. This work is not currenlty scheduled.

    Rapid Clone is the certified method for cloning Oracle E-Business Suite. Rapid Clone is documented in the following My Oracle Support Notes:

    - Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone[Article ID 1383621.1]

    - Cloning Oracle Applications Release 12 with Rapid Clone[Article ID 406982.1]



  • Samad Ul Haq Wednesday, March 5, 2014


    I want to know if we use Golden gate to create EBS DR to any other O/S, which oracle utility we should use to move ANYDATA and UROWID tables.


    Samad Ul Haq