Virtualizing Oracle on VMware

Sudhansu Pati, VCP Certified

4/20/2012

© 2011 VMware Inc. All rights reserved

Agenda
 Introduction
 Oracle Databases on VMware Key Benefits
• Performance, Support, and Licensing
• Server Consolidation
• Rapid Provisioning
• Workload Management
• Compliance
• High Availability and Business Continuity
• Oracle RAC on vSphere 5
 Oracle Support, Certification, License
 Q&A

2
 Benefits of Running Oracle on VMware

3
 Why Deploy Oracle Databases on VMware?
Consolidate licensing
Oracle Licensing Potentially Increase utilization of Oracle licenses
(Depends on degree of consolidation)

Reduce hardware costs by > 50%

DB Consolidation Consolidate servers by 4X – 20X

Provision databases on demand

DB On Demand Minutes to provision in production and in the lab

Increase application Quality of Service

Quality of Service Scale dynamically
Built-in high availability and simple disaster recovery

Complete isolation between systems on the same host

Security Protects databases and applications against network-based
threats

4 4
VM Density Is Critical in Virtual Environment

Physical World Virtual World

1:1 VM density
matters!
1:1

1:1 1:1

1:1
Many:1
1:1

1:1 relationship between Many:1 relationship between

applications and hardware applications and hardware
Relevant cost metric = Relevant cost metric =
cost per server cost per application

5
Distributed Resource Scheduler

 Automatically balances load

across ESX Clusters

6
VMware High Availability (HA)

 Protects VMs and automatically restarts VMs in the event of:

• Host failure
• VM failure (loss of heartbeat)

7
vSphere 4.1 and 5.0 – App-Aware HA

VMware HA
VMware HA

Resource Pool Resource Pool

vSphere vSphere vSphere vSphere

Protect against
hardware failures Protect against app failures

 App-aware HA bridges the gap with app-level clustering

• Automated availability for both hardware and software failures
• Third-party agents detect application and operating system failures (for
example, Symantec ApplicationHA)
• Invoke VMware HA through “Application Health Monitoring API”
8
vCenter Site Recovery Manager for Simple, Reliable DR

VMware vCenter Site Recovery Manager™ complements vSphere to provide the

simplest and most reliable disaster protection and site migration for
Oracle Database and applications

• Provide cost-efficient replication

Site A (Primary) Site B (Recovery) of applications to failover site
VMware Site Recovery VMware Site Recovery
vCenter Server Manager vCenter Server Manager

• Simplify management of
VMware vSphere VMware vSphere recovery and migration plans

• Automate failover, failback, and

migration processes for reliable
Servers Servers
recovery

9
The Trend Is Clear

% of Workload Instances Running on VMware in Customer Base

67%

53%
47%

42% 43%

34%
28% 28%
38% Apr
25% 25%
2011
18% Jan
2010
Microsoft Microsoft Microsoft Oracle Oracle
SAP
Exchange SharePoint SQL Middleware DB

Source: VMware customer survey, Jan 2010 and April 2011 interim results
Data: Total number of instances of that workload deployed in your organization and the percentage of those instances that are virtualized

10
 Oracle Databases on VMware
Key Benefits
Workload Management and QoS

11
Dynamic Scalability for Oracle Database and Applications

1 vCPU 4 vCPU
Hot-Add capacity 2GB
64GB

Dynamic  Zero downtime maintenance

Scaling  Migrate live databases
 Little impact to users
on
vSphere

Provision additional
app instance in minutes

12
Dynamic Load Balancing of Resources
Tier 1 Tier 2 Tier 3

APP APP APP APP APP

DRS – Load balances VMs

across hosts
VMware Cloud Infrastructure and Management

Storage DRS – Load balances

VMs across storage arrays

Physical Servers Network and Storage I/O

Tier 1 Tier 2 Tier 3 Control – Critical workloads
get preferential access to
network and storage I/O

Storage

13
Oracle 11g R2 DB Server – vMotion

14
Oracle 11g R2 DB Server – VMware Hot Add vCPU

15
 Maximum Scalability and Performance with vSphere 5

 1 million IOPS validated by VMware

VMware VMware
Performance Engineering
vSphere 4 vSphere 5
• http://www.vmware.com/files/pdf/1M-iops-
CPU 8 vCPUs 32 vCPUs perf-vsphere5.pdf
Memory 256GB per VM 1,000GB per VM  A vSphere 5.0 host can support
1 million+ I/O operations per second
Network 30Gb/s > 36Gb/s
 300,000 I/O operations per second
IOPS 300,000 1,000,000
achieved from a single virtual
machine
 Adequate storage infrastructure
required to meet the demand

16
The Average Oracle DB Fits Easily in a Virtual Machine

VM VM VM VM
32 vCPU 1TB 300,000 IOPS 30Gb/s

Oracle DB Oracle DB
2–4 CPU 4–8GB
Oracle DB
4% utilized 50% utilized Oracle DB
1200 IOPS
2MB/s

CPU Memory Disk I/O Network I/O

Source: VMware Capacity Planner™ analysis of > 700,000 servers in customer production environments

17
Oracle Database Server Scale Up Performance Relative to Native

• ESX scales extremely well – scale up

• Doubling processors – throughput increases by 90%
Source : http://vmware.com/pdf/Perf_ESX40_Oracle-eval.pdf

18
Conventional DB Consolidation Is Difficult

Multi-Instancing Shared Instance

App App App App App
Instance Instance Instance Instance Instance
Schema Schema Schema Schema Schema

DBMS DBMS DBMS DBMS DBMS Shared DBMS

Shared OS Shared OS

• No OS isolation (configuration, security, • No OS isolation (configuration, security,

fault) fault)
• Resource isolation requires Windows • No database isolation
Resource Manager • Resource isolation requires Oracle
• No load balancing across physical Resource Governor
nodes • No load balancing across physical
nodes

19
 Ideal Platform for DB Consolidation

Current DB 1 Fast consolidation with P2V

Increase performance!
Oracle 2 Preserve isolation in VM
OS isolation
DB isolation
Security isolation

ORCL 3 Guarantee resources

ORCL ORCL ORCL ORCL ORCL ORCL ORCL Reservations
Priorities
Maximums

4 Load balance across

nodes
vMotion
DRS

20
 Oracle Databases on VMware
Key Benefits
Rapid Provisioning

21
Accelerate Time-to-Market for Business-Critical Apps

3 4
Test Production
Run more Move changes
tests faster into production

2 1

vApp Exact copy of Archive for

production fast rollback
vSphere vApp

vSphere vSphere

vApp

 Faster testing of multitier applications

 More accurate testing on exact production copy
 Lower cost testing infrastructure
 Reduce storage footprint by over 60%
22
Rapid Provisioning of Oracle Databases

 Provisioning
• Simple and rapid
• Use Golden Images to provide on-demand Oracle DB
servers
QA • DBAs can deploy Oracle DB server with no additional
skills
Dev/Test
 Ideal for Test and Dev
• Clone, transfer, and share environments easily, take
Reports
system snapshots, or restore to previous state
• Automate SDLC with VMware vCloud Director™
 Database virtual machine libraries
• Central repository of virtual machine images
• Virtual machine images with different DB and OS
• Storage leases help to reclaim space from expired
images

23
 Oracle Databases on VMware
Key Benefits
Compliance

24
Retention Periods – Reproducing the Data and Audit Trail

 What if I need to reproduce a six year old legacy environment?

• Not as simple as locating the
backup and recovering the database
• Need to recreate the entire
hardware-software stack
• What OS?
• What application version?
• What database version?
• What patch level?
• On what hardware?
• If not, it is almost guaranteed
transactions will not produce
identical results
• Failed audit

25
Using vSphere for Compliance Purposes

 Cloning a fully virtualized database server captures the entire VM

• VM can be cloned and stored in a

virtual vault/archive
• Then powered on in the event of an
audit or discovery request Clone
OS OS
• Significantly simplifies environment
regeneration process VMware vSphere 4.1

• Hardware independent regeneration

and recovery
• There is no single answer or magic
solution to achieve compliance
• Capturing whatever solution suits a
customer’s environment in a VM is
a powerful step towards compliance

26
 Oracle Databases on VMware
Key Benefits
Oracle RAC on vSphere 5

