Oracle E-Business Suite And Oracle Maximum Availability .

An Oracle White PaperApril 2014Oracle E-Business Suite and Oracle MaximumAvailability Architecture Best PracticesIncluding a Case Study on Oracle Exalogicand Oracle Exadata Database Machine1

Table of Contents1Executive Overview . 62Introduction . 72.132.1.1Oracle Exalogic . 92.1.2Oracle Exadata Database Machine . 10Oracle E-Business Suite MAA . 113.1Oracle Database MAA . 123.1.1Oracle Real Application Clusters and Oracle Clusterware . 133.1.2Oracle Data Guard . 133.1.3Oracle Flashback and Snapshot Standby Database . 143.1.4Oracle Automatic Storage Management . 153.1.5Oracle Recovery Manager and Oracle Secure Backup . 153.1.6Database Configuration Best Practices . 153.2Oracle E-Business Suite High Availability Architecture . 213.2.1Middle Tier Configuration Best Practices . 223.2.2Multiple Load Balanced Application Tier Services . 263.2.3Parallel Concurrent Processing . 273.2.4Workflow Mailer High Availability . 283.33.3.24Oracle Engineered Systems. 8Site State Model and State Transitions. 29Data Stores. 29Summary of Best Practices . 314.1Oracle E-Business Suite Database High Availability . 314.2Application HA (Primary and Secondary) . 324.3Oracle E-Business Suite Application HA (Standby) . 32

5MAA Case Study on Exalogic and Exadata . 345.1Case Study Architecture and Software . 345.1.2Oracle E-Business Suite MAA Components . 345.1.3Software and Versions . 355.2Application Tier – High Availability Architecture . 355.2.15.36F5 BigIP Networks Local Traffic Manager . 37Database Tier – MAA . 375.3.1Database Setup . 385.3.2Database Features for the DR Site . 395.3.3Delegation of Roles and Administration . 395.3.4Oracle E-Business Suite Application and Web Tier Setup . 40Appendix A – Case Study Site State Transitions . 416.1Primary Site Setup . 416.1.1Compute Node Set Up . 416.1.2Shared File System Creation . 426.1.3vServer Creation . 436.1.4Shared File Systems Mounted on vServers . 446.1.5File System Folders Created . 456.1.6Oracle E-Business Suite Database Setup . 456.1.7Oracle E-Business Suite Application Tier Setup . 476.1.8Convert EBSBK Single Instance to Oracle RAC . 506.1.9Application Server Hardware Load Balancing Configuration . 536.1.106.2Preparing the Primary Site for Creating the Standby. 54Secondary Site Setup . 613

6.2.1OS Packages . 616.2.2OS User Setup . 616.2.3Configure HugePages . 626.2.4Configure CSS Misscount . 626.2.5Create the Standby Database from an Existing Primary . 626.2.6Complete File-Based Configurations at Standby Database. 676.2.7Stop the Database Listener on Standby Database Servers . 706.2.8Configure Oracle Net for Redo Transport and Start Listener . 716.2.9Enable Redo Transport . 726.2.10Verify Redo is Shipping . 726.2.11Standby Site Setup – Application Tier Configuration . 796.3Standby to Primary Site Test . 926.4Site Test to Standby . 956.5Execute Primary Site Switchover . 956.6Configuring Application Tiers after Role Transition . 976.6.1Perform File System Switchover on Application Tier. 976.6.2Update Host Name in Fnd Concurrent Requests andFnd Conc Req Outputs Tables . 1036.6.3Update Node Name in Fnd Concurrent Queues . 1056.6.4Complete the Configuration of Application Tiers . 1076.76.7.16.86.8.1Execute Primary Site Failover . 110Perform Primary Site Failover Tasks . 110Configuring Application after Failover . 112Configuring Application Tiers after Failover . 112

6.8.26.97Re-instantiate Former Primary as Standby . 112MAA Best Practices for ZFS Storage Appliance . 1176.9.1Shared APPL TOP Configuration . 1176.9.2Hardware Based Load Balancing . 121Appendix B – Creating ZFS Custom Projects and Shares. 1257.1Create the ZFS Project . 1257.2Configure Project File Systems and NFS Exceptions . 1258Appendix C - Adding Node to Shared App Tier File System . 1298.1Prepare Existing Node . 1298.2Make the Applications Files Accessible . 1298.3Configure the Node To Be Added . 1298.4Prompts While Running adclonectx.pl . 1309Prompts Running adclonectx.pl on Initial Node for RAC-RAC Cloning 13310Appendix D Configuring Hardware Load Balancing for Middle Tier10.1134Configuration Changes on the Application Tier . 13410.1.2Update the Applications Context Files . 13410.1.3Run AutoConfig . 13610.1.4Restart Application Services . 13610.1.5Test Sign On from Load Balancer Entry Point . 13611Appendix E Verify Oracle E-Business Suite Required Packages13712Appendix F TNSNAMES.ORA Content on Primary . 13813Appendix G References . 1445

