Using Oracle GoldenGate with Oracle E-Business Suite

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


Comments:

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?

Posted by Sujoy Bhattacharjee on June 14, 2011 at 04:08 PM PDT #

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.

Posted by Doug Reid on June 15, 2011 at 04:00 AM PDT #

Thanks for the info Doug...will look up the note you mentioned.
(Time to bid farewell to Oracle Streams)

Posted by Sujoy Bhattacharjee on June 15, 2011 at 05:31 PM PDT #

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

Posted by Arun on July 07, 2011 at 04:32 AM PDT #

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

Posted by Abip on February 04, 2012 at 01:42 AM PST #

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

Posted by Elke Phelps (Oracle Development) on February 06, 2012 at 09:18 AM PST #

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

Posted by Dinesh on August 14, 2012 at 12:07 AM PDT #

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

Posted by Doug Reid on August 16, 2012 at 02:45 PM PDT #

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

Posted by guest on October 23, 2012 at 04:49 AM PDT #

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

Posted by Steven Chan on October 23, 2012 at 09:37 AM PDT #

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

Posted by Parvinder on December 06, 2012 at 05:15 AM PST #

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.

Posted by Max Arderius on December 07, 2012 at 10:21 AM PST #

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

Posted by guest on September 17, 2013 at 06:07 PM PDT #

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

Posted by Steven Chan on September 27, 2013 at 11:23 AM PDT #

Can we use golden gate for real time clones.

Posted by Chenthil on January 28, 2014 at 01:05 PM PST #

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

Posted by Elke Phelps (Oracle Development) on January 29, 2014 at 09:20 AM PST #

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

Posted by Samad Ul Haq on March 04, 2014 at 11:50 PM PST #

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

Posted by Steven Chan on March 12, 2014 at 09:55 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today