Home > Store

Virtualizing Oracle Databases on vSphere

Add To My Wish List

Virtualizing Oracle Databases on vSphere

By Kannan Mani, Don Sullivan
Published Oct 15, 2014 by VMware Press. Part of the VMware Press Technology series.

eBook

Your Price: $38.39
List Price: $47.99
Includes EPUB and PDF
About eBook Formats

This eBook includes the following formats, accessible from your Account page after purchase:

ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

Adobe Reader PDF The popular standard, used most often with the free Acrobat® Reader® software.

This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Add to cart

Description

Sample Content

Updates

More Information

Description

Copyright 2015
Dimensions: 7" x 9-1/8"
Pages: 384
Edition: 1st

eBook
ISBN-10: 0-13-357020-7
ISBN-13: 978-0-13-357020-5

The start-to-finish guide to virtualizing business-critical Oracle Software and Databases on VMware vSphere

Virtualizing large-scale Oracle software and databases on vSphere can deliver powerful scalability, availability, and performance benefits. Recognizing this opportunity, thousands of organizations are moving to virtualize Oracle. However, reliable best practices have been difficult to find, and database and virtualization professionals often bring incompatible perspectives to the challenge.

Virtualizing Oracle® Databases on vSphere® is the first authoritative, comprehensive, and best-practice guide to running Oracle on VMware platforms. Reflecting a deep understanding of both Oracle and vSphere, this guide is supported by extensive in-the-field experience with the full spectrum of database applications and environments. Both a detailed reference and a practical cookbook, it combines theory and practice, and offers up-to-date insights for the entire lifecycle, supported by case studies.

Kannan Mani and Don Sullivan fully address architecture, performance, design, sizing, and high availability. Focusing on current versions of Oracle and vSphere, they highlight the differences between ESX/ESXi 4.x and 5.x wherever relevant. To deliver even more value, they provide extensive online resources, including easy-to-adapt scripts and expert how-to videos.

Coverage includes:

Understanding the DBA’s expanded role in virtualized environments, and the emergence of the vDBA, vRACDBA, and Cloud DBA
Identifying your best opportunities to drive value from virtualizing Oracle
Anticipating challenges associated with virtualizing Oracle-based Business Critical Applications on vSphere
Using VMware to overcome ongoing database deployment and management problems
Protecting your virtualized database environment with vSphere’s high-availability capabilities
Designing databases to achieve scalability on demand, maximize availability, consolidate servers, and improve compliance
Implementing best practices for memory, storage, and database layout
Demystifying the impact of virtualization on Oracle support and licensing
Using VMware Site Recovery Manager (SRM) to accelerate disaster recovery by seamlessly integrating VM and storage failover
Streamlining provisioning and taking advantage of opportunities to automate



Sample Content

Foreword xv

Introduction xix

About the Authors xxiii

Acknowledgments xxv

About the Reviewers xxix

Chapter 1 Introduction to Oracle Databases on Virtual Infrastructure 1

Virtualization with ESXi and vSphere and the Software-Defi ned Datacenter 3

Virtualizing Oracle Databases on vSphere: Benefi ts and Examples 7

Oracle Databases and DBA Fundamentals 8

Understanding Oracle Database Architectures 11

Summary 12

Chapter 2 Virtualization and High-Performance Oracle Workloads 15

Virtualized Oracle Environments on vSphere Key Benefi ts 15

Consolidating Platforms to Reduce Datacenter Costs 17

Enhancing Database Availability and Cost-Effective Disaster Recovery 19

Provisioning Rapid and New Database Server Environments 21

Reducing Planned Downtime with Migration of Live Oracle Database Servers 22

Guaranteeing Resources in a Shared Environment 23

Achieving IT Compliance 24

Zeroing In on Key Trigger Events 24

Solving Oracle Database Deployment and Management Issues Using VMware 25

Implementing Dynamic Oracle Datacenter Resource Management 26

Minimizing Server Sprawl 27

Meeting SLA Demands for Database Performance, Availability, and Disaster Recovery 27

Supporting a Dynamic Business Environment 27

Minimizing License Costs 28

Maximizing Oracle Workloads and Sizing 28

Option 1: Sizing the Oracle DB Workload 30

Option 2: Sizing the Oracle DB Application Vendor Recommendations 32

Option 3: Sizing Oracle DB Server Vendor Guidelines 35

Testing the Limits: Performance Studies and Stress Tests 36

Summary 36

Chapter 3 Oracle Databases and Applications in Virtual Infrastructure: Architectural Concepts 37

VMware ESXi Hypervisor 38

Designing Databases on VMware 41

Designing for Scalability on Demand 42

Designing for High Availability 44

Maintaining Compliance 48

Consolidating Database Servers 48

Virtualizing Oracle RAC 51

Identifying Key Stakeholders 53

Summary 54

Chapter 4 Oracle on vSphere Best Practices 55

Implementing ESX Host Best Practices 57

Maximizing Performance Using BIOS Settings 58

Operating System Processes 59

Upgrading the Version of ESX/ESXi and vSphere 60

Maximizing Support for a Hardware-Assisted Memory Management Unit 61

Implementing Memory-Related Best Practices 61

Supporting Large Pages 64

Implementing Compute (vCPU)-Related Best Practices 65

Confi guring Storage-Related Best Practices 68

Categorizing Storage Virtualization Technologies 71

Understanding Storage Protocol Capabilities 71

Understanding Database Layout Considerations 73

Comparing VMFS to RDM: Performance and Functionality 76

Networking Guidelines 78

Monitoring Performance on vSphere 79

Timekeeping in Virtual Machines 81

Summary 82

Chapter 5 Oracle Database High Availability: Planned and Unplanned Downtime 83

Protecting the Virtualized Environment with vSphere High Availability 84

Protecting Applications with vSphere and Symantec AppHA 86

Understanding Oracle RAC in Virtual Machines 88

Implementing Oracle RAC One Node 88

Implementing Multinode RAC 90

Deploying Oracle RAC on vSphere 92

Protecting Oracle Databases Against Downtime 98

Transitioning RAC Nodes Between Hosts Using VMware vMotion 100

To RAC or Not to RAC 103

Summary 104

Chapter 6 Performance Workload and Functional Stress Test Studies 105

Oracle Single-Instance Workload Study 106

Test Methodology 106

Test Result Details 109

Oracle RAC Workload Characterization Study 121

vMotion and VMware HA 121

Large-Scale Order Entry Benchmark Kit (Swingbench) 122

Architecture 123

Network Confi guration 125

Oracle RAC Installation Overview 130

24-Hour Workload Test 131

Oracle RAC Node vMotion Test 132

Mega vMotion-RAC Functional Stress Test 135

Summary 139

Chapter 7 Support and Licensing 141

Contemplating Oracle Software Support and Licensing 141

Understanding Oracle Certifi cation and Support for VMware Environments 143

Certifi cation of Oracle on VMware vSphere 144

Licensing Oracle 147

Advising VMware Customers 149

Summary 154

Chapter 8 Performance Management and Monitoring 155

Performance Management Terminology 157

The Role of the DBA in Performance Management 158

Processing Power: CPU or vCPU 159

CPU Ready Time (%RDY) 162

Memory 164

System Huge Pages 167

Transparent Page Sharing 172

Non-Uniform Memory Access 172

Networking 175

Network Load Testing 176

Dropped Packets 177

Storage Confi guration and Utilization 181

SCSI Queues 182

NFS Storage 185

Storage Access Latency 187

Spindle Busy Average 190

Understanding SCSI Queue Depth on an ESX/ESXi Host and Virtual Machine 191

Storage Path Throughput 192

Storage Benchmarking VMDK 193

Benchmarking and Ongoing Maintenance 197

Iometer 198

Oracle ORION 203

Comparing Storage Types 219

Block Alignment 220

Using pvSCSI and LSI Controllers 222

