Oracle® Real Application Clusters

1 oracle real Application ClustersAdministration and Deployment Guide 11g Release 1 ( ) B28254-07 January 2009 oracle real Application Clusters Administration and Deployment Guide, 11g Release 1 ( ) B28254-07 Copyright 1999, 2009, oracle and/or its affiliates. All rights Authors: Mark Bauer, Richard StrohmContributing Authors: Troy Anthony, Lance Ashdown, Prasad Bagal, Anand Beldalker, Eric Belden, George Claborn, Carol Colrain, Jonathan Creighton, Rajesh Dasari, Steve Fogel, Richard Frank, GP Prabhaker Gongloor, Wei Hu, Yong Hu, Rajiv Jayaraman, Dominique Jeunot, Sameer Joshi, Roland Knapp, Raj Kumar, Ken Lee, Karen Li, Barb Lundhild, Venkat Maddali, Bill Manry, Gaurav Manglik, Komal Mangtani, John McHugh, Saar Maoz, Matthew Mckerley, Markus Michalewicz, Anil Nair, Philip Newlan, Michael Nowak, Peter Ogilvie, Muthu Olagappan, Bharat Paliwal, Hanlin Qian, Mark Ramacher, Kevin Reardon, Dipak Saggi, Sudheendra Sampath, Viv Schupmann, Daniel Semler, Ara Shakian, Cathy Shea, Khethavath P.

2 Singh, Bipul Sinha, Qun Song, Kesavan Srinivasan, Alok Srivastava, Janet Stern, Juan Tellez, Leo Tominna, Peter Wahl, Tak Wang, Douglas Williams, Mike Zampiceni, Michael ZollThis software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is information contained herein is subject to change without notice and is not warranted to be error-free.

3 If you find any errors, please report them to us in this software or related documentation is delivered to the Government or anyone licensing it on behalf of the Government, the following notice is GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR , Commercial Computer Software License (December 2007).

4 oracle USA, Inc., 500 oracle Parkway, Redwood City, CA software is developed for general use in a variety of information management applications . It is not developed or intended for use in any inherently dangerous applications , including applications which may create a risk of personal injury. If you use this software in dangerous applications , then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous is a registered trademark of oracle Corporation and/or its affiliates. Other names may be trademarks of their respective software and documentation may provide access to or information on content, products, and services from third parties.

5 oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or xiiiDocumentation Accessibility .. xiiiRelated Documents .. xivConventions .. xvWhat's New in oracle real Application Clusters Administration and Deployment?.. xviiOracle Database 11g Release 1 ( ) New Features in oracle real Application Clusters .. xvii1 Introduction to oracle real Application ClustersOverview of oracle real Application 1-1 Overview of oracle Clusterware for oracle real Application 1-3 Overview of oracle real Application Clusters Architecture and 1-4 Understanding cluster -Aware Storage 1-4 Overview of Connecting to oracle Database Using Services and VIP Addresses.

6 1-4 About oracle real Application Clusters Software Components .. 1-5 About oracle real Application Clusters Background Processes .. 1-6 Overview of Automatic Workload 1-7 Overview of Installing oracle real Application 1-8 Understanding Compatibility in oracle real Application Clusters 1-9 Overview of oracle real Application Clusters Installation and Database Creation .. 1-9 Overview of Extending oracle ASM and oracle real Application Clusters Software .. 1-10 Overview of Managing oracle real Application Clusters 1-11 About Designing and Deploying oracle real Application Clusters Environments .. 1-11 About Administrative Tools for oracle real Application Clusters 1-12 About Monitoring oracle real Application Clusters Environments .. 1-13 About Evaluating Performance in oracle real Application Clusters Environments.

7 1-142 Administering Storage Overview of Storage in oracle real Application 2-1 oracle Flexible 2-2 Datafile Access in oracle real Application 2-2 Redo Log File Storage in oracle real Application 2-2 Automatic Undo Management in oracle real Application 2-3ivAutomatic Storage Management in oracle real Application 2-3 ASM Storage Management in oracle real Application 2-4 Modifying Disk Group Configurations for ASM in oracle real Application 2-4 Standalone ASM Disk Group 2-5 Performing Automatic Storage Management Rolling 2-5 Configuring Preferred Mirror Read Disks in Extended Distance Clusters .. 2-5 Converting Single-Instance ASM to Clustered ASM .. 2-6 Extending ASM to Nodes Running Single-Instance or oracle RAC Databases .. 2-6 Administering ASM Instances and Disk Groups with oracle Enterprise Manager in oracle RAC.

8 2-9 Administering ASM Instances with SRVCTL in oracle real Application Clusters .. 2-93 Administering Database Instances and cluster Databases Tools for Administering oracle real Application 3-1 Administering oracle real Application Clusters with oracle Enterprise Manager .. 3-1 Administering oracle real Application Clusters with SQL* 3-2 Changing the SQL*Plus Prompt .. 3-3 How SQL*Plus Commands Affect Instances .. 3-3 Administering oracle real Application Clusters with SRVCTL .. 3-4 Starting and Stopping Instances and oracle real Application Clusters 3-4 Starting and Stopping with oracle Enterprise Manager .. 3-5 Starting Up and Shutting Down with SQL*Plus .. 3-5 Starting Up and Shutting Down with SRVCTL .. 3-6 Verifying That Instances are 3-7 Terminating Sessions On a Specific cluster 3-7 Overview of Initialization Parameter Files in oracle real Application 3-9 Setting SPFILE Parameter Values for oracle real Application Clusters .

9 3-10 Parameter File Search Order in oracle real Application Clusters .. 3-11 Backing Up the Server Parameter File .. 3-11 Initialization Parameter Use in real Application 3-11 Parameters That Must Have Identical Settings on All Instances .. 3-14 Parameters That Have Unique Settings on All 3-14 Parameters That Should Have Identical Settings on All 3-15 Quiescing oracle real Application Clusters 3-15 Administering Multiple cluster Interconnects on Linux and UNIX 3-16 Recommendations for Setting the CLUSTER_INTERCONNECTS 3-17 Usage Examples for the CLUSTER_INTERCONNECTS Parameter .. 3-18 Customizing How oracle Clusterware Manages oracle RAC 3-19 Advanced oracle Enterprise Manager 3-20 Using oracle Enterprise Manager Grid Control to Discover Nodes and 3-20 Administering Jobs and Alerts in oracle real Application Clusters .

10 3-21 Administering Jobs in oracle real Application 3-21 Administering Alerts in oracle real Application Clusters with oracle Enterprise 3-21 Performing Scheduled Maintenance Using Defined Blackouts in oracle Enterprise 3-22v4 Introduction to Automatic Workload ManagementOverview of Automatic Workload 4-1 Automatic Workload 4-3 Service Deployment 4-3 Using oracle Services .. 4-3 Default Service 4-5 Connection Load Balancing .. 4-5 Fast Application 4-7 Overview of Fast Application Notification .. 4-7 Application High Availability with Services and 4-8 Managing Unplanned Outages .. 4-8 Managing Planned Outages .. 4-9 Fast Application Notification High Availability Events .. 4-9 Using Fast Application Notification Callouts.