Tài liệu Virtualizing Oracle Database 10g/11g on VMware Infrastructure docx

Virtualizing Oracle Database 10g/11g on VMware

Infrastructure

Consolidation Solutions with VMware®

Infrastructure 3

and EMC Celerra NS40 Multi-Protocol Storage

May 2009

VMware Inc. Virtualizing Oracle Database 10g/11g on VMware Infrastructure

Technical White Paper ii

Contents

Executive Overview.......................................................................................................1

Introduction....................................................................................................................1

Related Documents and Resources ...........................................................................................................................................................1

Commercial Publications ...............................................................................................................................................................................1

VMware Resources.............................................................................................................................................................................................2

EMC Publications................................................................................................................................................................................................2

Oracle Support.....................................................................................................................................................................................................2

Business Challenges......................................................................................................4

Virtualization Technology Solution ...........................................................................4

Consolidation with VMware Infrastructure versus Oracle RAC..................................................................................................5

Simplified High Availability ...........................................................................................................................................................................5

Simplified Project Consolidation................................................................................................................................................................7

Reduced Oracle Licensing Costs ................................................................................................................................................................8

Improved Performance ...................................................................................................................................................................................8

Solution Components .....................................................................................................................................................................................10

VMware Infrastructure................................................................................................................................................................................... 10

Oracle Database 10g/11g ........................................................................................................................................................................... 12

EMC Celerra NS Series Storage ................................................................................................................................................................. 12

Solution Architecture................................................................................................. 13

Configuration 1 – Oracle Database on VMware Infrastructure Using a Pure NFS Storage Design ..................14

VMware Architecture..................................................................................................................................................................................... 16

Storage Architecture...................................................................................................................................................................................... 17

Configuration 2 – Oracle Database on VMware Infrastructure Using a Pure NFS Storage Design with a

Four-Node VMware HA/DRS Cluster Solution ..................................................................................................................................18

VMware Architecture..................................................................................................................................................................................... 20

Storage Architecture...................................................................................................................................................................................... 21

Configuration 3 – Oracle Database on VMware Infrastructure Using Blended FCP/NFS Storage Design...22

VMware Architecture..................................................................................................................................................................................... 24

Storage Architecture...................................................................................................................................................................................... 25

Conclusion .................................................................................................................. 26

Appendix A. Oracle Solution Features and Capabilities ..................................... 27

Appendix B. Storage Layouts for Pure NFS Configuration................................. 28

VMware Inc. Virtualizing Oracle Database 10g/11g on VMware Infrastructure

Technical White Paper iii

Appendix C. Storage Layouts for Blended NFS/FCP Configuration ................. 33

Appendix D. Hardware and Software Resources ................................................. 37

Hardware Resources .........................................................................................................................................................................................37

Software Resources ...........................................................................................................................................................................................38

VMware Inc. Virtualizing Oracle Database 10g/11g on VMware Infrastructure

Technical White Paper 1

Executive Overview

This document describes the configuration of three different solutions for virtualizing Oracle

database servers on VMware® Infrastructure and EMC Celerra storage. These solutions enable

enterprises to take a number of their departmental databases and consolidate them on to a

smaller number of servers, thereby reducing administrative requirements, simplifying end-user

access and control, and reducing overall system costs associated with complex Oracle

environments. Once virtualized, Oracle databases can reap all the benefits of a virtualized

platform. These benefits include rapid database server provisioning, simplified high availability

and disaster recovery, reduced server hardware requirements and associated costs such as power,

cooling, and rack space.

Introduction

This document is intended to provide customers with technical solution and configuration

information that can be used as the basis for virtualizing Oracle database servers on the VMware

Infrastructure platform. The specific solutions described in this document are the following:

1. Oracle Database on VMware Infrastructure using a pure NFS storage design (on a single

VMware® ESX host).

2. Oracle Database on VMware Infrastructure using a pure NFS storage design with a four-node

VMware® High Availability (HA)/VMware® Distributed Resource Scheduler (DRS) cluster

solution (using multiple ESX servers).

3. Oracle Database on VMware Infrastructure using a blended FCP/NFS storage design (on a

single ESX server).

Details are provided for the ESX server and virtual machine configurations as well as Celerra disk

storage layouts for the three different configurations. Testing was also done to demonstrate how

each of these configurations can provide capabilities for backup, disaster recovery and test/dev.

Readers should have a thorough understanding of storage, virtualization and Oracle database

concepts to get the most value from this document.

All solution design and testing was done at EMC labs in Raleigh, North Carolina in conjunction

with VMware.

Related Documents and Resources

Documents listed here provide additional information relevant to the topics described in this

document.

Commercial Publications

• Scalzo, Bert. Oracle on VMware: Expert Tips for Database Virtualization. Kittrell, NC: Rampant

Techpress, 2008.