Book description
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.
Table of contents
- Cover
- Title
- Copyright
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewers
- Acknowledgments
- Chapter 1: Overview of Oracle RAC
-
Chapter 2: Clusterware Stack Management and Troubleshooting
- Clusterware 12cR1 and Its Components
-
Clusterware Management
- Clusterware Management Tools and Utilities
- Start Up and Stop Clusterware
- Managing Oracle Clusterware
- Managing OCR and the Voting Disk
- Managing CRS Resources
- Adding and Removing Cluster Nodes
- Troubleshooting common Clusterware Stack Start-Up Failures
- Diagnose, Debug, Trace Clusterware and RAC Issues
- Debugging Clusterware Components and Resources
- Grid Infrastructure Component Directory Structure
- Oracle Clusterware Troubleshooting - Tools and Utilities
- CHM
- Summary
-
Chapter 3: RAC Operational Practices
- Workload Management
- Services
- SCAN and SCAN Listeners
- Failover in RAC
- Policy-Managed Databases
- Temporary Tablespaces
- Massive Data Changes
- Performance Metrics Collection
- Parameter File Management
- Password File Management
- Managing Databases and Instances
- Managing VIPs, Listeners
- Miscellaneous Topics
- Summary
-
Chapter 4: New Features in RAC 12c
- Oracle Flex Clusters
- Flex ASM Architecture
- What-If Command Evaluation
- PDBs on Oracle RAC
-
12cR1: Miscellaneous New Features for RAC
- Public Networks for RAC: IPv6 Support Added
- Global Data Services
- Online Resource Attribute Modification
- RAC 12cR1: Policy-Based Management and Administration
- ASM Disk Group: Shared ASM Password File
- Valid Node Checking: Restricting Service Registration
- 12cR1: Shared GNS
- RAC 12cR1: Restricting Service Registration
- Oracle ASM, ACFS, and ADVM: Improvements and New Features
- NFS High Availability
- 12cR1: CHM Enhancements
- Windows: Support for Oracle Home User
- OUI: Enhancements and Improvements
- 12cR1: Installations/Upgrades—Running Scripts Automatically
- 12cR1: Introducing Application Continuity
- Transaction Idempotence and Java Transaction Guard
- Deprecated and Desupported Features
- Summary
- Chapter 5: Storage and ASM Practices
-
Chapter 6: Application Design Issues
- Localized Inserts
- Excessive TRUNCATE or DROP Statements
- Sequence Cache
- Freelists and ASSM
- Excessive Commits
- Long Pending Transactions
- Localized Access
- Small Table Updates
- Index Design
- Inefficient Execution Plan
- Excessive Parallel Scans
- Full Table Scans
- Application Affinity
- Pipes
- Application Change Deployment
- Summary
-
Chapter 7: Managing and Optimizing a Complex RAC Environment
- Shared vs. Non-Shared Oracle Homes
- Server Pools
- Types of Server Pools
- Planning and Designing RAC Databases
- Small- vs. Large-Scale Cluster Setups
- Split-Brain Scenarios and How to Avoid Them
- Understanding, Debugging, and Preventing Node Evictions
- Extended Distance (Stretch) Clusters—Synopsis, Overview, and Best Practices
- Setup and Configuration—Learning the New Way of Things
- RAC Installation and Setup—Considerations and Tips for OS Families: Linux, Solaris, and Windows
- RAC Database Performance Tuning: A Quick n’ Easy Approach
- Summary
- Chapter 8: Backup and Recovery in RAC
-
Chapter 9: Network Practices
- Types of Network
- Network Layers
- Protocols
- VIPs
- Subnetting
- Cluster Interconnect
- Jumbo Frames
- Load Balancing and Failover
- Kernel Parameters
- Network Measurement Tools
- GC Lost Block Issue
- Configuring Network for Oracle RAC and Clusterware
- Network Configuration in Clusterware
- Network Failover
- Second Network
- Summary
- Chapter 10: RAC Database Optimization
- Chapter 11: Locks and Deadlocks
- Chapter 12: Parallel Query in RAC
- Chapter 13: Clusterware and Database Upgrades
- Chapter 14: RAC One Node
- Index
Product information
- Title: Expert Oracle RAC 12c
- Author(s):
- Release date: August 2013
- Publisher(s): Apress
- ISBN: 9781430250456
You might also like
video
The Oracle Database RAC Administration Course (12c and 19c)
Experience the power of Oracle database RAC administration with this comprehensive course tailored for proficient Oracle …
book
Expert Oracle Exadata
Throughout history, advances in technology have come in spurts. A single great idea can often spur …
book
Oracle Exadata Expert’s Handbook
The Practical, Authoritative, 360-Degree Technical Guide to Oracle Exadata: From Setup to Administration, Optimization, Tuning, and …
book
Cost-Based Oracle Fundamentals
The question, "Why isn't Oracle using my index?" must be one of the most popular (or …