Oracle® Real Application Clusters
Installation Guide
11g Release 2 (11.2) for Microsoft Windows
E10818-03
March 2010
Oracle Real Application Clusters Installation Guide, 11g Release 2 (11.2) for Microsoft Windows
E10818-03
Copyright © 2007, 2010, Oracle and/or its affiliates. All rights reserved.
Primary Author: Janet Stern, Douglas Williams
Contributing Authors: Mark Bauer, Jonathan Creighton, Reema Khosla, Barb Lundhild, Venkat Maddali,
Markus Michalewicz, Philip Newlan
Contributors: Eric Belden, Karin Brandauer, Willard Cole, Bjørn Engsig, Mark Fuller, Alexander Keh, Roland
Knapp, To-Choi Lau, Satish Panchumarthy, Srinivas Poovala, Rajesh Prasad, Mohammed Quadri, Ravi
Ramikissoon, Kevin Reardon, Trivikrama Samudrala, David Schreiner, Jacueline Sideri, Janelle Simmons,
James Stenoish, Preethi Vallam, Nitin Vengurlekar, Xiaofang Wang, Martin Widjaja, Sergiusz Wolicki
This 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
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this software or related documentation is delivered to the U.S. Government or anyone licensing it on
behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data
delivered to U.S. 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 52.227-19, Commercial Computer Software
License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This 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 applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks
of their respective owners.
This software and documentation may provide access to or information on content, products, and services
from third parties. 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 services.
iii
Contents
Preface ................................................................................................................................................................. xi
Audience....................................................................................................................................................... xi
Documentation Accessibility..................................................................................................................... xi
Related Documents .................................................................................................................................... xii
Conventions ............................................................................................................................................... xiii
What's New in Oracle Real Application Clusters Installation?....................................... xv
New Features for Oracle Database 11g Release 2 (11.2) ...................................................................... xv
New Features for Oracle Database 11g Release 1 (11.1) ...................................................................... xix
1 Preinstallation Checklist
Before You Start: Planning your Installation...................................................................................... 1-1
Check My Oracle Support................................................................................................................. 1-2
Check Oracle Technical Network .................................................................................................... 1-2
Review Installation Steps for Oracle RAC...................................................................................... 1-2
Review How to Use Cluster Verification Utility ........................................................................... 1-3
Review and Back Up Existing Oracle Installations....................................................................... 1-4
Review Globalization Requirements............................................................................................... 1-5
Review Documentation..................................................................................................................... 1-5
Overview of Server Hardware, Network and Operating System ................................................... 1-6
Review Server Hardware and Software Requirements................................................................ 1-7
Overview of Server Environment Configuration.......................................................................... 1-8
Overview of Oracle Base................................................................................................................... 1-9
Overview of Configuring Internode Communication.................................................................. 1-9
Overview of Browser Requirements............................................................................................... 1-9
Overview of Platform-Specific Server Configuration................................................................ 1-10
Overview of Oracle RAC Storage ...................................................................................................... 1-10
General Storage Considerations for Oracle RAC ....................................................................... 1-11
Overview of Oracle Database and Recovery File Options........................................................ 1-12
Additional Information to Prepare for Installation........................................................................ 1-13
Oracle ASM is Installed with Oracle Grid Infrastructure ......................................................... 1-13
Shared Components of Oracle RAC Installations ...................................................................... 1-13
Simplified Upgrade of TIMESTAMP WITH TIME ZONE Data.............................................. 1-14
Oracle Database 11g Real Application Clusters Release Compatibility.................................. 1-14
Confirming Cluster Readiness for Oracle RAC Installation with CVU .................................... 1-15
iv
Installing Oracle RAC on Systems with Coexisting Databases .................................................. 1-16
Installing Oracle Database 11g on a System with Oracle Database 10g.................................. 1-16
Installing Oracle 11g Database on a System with Oracle9i Database Release 2..................... 1-17
2 Installing Oracle Database 11g with Oracle Real Application Clusters
Reviewing Oracle Application Express Requirements..................................................................... 2-2
Selecting an Installation Type ............................................................................................................... 2-2
Selecting an Installation Option ........................................................................................................... 2-2
Oracle Database Configuration Type Descriptions........................................................................... 2-3
General Purpose and Transaction Processing, and Data Warehouse Configuration Types... 2-3
Using the Advanced Database Configuration Type..................................................................... 2-3
Installing Oracle Database with Other Languages........................................................................ 2-4
Oracle Database Vault Option ............................................................................................................... 2-4
Oracle Configuration Manager Option................................................................................................ 2-4
Selecting a Database Name .................................................................................................................... 2-5
Selecting Database Passwords............................................................................................................... 2-5
Database Security Options ..................................................................................................................... 2-5
Actions of OUI and DBCA During Installation................................................................................. 2-6
Managing Database Services After Installation............................................................................. 2-6
Installing Older NLS Compatibility Definition Files .................................................................... 2-7
Installing Oracle Database Vault .......................................................................................................... 2-7
Using Oracle Universal Installer to Install Oracle RAC................................................................... 2-7
Update Environment Variables on Remote Nodes............................................................................ 2-9
3 Creating Oracle Real Application Clusters Databases with Database
Configuration Assistant
Using Database Configuration Assistant with Oracle RAC............................................................ 3-1
Benefits of Using Database Configuration Assistant ....................................................................... 3-2
Automatic Listener Migration from Earlier Releases........................................................................ 3-2
Verifying Requirements for DBCA ...................................................................................................... 3-3
Creating an Oracle RAC Database with DBCA ................................................................................. 3-4
Deleting an Oracle RAC Database with DBCA ................................................................................. 3-6
Configuring Database Control During Installation.......................................................................... 3-7
4 Oracle Real Application Clusters Postinstallation Procedures
Required Postinstallation Tasks............................................................................................................ 4-1
Download and Install Patch Updates ............................................................................................. 4-1
Configure Exceptions for the Windows Firewall.......................................................................... 4-3
Configure Oracle Products ............................................................................................................... 4-3
Configuring Oracle Database Vault......................................................................................... 4-3
Configuring Oracle Database Security Settings ..................................................................... 4-3
Configure Storage for External Tables, Shared Files, or Directory Objects............................... 4-3
Recommended Postinstallation Tasks.................................................................................................. 4-4
Recompile all PL/SQL modules ...................................................................................................... 4-4
Set Up User Accounts........................................................................................................................ 4-4
Configuring Oracle Administration Assistant for Windows ...................................................... 4-4
v
Using Oracle9i Language and Definition Files with Oracle Database 11g ................................ 4-5
Enabling and Disabling Database Options ........................................................................................ 4-5
Applying Patches to Older Versions of Oracle Software ................................................................. 4-6
Oracle Configuration Manager Postinstallation Configuration for Oracle RAC........................ 4-6
Additional Step for Oracle Enterprise Manager Grid Control.................................................... 4-7
5 Configuring Server Parameter Files in Oracle RAC
About the Server Parameter File ........................................................................................................... 5-1
Creating Server Parameter Files for Oracle RAC............................................................................... 5-2
Storage Requirements for the Server Parameter File in Oracle RAC ............................................ 5-3
Parameter File Search Order in Oracle RAC....................................................................................... 5-3
Migrating to the SPFILE in Oracle RAC Environments................................................................... 5-3
Server Parameter File Errors in Oracle RAC....................................................................................... 5-4
6 Configuring Server Pools and Enterprise Manager Database Control
Understanding Server Pools................................................................................................................... 6-1
Policy-based Cluster and Capacity Management ......................................................................... 6-2
Configuring Enterprise Manager Database Control ......................................................................... 6-2
Understanding EMCA with Oracle RAC ....................................................................................... 6-2
Using DBCA to Configuring an Existing Database to Use Database Control .......................... 6-3
Configuring Database Control After Installation Using EMCA ................................................. 6-4
Reconfiguring Existing Database Control Configurations on Remote Nodes.......................... 6-4
Updating Database Control Configuration When Adding and Removing Nodes.................. 6-5
Using an Input File for EMCA Parameters .................................................................................... 6-6
Specifying the Ports Used By Database Control............................................................................ 6-7
EMCA Troubleshooting Tips ........................................................................................................... 6-8
Using EMCA After Changing the Database Listener Port ................................................... 6-8
Upgrading Grid Control Agents for Oracle Database 11g Release 2 .................................. 6-8
Using EMCA After Changing the Database Host Name or IP Address............................. 6-8
Using EMCA When the TNS Configuration Is Changed...................................................... 6-9
7 Understanding the Oracle Real Application Clusters Installed Configuration
Understanding the Configured Environment in Oracle RAC......................................................... 7-1
Working with Multiple Oracle Home Directories on Windows..................................................... 7-2
Database Components Created Using Database Configuration Assistant................................... 7-2
Tablespaces and Data files................................................................................................................ 7-2
Control Files........................................................................................................................................ 7-4
Redo Log Files .................................................................................................................................... 7-4
Managing Undo Tablespaces in Oracle RAC ..................................................................................... 7-4
Initialization Parameter Files................................................................................................................. 7-4
Oracle Database Default Audit Policy and Initialization Parameters........................................... 7-5
Understanding Service Registration-Related Parameters ................................................................ 7-5
Understanding Single Client Access Name (SCAN) and Load-balancing................................ 7-5
Understanding Load-Balancing, Failover, and High Availability.............................................. 7-6
Configuring the Listener File (listener.ora)......................................................................................... 7-7
Grid Naming Service (GNS) and Listeners .................................................................................... 7-7
- 1
- 2
- 3
前往页