Pro Oracle Database 11g RAC on Linux - Steve Shaw, Martin Bach.pdf

(19005 KB) Pobierz
Pro Oracle Database 11g RAC
on Linux
Steve Shaw
Martin Bach
Pro Oracle Database 11g RAC on Linux
Copyright © 2010 by Steve Shaw and Martin Bach
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means,
electronic or mechanical, including photocopying, recording, or by any information storage or retrieval
system, without the prior written permission of the copyright owner and the publisher.
ISBN-13 (pbk): 978-1-4302-2958-2
ISBN-13 (electronic): 978-1-4302-2959-9
Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1
Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol
with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only
in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of
the trademark.
The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are
not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject
to proprietary rights.
President and Publisher: Paul Manning
Lead Editor: Jonathan Gennick
Technical Reviewer: Bernhard Cock Buning and Sandesh Rao
Editorial Board: Clay Andres, Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell,
Jonathan Gennick, Jonathan Hassell, Michelle Lowman, Matthew Moodie, Duncan Parkes,
Jeffrey Pepper, Frank Pohlmann, Douglas Pundick, Ben Renow-Clarke, Dominic Shakeshaft,
Matt Wade, Tom Welsh
Coordinating Editor: Anita Castro
Copy Editor: Patrick Meader and Mary Ann Fugate
Compositor: Bytheway Publishing Services
Indexer: BIM Indexing & Proofreading Services
Artist: April Milne
Cover Designer: Anna Ishchenko
Distributed to the book trade worldwide by Springer Science+Business Media, LLC., 233 Spring Street,
6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail
orders-ny@springer-
sbm.com,
or visit
www.springeronline.com.
For information on translations, please e-mail
rights@apress.com,
or visit
www.apress.com.
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use.
eBook versions and licenses are also available for most titles. For more information, reference our
Special Bulk Sales–eBook Licensing web page at
www.apress.com/info/bulksales.
The information in this book is distributed on an “as is” basis, without warranty. Although every
precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have
any liability to any person or entity with respect to any loss or damage caused or alleged to be caused
directly or indirectly by the information contained in this work.
CONTENTS AT A GLANCE
Contents at a Glance
About the Author.................................................................................................. xxi
About the Technical Reviewer ............................................................................ xxii
Acknowledgments ............................................................................................. xxiii
Chapter 1: Introduction...........................................................................................1
Chapter 2: RAC Concepts ......................................................................................27
Chapter 3: RAC Architecture .................................................................................63
Chapter 4: Hardware.............................................................................................97
Chapter 5: Virtualization.....................................................................................165
Chapter 6: Linux Installation and Configuration .................................................231
Chapter 7: Grid Infrastructure Installation .........................................................323
Chapter 8: Clusterware .......................................................................................379
Chapter 9: Automatic Storage Management.......................................................455
Chapter 10: RDBMS Installation and Configuration ............................................505
Chapter 11: Workload Management ...................................................................559
Chapter 12: Oracle Performance Monitoring ......................................................607
Chapter 13: Linux Performance Monitoring........................................................653
Chapter 14: Parallel Execution ...........................................................................687
Chapter 15: Upgrading to Oracle 11g Release 2 .................................................717
Index ...................................................................................................................771
iii
CONTENTS
Contents
About the Authors................................................................................................ xxi
About the Technical Reviewers .......................................................................... xxii
Acknowledgments ............................................................................................. xxiii
Chapter 1: Introduction...........................................................................................1
Introducing Oracle Real Application Clusters ....................................................................1
Examining the RAC Architecture........................................................................................3
Deploying RAC ...................................................................................................................4
Maintaining High Availability .................................................................................................................... 5
Defining Scalability................................................................................................................................... 6
Scaling Vertically vs. Horizontally............................................................................................................. 7
Increasing Manageability ......................................................................................................................... 8
Assessing the Cost of Ownership ........................................................................................................... 10
Clustering with Oracle on Linux.......................................................................................13
Running Linux on Oracle..................................................................................................16
Understanding the Role of Unix .............................................................................................................. 16
Liberating Software ................................................................................................................................ 17
Developing Linux .................................................................................................................................... 18
Expanding the Concept of Free with Open Source ................................................................................. 19
Combining Oracle, Open Source, and Linux ....................................................................20
Drilling Down on Unbreakable Linux ...................................................................................................... 21
Creating and Growing Red Hat Enterprise Linux .................................................................................... 22
Extending Red Hat with Oracle Enterprise Linux .................................................................................... 23
Drilling Down on SuSE Linux Enterprise Server ..................................................................................... 24
iv

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin