Book description
This comprehensive guide has been fully updated to cover the latest features and tools of Oracle Real Application Clusters 12c
Through clear instruction and detailed examples, Oracle Database 12c Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting teaches how to build, configure, and maintain a dynamic enterprise computing infrastructure. This thoroughly revised edition covers best uses for the latest tools and features—all from the practical standpoint of a working DBA.
You will discover how to prepare hardware, configure the software, optimize data integrity, and integrate seamless failover protection. Brand-new flex and large cluster technologies are explained in full detail, and readers will get complete solutions for securing data and continuing business operations in the event of hardware failure.- Presents all the new information needed to effectively use Oracle Real Application Clusters 12c -considered the most radical overhaul ever
- Offers detailed coverage of troubleshooting, performance tuning, and application development
Table of contents
- Cover
- Title Page
- Copyright Page
- Dedication
- Contents
- Contents
- Acknowledgments
- Introduction
-
PART I High Availability Architecture and Clusters
- 1 Introduction to High Availability and Scalability
- 2 Oracle Database Clustering Basics and Its Evolution
- 3 Oracle RAC Architecture
-
PART II Installation, Configuration, and Storage
-
4 Oracle Grid Infrastructure Installation
- An Overview of the Grid Infrastructure Installation Process
-
Preinstallation Tasks
- Understanding the Installer, CVU, and ORAchk
- Configuring the Operating System
- Configuring the Network
- Configuring NTP
- Setting Up the Groups and Users
- Creating the Required Linux Directories
- Configuring Shared Storage
- Secure Shell and User Limits Configuration
- Setting User Limits
- Configuring the Kernel Parameters
- Running the Cluster Verification Utility
- Installing Oracle Grid Infrastructure with OUI
-
Installing Oracle Grid Infrastructure
- Choosing the Installation Options and Naming Your Cluster
- Specifying the Cluster Nodes and Verifying SSH Connectivity
- Specifying the Network Interfaces
- Selecting the Storage Options
- Specifying Management Options and Privileged OS System Groups
- Performing the Prerequisite Checks
- Running the root Scripts
- The Product Installation
- Verifying the Oracle Grid Infrastructure Installation
- Summary
- 5 Installing Oracle RAC and Creating an Oracle RAC Database
- 6 Automatic Storage Management
-
4 Oracle Grid Infrastructure Installation
-
PART III Oracle RAC Administration and Management
-
7 Oracle RAC Basic Administration
- Oracle RAC Initialization Parameters
- Starting and Stopping Instances
-
Common SRVCTL Management Commands
- Database-Related SRVCTL Commands
- Instance-Related SRVCTL Commands
- Listener-Related SRVCTL Commands
- Setting, Unsetting, and Displaying the Environment Variables
- Changing the Configuration of Databases and Instances
- Relocating Services
- Removing the Configuration Information for Specific Targets
- Predicting the Impact of Failures
- Managing Pluggable Databases in a RAC Environment
- Administering Undo in an Oracle RAC Database
- Administering a Temporary Tablespace
- Administering Online Redo Logs
- Enabling the Flashback Area
- Managing Database Configuration with SRVCTL
- Killing Sessions on Specific Instances of a Cluster
- Managing Database Objects
- Administering Server Pools
- Summary
-
8 Managing Oracle Clusterware
- Configuring and Administering Oracle Clusterware
- Role-Separated Management
- Weight-Based Server Node Eviction
- Administering SCAN
- Using the CLUVFY Utility for Managing Oracle RAC
- Clusterware Startup
- Using CRSCTL to Manage the Clusterware
- Using Other Utilities to Manage Oracle Clusterware
- Administering the OCR
- Administering the Oracle Local Registry
- Administering the Voting Disks
- Summary
- 9 Oracle RAC Backup and Recovery
-
10 Oracle RAC Performance Management
- Oracle RAC Design Considerations
- Partitioning the Workload
- Scalability and Performance
- Choosing the Block Size for an Oracle RAC Database
- Introduction to the V$ and GV$ Views
- Oracle RAC Wait Events
- Global Cache Statistics
- Global Cache Service Times
- Enqueue Tuning in Oracle RAC
- Oracle AWR Report
- Tuning the Cluster Interconnect
- Summary
-
7 Oracle RAC Basic Administration
-
PART IV Advanced Oracle RAC Concepts
- 11 Global Resource Directory
- 12 A Closer Look at Cache Fusion
- 13 Workload Management, Connection Management, and Application Continuity
-
14 Oracle RAC Troubleshooting
- Installation Log Files
- Log Directory Structure in the Oracle RDBMS
- Log Directory Structure in Oracle Grid Infrastructure
- Troubleshooting a Failed Oracle Grid Infrastructure Installation
- Inside the Database Alert Log
- RAC ON and OFF
- Database Performance Issues
- Debugging Node Eviction Issues
- Advanced Debugging for Oracle Clusterware Modules
- Debugging Various Utilities in Oracle RAC
- Using ORAchk to Troubleshoot RAC
- Summary
-
PART V Deploying Oracle RAC
- 15 Extending Oracle RAC for Maximum Availability
- 16 Developing Applications for Oracle RAC
- PART VI Appendixes
- Index
Product information
- Title: Oracle Database 12c Release 2 Oracle Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting
- Author(s):
- Release date: February 2018
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071830478
You might also like
book
Oracle Database 12c DBA Handbook
The definitive reference for every Oracle DBA—completely updated for Oracle Database 12 c Oracle Database 12c …
book
Oracle Database 12c Security
Best Practices for Comprehensive Oracle Database Security Written by renowned experts from Oracle's National Security Group, …
book
Oracle Database Administration: The Essential Refe
Visit the catalog page for Oracle Database Administration: The Essential RefeVisit the errata page for Oracle …
book
Oracle Database 12c Oracle RMAN Backup & Recovery
This authoritative Oracle Press resource on RMAN has been thoroughly revised to cover every new feature, …