ORACLE E-BUSINESS SUITE IN A SCALABLE AND RELIABLE VIRTUAL .

3y ago
51 Views
2 Downloads
2.13 MB
43 Pages
Last View : 1m ago
Last Download : 2m ago
Upload by : Emanuel Batten
Transcription

IMPLEMENTINGORACLE E-BUSINESS SUITEIN A SCALABLE AND RELIABLEVIRTUAL SYSTEMARCHITECTUREA Dell Technical White PaperDell Database Solutions Engineering, Dell Product GroupKai YuDell Global Database Management, Dell ITJohn TaoJanuary 2010

THIS WHITE PAPER IS FOR INFORMATIONAL PURPOSES ONLY, AND MAY CONTAINTYPOGRAPHICAL ERRORS AND TECHNICAL INACCURACIES. THE CONTENT IS PROVIDED AS IS,WITHOUT EXPRESS OR IMPLIED WARRANTIES OF ANY KIND.Dell, the Dell logo, OpenManage, and PowerEdge are trademarks of Dell Inc; Linux is theregistered trademark of Linus Torvalds in the United States and other countries; Red HatEnterprise Linux is a registered trademark of Red Hat, Inc in the United States and othercountries; Intel and Xeon are registered trademarks of Intel Corporation in the U.S. and othercountries; Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Microsoftand Internet Explorer are registered trademarks of Microsoft Corporation in the United Statesand/or other countries. 2010 Dell Inc. All rights reserved.Reproduction in any manner whatsoever without the express written permission of Dell Inc. isstrictly forbidden. For more information, contact Dell.THE INFORMATION IN THIS DOCUMENT IS SUBJECT TO CHANGE WITHOUT NOTICE ANDIS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND. THE ENTIRE RISK ARISING OUTOF THIS INFORMATION REMAINS WITH THE USER OF THE INFORMATION. IN NO EVENTSHALL DELL BE LIABLE FOR ANY DIRECT, CONSEQUENTIAL, INCIDENTAL, SPECIAL,PUNITIVE OR OTHER DAMAGES, EVEN IF DELL HAS BEEN ADVISED OF THE POSSIBILITYOF SUCH DAMAGES.2

ContentsAbstract . 4Audience and Scope . 4Section I – Introduction . 5Oracle E-Business Suite on RAC: . 6Oracle VM: Oracle Server Virtualization Technology . 7Section II – Dell Oracle Grid Reference POC Project: Combining RAC and VM . 9Dell Oracle Grid Reference Architecture . 9Grid Architecture Design and Implementation . 10Physical Grid . 10Virtual Grid . 11Enterprise Manager as the unified management solution . 13Grid hardware platform and storage . 13Consolidate enterprise applications on the Grid: a general guideline . 16Oracle E-Business Suite R12 on the Grid: architecture design . 17Section III – Oracle E-Business Suite R12 Implementation on RAC and VM . 18Prepare the VMs on virtual Grid for EBS application nodes . 19Prepare 11g RAC node 1 on Physical Grid for EBS Fresh Install . 22Oracle EBS R12 Fresh Install . 24Oracle EBS 11g Database upgrade . 29Converting the Oracle EBS 11g Database to RAC . 32Expanding the database and application nodes to scale out the Oracle EBS system . 36Section IV – Implement an Oracle EBS R12 Development/Test Instance on the Virtual Grid . 39Deploy Oracle EBS R12 on VMs . 39Create Oracle EBS R12 VM templates . 40Create new Oracle E-Business Suite instance from the templates . 41Conclusion . 42References . 423

AbstractAn Oracle E-Business Suite system with an Oracle Real Application Cluster- (OracleRAC) enabled database delivers a complete business solution with user access andflexible capacity features that address the most demanding of requirements. Applicationdeployment and management for this environment is simplified using the Oracle VirtualMachine (Oracle VM) server. The benefits derived from the composite environment,however, are not often realized without gaining a perspective on how to address itscomplexity. This paper presents an overview of the architecture and each component ofthe technology stack including Dell PowerEdge Blade servers and Dell EqualLogicstorage. Best practices implementation and configuration details in this document are acomplement to achieving the benefits of Oracle RAC and Oracle VM for Oracle EBusiness Suite Release 12 applications. These technologies are fully aligned with Dell’sinitiatives to simplify data centers and build solutions which are easily scalable. Thetechnology stacks and configurations discussed in this white paper have been fullytested by the database solutions team at Dell.Audience and ScopeThis paper provides a top-down view of the system infrastructure beginning with a high-leveldiscussion of the related technology. The Dell Grid infrastructure proof of concept (POC) projectis introduced along with detailed implementation aspects. Audiences interested in a high-leveloverview benefit best by reading the introduction. Those interested in implementation and bestpractices specifics should read later sections of this document.This paper is divided into four major sections: Introduction to Oracle E-Business Suite, Oracle RAC, and Oracle VM technologiesDell POC Project Oracle E-Business Suite Release 12 on the Grid: Architecture DesignOracle E-Business Suite Release 12 implementation on Oracle RAC and Oracle VMImplementing an Oracle E-Business Suite Release 12 Development/Test instance on theVirtual Grid4