Oracle MAAE-Business Suite MAA with Case Study on Exalogic and Exadata1 Executive OverviewThe Oracle E-Business Suite is a comprehensive suite of integrated, global business applicationsspanning enterprise resource planning, customer relationship management, human resourcemanagement, financial management, service management, project portfolio management, value chainplanning and execution, procurement and supply chain planning. It utilizes the core softwaretechnology stack of Oracle Database, Oracle Fusion Middleware (JAVA/JSP, Oracle Containers forJava (OC4J), Oracle Application Development Framework (ADF), Business Intelligence (BI) Publisher,Forms and Reports) and the respective clients used to access the application.The Oracle Maximum Availability Architecture (MAA) is Oracle's best practices blueprint based onOracle high availability (HA) technologies, extensive validation performed by the Oracle MAAdevelopment team, and the accumulated production experience of customers who have successfullydeployed business critical applications on Oracle.This paper describes: The Oracle E-Business Suite 12.1.3 MAA architecture along with installation, configurationand operational best practices. Unless explicitly noted as pertaining to Oracle EngineeredSystems, the MAA best practices described are relevant to all platforms that support OracleE-Business Suite 12.1.3. A case study of Oracle E-Business Suite 12.1.3 MAA implemented on Oracle Exalogic andExadata machines. The Oracle family of Engineered Systems, which includes Exadata andExalogic, incorporate pre-optimized, pre-configured, integrated systems of software, serversand storage that implement MAA configuration best practices.The tests performed to validate best practices and measure downtime in various outage scenarios,along with the results obtained, are detailed in a separate paper.6

Oracle MAAE-Business Suite MAA with Case Study on Exalogic and Exadata2 IntroductionOracle E-Business Suite customers represent a very broad spectrum of industry and application focus.The continued growth of Oracle’s E-Business Suite applications, around the world and acrossindustries, presents ever-growing solutions that enable businesses to centralize global operations toreduce operating costs and increase competitiveness and performance.Disaster recovery can be a challenge both from a business and technical perspective for customersmanaging the complexities of global business environments whether the organization is small, mediumor large in size.This paper describes the architecture and configuration of the Oracle E-Business Suite deployed in ahighly available topology using MAA best practices. The example presented in the paper utilizes anExadata Database Machine (database tier) and Exalogic (middle tier), with an identical configuration ata standby site. In addition to the incorporation of the previously published MAA best practices [1],[2]and My Oracle Support deployment notes [3], this paper includes a case study focused on bestpractices and configuration of the use of Oracle Exalogic’s ZFS Storage Appliance to provide a highlyavailable Oracle E-Business Suite middle tier. The architecture used makes scaling simple both at thedatabase and application tiers; the process flows that enable the scaling are also described in somedetail.This paper is organized into the following sections: A high-level introduction to Oracle Exalogic and Oracle Exadata Database Machine Oracle E-Business Suite MAA – a high level description of the architecture and keytechnology components Oracle E-Business Suite MAA Case Study on Exalogic and Exadata – how the MAAarchitecture was established on the target system7

Oracle MAA E-Business Suite MAA with Case Study on Exalogic and ExadataAn Appendix with details on how to implement Oracle E-Business Suite on Exalogic andExadata2.1Oracle Engineered SystemsOracle’s Engineered Systems combine best-of-breed hardware and software components with gamechanging technical innovations. Designed, engineered, and tested to work best together, Oracle’sEngineered Systems can power the cloud or streamline data center operations to make traditionaldeployments even more efficient. The components of Oracle’s Engineered Systems are preassembledfor targeted functionality, and then the entire system is optimized for extreme performance. By takingthe guesswork out of these highly available, purpose-built solutions, Oracle delivers a solution that isintegrated across every layer of the technology stack, a simplicity that translates into less risk and lowercosts for business. Only Oracle can innovate and optimize at every layer of the stack to simplify datacenter operations, drive down costs, and accelerate business innovation.8

Oracle MAAE-Business Suite MAA with Case Study on Exalogic and ExadataFigure 1 : Key Components of Exalogic2.1.1Oracle ExalogicOracle Exalogic is an engineered system on which enterprises deploy Oracle business applications,Oracle Fusion Middleware or third-party software products. Exalogic comes pre-built with computenodes, memory and centralized storage; all connected using Infiniband in a highly available architecturewith fault tolerance and near zero-down-time maintenance.An in-depth overview of Exalogic is provided in Oracle Exalogic Elastic Cloud: System Overview.9

Oracle MAA2.1.2E-Business Suite MAA with Case Study on Exalogic and ExadataOracle Exadata Database MachineOracle’s Exadata Database Machine is Oracle’s database platform delivering extreme performance fordatabase applications including Online Transaction Processing, Data Warehousing, Reporting, BatchProcessing, or Consolidation of mixed database workloads. Exadata is a pre-configured, pre-tuned, andpre-tested integrated system of servers, networking and storage all optimized around the Oracledatabase.An in-depth overview of the Exadata Database Machine and the Exadata Storage Server is provided inA Technical Overview of the Oracle Exadata Database Machine and Exadata Storage Server.Figure 2: Key Components of Exadata10

Oracle MAAE-Business Suite MAA with Case Study on Exalogic and Exadata3 Oracle E-Business Suite MAAOracle E-Business Suite MAA is an Oracle E-Business Suite high availability architecture layered ontop of the Oracle Database MAA, including a secondary site to provide business continuity in theevent of a primary site failure. In this section the Oracle Database MAA is presented first, followed bya description of how to layer the Oracle E-Business Suite application on top of that foundation,resulting in a full Oracle E-Business Suite MAA implementation.Figure 3: Oracle E-Business Suite MAA on Exalogic and Exadata Database Machine [[16]]11