ASM Is Comparable to an LVM 225

Understanding the Oracle Enterprise Manager vCOPS Adapter 228

Using Oracle Database Server Metrics 230

Installing Oracle Enterprise Manager Adapter 232

Validating the OEM Adapter 233

Creating Oracle Database Custom Dashboard 233

Confi guring a Metric Graph (Rollover View) Widget 235

Confi guring a Generic Scoreboard Widget 235

Finalizing the Oracle Database Dashboard 236

Summary 239

Chapter 9 Business Continuity and Disaster Recovery 241

VMware vCenter Site Recovery Manager 243

vSphere Replication 245

Storage Array-Based Replication 247

Storage Replication Adapters 247

Application-Based Replication 248

Oracle Data Guard 248

Repairing Logical Data Block Corruption with Oracle Data Guard 249

Combining vSphere Replication and Data Guard 250

Testing SRM vSphere Replication 251

Using Storage Array-Based Replication with vSphere 253

Virtual Provisioning for Oracle ASM Disk Groups 255

Solution Findings 256

Creating a Disaster Recovery Plan 257

Confi gure Connections 257

Break the Connection 257

Export System Logs 257

Using Array-Based Replication 258

Summary 264

Chapter 10 Backup and Recovery 267

Backup and Recovery Principles 269

Backing Up Data Using In-Guest Software Solutions 270

Oracle Database Backup Methods 270

Classic Oracle Database Backups 270

Listing of Storage Vendor Backup Tools 272

Other Backup Tools 273

Storage Vendor Backup Solutions 273

Working with NetApp Backup Solutions 274

NetApp Backup and Restore Solution Overview 274

Integrating NetApp with vSphere 274

Working with NetApp Snapshot 275

Backing Up a Virtualized Oracle Database with NetApp Snapshot 275

Tools Available for Backups of Oracle Using NetApp 276

Step-by-Step Solution for Backing Up a Virtualized Oracle Database with NetApp Storage and NFS Datastores 277

Restoring a Database Using NetApp Snapshot 277

Backup and Restore Use Case with Snap Creator 278

EMC Avamar Backup and Restore Solution Overview 279

Backing Up the Oracle Database 280

Restoring the Oracle Database 281

VMware Data Protection Advanced 281

Comparing VMFS and RDM 282

Backups 283

Understand the Functionality of VMFS Versus RDMs 283

Oracle Data Guard for Backup 284

Oracle Database Backup Strategy Matrix 286

Summary 286

Chapter 11 Provisioning and Automation 289

Migrating Oracle Database from a Physical to Virtual Environment 291

Viewing Oracle Migration from a Physical to Virtual Solution 293

Facilitating Deployments 294

Understanding the Business Scenario 294

Lab Architecture 295

Migrating Oracle Database from Physical to Virtual 296

Confi guring Application Blueprints Using vCAC 302

Building a Database-as-a-Service Platform 311

Listing the Benefi ts of DBaaS 312

Allocating Storage as Part of the DBaaS Paradigm 313

Choosing the Components of a DBaaS Architecture 313

Summary 314

Chapter 12 Case Studies 317

Indiana University 318

American Tire Distributors 320

EMC Information Technology 321

Green Mountain Power 323

The Idaho Supreme Court 324

The University of British Columbia 326

VMware Information Technologies 327

So Many Others 330

Working with Events 330

Summary 332

Book Conclusion 332

TOC, 9780133570182, 9/26/2014



Updates

Submit Errata



More Information



InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Privacy Notice

Overview

Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security

Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children

This site is not directed to children under the age of 13.

Marketing

Pearson may send or direct marketing communications to users, provided that

Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
Such marketing is consistent with applicable law and Pearson's legal obligations.
Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out

Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

As required by law.
With the consent of the individual (or their parent, if the individual is a minor)
In response to a subpoena, court order or legal process, to the extent permitted or required by law
To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
To investigate or address actual or suspected fraud or other illegal activities
To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links

This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020

Email Address

Corporate, Academic, and Employee Purchases