Expert Oracle RAC 12c

Front Cover

Expert Oracle RAC 12c is a hands-on book helping you understand and implement Oracle Real Application Clusters (RAC), and to reduce the total-cost-of-ownership (TCO) of a RAC database. As a seasoned professional, you are probably aware of the importance of understanding the technical details behind the RAC stack. This book provides deep understanding of RAC concepts and implementation details that you can apply toward your day-to-day operational practices. You’ll be guided in troubleshooting and avoiding trouble in your installation. Successful RAC operation hinges upon a fast-performing network interconnect, and this book dedicates a chapter solely to that very important and easily overlooked topic.

All four authors are experienced RAC engineers with a wealth of hard-won experience encountering and surmounting the challenges of running a RAC environment that delivers on its promise. In Expert Oracle RAC 12c they provide you a framework in which to avoid repeating their hard-won lessons. Their goal is for you to manage your own RAC environment with ease and expertise.

Provides a deep conceptual understanding of RAC Provides best practices to implement RAC properly and match application workload Enables readers to troubleshoot RAC with ease

What you’ll learn Know when to apply RAC, and when not to Design applications to take advantage of RAC Troubleshoot and solve clusterware problems Manage database backup and recovery in RAC Stay on top of locking issues and deadlock detection Harness the performance from parallel processing in RAC Support your RAC environment with a healthy network interconnect Who this book is for

Expert Oracle RAC 12c is for experienced Oracle Database Administrators (DBAs) who are ready to take the next step in their career by expanding their skill set to include building and managing Oracle Real Application Clusters (RAC). DBAs and architects who are in the process of implementing RAC can immensely benefit from this book. It’s an excellent choice for DBAs to learn RAC conceptually, understand best practices, and become experts in troubleshooting RAC problems.

Table of ContentsOverview of Oracle RAC Clusterware Management and Troubleshooting RAC Operational Practices RAC New Features Storage and ASM Practices Application Design Issues Managing and Optimizing a Complex RAC Environment Backup and Recovery in RAC Network Practices in RAC RAC Database Optimization Locks and Deadlocks Parallel Query in RAC Clusterware and Database Upgrades Oracle RAC One Node

 

Contents

Chapter 1 Overview of Oracle RAC
1
Chapter 2 Clusterware Stack Management and Troubleshooting
29
Chapter 3 RAC Operational Practices
69
Chapter 4 New Features in RAC 12c
97
Chapter 5 Storage and ASM Practices
123
Chapter 6 Application Design Issues
165
Chapter 7 Managing and Optimizing a Complex RAC Environment
181
Chapter 8 Backup and Recovery in RAC
217
Chapter 11 Locks and Deadlocks
321
Chapter 12 Parallel Query in RAC
353
Chapter 13 Clusterware and Database Upgrades
381
Chapter 14 RAC One Node
411
Index
431
Contents
v
About the Authors
xvii
About the Technical Reviewers
xix

Chapter 9 Network Practices
243
Chapter 10 RAC Database Optimization
285
Acknowledgments
xx
Copyright

Other editions - View all

Common terms and phrases

About the author (2013)

Riyaj Shamsudeen is an industry-recognized RAC expert and performance tuning specialist with 19+ years of experience in implementing, using, and tuning RAC and Oracle products. He is an Oracle ACE Director and proud member of the OakTable network. Riyaj has co-authored many books about Oracle Database. He is an active blogger (at http://orainternals.wordpress.com ) and frequent international speaker in major conferences such as UKOUG, HOTSOS, Open World, and RMOUG. Syed Jaffar Hussain has over 20 years I.T. experience that includes more than 12 years of production Oracle database administration. Oracle has honored him with the prestigious Oracle ACE Director role, and named him DBA of the Year for 2011, both for his excellent knowledge and contributions to the Oracle community. He is an Oracle Certified Master (OCM) for Oracle Database 10g--a status granted only after passing extenstive challenges in a hands-on environment. He is also an Oracle Database 10g RAC Certified Expert. Syed Jaffar is coauthor of Oracle 11g R1/R2 Real Application Clusters Essentials, and he blogs regularly at: http://jaffardba.blogspot.com Kai Yu is a Senior Principal Engineer and technologist in Dell s Oracle Solutions Engineering Lab specializing in Oracle RAC, Oracle Virtualization, and Cloud. With 18+ years of experience working on Oracle technology, he has implemented and managed many large, mission-critical Oracle RAC databases, including those in his tenure with an IT organization having more than two thousand RAC databases. Kai is a well-known author of technical articles and a frequent speaker at Oracle conferences such as OpenWorld, Collaborate, UKOUG, Finland OUG, Norway OUG, OTN Asia/Pacific tour, and Latin Americas tour. He has also keynoted at Oracle Architect Day.Kai has served IOUG s Oracle RAC SIG as president, and in two chair positions. He has served the IOUG Collaborate conference committee, as well as managing IOUG s RAC boot camp, HA boot camp, and Enterprise Manager 12c deep dive. He was awarded the Oracle ACE Director title in 2010, given the Oracle ACE Spotlight in 2011 by Oracle Technology Network (OTN), and named the 2011 OAUG Innovator of Year Award by the Oracle Applications User Group (OAUG). In 2012, Oracle Magazine awarded him the Oracle Excellence Award: Technologist of the Year: Cloud Architect. Kai has been active in sharing his Oracle knowledge on his Oracle blog at http://kyuoracleblog.wordpress.com/. Tariq Farooq is an Oracle Technologist/Architect/Problem-Solver and has been working with various Oracle Technologies for 20+ years in very complex environments at some of the world's largest organizations. He is the founding President of the IOUG Virtualization & Cloud Computing Special Interest Group. He is an active Community Leader/Organizer, Speaker, Author, Forum contributor, and Blogger. He is the founder of www.brainSurface.com, a Social Networking & IT Collaboration site for the various Oracle Communities with thousands of signed-up users. Tariq founded, organized and chaired various conferences including, amongst others, VirtaThon, the largest online-only conference for the various Oracle domains; the CloudaThon & RACaThon series of conferences; and the first ever Oracle-centric conference at the Massachusetts Institute of Technology (MIT) in 2011. He was the founder and Achor/Show-Host of the VirtaThon Internet Radio series program. He was also the Track Manager for the Virtualization and Cloud Computing Tracks for COLLABORATE 2012 & 2013. Tariq is an Oracle RAC Certified Expert, holds a total of 14 professional Oracle Certifications and, is the author of 100+ articles, whitepapers & other publications. Tariq has presented and spoken at almost every major Oracle Conference/Event all over the world, including Oracle OpenWorld, COLLABORATE, BrainSurface, VirtaThon, IOUG, OOUG, OUGLC, TCOUG, UKOUG, The OTNExpert+ Conference & others. Tariq has been awarded the Oracle ACE and ACE Director awards from 2010 - 2013.

Bibliographic information