© 2008 IBM Corporation

Implementing Oracle EBS 12 with Maximum Availability Architecture on IBM Power

Wojciechowski DidierSolution Technical Specialist Oracle/IBM Joint Solutions Center

Boutault RobertSolution IT ArchitectIBM e-Business Solutions

Technical Sales (eTS)

E18

© 2008 IBM Corporation2

<Insert Picture Here>

AgendaThe Oracle / IBM Relationship Maximum Availability Architecture (MAA)E-Business Suite MAA

Target Architecture Oracle Database MAA E-Business Suite High Availability

E-Business Suite Customer ExampleOracle Optimised Warehouse InitiativeConclusion / Wrap-up

© 2008 IBM Corporation3

Objectives

At the conclusion of this presentation, you should be able to: Understand what are the foundations of EBS 12 with MAA on

Power Understand the added value of the Oracle Warehouse Initiative on

Power Understand what the JSC can bring to joint engagement

© 2008 IBM Corporation4

<Insert Picture Here>

The Oracle / IBM Relationship

© 2008 IBM Corporation5

Oracle and IBMThe Technology Relationship

http://www.oracle.com/partnerships/hw/ibm/oracle-ibm-relationship.pdf

Did You Know?

• Oracle and IBM have worked together for over 30 years and collaborate daily on development, marketing and sales activities.

• IBM maintains a team of engineers onsite at Oracle as well as hundreds of servers and hundreds of Terabytes of storage for development and support.

• Senior IBM and Oracle architects work together to influence technical product direction for each company and are continually looking years ahead when developing future advanced solutions.

• IBM Systems hold benchmark leadership positions for all Oracle applications including EBS, Peoplesoft, JDE and Siebel.

Oracle products “are all supported on AIX 5L and are developed concurrently with Oracle’s base development environment. Additionally, Oracle development uses System p for stress testing of current and future releases of Oracle Real Application Clusters (RAC)”

© 2008 IBM Corporation6

Built for you: The Oracle/IBM Joint Solutions Center

The living proof of Oracle and IBM’s desire to work closely together

Ten years of experience

What is the JSC? The Oracle/IBM Joint Solutions Center, created in 1998, is a presales support team, permanently staffed by 6 Oracle + 4 IBMers to contribute to the successful delivery of Oracle/IBM Joint solutions.

What can we do for you? Infrastructure Technical Pre Sales Assistance through the whole project/sales cycle Help me to Convince : Briefings & Conferences (50) Help me to Build : Architecture, Design, Sizing Assistance (200-250) Help me to Demonstrate : Proof-of-Concept, Benchmarks Assistance (50) Help me to Deliver : Publications & Hands-on Workshops (15)

Which Products & Solutions are we covering? Oracle Technologies (Maximum Availability Architecture) & Oracle Applications

(EBS, Siebel and OBI & OWI) on IBM Power , Modular, Mainframe. Entry point to other teams on BRM, iFlex, Retail and others…

© 2008 IBM Corporation7

5 Strategic Workshops

• Oracle Solutions on IBM System z running Linux for SI

• Implementing 11g R1 RAC on System p running AIX5L in Moscow & Geneva

• 1st WW Implementing Oracle 10g R2 RAC for Siebel on System p running AIX5L in MOP

• 1st WW Oracle Solutions on System z running Linux boot camp in Montpellier

2 New Cookbooks

• Implementing 11g R1 RAC on System p running AIX5L with ASM

• Implementing 10g R2 RAC on System z running Linux (SLES10) with NTC

5 Examples of Projects

Vietnamese Bank: Oracle driven HA/DR Design workshop in Montpellier

• German SMB : EBS12 on Power running AIX – Architecture & Sizing Study

• English Bank: Infrastructure Simplification on System z running Linux – Architecture

• French Telco – Oracle 8 Nodes 11g RAC on Blades with Infiniband benchmark

• Russian Retail – Oracle Retail on Power Architecture & Sizing study

The Oracle/IBM Joint Solutions Center Activities YTD

© 2008 IBM Corporation8

Complementarity to SI - eTS can make the bridge Business / IT

CSI maintains focus on delivering

business benefits

IBM eTS (pre-Sales) providesIT infrastructure design & configuration, optimised technologies & system

implementation capability ... to reduce project risk and delivery

timescales

Installation

World class Hardware & Middleware

IT Infrastructure Design

Configuration

World Class Servers, Storage, Middleware & System Mgt software

Application Development

IT

eTS FOCUS

Business Process

Application Development

IT Infrastructure Design

Configuration Installation

Business

CSIFOCUS

Solutions

© 2008 IBM Corporation9

<Insert Picture Here>

Maximum Availability Architecture (MAA)

