Maximum Availability Architectures and the E-Business Suite

Put all your eggs in one basket and --- WATCH THAT BASKET.

Following the IT industry's never-ending quest to introduce new and confusing names for well-understood concepts, our gurus in the High Availability engineering teams for the Oracle database and application server products have coined a new term:  Oracle Maximum Availability Architecture.

MAA Architecture:

From their OTN website:
  • "Oracle Maximum Availability Architecture (MAA) is Oracle's best practices blueprint based on proven Oracle high availability technologies and recommendations. The goal of MAA is to remove the complexity in designing the optimal high availability architecture."

This team held a fascinating session at OpenWorld 2006, "MAA Best Practices: Building an Oracle E-Business Suite Maximum Availability Architecture" (S283064).  They covered a range of MAA topics for E-Business Suite environments, including:
  • RAC, ASM
  • Flashback databases
  • Data Guard Redo Apply
  • Disaster recovery
  • Minimizing outages while converting to MAA architectures
  • Switchover and failover procedures
  • Hardware vendor partner validations on:
    • HP-UX, HP 9000, HP Integrity, HP StorageWorks, HP ServiceGuard
    • Sun Solaris, Sun Clusters, Sun Fire, Sun StorEdge

Excellent stuff.  Associated with their OpenWorld session, they have a Powerpoint and a detailed whitepaper available for download.  See the article below for pointers to the OOW Content Catalog.

Oct. 14, 2011 Update: This presentation is available here.



Hi Steven,
Biggest MAA gain will be with Availability during database Upgrades . any idea when is rolling upgrades going to be certified with Physical Standby dataases so this can be utilised in MAA during Upgrades.


Posted by Atul Kumar on November 05, 2006 at 08:21 AM PST #

I second Atul's sentiments. The bulk of our downtime is scheduled, so we've got to figure out how to deploy database code/objects, and do upgrades without kicking off the users.

Posted by Dan Loomis on November 06, 2006 at 06:15 AM PST #

I agree that this would be highly desirable.  There are some pretty stiff technical challenges that we're working on now, but I don't have specifics that I can share at this stage.  I'll be sure to post updates on this as soon as they're available.Regards,Steven 

Posted by Steven Chan on November 07, 2006 at 05:05 AM PST #

Was looking for information on 'flashback database' and its use within an 11i environment. Are there any docs/case studies and has anyone tried it in their environments as part of the MAA ???

I have used it with teh 10g database (3rd Party App but not with the 11i techstack).


Posted by John Fak on April 01, 2007 at 12:38 PM PDT #

John,Use of the Flashback database feature is supported with the E-Business Suite.  The base Oracle database documentation applies to E-Business Suite, so there's no Apps-specific documentation for using this feature.Regards,Steven 

Posted by Steven Chan on April 02, 2007 at 02:58 AM PDT #

Hi Steven,
Just want to confirm that in Release 12 EBS with RAC in PRIMARY site and single instance in STANDBY site with Database 10g is supported? I checked database docs, which states that standby can be non-RAC, does same applies for EBS R12 as well?


Posted by Preet on February 25, 2008 at 02:12 AM PST #

Do Oracle support Harware Failover Load Balancing for E-Business Suite??? i know they support software level load balancing but i m not sure about hardware LB.

Posted by Ishaq on July 07, 2008 at 05:08 PM PDT #


Yes, we support hardware-based load-balancers. See this article for more information and pointers to EBS 11i resources:


Posted by Steven Chan on July 08, 2008 at 03:28 AM PDT #

Hi Steven
We are now running into a project of using MSCA on our production lines. This will require us to a 24x7 EBS availability to avoid stopping production lines. Currently we patch our system on a bi-weekly basis putting the system down for 2 hours (both Oracle and custom code patches). Is there a way to avoid downtime at all ? What is Oracle's best practice to achieve that business requirement ?



Posted by Nitzan on August 24, 2008 at 10:28 PM PDT #

Hi, Nitzan,

Congratulations on getting MSCA into production. You'll find a number of recommendations in these articles:

Top 7 Ways of Reducing Patching Downtimes for Apps -

Reducing Patching Downtimes via Shared Apps File Systems -


Posted by Steven Chan on August 25, 2008 at 03:25 AM PDT #

Hi Steve,

The link seems to be broken:
Error: 404 Not Found!
Sorry, that page does not exist. Please try another location or you can search.


Van you check what's happenned here or do you have latest info.?


Posted by Vasu Ranganathan on October 11, 2011 at 10:49 AM PDT #


Our IT team has moved content around. Article updated with a new link.


Posted by Steven Chan on October 14, 2011 at 06:24 AM PDT #

We are running new project with two environments , PROD & DEV on the different hosts.
The DEV instance restore and recover from PROD rman backup and it worked during the day then flashback
and recover(only recover) from rman backup and the cycle is repeated.
The goal is to reduce the recovery time and the amount of data transmitted.

Posted by vladimir on January 26, 2015 at 12:27 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed


« November 2015