Section I – IntroductionOracle E-Business Suite R12 ArchitectureOracle E-Business Suite R12 is an industry leading Enterprise Resource Planning (ERP) softwareplatform that integrates a set of enterprise applications that seamlessly automate various lineof-business processes — including sales, service, marketing, financial, human resources, supplychain, and manufacturing. Oracle E-Business Suite R12 incorporates the latest technology in atiered structure (Figure 1):1) The Client tier adapted the Native Sun Java plug-in for end-users to connect toapplications via internet browsers (e.g., Microsoft Internet Explorer , Mozilla Firefox,and Apple Safari).2) The Application tier uses Oracle Application Server (AS) 10g that includes Oracle AS 10g10.1.2 for forms and Reports services, Oracle AS 10g 10.1.3 for Oracle containers forJava (OC4J), as well as Oracle JDeveloper 10.1.3. The application tier is certified withOracle Fusion middleware.3) The Database tier starts with Oracle Database 10gR2 and can be upgraded to OracleDatabase 11g for improved manageability and better performance with advanceddatabase features such as Automatic Workload Repository, Automatic SGA Tuning, RACand Automatic Storage Management (ASM), etc.The original release of E-Business Suite (EBS) R12 occurred early in 2007. Since that time, mostcustomers have upgraded or are planning to upgrade their systems to it. Oracle EBS R12 is fullycertified for 64-bit platforms on both the application and database tiers. As a result, both tiersbenefit from Dell PowerEdge servers and 64-bit Linux variants.Figure 1: Oracle E-Business suite R12 architecture5

Oracle E-Business Suite on RAC:Oracle RAC is composed of multiple database instances on servers that are interconnectedthrough a high-speed private network. As a part of Oracle RAC, cache fusion technology fornode synchronization makes it possible for multiple database instances to share a singledatabase and execute transactions simultaneously on the single database.ASM is an integrated file system and volume manager that is built into the Oracle databasekernel. ASM provides the database administrator with a simple storage management interfacethat is consistent across all server and storage platforms. ASM provides some key benefits forOracle 10g and 11g databases such as: I/O distributed evenly among available disk drives maximizes performanceAutomatic disk rebalancing feature allows online addition and removal of storageManages database file systems easilyProvides simple management of shared storage for Oracle RAC databaseOracle E-Business Suite applications 11i and R12 can take advantage of Oracle RAC and ASMtechnology: High Availability: Applications connect to multiple Oracle RAC database instances whichcan be failed over from one another.Load Balancing: Workload requests from the applications can be evenly distributed tomultiple database instances.Scalability: As application loads increase, Oracle RAC database capacity can be scaledout by adding additional database servers to the cluster.Oracle RAC is also a key component to implementing Oracle Grid.However, Oracle E-Business applications implementation with Oracle RAC and ASM hasrequirements you need to be aware of during the application architecture design: Oracle EBS Rapid Install program is not aware of Oracle RAC/ASM. The default OracleEBS Rapid Install process only installs the Oracle E-Business database on a single serverand stores the database files on an operating system’s file system.There are additional hardware and license cost considerations for Oracle RAC.Manual steps are required to convert the Rapid Installed Oracle E-Business applicationsdatabase to Oracle RAC and ASM using the rconfig and autoconfig utilities. Certainspecific tasks need to be performed in the application tier in order for the applicationtechnology stack to connect to the Oracle RAC database. Refer to Metalink note #783044.1[6] for more details of these steps. The complete implementation of thesesteps will be also examined in the Oracle E-Business Suite R12 implementation on RACand VM section of this white paper.6