© 2008 IBM Corporation10

Maximum Availability Architecture (MAA)Maximum Availability = Unbreakable Architecture + Best Practices

Oracle's best practices blueprint based on proven

Oracle and IBM high availability technologies and

recommendations Technology + Configuration + Operational Practices

Constantly validated and enhanced as new products and

features become available

Focused on reducing unplanned and planned downtime

Focused on making our customers successful• Best practices available through Oracle white papers and IBM

Redbooks

© 2008 IBM Corporation11

<Insert Picture Here>

E-Business Suite MAA

© 2008 IBM Corporation12

© 2008 IBM Corporation13

E-business Suite MAATarget Architecture

Primary Site

OracleRAC and

ASM

Disaster Recovery Site

Oracle Data Guard

OracleDatabase

OracleStandby

Database

Database Tier OracleRAC and

ASM

Application Tier

HA Storage

© 2008 IBM Corporation14

E-business Suite MAA Oracle Database MAA

Primary Site Disaster Recovery Site

Real Application Clusters & Clusterware

Fault TolerantServer Scale-Out

Data GuardFully Active Failover Replica

FlashbackCorrect Errors by Moving Back in Time

Automatic Storage Management

Fault TolerantStorage Scale-Out

Recovery Manager & Oracle Secure BackupLow Cost High Performance Data Protection and Archival

Database Servers Database Servers

Storage Storage

© 2008 IBM Corporation15

Oracle/IBM Technology Blueprint to Scale Right

One Technology : Database 10g/11g, AIX- LINUX

Performance/Scalability: IBM Power, Oracle Grid Architecture

Flexibility / Availability: Oracle Services, IBM Virtualization

FileSystem/LVM: GPFS, ASM

Hight Availability RAC, CRS, HACMP

Business Continuity PPRC, Metro or Global Mirror, ASM or GPFS Mirroring , Data Guard, RMAN…

Monitoring: GRID Control, Tivoli

MERGED PRODUCTSTO GET YOU THE POWER OF SYNERGY

© 2008 IBM Corporation16

Jay Kruemcke IBM 2003

DLPAR & SPLPAR are supported by Oracle Virtual IO Servers (VIOs or shared HBAs) and Virtual LAN (VLAN or Shared Network

Card) Certified SMT On/Off (+30% TPM throughput, better response time for queries) AIX 6.1 : Oracle 10g single & RAC only. Oracle 11g & EBS not completed. New features under consideration (LPM – WPAR)

SPLPAR

Agent Agent Agent

Always adjust resource allocation based on business priority

Test LPAR CRM LPAR Finance LPAR

0.5CPU

1.1CPU

6.4CPU

IBM Power Main Advanced Virtualization options

LPAR

Test LPAR

Agent

CRM LPAR

Agent

Finance LPAR

Agent

Unbalanced resource allocation

2CPU

5CPU

1CPU

4CPU

3CPU

© 2008 IBM Corporation17

End users

HMC

Oracle CRS

VIP 1

RAC for Failover & reconnectCRS & System p console communication

System p & AIX5L to adapt and reconfigure

dynamically automatically or manually depending on strategy.

PRODCluster

Dev-Q/A

VIO

PRODCluster

Dev-Q/A

VIO

VIP 2

Oracle MAA for Applications Oracle Database MAA features on IBM System p

33

11

VIP 1 VIP 122

CRS callout : ssh requests to HMC 44

Reduce Q/A + Increase RAC Node 2 55

66

© 2008 IBM Corporation18

E-business Suite MAA Application HA Features

Hardware Load BalancersRedundant Configuration

Application Tier

Database Tier

Multiple Web ServersLoad Balanced

Parallel Concurrent ProcessingFault tolerant batch processing

Database or Application Tier

Multiple Forms ServersLoad Balanced

© 2008 IBM Corporation19

E-business Suite MAATarget Architecture

Primary Site

OracleRAC and

ASM

Disaster Recovery Site

Oracle Data Guard

OracleDatabase

OracleStandby

Database

Database Tier OracleRAC and

ASM

Application Tier

HA Storage

© 2008 IBM Corporation20

<Insert Picture Here>

E-business Suite MAA Customer Example

© 2008 IBM Corporation21

Oracle MAA for Applications Oracle EBS in a production environment

EBS 11.5.10.2 Database 10.1.0.5 Multi Node Environment

2 Application Nodes, shared 2 DB Nodes in RAC (CRS 10.2.0.2)

5 IBM p570 AIX 5.3 EMC Symmetrix Storage 20TB 16 Countries 1500 Users 5 Languages

© 2008 IBM Corporation22

Oracle MAA for Applications Oracle EBS in a production environment – D/R and B/R

