Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Real Application Clusters Administration and Deployment Guide
- 1
Introduction to Oracle RAC
- 1.1 Overview of Oracle RAC
- 1.2 Overview of Installing Oracle RAC
- 1.3 Overview of Oracle Real Application Clusters One Node
- 1.4 Overview of Oracle Clusterware for Oracle RAC
- 1.5
Overview of Oracle RAC Architecture and Processing
- 1.5.1 Understanding Cluster-Aware Storage Solutions
- 1.5.2 Oracle RAC and Network Connectivity
- 1.5.3 Overview of Using Dynamic Database Services to Connect to Oracle Databases
- 1.5.4 Overview of Virtual IP Addresses
- 1.5.5 Restricted Service Registration in Oracle RAC
- 1.5.6 About Oracle RAC Software Components
- 1.5.7 About Oracle RAC Background Processes
- 1.6 Overview of Automatic Workload Management with Dynamic Database Services
- 1.7 Overview of Server Pools and Policy-Managed Databases
- 1.8 Overview of Oracle Database Quality of Service Management
- 1.9 Overview of Hang Manager
- 1.10 Overview of Oracle Multitenant with Oracle RAC
- 1.11 Overview of Database In-Memory and Oracle RAC
- 1.12 Overview of Managing Oracle RAC Environments
- 2
Administering Storage in Oracle RAC
- 2.1 Overview of Storage Management for Oracle RAC
- 2.2 Data File Access in Oracle RAC
- 2.3 NFS Server for Storage
- 2.4 Redo Log File Storage in Oracle RAC
- 2.5 Automatic Undo Management in Oracle RAC
- 2.6
Oracle Automatic Storage Management with Oracle RAC
- 2.6.1 Storage Management in Oracle RAC
- 2.6.2 Modifying Disk Group Configurations for Oracle ASM
- 2.6.3 Oracle ASM Disk Group Management
- 2.6.4 Configuring Preferred Mirror Read Disks in Extended Distance Clusters
- 2.6.5 Converting Nonclustered Oracle ASM to Clustered Oracle ASM
- 2.6.6 Administering Oracle ASM Instances with SRVCTL in Oracle RAC
- 3
Administering Database Instances and Cluster Databases
- 3.1 Overview of Oracle RAC Database Administration
- 3.2 Starting and Stopping Instances and Oracle RAC Databases
- 3.3 Starting and Stopping PDBs in Oracle RAC
- 3.4 Verifying That Instances are Running
- 3.5 Terminating Sessions On a Specific Cluster Instance
- 3.6 Overview of Initialization Parameter Files in Oracle RAC
- 3.7 Initialization Parameter Use in Oracle RAC
- 3.8 Converting an Administrator-Managed Database to a Policy-Managed Database
- 3.9 Managing Memory Pressure for Database Servers
- 3.10 Quiescing Oracle RAC Databases
- 3.11 Administering Multiple Cluster Interconnects on Linux and UNIX Platforms
- 3.12 Customizing How Oracle Clusterware Manages Oracle RAC Databases
- 3.13 Advanced Oracle Enterprise Manager Administration
- 4 Administering Oracle RAC One Node
- 5
Workload Management with Dynamic Database Services
- 5.1 Connection Load Balancing
- 5.2 Load Balancing Advisory
- 5.3
Enabling Clients for Oracle RAC
- 5.3.1 Overview of Oracle Integrated Clients and FAN
- 5.3.2 Enabling JDBC-Thin Clients for Fast Connection Failover
- 5.3.3 Enabling JDBC Clients for Run-time Connection Load Balancing
- 5.3.4 Configuring JDBC-Thin Clients for Application Continuity for Java
- 5.3.5 Configuring JDBC-Thin Clients for Transaction Guard
- 5.3.6 Enabling OCI Clients for Fast Connection Failover
- 5.3.7 Enabling OCI Clients for Run-time Connection Load Balancing
- 5.3.8 Configuring OCI Clients to use Transaction Guard
- 5.3.9 Enabling ODP.NET Clients to Receive FAN High Availability Events
- 5.3.10 Enabling ODP.NET Clients to Receive FAN Load Balancing Advisory Events
- 5.3.11 Configuring ODP.NET Clients to use Transaction Guard
- 5.4 Distributed Transaction Processing in Oracle RAC
- 5.5 Automatic Workload Repository
- 5.6 Measuring Performance by Service Using the Automatic Workload Repository
- 5.7 Automatic Workload Repository Service Thresholds and Alerts
- 5.8 Using Oracle Services
- 5.9
Service Deployment Options
- 5.9.1 Service Usage in an Oracle RAC Database
- 5.9.2
Service Characteristics
- 5.9.2.1 Service Name
- 5.9.2.2 Service Edition
- 5.9.2.3 Service Management Policy
- 5.9.2.4 Database Role for a Service
- 5.9.2.5 Instance Preference
- 5.9.2.6 Server Pool Assignment
- 5.9.2.7 Load Balancing Advisory Goal for Run-time Connection Load Balancing
- 5.9.2.8 Connection Load Balancing Goal
- 5.9.2.9 Distributed Transaction Processing
- 5.9.3 Default Service Connections
- 5.9.4 Restricted Service Registration
- 5.10
Administering Services
- 5.10.1 Overview of Service Administration
- 5.10.2 Administering Services with Oracle Enterprise Manager
- 5.10.3
Administering Services with SRVCTL
- 5.10.3.1 Creating Services with SRVCTL
- 5.10.3.2 Creating Services for Application Continuity and Transaction Guard
- 5.10.3.3 Starting and Stopping Services with SRVCTL
- 5.10.3.4 Enabling and Disabling Services with SRVCTL
- 5.10.3.5 Relocating Services with SRVCTL
- 5.10.3.6 Obtaining the Status of Services with SRVCTL
- 5.10.3.7 Obtaining the Configuration of Services with SRVCTL
- 5.11 Global Services
- 5.12 Service-Oriented Buffer Cache Access
- 5.13 Connecting to a Service: An Example
- 6
Ensuring Application Continuity
- 6.1 Fast Application Notification
- 6.2 About Application Continuity
- 6.3
Application Continuity Operation and Usage
- 6.3.1 How Application Continuity Works for Applications
- 6.3.2
Actions for Using Application Continuity
- 6.3.2.1 When Application Continuity is Transparent
- 6.3.2.2 Configuring Oracle Application Continuity
- 6.3.2.3 Configuring Oracle Database for Application Continuity
- 6.3.2.4 Establishing the Initial State Before Application Continuity Replays
- 6.3.2.5 Delaying the Reconnection in Application Continuity
- 6.3.2.6 Using Application Continuity with SQL*Plus
- 6.3.2.7 Using Application Continuity for Planned Maintenance
- 6.3.2.8 Running Without Application Continuity
- 6.3.2.9
Disabling Replay in Application Continuity
- 6.3.2.9.1 Application Calls Autonomous Transactions, External PL/SQL, or Java Actions that Should Not Be Repeated
- 6.3.2.9.2 Application Synchronizes Independent Sessions
- 6.3.2.9.3 Application Uses Time at the Middle Tier in the Execution Logic
- 6.3.2.9.4 Application Assumes that ROWIds Do Not Change
- 6.3.2.9.5 Application Assumes that Location Values Do Not Change
- 6.3.2.10 Terminating or Disconnecting a Session Without Replay
- 6.3.3 Mutable Functions and Application Continuity
- 6.3.4 Administering Mutable Values
- 6.3.5 Session State Consistency
- 6.4 Potential Side Effects of Application Continuity
- 6.5 Restrictions and Other Considerations for Application Continuity
- 6.6 Transaction Guard for Improving Client Failover
- 6.7 Failing Over OCI Clients with TAF
- 7
Configuring Recovery Manager and Archiving
- 7.1 Overview of Configuring RMAN for Oracle RAC
- 7.2 Archiving Mode in Oracle RAC
- 7.3 Configuring the RMAN Snapshot Control File Location
- 7.4 Configuring RMAN to Automatically Backup the Control File and SPFILE
- 7.5 Crosschecking on Multiple Oracle RAC Nodes
- 7.6 Configuring Channels for RMAN in Oracle RAC
- 7.7 Managing Archived Redo Logs Using RMAN in Oracle RAC
- 7.8 Archived Redo Log File Conventions in Oracle RAC
- 7.9
RMAN Archiving Configuration Scenarios
- 7.9.1 Oracle Automatic Storage Management and Cluster File System Archiving Scheme
- 7.9.2
Noncluster File System Local Archiving Scheme
- 7.9.2.1 Considerations for Using Noncluster File System Local Archiving
- 7.9.2.2 Initialization Parameter Settings for Noncluster File System Local Archiving
- 7.9.2.3 Location of Archived Logs for Noncluster File System Local Archiving
- 7.9.2.4 File System Configuration for Noncluster File System Local Archiving
- 7.10 Monitoring the Archiver Processes
- 8
Managing Backup and Recovery
- 8.1 RMAN Backup Scenario for Noncluster File System Backups
- 8.2 RMAN Restore Scenarios for Oracle RAC
- 8.3 Instance Recovery in Oracle RAC
- 8.4 Media Recovery in Oracle RAC
- 8.5 Parallel Recovery in Oracle RAC
- 8.6 Using a Fast Recovery Area in Oracle RAC
- 9 Cloning Oracle RAC to Nodes in a New Cluster
- 10 Using Cloning to Extend Oracle RAC to Nodes in the Same Cluster
- 11 Adding and Deleting Oracle RAC from Nodes on Linux and UNIX Systems
- 12 Adding and Deleting Oracle RAC from Nodes on Windows Systems
- 13
Design and Deployment Techniques
- 13.1 Deploying Oracle RAC for High Availability
- 13.2 General Design Considerations for Oracle RAC
- 13.3
General Database Deployment Topics for Oracle RAC
- 13.3.1 Tablespace Use in Oracle RAC
- 13.3.2 Object Creation and Performance in Oracle RAC
- 13.3.3 Node Addition and Deletion and the SYSAUX Tablespace in Oracle RAC
- 13.3.4 Distributed Transactions and Oracle RAC
- 13.3.5 Deploying OLTP Applications in Oracle RAC
- 13.3.6 Flexible Implementation with Cache Fusion
- 13.3.7 Deploying Data Warehouse Applications with Oracle RAC
- 13.3.8 Data Security Considerations in Oracle RAC
- 14
Monitoring Performance
- 14.1 Overview of Monitoring and Tuning Oracle RAC Databases
- 14.2 Verifying the Interconnect Settings for Oracle RAC
- 14.3 Influencing Interconnect Processing
- 14.4 Performance Views in Oracle RAC
- 14.5 Creating Oracle RAC Data Dictionary Views with CATCLUST.SQL
- 14.6 Oracle RAC Performance Statistics
- 14.7 Automatic Workload Repository in Oracle RAC Environments
- 14.8 Active Session History Reports for Oracle RAC
- 14.9 Monitoring Oracle RAC Statistics and Wait Events
- 15
Converting Single-Instance Oracle Databases to Oracle RAC and Oracle RAC One Node
- 15.1 Administrative Issues for Converting Databases to Oracle RAC
- 15.2 Converting to Oracle RAC and Oracle RAC One Node Using DBCA
- 15.3 Preparing to Convert with rconfig and Oracle Enterprise Manager
- 15.4 Converting Databases to Oracle RAC Using rconfig
- 15.5 Example of rconfig XML Input Files for ConvertToRAC
- 15.6 Postconversion Steps
- A
Server Control Utility Reference
- A.1 SRVCTL Usage Information
- A.2 Specifying Command Parameters as Keywords Instead of Single Letters
- A.3 Character Set and Case Sensitivity of SRVCTL Object Values
- A.4 Summary of Tasks for Which SRVCTL Is Used
- A.5 Using SRVCTL Help
- A.6 SRVCTL Privileges and Security
- A.7 Additional SRVCTL Topics
- A.8 Deprecated SRVCTL Subprograms or Commands
- A.9
SRVCTL Command Reference
- A.9.1 srvctl add database
- A.9.2 srvctl config database
- A.9.3 srvctl convert database
- A.9.4 srvctl disable database
- A.9.5 srvctl downgrade database
- A.9.6 srvctl enable database
- A.9.7 srvctl getenv database
- A.9.8 srvctl modify database
- A.9.9 srvctl predict database
- A.9.10 srvctl relocate database
- A.9.11 srvctl remove database
- A.9.12 srvctl setenv database
- A.9.13 srvctl start database
- A.9.14 srvctl status database
- A.9.15 srvctl stop database
- A.9.16 srvctl unsetenv database
- A.9.17 srvctl update database
- A.9.18 srvctl upgrade database
- A.9.19 srvctl disable diskgroup
- A.9.20 srvctl enable diskgroup
- A.9.21 srvctl predict diskgroup
- A.9.22 srvctl remove diskgroup
- A.9.23 srvctl start diskgroup
- A.9.24 srvctl status diskgroup
- A.9.25 srvctl stop diskgroup
- A.9.26 srvctl start home
- A.9.27 srvctl status home
- A.9.28 srvctl stop home
- A.9.29 srvctl add instance
- A.9.30 srvctl disable instance
- A.9.31 srvctl enable instance
- A.9.32 srvctl modify instance
- A.9.33 srvctl remove instance
- A.9.34 srvctl start instance
- A.9.35 srvctl status instance
- A.9.36 srvctl stop instance
- A.9.37 srvctl update instance
- A.9.38 srvctl add listener
- A.9.39 srvctl config listener
- A.9.40 srvctl disable listener
- A.9.41 srvctl enable listener
- A.9.42 srvctl getenv listener
- A.9.43 srvctl modify listener
- A.9.44 srvctl predict listener
- A.9.45 srvctl remove listener
- A.9.46 srvctl setenv listener
- A.9.47 srvctl start listener
- A.9.48 srvctl status listener
- A.9.49 srvctl stop listener
- A.9.50 srvctl unsetenv listener
- A.9.51 srvctl update listener
- A.9.52 srvctl add network
- A.9.53 srvctl config network
- A.9.54 srvctl modify network
- A.9.55 srvctl predict network
- A.9.56 srvctl remove network
- A.9.57 srvctl add nodeapps
- A.9.58 srvctl config nodeapps
- A.9.59 srvctl disable nodeapps
- A.9.60 srvctl enable nodeapps
- A.9.61 srvctl getenv nodeapps
- A.9.62 srvctl modify nodeapps
- A.9.63 srvctl remove nodeapps
- A.9.64 srvctl setenv nodeapps
- A.9.65 srvctl start nodeapps
- A.9.66 srvctl status nodeapps
- A.9.67 srvctl stop nodeapps
- A.9.68 srvctl unsetenv nodeapps
- A.9.69 srvctl add ons
- A.9.70 srvctl config ons
- A.9.71 srvctl disable ons
- A.9.72 srvctl enable ons
- A.9.73 srvctl modify ons
- A.9.74 srvctl remove ons
- A.9.75 srvctl start ons
- A.9.76 srvctl status ons
- A.9.77 srvctl stop ons
- A.9.78 srvctl add scan
- A.9.79 srvctl config scan
- A.9.80 srvctl disable scan
- A.9.81 srvctl enable scan
- A.9.82 srvctl modify scan
- A.9.83 srvctl predict scan
- A.9.84 srvctl relocate scan
- A.9.85 srvctl remove scan
- A.9.86 srvctl start scan
- A.9.87 srvctl status scan
- A.9.88 srvctl stop scan
- A.9.89 srvctl add scan_listener
- A.9.90 srvctl config scan_listener
- A.9.91 srvctl disable scan_listener
- A.9.92 srvctl enable scan_listener
- A.9.93 srvctl modify scan_listener
- A.9.94 srvctl predict scan_listener
- A.9.95 srvctl relocate scan_listener
- A.9.96 srvctl remove scan_listener
- A.9.97 srvctl start scan_listener
- A.9.98 srvctl status scan_listener
- A.9.99 srvctl stop scan_listener
- A.9.100 srvctl update scan_listener
- A.9.101 srvctl relocate server
- A.9.102 srvctl status server
- A.9.103 srvctl add service
- A.9.104 srvctl config service
- A.9.105 srvctl disable service
- A.9.106 srvctl enable service
- A.9.107 srvctl modify service
- A.9.108 srvctl predict service
- A.9.109 srvctl relocate service
- A.9.110 srvctl remove service
- A.9.111 srvctl start service
- A.9.112 srvctl status service
- A.9.113 srvctl stop service
- A.9.114 srvctl add srvpool
- A.9.115 srvctl config srvpool
- A.9.116 srvctl modify srvpool
- A.9.117 srvctl remove srvpool
- A.9.118 srvctl status srvpool
- A.9.119 srvctl add vip
- A.9.120 srvctl config vip
- A.9.121 srvctl disable vip
- A.9.122 srvctl enable vip
- A.9.123 srvctl getenv vip
- A.9.124 srvctl modify vip
- A.9.125 srvctl predict vip
- A.9.126 srvctl relocate vip
- A.9.127 srvctl remove vip
- A.9.128 srvctl setenv vip
- A.9.129 srvctl start vip
- A.9.130 srvctl status vip
- A.9.131 srvctl stop vip
- A.9.132 srvctl unsetenv vip
- A.9.133 srvctl config volume
- A.9.134 srvctl disable volume
- A.9.135 srvctl enable volume
- A.9.136 srvctl remove volume
- A.9.137 srvctl start volume
- A.9.138 srvctl status volume
- A.9.139 srvctl stop volume
- B
Troubleshooting Oracle RAC
- B.1 Where to Find Files for Analyzing Errors
- B.2 Managing Diagnostic Data in Oracle RAC
- B.3 Using Instance-Specific Alert Files in Oracle RAC
- B.4 Enabling Tracing for Java-Based Tools and Utilities in Oracle RAC
- B.5 Resolving Pending Shutdown Issues
- B.6 How to Determine If Oracle RAC Instances Are Using the Private Network
- B.7 Database Fails to Start after Private NIC Failure
- Glossary
- Index