|
ISBN 10:
0-9797951-4-1
ISBN 13:
978-0-9797951-4-5 |
Library of
Congress Number: 2008932387 |
232
pages
Perfect bind - 9x7 |
Publication Date: September 2008 |
|
Shelving:
Databases/Oracle |
Easy Oracle Series #xx |
|
|
Oracle on VMWare
Expert tips for database virtualization
Dr. Bert Scalzo
Retail Price $34.95
/ £22.95
| Order now at 30% off and
get access to the
code depot! |
Only $23.95
(30% off) |
 |
Intended
for Database Administrators, System Administrators,
Technologists and Technology Consultants, this book covers
all basic concepts through proven best practices for
successfully implementing Oracle databases on virtualized
hardware using VMware – including virtualized Real
Application Clusters. To help put those concepts to work in
reality, this book provides a broad spectrum of
technological recommendations, which should inform the savvy
reader on how to reliably and consistently achieve optimal
configuration and maximum performance for any virtualized
Oracle database scenario. Moreover many of these concepts
and techniques can be generically and liberally applied to
other virtualization technologies. |
|
Virtualization
has arrived as a truly disruptive and increasingly pervasive
technology in today's data centers - with VMware as the market
leader. It’s been truly disruptive in nature by totally altering
the approach to servers – from sizing and ordering, to
deployment and maintenance. It’s become pervasive because not
only does it provide for better resource management – but it’s
green to boot. The days of stand-alone servers, even database
servers, are truly numbered.
Oracle has
always been the premier enterprise database server – but
historically, one’s Oracle databases tended to reside on
dedicated hosts. But times have changed – and now these two
great technologies are being increasingly utilized together.
Thus the complexities of designing, configuring, maintaining and
tuning Oracle database deployments has risen to a new level of
challenge. This book offers a comprehensive reference for
successfully meeting the challenges of combining VMware and
Oracle – with real world examples and highly applicable advice.
For Oracle
DBA’s tasked with managing virtualized databases, this book will
become the primary reference. While the Oracle manuals and
numerous other books out there cover the database technology,
nowhere else will you find a complete compendium for keeping
your virtualized Oracle databases in top form.
|
|
|
Discover the
secrets to a happy
marriage: Between
Oracle
and
VMware!
|
|
- Learn recommended Oracle
"best practices" for visualized servers
- Discover suggested
visualized server configuration as a database server
- Exposure to "client OS"
configuration for Oracle in a virtual world
|
About the Author:
Bert Scalzo, Ph.D. |
Dr. Bert Scalzo is a
Database Architect for Quest Software and a member of
the TOAD team. Mr. Scalzo has worked with Oracle
databases for well over two decades, starting with
version 4. His work history includes time at Oracle
Education and Oracle Consulting, plus he holds several
Oracle Masters certifications. Mr. Scalzo also has an
extensive academic background - including a BS, MS and
PhD in Computer Science, an MBA and several insurance
industry designations.
Mr. Scalzo is an accomplished speaker and has
presented at numerous Oracle conferences and user groups
- inclduding OOW, ODTUG, IOUGA, OAUG, RMOUG, et al. His
key areas of DBA interest are Data Modeling, Database
Benchmarking, Database Tuning & Optimization, "Star
Schema" Data Warehouses and Linux. Mr. Scalzo has
written articles for Oracle’s Technology Network (OTN),
Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell
PowerEdge Magazine, The Linux Journal,
www.linux.com, and
www.orafaq.com.
He also has written four books: "Oracle DBA Guide to
Data Warehousing and Star Schemas", "TOAD Handbook",
"TOAD Pocket Reference" (2nd Edition), "Database
Benchmarking: Practical methods for Oracle 10g & SQL
Server 2005", "Oracle on VMware: from Laptops to
Production" [2008], and "Oracle Utilities: The
Definitive Reference" [2008]. Mr. Scalzo can be reached
via email at
bert.scalzo@quest.com or
bert.scalzo@yahoo.com. |
Table of Contents:
Preface 12
Prologue 14
Enter Oracle vmware 15
A brief history of Oracle virtualization 16
The second age of mainframe computing 17
Chapter 1: Introduction
What is Virtualization? 20
Virtualization’s Popularity 22
Virtualization’s Benefits 23
Virtualization Support 25
Why VMware 26
Future Trends 27
Oracle’s Own VM 27
Conclusion 29
Chapter 2: Architecture
Reasonable Choices 30
Performance Ramifications 32
Ever Increasing Abstraction 34
Virtualized Oracle Architecture 38
Additional Complexities 42
Conclusion 43
Chapter 3: Host Setup
Host Impacts 44
Hardware Considerations 45
BIOS Basics 50
Host OS Selection 51
Host OS Install 55
Incremental Host Tuning 58
Optimize by Subsystem 59
Optimizing Linux 60
Optimizing Windows 63
Quick Reference 68
Conclusion 70
Chapter 4: Guest Setup
Virtual Impacts 71
Virtual Ramifications 73
VM Creation 73
VM Customization 79
Incremental Guest Tuning 84
Optimize by Subsystem 85
Quick Reference 94
Conclusion 95
Chapter 5: Oracle 11g Setup
Overview 96
Preparation 97
Host Setup 98
VMware Host Settings 105
Client Operating System 111
Oracle 11g Software Install 123
Create the Demo Database 124
DB Auto-Start 131
Conclusion 132
|
Chapter 6: Pseudo RAC Setup
Overview 133
Preparation 135
VMware Host Settings 137
Virtual Machine Setup 138
Client Operating System 140
Oracle 10G Software Install 148
Create the RAC Database 153
RAC Auto-Start 162
Conclusion 163
Chapter 7: True RAC Setup
Overview 164
RAC and VM Compatibility 165
Preparation 169
VMware Host Settings 172
Virtual Machine Setup 174
Remaining Steps Same 175
Other Things that Matter 175
Conclusion 178
Chapter 8: Performance Comparisons
Overview 179
The Benchmarking Process 180
Benchmarking Quick Bites 181
Benchmarking Best Practices 189
Selecting Among Benchmarks 197
Relative Results 199
Conclusion 200
Chapter 9: Additional Tuning Thoughts
Overview 202
Two Basic Approaches 203
Why Two Approaches 205
Yet a Third Dimension 207
Virtualization Wrinkles 211
Interesting Possibilities 214
Conclusion 218
Chapter 10: Oracle Virtual Appliances
Overview 219
Software Delivery 220
Content Delivery 223
Repository Platforms 224
Application Development 225
Education & Learning 226
Book’s Virtual Machine 226
Conclusion 229
|
|
|
|
|
Index Topics:
|
A
Advanced BIOS Features
Advanced Chipset Features
anacron
APIC mode
apmd
atd
auditing_trail
Automated Storage Management
B
BIOS
bonding
bridged network
bridging
C
chkconfig
Citrix
crond
cups
cups-config
cursor_sharing
cursor_space_for_time
D
Database Configuration Assistant
db_file_multiblock_read_count
disable last access update
Disable Last Access Update
disk hot-spots
Dynamic Host Configuration Protocol
E
Enterprise Manager Diagnostics Pack
F
file system cache
filesystemio_options
Full Virtualization
H
haldaemon
Hard Partitions
HDD S.M.A.R.T
heartbeat
highly shared hosts
host bus adapters
Host Virtual Adapters
host-only network
huge pages
Huge Pages
Hugepagesize
Hyper-Threading
hypervisor
|
I
i3 for Oracle
IDE
Incremental Tuning
installing a new kernel
iSCSI
isdn
J
job_queue_processes
K
kudzu
L
last access time
libaio
linux_rac
linux_rac-vip
Logical Volume Manager
Logical Volume Managers
lvm2-monitor
M
max_dump_file_size
mdmonitor
memlock
Method-R
Microsoft Virtual PC
minimal host operating system
mkfs.ocfs
monolithic kernel
Native Command Queuing
Native Virtualization
netfs
Network Address Translation
nfslock
NIC Teaming
O
openibd
optimization directives
Oracle Advanced Security
Oracle Application Express
Oracle Data Mining RDBMS Files
Oracle Database Configuration Assistant
Oracle Enterprise Manager
Oracle Managed Files
Oracle OLAP
Oracle Programmer
Oracle Real Application Testing
Oracle Spatial
Oracle Universal Installer
Oracle VM
|
P
paravirtualization
para-virtualization
Paravirtualization
Para-Virtualization
pcmcia
Phoenix-Award BIOS
platform virtualization
R
rawdevices
Real Application Cluster
Remote Shell
Resolved Acceleration Control
resource virtualization
runInstaller
runtime library
S
SCSI
Secure Shell
sendmail
Serial Attached SCSI
skew
SLA levels
Smart DBA for Oracle
smartd
Spotlight for Oracle
SQL Developer
SQL Net
Standard Database Components
Storage Area Networks
stripe and mirror everything
System BIOS
T
TAF Policy
Tagged Command Queuing
tnsnames
Transactions per Second
Transparent Application Failover
V
Video BIOS
Video RAM
Virtual Iron
virtual switches
VM configuration parameters
VMark
VMware ESX
X
Xen
XML Development Kit
xml_db_events
|
Reviews:
|
|
Errata: |
|