Figure 2 shows the Oracle E-Business Suite R12 applications stack that is running on Oracle RACand ASM.Figure 2: Oracle E-Business Suite R12 on Oracle RAC and ASMOracle VM: Oracle Server Virtualization TechnologyVirtualization introduces significant benefits to the design and implementation of database andapplication environments. Oracle VM provides a platform that leverages the benefits ofvirtualization [8]: Server consolidation: By allowing multiple guest operating systems to execute on asingle physical server, it increases hardware utilization and significantly reduces thenumber of physical servers in the data center.Isolation: Because the VMs work independently, the operating system and applicationsrunning on the different VMs don’t affect one another.High performance server virtualization: The difference in performance between a VMand a physical server is minimal. Performance overhead of an Oracle VM server is evensmaller for a workload that is less I/O intensive such as an application server workload[10].Fast deployment through a pre-configured Oracle VM template: An Oracle VM templatecan be created to include all components of the VM including the VM operating system,applications on the operating system, patches, and the configuration. The templateallows for easy, predictable deployment in a few mouse clicks. The implementation ofVMs in this paper will be based on this deployment method. See Section IV for moredetails.7

Centralized management solutions: Oracle Enterprise Manager with the Oracle VMmanagement pack provides the centralized management solution for both the virtualand physical environment.Combined benefits of Grid Computing and server virtualization: Oracle VM is the newevolvement of the Oracle Grid computing model. In this model, the new Grid iscomposed of the physical server as well as the virtual servers.Oracle VM is the only software virtualization solution certified for any Oracle Software. OracleVM release 2.1 and above are certified with Oracle database 10g/11g, Oracle RAC database 10gand 11g, and Oracle application servers. The following Oracle E-Business Suite versions arecertified with Oracle VM 2.1 as of the writing of this document according to Metalink note465915.1: 11.5.10 CU2 or later with 11i.ATG PF.H.RUP5 for Linux x8612.0.2 RUP2 or later for Linux x8612.0.4 and above, for 64-bit Oracle Enterprise Linux and 64-bit Red Hat EnterpriseLinux (RHEL) 5 on x86-64 with Oracle VM12.0.3 (RUP3) or later (including 12.1) with 64-bit Oracle Enterprise Linux (OEL) 4 and64-bit Red Hat Enterprise Linux 4 on x86-64 with Oracle VM12.0.4 or higher and 12.1.1 (or higher) is certified on Microsoft Windows Server 2003(32-bit) running as a guest on Oracle VM using Windows PV driver version 1.0.8 orhigher12.1.1 or higher on Windows Server 2008 (32-bit) running as a guest on Oracle VM usingWindows PV driver version 1.0.8 or higherFor t

Oracle E-Business Suite Release 12 implementation on Oracle RAC and Oracle VM . Oracle Fusion middleware. 3) . certified with Oracle VM 2.1 as of the writing of this document according to Metalink note 465915.1: 11 .

Related Documents:

7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence

Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,

Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,

E-Business Suite and HCM Cloud E-Business Suite and ERP/SCM Cloud E-Business Suite and CX Cloud 10 Oracle E-Business Suite and Practical Coexistence Scenarios Extend with SaaS –Hybrid is the New Normal 1.EBS ERP to Oracle HCM Cloud 2.EBS Payroll with Oracle HCM Cloud 3.EBS HCM to Oracle Taleo Cloud 4.EBS HCM to Oracle Talent Management Cloud .

the EBS instance specific configuration and form the complete ready-to-run Oracle E-Business suite instance. Certification of Oracle E-Business Suite on Oracle VM Oracle VM has been fully certified with Oracle E-Business Suite systems for more than 2 years and it's the only virtualization solution certified and supported by Oracle.

Process Integration Pack for Oracle Product Hub Jan 2009 Foundation Pack 2.4 Oracle E-Business Suite PIM 12.1 Siebel CRM 8.0.0.5 SIA Oracle E-Business Suite 11.i.10 CU2 Oracle CRM On Demand Integration Pack for Oracle E-Business Suite Oct 2007 N/A Oracle CRM On Demand Oracle E-Business Suite 11.i.10 CU2 Cross Industry Process Integration Packs

PeopleSoft Oracle JD Edwards Oracle Siebel Oracle Xtra Large Model Payroll E-Business Suite Oracle Middleware Performance Oracle Database JDE Enterprise One 9.1 Oracle VM 2.2 2,000 Users TPC-C Oracle 11g C240 M3 TPC-C Oracle DB 11g & OEL 1,244,550 OPTS/Sec C250 M2 Oracle E-Business Suite M

Toad for Oracle Base Edition Toad for Oracle Professional Edition Toad for Oracle Xpert Edition Toad DB Admin Module (add-on) Toad Development Suite for Oracle Toad DBA Suite for Oracle Toad DBA Suite for Oracle - RAC Edition Toad DBA Suite for Oracle - Exadata Edition Convert embedded SQL to other programming languages (Delphi, C, C ,