Business Requirements (SLA)Max 4 hours of downtimeMax 20 minutes of data lost24/7 availability

Technical RequirementsOracle CRSOracle DataGuard IBM GPFSEMC SRDFEMC TimeFinder BCV-CloneLegato Network Tape Backup

© 2008 IBM Corporation23

Oracle MAA for Applications Oracle EBS in a production environment – Architecture overview

© 2008 IBM Corporation24

You can find all this in the presentations delivered by JSC at the 2008 STG Technical Conference in Sevilla- Spain:

• zVL01 - Virtualized Data Center - Oracle MAA & Solutions on IBM System z running Linux

• pTS01 - Implementing Oracle11g R1 RAC on Power

• pHA07 – Oracle HA&DR Solutions with IBM Power

• pS013 – Oracle Portfolio on Power

• pS014 – Oracle & AIX Performance & Tuning

• xSS03 – New & Evolving Oracle-Based System x Solutions

• SGI13 – Oracle Implementation on IBM System Storage Infrastructure

Don’t hesitate to ask for a PDF copy by contacting the Oracle/IBM Joint Solutions Center at oraclibm@fr.ibm.com

The Oracle/IBM Joint Solutions Center New Presentations

© 2008 IBM Corporation25

Configuration for Database Tier Software Releases OASB BenchmarkDate

SubmittedCores

Number of Benchmark Users Users/Core

IBM System p 570

(4.7 GHz POWER6)128 GB Memory

Oracle Apps 11.5.10AIX 5L V5.3 Oracle 10g

11.5.10 Single System, Medium

Configuration05/21/07 8

3,000@ 0.76 sec

375

2 x IBM System p5 505 2-way

(1 x 2.1 GHz Dual Core POWER5+)32 GB Memory each

Oracle Apps 11.5.10AIX 5L V5.3 Oracle 10g RAC

11.5.10 RACSmall

Configuration11/30/06 4

1,000@ 0.87 sec

250

HP Proliant DL 580/G3(2x3.0 GHz Dual Core Xeon MP w/ 1MB L2 & 8MB L3) – 32 GB Memory

Oracle Apps 11.5.10Oracle 10g

11.5.10 Single System, Small Configuration

3/11/06 4800

@ 0.76 sec200

HP Proliant DL 580/G3(4x3.0 GHz Dual Core Xeon MP w/ 2MB L2)32 GB Memory

Oracle Apps 11.5.10RHEL4u3Oracle 10g

11.5.10 Single System, Small Configuration

10/24/06 81,000

@ 0.51sec125

IBM System p5 570

(1.9 GHz POWER5)128 GB Memory

Oracle Apps 11.5.10AIX 5L V5.3 Oracle 10g

11.5.10 Single System, Medium

Configuration5/25/06 8

2,000@ 0.98 sec

250

All results are as of 05/21/06.

We also have benchmarks for you : Oracle Apps Standard Benchmark 11.5.10 - Single System & RAC

Not all results listed. Source: http://www.oracle.com/apps_benchmark/html/results.html

Clients can do more and spend less - with System p cluster or single system

NEW!

Available Benchmarks for Oracle EBS, PeopleSoft, Siebel, SAP with Oracle Database….and more to come.

© 2008 IBM Corporation26

MetaLink Note 452056.1 - Business Continuity for Oracle Applications Release 12 on Database Release 10gR2

Transitioning E-Business Suite to the Maximum Availability Architecture with Minimal Downtime: E-Business Suite 11i.10.2 and Database 10gR2

MetaLink Note 403347.1 - MAA Roadmap for the E-Business Suite

MetaLink Note 341437.1 - Business Continuity for Oracle Applications 11i Using RAC and Physical Standby

MetaLink Note 340859.1 - Upgrading Oracle Applications 11i 9i Database to Oracle Database 10g with Physical Standby in Place

MetaLink Note 312731.1 - Configuring Oracle Applications Release 11i with 10g RAC and 10g ASM

MetaLink Note 294652.1 - E-Business Suite 11i on RAC: Configuring Database Load Balancing & Failover

MetaLink Note 216212.1 - Business Continuity for Oracle Applications Release 11i, Database Releases 9i and 10g

Additional Resources

© 2008 IBM Corporation27

<Insert Picture Here>

Oracle Optimized Warehouse Initiative

© 2008 IBM Corporation

Full Range of DW Solution OptionsCustomCustom

• Flexibility for the most demanding data warehouse

• Benefits:

•High performance

•Unlimited scalability

•Completely customizable

•Industry-leading database and hardware

• Partitioning

• RAC• Partitioning

• RAC

Reference Configurations

Reference Configurations

• Documented best-practice configurations for data warehousing

