Oracle 9i Real Application Clusters. Installation and Configuration

Bauer M.

Oracle 9i Real Application Clusters Installation and Configuration is primarily for network or Database Administrators (DBAs) responsible for the installation and configuration of Real Application Clusters.To use this document you should have a conceptual understanding of Real Application Clusters processing and its software and hardware components as described in Oracle 9i Real Application Clusters Concepts. That book also contains conceptual information about Oracle Real Application Clusters Guard.

---

Table of contents :
Contents……Page 3
Send Us Your Comments……Page 15
Preface……Page 17
What’s New in Cluster Software Installation and Configuration?……Page 27
Part I Installing Oracle9i Real Application Clusters……Page 31
1 Introduction to Real Application Clusters Installation and Configuration……Page 33
The Operating System-Dependent Clusterware……Page 34
The Oracle Universal Installer and Real Application Clusters……Page 35
Server Management and Performance Manager for Real Application Clusters……Page 36
System Installation Requirements……Page 37
Software……Page 38
Version Compatibility……Page 39
2 Configuring the Shared Disks……Page 41
The Configuration Raw Device……Page 42
Additional Raw Devices Required by the DBCA……Page 43
DBCA Database Configuration Options……Page 44
Recommended Tablespace and File Capacities……Page 45
Configuring Raw Volumes for Real Application Clusters on UNIX……Page 47
UNIX Preinstallation Steps……Page 51
Configuring Logical Drives on Windows NT and Windows 2000……Page 52
3 Using the Oracle Universal Installer for Real Application Clusters……Page 55
Starting the Oracle Universal Installer……Page 56
Selecting a Database Configuration Type……Page 57
Descriptions for Using the Configuration Types in Real Application Clusters……Page 58
Using The Customized Configuration Type……Page 59
Using the General Purpose, Transaction Processing, and Data Warehouse Database Configuration Types……Page 60
Using the Customized Database Configuration Type……Page 62
4 Creating Databases with the Oracle Database Configuration Assistant……Page 65
Benefits of Using the Oracle Database Configuration Assistant……Page 66
Creating a Real Application Clusters Database with the DBCA……Page 67
UNIX Clusterware Diagnostics……Page 68
Windows NT and Windows 2000 Clusterware Diagnostics……Page 69
Deleting a Database with the Database Configuration Assistant……Page 81
Migrating or Upgrading to Release 1 (9.0.1)……Page 84
Multiple Oracle Homes……Page 85
5 Manually Creating Real Application Clusters Databases……Page 87
Setting MAXLOGHISTORY……Page 88
Changing Values for CREATE DATABASE Options……Page 89
Creating Additional Rollback Segments (Optional)……Page 90
Using Public Rollback Segments……Page 91
Creating Threads……Page 92
Setting the Log Mode……Page 93
Creating a Database Manually……Page 94
Task 1: Back Up Existing Databases……Page 95
Task 2: Specify the Database and Instance Settings……Page 96
Task 3: Create the Real Application Clusters Configuration with SRVCTL……Page 97
Task 5: Set ORACLE_SID for Each Node……Page 98
Task 6: Create the Server Parameter File……Page 100
Task 7: Create the Password Files……Page 101
Task 8: Prepare a Cluster CREATE DATABASE Script……Page 102
Task 10: Back Up the Database……Page 103
Task 11: Configure Oracle Net on All Nodes……Page 104
6 Configuring the Server Parameter File in Real Application Clusters Environments……Page 105
Location of The Server Parameter File……Page 106
Procedures for Migrating to the Server Parameter File……Page 109
Server Parameter File Errors……Page 110
Backing Up the Server Parameter File……Page 111
Part II Oracle Enterprise Manager Installation Highlights……Page 113
7 Installation and Configuration Highlights for Oracle Enterprise Manager in Real Application Clu………Page 115
Server Management Architecture……Page 116
SRVM Requirements……Page 118
Console, Management Server, and Repository on Same Machine……Page 119
Console, Management Server, and Repository on Separate Machines……Page 120
Task 1: Oracle Enterprise Manager Installation……Page 121
Task 2: Specify Preferred Credentials for Nodes and Database……Page 122
Task 5: Set User Credentials in the Console……Page 123
Configuring Oracle Performance Manager……Page 124
Instances Folder……Page 125
Additional Notes for Running the Console in Stand-Alone Mode……Page 126
Part III Managing the Configuration……Page 127
8 Understanding The Installed Configuration for Real Application Clusters……Page 129
Understanding the Configured Environment……Page 130
Executing srvconfig on Windows Platforms……Page 131
oratab File on UNIX……Page 132
Tablespaces and Datafiles……Page 133
Control Files……Page 135
Shared Server Configuration……Page 136
Dedicated Server Configuration……Page 137
How Oracle Uses the Listener (listener.ora File)……Page 138
Directory Server Access (ldap.ora File)……Page 140
Net Service Names (tnsnames.ora File)……Page 141
Profile (sqlnet.ora File)……Page 145
9 Configuring High Availability Features for Real Application Clusters……Page 147
FAILOVER_MODE Parameters……Page 148
TAF Implementation……Page 149
Transparent Application Failover Verification……Page 151
Overview of Primary and Secondary Instances……Page 152
Client Configuration……Page 153
Connecting to Secondary Instances……Page 154
Configuring Clients for Real Application Clusters……Page 155
Implementation of Client Configurations……Page 156
Testing the Oracle Net Configuration……Page 157
Part IV Migration……Page 159
10 Migrating to Real Application Clusters……Page 161
Hardware and Software Requirements……Page 162
Migrating Databases from Single Instance to Cluster-Enabled Environments……Page 163
Task 5: Install Operating System-Dependent Cluster Software……Page 164
Task 8: Import from Old Database into New Database……Page 165
Migrating to Real Application Clusters When Using Raw Devices or Shared File Systems……Page 166
Migrating Oracle8i Configurations to Oracle9i……Page 167
Part V Reference……Page 169
A Directory Structure for Real Application Clusters Environments……Page 171
UNIX Directory Structure for Real Application Clusters……Page 172
Windows NT and Windows 2000 Directory Structure for Real Application Clusters……Page 174
Shared Oracle Home……Page 175
B Oracle Enterprise Manager in Real Application Clusters Reference……Page 177
Understanding Discovery……Page 178
oratab on UNIX and Registry on Windows NT/Windows 2000……Page 179
tnsnames.ora……Page 180
Discovery Results……Page 181
Troubleshooting Discovery……Page 182
Glossary……Page 185
Index……Page 203