Building Database Clouds in Oracle 12c / Edition 1

by Tariq Farooq, Sridhar Avantsa, Pete Sharman

Overview

An Expert Guide to Building Oracle Database Cloud Infrastructures

This is the first complete, practical guide to architecting, designing, and building Database Clouds with Oracle 12c. Written by a veteran author team of Oracle gurus and ACE Directors, Building Database Clouds in Oracle 12c combines a real-world, hands-on operations guide with an expert handbook on Oracle Database-As-A-Service (DBaaS) and Oracle Real Application Clusters (RAC).

Writing for Oracle DBAs, DMAs, cloud administrators, and other Oracle professionals, the authors present authoritative technical information for database cloud build-out, management, monitoring, and day-to-day administration.

The authors first explain the key concepts underlying DBaaS, describe cloud computing implementations related to it, and outline the business and technology benefits. Next, they show how the Oracle DBA’s approach changes in cloud environments. Then, building on this foundation, they offer insider advice on all key facets of database cloud deployment and operation with Oracle Enterprise Manager 12c and Oracle RAC 12c.

This guide helps you

• Make the business case for cloud computing with DBaaS
• Organize DBA responsibilities in cloud environments
• Plan, design, and deploy Database Clouds with Oracle’s latest components
• Consolidate schema and databases with Oracle Enterprise Manager 12c
• Use best practices for management, administration metering, and chargeback
• Clone databases quickly and reliably
• Set up grid infrastructure on Oracle VM for x86 or Oracle VM VirtualBox

Product Details

ISBN-13:	9780134310862
Publisher:	Addison-Wesley
Publication date:	06/29/2016
Pages:	320
Product dimensions:	7.00(w) x 9.10(h) x 0.80(d)

About the Author

Tariq Farooq, Oracle Technologist, has worked with various Oracle technologies in complex environments for more than twenty-four years. A world-renowned Oracle Expert, he has earned both the Oracle ACE and ACE Director awards. His books include Oracle Database Problem Solving and Troubleshooting Handbook, Oracle Exadata Expert’s Handbook, and the best-selling Expert Oracle RAC 12c.

Sridhar Avantsa runs the National Oracle Database Infrastructure Consulting Practice for Rolta AdvizeX. He has more than twenty years of Oracle experience as developer, DBA, and architect, for companies including Amazon.com and REI. His expertise includes infrastructure architecture, database tuning, high availability, disaster recovery/business continuity, Oracle RAC clustering, EXADATA, ODA, OVCA, and ZFS Appliance.

Pete Sharman is principal product manager for the Oracle Enterprise Manager (OEM) Suite. He has worked at Oracle for twenty years in roles ranging from education and consulting to development, and has used Enterprise Manager since its 0.76 release. He is coauthor of Expert Enterprise Manager 12c, Practical Oracle Database Appliance, and Expert OEM 12c.

Table of Contents

Preface xi

Acknowledgments xiii

About the Authors xv

About the Technical Reviewers and Contributors xvii

Chapter 1: Database as a Service Concepts–360 Degrees 1

Cloud Computing: Definition and Classical View 1

DBaaS–A Special Case of Cloud Computing 4

Services Applicable to DBaaS 7

Architecture of an Oracle-Based DBaaS Implementation 9

Business and Technology Benefits of Having DBaaS Enabled 14

Great First Step for Transitioning into the Cloud 16

Summary 17

Chapter 2: The Database Cloud Administrator–Duties and Roles 19

DBA Responsibilities in a Traditional Environment 19

What’s Changed with DBaaS 21

The New Role of the Cloud DBA 25

Preparing to Be a Cloud DBA 28

Summary 30

Chapter 3: Cloud Computing with DBaaS–Benefits and Advantages over Traditional IT Computing 31

DBaaS Evolution: Pre—Database Cloud Strategies 31

Delivering DBaaS with Oracle Technologies 33

Cloud Computing with DBaaS 47

Summary 49

Chapter 4: Schema Consolidation in Enterprise Manager 12c 51

Architecture and Components 52

Schema as a Service Setup 53

Using Schema as a Service 77

Deployment Issues 83

Summary 87

Chapter 5: Database Consolidation in Enterprise Manager 12c 89

PDBaaS Setup 90

Using the Self-Service Portal with PDBaaS in Enterprise Manager 12.1.0.4 114

Deployment Issues 119

Summary 122

Chapter 6: Metering and Chargeback in Enterprise Manager 12c 123

Terminology 125

Setting Up Chargeback 128

Summary 145

Chapter 7: Manage and Administer the Database Cloud in Enterprise Manager 12c 147

The Cloud Home Page 148

The Cloud Adviser 152

Summary 156

Chapter 8: Cloning Databases in Enterprise Manager 12c 157

Full Clones 157

Snap Clones 176

Summary 184

Chapter 9: Virtualizing RAC 12c (DB Clouds) on Oracle VM–Grid Infrastructure 185

Database Clouds Based on RAC–The Necessary Ingredients 186

Virtualization–360 Degrees 187

What Are VM Monitors (Hypervisors)? 187

Types of Hypervisors 187

Types of Virtualization 188

OVM for x86–360 Degrees 189

Xen–Synopsis and Overview 190

OVM–Overview and Architecture 190

What Are OVM Templates? 191

OVM 3.x–A Brief Introduction 192

Virtualized RAC Using OVM Templates–Approach 1 193

Set Up and Configure a Virtualized RAC Database Cloud–Approach 2 195

Summary 234

Chapter 10: Virtualizing RAC 12c (DB Clouds) on Oracle VM VirtualBox–RAC Databases 237

OVM VirtualBox: A Brief Introduction 238

What Is Cloud Computing? Synopsis and Overview 239

Oracle’s Strategy for Cloud Computing 240

EM12c and OVM: Management and Virtualization Components for Oracle Database Clouds 241

RAC Private Cloud on OVM VirtualBox–Software and Hardware Requirements 241

Setting Up, Installing, and Configuring Oracle RAC 12c Private Cloud on OVM VirtualBox 242

EM12c: Implementing DBaaS 272

Summary 274

Index 277