X

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

    http://arundaskalathil.blogspot.com/2011/06/goldengate-active-activebidirectional.html


  • Abip Saturday, February 4, 2012

    Hi,

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

    The version of components as following:

    1. EBS: 11.5.10.2 running on HP-UX 11.11

    2. DB: 10.2.0.3 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 10.2.0.3 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 11.2.0.2 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

    Abip,

    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.

    Regards,

    ~ep


  • 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

    Thanks

    Dinesh


  • 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,

    Doug


  • 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.

    Regards,

    Steven


  • Parvinder Thursday, December 6, 2012

    Hi,

    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?

    Regards,

    Steven


  • Chenthil Tuesday, January 28, 2014

    Can we use golden gate for real time clones.


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

    Chenthil,

    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]

    Thanks.

    Elke


  • Samad Ul Haq Wednesday, March 5, 2014

    Hi,

    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.

    Regards

    Samad Ul Haq


  • Steven Chan Wednesday, March 12, 2014

    Hello, Samad,

    GoldenGate can be used to extract subsets of E-Business Suite data, as described in the article above.

    As noted above, it cannot be used for any other scenarios. It cannot be used for disaster recovery purposes due to limitations in datatype support and other considerations (including the lack of primary keys for over 10,000 EBS tables).

    You should use Oracle Data Guard or Oracle Active Data Guard to meet your EBS disaster recovery requirements.

    Regards,

    Steven


  • Diwakar Rao Tuesday, May 6, 2014

    Hi Steven/Elke,

    We are upgrading our EBS version 11.5.10.2/11.2.0.2(db) to 12.1.3/11.2.0.4 along with platform migration from solaris to AIX.

    Can you please give an update on goldengate certification, whether it will work with EBS db platform migration.

    Regards,

    Diwakar.


  • Elke Phelps (Oracle Development) Wednesday, May 7, 2014

    Diwakar,

    Greetings. Thanks for your inquiry. We currently have not certified the use of GoldenGate with Oracle E-Business Suite for platform migrations.

    Thanks.

    Elke


  • anil Thursday, June 5, 2014

    Hi,

    Can I use golden gate replication for R12 Ebusiness suite database (11.2.0.2.0).

    My source platform is Solaris 11.1 and target platform will be Linux 5.6.


  • Elke Phelps (Oracle Development) Thursday, June 5, 2014

    Anil,

    Greetings. Thanks for your inquiry. We currently have not certified the use of GoldenGate with Oracle E-Business Suite for database platform migrations.

    Regards,

    Elke


  • Pdaga Wednesday, September 24, 2014

    I have multiple ERP E Business Instances on different version. Can I use Golden gate for consolidation of instances


  • Steven Chan Wednesday, September 24, 2014

    Hello, Pdaga,

    There are no off-the-shelf utilities for consolidating EBS instances automatically. This is something that typically requires assistance from Oracle Consulting. They might use Golden Gate as one of several tools required to accomplish this goal.

    Regards,

    Steven


  • guest Friday, October 17, 2014

    Hi

    Can golden gate take the dtabase objects like FND% packages from EBS instance to replicated DB using Golden gate.

    Thanks

    Navin


  • Steven Chan Tuesday, October 21, 2014

    Hi, Navin,

    You can use Golden Gate to replicate any EBS tables as long as Golden Gate supports the datatypes in that table.

    Regards,

    Steven


  • guest Monday, November 24, 2014

    Can we use this solution with Oracle apps 12.2.3 release?


  • Steven Chan Tuesday, December 2, 2014

    Hello, Guest,

    Sorry for the delay in responding to this.

    Not yet. We're in the final stages of certifying Golden Gate with EBS 12.2.3 right now.

    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates in a new article as soon as soon as they're available.

    Regards,

    Steven


  • guest Thursday, April 2, 2015

    Hi,

    May I know whether any of Oracle GoldenGate version has certified to use with EBS 12.2.4 ?

    Regards,

    Vishal


  • Steven Chan Tuesday, April 7, 2015

    Hi, Vishal,

    Not yet. We're working on that certification right now.

    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.

    Regards,

    Steven


  • guest Thursday, July 23, 2015

    If I have an update statement on Source which says "UPDATE EMP SET SALARY = SALARY * 1.1 WHERE DEPTNO > 20; there may be more than 1 row which gets updated since DEPTNO IS NOT PRIMARY KEY. Should DEPTNO also be logged on the source system? Will Replicat also generate the same update statement and update many rows simultaneously on the target?


  • guest Friday, July 24, 2015

    Hello, Guest,

    I'm afraid that I don't have any advice on specific Golden Gate implementation questions. I'd recommend that you log a formal Service Request against Golden Gate with your implementation questions like this.

    Regards,

    Steven


  • guest Friday, August 28, 2015

    Hi Steven,

    We are considering GoldenGate for EBS 11.5.10 Unidirectional (Reporting Instance). However, our DB is 9i.

    MOS Note 1112325.1 (specified in this blog), states that minimum Oracle DB version should be 10.2. I was wondering if we could still go ahead and deploy GoldenGate for our Reporting Instance.

    Regards,

    Vinay


  • Steven Chan Friday, August 28, 2015

    Vinay,

    The minimum stated above is really the minimum.

    Extended Support for Database 9i, released in 2002, ended in 2010. You should upgrade your EBS 11i database to 11.2.0.4, at minimum, or database 12.1.0.2.

    Regards,

    Steven


  • Mohammed Anis Thursday, December 7, 2017
    Is it certified now or not yet to use Golden gate as DR for EBS database.

    For Active dataguard, it takes hardly a day for us. For golden gate configuration how much time approximately it takes for ebs database.
  • Steven Chan Thursday, December 7, 2017
    Hello, Mohammed,

    Golden Gate can only be used for replicating subsets of EBS data into operational data stores, as described in the article above. The limitations stated above (e.g. lack of primary keys, lack of complete datatype support) still apply.

    Regards,
    Steven
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.

Recent Content