Skip Headers
Oracle9
i
Real Application Clusters Setup and Configuration
Release 2 (9.2)
Part Number A96600-01
Home
Book List
Index
Master Index
Feedback
Contents
Title and Copyright Information
List of Figures
List of Tables
Send Us Your Comments
Preface
What's New in Real Application Clusters Setup and Configuration?
Part I Setup and Configuration of Oracle9i Real Application Clusters
1 Introduction to Real Application Clusters Installation and Configuration
Real Application Clusters Software Components
The Oracle9i Enterprise Edition and Oracle9i Real Application Clusters
The Operating System-Dependent Clusterware
The Oracle Universal Installer and Real Application Clusters
The Installed Real Application Clusters Storage Components
Installation Overview
System Installation Requirements
Hardware and Software Requirements for Oracle9i Real Application Clusters
Supported Interconnect Software
Version Compatibility
2 Configuring the Shared Disks
Configuring Shared Disk Subsystems for Real Application Clusters
The Configuration Raw Device
Additional Raw Devices Required by the DBCA
Recommended Tablespace and File Capacities
Configuring Logical Devices
Configuring Raw Volumes for Real Application Clusters on UNIX
Configuring Logical Drives on Windows NT and Windows 2000
3 Using the Oracle Universal Installer for Real Application Clusters
Starting the Oracle Universal Installer
Selecting a Database Configuration Type
Database Configuration Assistant Processing
Using the Pre-Configured Database Configuration Types
Using the Customized Database Configuration Type
Deinstalling Real Application Clusters with the Oracle Universal Installer
4 Creating Databases with the Database Configuration Assistant
Using the Database Configuration Assistant
Benefits of Using the Database Configuration Assistant
Creating the Database after Installation Using the Database Configuration Assistant
Creating a Real Application Clusters Database with the DBCA
Deleting a Database with the Database Configuration Assistant
Migrating or Upgrading to Release 2 (9.2)
Co-Existence of Oracle Versions on the Same Cluster
Co-Existence of Operating System-Dependent Clusterware on Windows Platforms
Rolling Upgrades
Multiple Oracle Homes
5 Manually Creating Real Application Clusters Databases
Setting CREATE DATABASE Options for Cluster-Enabled Environments
Setting MAXINSTANCES
Setting MAXLOGFILES and MAXLOGMEMBERS
Setting MAXLOGHISTORY
Setting MAXDATAFILES
Setting ARCHIVELOG Mode
Changing Values for CREATE DATABASE Options
Database Objects to Support Clusters
Creating Additional Undo Tablespaces
Configuring the Online Redo Log for Real Application Clusters
Creating a Database Manually
Install Oracle Products
Manually Create the Database
Creating Real Application Clusters Data Dictionary Views with CATCLUST.SQL
6 Configuring the Server Parameter File in Real Application Clusters Environments
Parameter Files and Real Application Clusters
Using The Server Parameter File in Real Application Clusters
Location of The Server Parameter File
Parameter File Search Order
Migrating to the Server Parameter File in Real Application Clusters Environments
Server Parameter File Placement in Real Application Clusters
Procedures for Migrating to the Server Parameter File
Server Parameter File Errors
Backing Up the Server Parameter File
Part II Oracle Enterprise Manager Installation Highlights for Real Application Clusters
7 Configuration Highlights for Using Enterprise Manager in Real Application Clusters Environments
Server Management Architecture
Server Management Requirements
Understanding the Oracle Enterprise Manager Setup
Using the Console, Management Server, and Repository on the Same Machine
Using the Console, Management Server, and Repository on Separate Machines
Notes for Running the Console in Standalone Mode
Configuring Enterprise Manager for Real Application Clusters Management
Task 1: Oracle Enterprise Manager Installation
Task 2: Specify Preferred Credentials for Nodes and Database
Task 3: Create an Operating System Account
Task 4: Grant SYSDBA or SYSOPER Privileges to a Database User
Task 5: Set Preferred Credentials in the Console
Using Oracle Performance Manager for Real Application Clusters Management
Task 1: Start Oracle Performance Manager
Task 2: Accessing Statistical Charts
Part III The Real Application Clusters Installed Configuration and High Availability
8 Understanding the Installed Configuration for Real Application Clusters
Understanding the Configured Environment
Shared Configuration File
Executing srvconfig on UNIX Platforms
Executing srvconfig on Windows Platforms
UNIX Operating System Configurations
Database Components Created Using the Database Configuration Assistant
Tablespaces and Datafiles
Redo Log Files
Control Files
Managing Undo Tablespaces
Initialization Parameter Files
Configuring Service Registration-Related Parameters in Real Application Clusters
Configuring the Listener File (listener.ora)
Nondefault Listeners
Multiple Listeners
How Oracle Uses the Listener (listener.ora File)
Directory Server Access (ldap.ora File)
Net Service Names (tnsnames.ora File)
Profile (sqlnet.ora File)
9 Configuring High Availability Features for Real Application Clusters
Transparent Application Failover
FAILOVER_MODE Parameters
TAF Implementation
Primary/Secondary Instances
Overview of Primary and Secondary Instances
Initialization Parameter Configuration
Client Configuration
Listener Configuration
Connecting to Secondary Instances
Warming the Library Cache on the Secondary Instance
Real Application Clusters Guard II
Configuring Clients for Real Application Clusters
Implementation of Client Configurations
Testing the Oracle Net Configuration
Part IV Migrating to Real Application Clusters
10 Migrating to Real Application Clusters from Single-Instance Oracle Databases
Migrating from a Single Instance to Real Application Clusters
Deciding to Migrate
Preparing to Migrate
Migrating Databases from Single Instance to Cluster-Enabled Environments
Migrating with Raw Devices or Shared File Systems
Upgrading Oracle8
i
Configurations to Oracle9
i
Configurations
Part V Reference for Real Application Clusters Setup and Configuration
A Directory Structure for Real Application Clusters Environments
Understanding the Real Application Clusters Directory Structure
UNIX Directory Structures for Real Application Clusters
Windows Directory Structures for Real Application Clusters
Shared Oracle Home
B Troubleshooting Oracle Enterprise Manager in Real Application Clusters
Resolving Service Discovery Failures
Understanding Discovery
The UNIX oratab File and the Windows NT and Windows 2000 Registry
SRVM Configuration Repository
The listener.ora File
The tnsnames.ora File
The sqlnet.ora File
Discovery Results
Troubleshooting Discovery
Glossary
Index
Copyright © 1998, 2002 Oracle Corporation.
All Rights Reserved.
Home
Book List
Index
Master Index
Feedback