27
Oracle Databases on vSphere – Oracle RAC Logical Architecture

28
 Oracle RAC Node VM – vMotion Testing Steps

Step 1: Migrate the Oracle RAC

node VMORARAC2 from ESX2
(10.1.1.35) to ESX4 (10.1.1.43)
so that ESX2 can be taken
down for a firmware upgrade

Step 2: After the hardware

maintenance is completed on
ESX2, move VMORARAC2
from ESX4 (10.1.1.43) back to
ESX2 (10.1.1.35)

29
CPU Utilization During Oracle RAC Node VM vMotion

30
 Oracle Support, Certification, License Cost

31
Oracle Licensing Comparison – Customer Example
PHYSICAL VIRTUAL
Siebel Loadstar OBIEE
Prod,
X 12 Stage,
Prod Dev, Test

ESX
8 core 8 core 4 core

8 core/96GB
Stage
8 core/96GB

8 core 8 core 4 core

8 core/96GB

Dev 8 core/96GB

/Test
12 core 12 core

Enterprise Edition Pricing per Oracle Technology Global Price List, October 20, 2011

32
Oracle’s Support Statement (Tech Note: 249212.1)

Oracle has not certified any of its products on VMware virtualized environments. Oracle Support will assist
customers running Oracle products on VMware in the following manner: Oracle will only provide
support for issues that either are known to occur on the native OS, or can be
demonstrated not to be as a result of running on VMware.

If a problem is a known Oracle issue, Oracle support will recommend the appropriate solution on the native
OS. If that solution does not work in the VMware virtualized environment, the customer will be referred to
VMware for support. When the customer can demonstrate that the Oracle solution does not work when
running on the native OS, Oracle will resume support, including logging a bug with Oracle Development for
investigation if required.

If the problem is determined not to be a known Oracle issue, we will refer the customer to VMware for
support. When the customer can demonstrate that the issue occurs when running on the native OS,
Oracle will resume support, including logging a bug with Oracle Development for investigation if required.

NOTE: Oracle has not certified any of its products on VMware. For Oracle RAC, Oracle will only accept
Service Requests as described in this note on Oracle RAC 11.2.0.2 and later releases.

33
How to Read Oracle’s Support Statement

 Certification
• Oracle doesn’t Certify Below OS
• Examples: Sun, HP, IBM, EMC, NetApp, Cisco, Dell, F5, Brocade, Intel, AMD
• Certification for VMware Not Required – No changes to OS
 Support
• Known Issues
• Unknown Issues
• Rare
• Oracle Prefers Work Around
• Reproduce in Another Physical Env May Be Necessary Even W/O VMware
• RAC support Added on Nov 8th 2010
 Ask for List of Unknown Issues You Have Ever Experienced
• Contact Oracle Support (Not Sales)

34
Oracle on VMware is Better Supported Than Physical

 VMware will Own Your Oracle Support Issue

 For “Known Issues”
• VMware is Supported
 For “Unknown Issues”
• Option 1: Move Virtual To Physical
• Much Simpler than Physical To Physical
• Option 2: Switch VMware to OVM
• In-place reboot of Oracle using OVM in the Same HW
• No third-party license is required
• Option 3: Maintain Physical/Virtual using Dataguard
• Dataguard License is Required
 Many Customers Have Support Addendums

35
Oracle Licensing For VMware

 Example – A VMware vSphere Distributed Resource Scheduler

(DRS) cluster with Oracle
• 4 blades, each with 4 CPU cores and each virtual machine is 2 vCPU (2-core)
vCenter Cluster 1

vCenter Cluster 2
Oracle
DB

vMotion

• Solution
• Both Oracle hosts must be licensed for all 8 cores on 2 blades
• Same for physical or virtual: (8 cores) x (0.5 x86 factor) = 4 licenses
• Free to move that Oracle database virtual machine to and from Host 1 and Host 2
• Do not let Oracle Database virtual machines migrate to App Host 3 or App Host 4!
• Isolate – VMware vCenter™ logical clusters, or DRS 4.1/5.0 host affinity rules
• See Gartner Research Doc ID #G00165003 for similar guidance

36
 Q&A

37