Skip Headers
Oracle9
i
Real Application Clusters Setup and Configuration
Release 2 (9.2)
Part Number A96600-02
Home
Book List
Contents
Index
Master Index
Feedback
View PDF
Contents
Title and Copyright Information
List of Figures
List of Tables
Send Us Your Comments
Preface
What's New in Oracle9i Real Application Clusters Setup and Configuration?
Part I Setup and Configuration of Oracle9i Real Application Clusters
1 Introduction to Real Application Clusters Setup and Configuration
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 Components
Real Application Clusters Installation Overview
System Installation Requirements for Real Application Clusters
Hardware and Software Requirements for Oracle9i Real Application Clusters
Supported Interconnect Software
Version Compatibility in Real Application Clusters Databases
2 Configuring Shared Disks for Real Application Clusters
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 for Real Application Clusters
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 to Install Real Application Clusters
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 Cluster Databases with the Database Configuration Assistant
Using the Database Configuration Assistant in Real Application Clusters
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 Real Application Clusters Database with the DBCA
Upgrading to Release 2 (9.2)
Co-Existence of Oracle Versions on the Same Cluster
Rolling Upgrades
Multiple Oracle Homes
5 Manually Creating Real Application Clusters Databases
Setting Real Application Clusters CREATE DATABASE Options
Setting MAXINSTANCES
Setting MAXLOGFILES and MAXLOGMEMBERS
Setting MAXLOGHISTORY
Setting MAXDATAFILES
Setting ARCHIVELOG Mode
Changing Values for CREATE DATABASE Options
Database Objects to Support Clusters
Using Automatic Undo Management
Using Manual Undo Management
Configuring the Online Redo Log for Real Application Clusters
Creating a Database Manually
Install Oracle Products
Manually Create the Database
Create the Real Application Clusters Data Dictionary Views with CATCLUST.SQL
Database Password and Role Management in Real Application Clusters
6 Configuring the Server Parameter File in Real Application Clusters Environments
Parameter Files and Real Application Clusters
Using Server Parameter Files in Real Application Clusters
Location of The Server Parameter File
Parameter File Search Order in Real Application Clusters
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 in Real Application Clusters
Backing Up the Server Parameter File in Real Application Clusters
Part II Oracle Enterprise Manager Installation Highlights for Real Application Clusters
7 Configuration Highlights for Enterprise Manager in Real Application Clusters Environments
Server Management Architecture for Enterprise Manager in Real Application Clusters
Server Management Requirements for Enterprise Manager in Real Application Clusters
Understanding the Enterprise Manager Setup in Real Application Clusters
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 Real Application Clusters Installed Configuration
Understanding the Configured Environment in Real Application Clusters
Shared Configuration File in Real Application Clusters
Executing srvconfig on UNIX Platforms
Executing srvconfig on Windows Platforms
UNIX oratab Configurations for Real Application Clusters
Database Components Created Using the Database Configuration Assistant
Tablespaces and Datafiles
Control Files
Redo Log Files
Managing Undo Tablespaces in Real Application Clusters
Initialization Parameter Files
Configuring Service Registration-Related Parameters in Real Application Clusters
Configuring the Listener File (listener.ora)
Local 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 Clients and High Availability Features for Real Application Clusters
Configuring Clients for Real Application Clusters
Implementation of Client Configurations
Testing the Oracle Net Configuration
Transparent Application Failover in Real Application Clusters
FAILOVER_MODE Parameters
TAF Implementation in Real Application Clusters
Primary/Secondary Instance Feature in Real Application Clusters
Configuring the Primary/Secondary Instance Feature
Client Configuration in Primary/Secondary Instance Configurations
Listener Configuration in Primary/Secondary Instance Configurations
Connecting to Secondary Instances in Primary/Secondary Instance Configurations
Warming the Library Cache on the Secondary Instance
Real Application Clusters Guard II
Part IV Converting to Real Application Clusters
10 Converting to Real Application Clusters from Single-Instance Oracle Databases
Considerations Before Converting
Deciding to Convert
Prerequisites for Conversion
Single-Instance to Cluster-Enabled Conversion Administrative Issues
Converting from Single-Instance to Real Application Clusters
Single Instance on a Non-Cluster Machine to Oracle9i Real Application Clusters
Single Instance on a Cluster to Oracle9i Real Application Clusters
Post-Conversion Steps
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 Homes in Real Application Clusters
B Troubleshooting Oracle Enterprise Manager in Real Application Clusters
Resolving Service Discovery Failures in Real Application Clusters
Understanding Discovery in Real Application Clusters
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 in Real Application Clusters
Troubleshooting Discovery in Real Application Clusters
Glossary
Index