• Benefits:

•High performance

•Simple to scale; modular building blocks

•Industry-leading database and hardware

•Available today

FlexibilityFlexibility

Pre-configured, Pre-installed, ValidatedPre-configured, Pre-installed, Validated

Oracle Optimized Warehouse

Oracle Optimized Warehouse

• Scalable systems pre-installed and pre-configured: ready to run out-of-the-box

• Benefits:

•High performance

•Simple to buy

•Fast to implement

•Easy to maintain

•Competitively priced

• Partitioning

• RAC

© 2008 IBM Corporation

Oracle Optimized Warehouse Initiative

Oracle Optimized Warehouse

< 1 - 2 week

Take delivery of Oracle

Optimized Warehouse

Build from Scratchwith Components

Pre-implementation system sizing

Acquisition of components

Installation and configuration

Testing and Validation

Weeks to Months

Faster deployment

Lower Risk

Reference Configurations

Acquisition of components

Installation and configuration

Testing and Validation

Weeks to MonthsAll systems consist of a pre-built and pre-configured databaseAll systems have Predefined LUNs, Predefined ASM disk groups and tablespaces, Predefined, init.ora setting, Predefined listener, Database Control - Optional : Database in ARCHIVE LOG mode plus pre-defined flashback recovery area, Different high-availability offerings for the hardware, Disk and fabric redundancy

© 2008 IBM Corporation30

Real Application Cluster Scale Out

5 TB

20 TB

10 TB

30 TB

5 TB 10 TB 20 TB 30 TB 40+ TBCustomer Data (Raw) Size

Cus

tom

er D

ata

(Raw

) D

ata

Siz

e

SM

P S

cale

Up

Cap

acity

per

Sys

tem

IBM System p

IBM System x

Server p570(Power6)DS4800

x3850(Intel x86)

DS3400

x3755(AMD x86 )

DS3400Storage

IBM Systems Reference Configurations

40+ TBOracle Optimized Warehouse Initiative

Reference Configurations

15 TB

15 TB

p595 DS8300

Optimized Warehouse

© 2008 IBM Corporation31

IBM Systems Architecture for Oracle Optimized WarehouseSystem p570 and System Storage DS4800

DS4800 Controller

DS4800 EXP810

storageexpansion drawers

p570 server4-core, 4.7GHz

POWER6HMC additional

SAN Switch

Single rackbuilding block

5TB

3TB

1TB5TB

20TB

15TB

10TB

Rack components Scale out building blocks: 5TB to 20 TB

Oracle Components•Oracle Database 10g EE•Oracle RAC•Oracle Partitioning

© 2008 IBM Corporation32

Provides repeatable, balanced building blocks of IBM System p & System Storage supporting Oracle Optimized Warehouse & Reference Configurations for businesses needing to support:

• Up to 30 “power users” (Oracle test suite)• Up to 5TB of customer data (21.7TB Cap.)• Leverage latest POWER6 technology• Scale out to 20 TB and beyond

IBM System p 570• Two 4.7 GHz dual-core POWER6 processors (4 cores)• Up to 32 GB Memory• Up to 8 x 4 Gbps Fiber Channel• Up to 4 x 1 Gb Ethernet• AIX V5.3

Item 1 TB 3 TB 5 TB

p570* $211,112 $244,728 $251,344

SAN* included included included

DS4800* $181,012 $260,004 $436,407

IBM Hardware*

$392,124 $504,732 $687,751

Oracle Software*

$256,200 $256,200 $256,200

Warehouse List Price*

$648,324 $760,932 $943,951

List price / TB*

$648,324 $253,644 $188,790

IBM System Storage SAN 16M-2Up to (3) 16/32 ports, 2 Gb

IBM DS4800 (FC attach)• Up to (8) EXP 810 • Up to 160 Disks configured• Up to Max 224 drive capacity• Up to 46 GB 15K Drives • Up to 5 TB Storage configured• Single 42U Enterprise Rack

Oracle Components• Oracle Database 10g EE• Oracle Real Application Clusters• Oracle Partitioning

New LowPrice / TBOracle Optimized Warehouse for System p570

* All prices are US list prices as of 11/09/07 and provided for information only. Please consult your IBM and Oracle BP or sales representatives for pricing.

© 2008 IBM Corporation33

Conclusion / Wrap-upOracle Maximum Availability Architecture integrates easily with

IBM Power Performance & Virtualization capabilities, which helps elaborate best of breed architectures.

Oracle/IBM Joint Solutions Center & IBM eTS Team are at your disposal for any Oracle E-Business Suite (or Siebel, PeopleSoft, JD Edwards, ...) project : don’t hesitate to solicit us!

© 2008 IBM Corporation34