Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 Why clusters? -- 1.1.1 Availability -- 1.1.2 Scalability -- 1.1.3 Load sharing -- 1.1.4 Parallel processing -- 1.2 Oracle9i RAC overview -- 1.3 Cluster building blocks -- 1.3.1 Hardware components -- 1.3.2 Software components -- Chapter 2. Typical Oracle9i RAC configurations -- 2.1 Basic building blocks -- 2.2 Oracle9i RAC on RAW devices -- 2.2.1 Hardware requirements -- 2.2.2 Software requirements -- 2.2.3 Application architecture -- 2.3 Oracle9i RAC on VSD -- 2.3.1 Hardware requirements -- 2.3.2 Software requirements -- 2.3.3 Application architecture -- 2.4 Oracle9i RAC on GPFS -- 2.4.1 Hardware requirements -- 2.4.2 Software requirements -- 2.4.3 Application architecture -- Chapter 3. Planning and implementation -- 3.1 Configuration objectives -- 3.2 Hardware architecture -- 3.3 Software architecture -- 3.3.1 Oracle9i RAC on an RPD-based GPFS cluster -- 3.4 Network architecture -- 3.4.1 Networking design -- 3.4.2 Client and administrative network -- 3.4.3 Oracle interconnect networks -- 3.4.4 GPFS network -- 3.4.5 Serial (non-IP) network -- 3.5 Storage subsystem architecture -- 3.6 Node installation and configuration -- 3.6.1 AIX 5.2 ML1 -- 3.6.2 APARs/PTFs -- 3.6.3 AIX 5L 32/64-bit kernel considerations -- 3.6.4 File system considerations -- 3.6.5 Memory requirements -- 3.6.6 Paging space (swap) requirements -- 3.6.7 Temporary space -- 3.6.8 Environment and user settings -- 3.7 Network configuration -- 3.7.1 Name resolution -- 3.7.2 Enabling remote command execution -- 3.7.3 Tuning network options -- 3.8 ESS Configuration -- 3.8.1 Configuring host adapter ports -- 3.8.2 Creating the hosts (on the storage side) -- 3.8.3 Creating the Logical Unit Numbers (LUNs).

3.9 Cluster nodes SAN configuration -- 3.9.1 FC adapter microcode -- 3.9.2 Configuring logical disks -- 3.9.3 Enable Fast I/O Failure for FC adapters -- 3.9.4 Dynamic tracking of Fibre Channel adapters -- 3.9.5 ESS Subsystem Device Driver setup -- 3.9.6 Configuring the virtual path devices -- 3.10 Configuring a clustering infrastructure -- 3.10.1 RSCT Peer Domain (RPD) cluster -- 3.10.2 GPFS cluster configuration -- 3.10.3 HACMP 4.5 installation -- 3.10.4 HACMP configuration -- 3.10.5 HACMP cluster and nodes definition -- 3.10.6 HACMP IP networks -- 3.10.7 HACMP serial networks -- 3.10.8 HACMP configuration considerations -- 3.10.9 HACMP start/stop and monitoring -- 3.10.10 HACMP in an Oracle9i RAC environment -- 3.11 Check list -- 3.12 Troubleshooting -- 3.12.1 ESS Specialist does not list the WWPN -- 3.12.2 HACMP does not synchronize -- 3.12.3 HACMP does not start -- 3.12.4 The HACMP clstat command does not work -- 3.12.5 Oracle9i RAC does not start -- 3.12.6 GPFS issues -- 3.12.7 Miscellaneous -- Chapter 4. Oracle9i RAC installation and configuration -- 4.1 Prerequisites and dependencies -- 4.1.1 OS prerequisites checking -- 4.2 Oracle9i RAC installation and configuration (on GPFS) -- 4.2.1 Running Universal Installer for Oracle9i -- 4.2.2 Oracle9i RAC Database Server Patch set 9.2.0.3.0 -- 4.2.3 Oracle Net Services initial configuration -- 4.3 Creating and validating the database -- 4.3.1 Database storage planning -- 4.3.2 DBCA configuration file creation -- 4.3.3 Database creation using the Database Configuration Assistant -- 4.3.4 Post database creation steps -- 4.3.5 Oracle Net Services configuration for RAC -- 4.3.6 Manual creation of an Oracle9i RAC database -- 4.4 Oracle9i general tuning considerations on AIX platforms -- 4.4.1 Memory and paging on JFS/JFS2 file systems -- 4.4.2 AIX Logical Volume Manager -- 4.4.3 Resilvering with Oracle9i.

4.4.4 CPU scheduling and process priorities -- 4.4.5 Oracle9i Real Application Clusters and HACMP/ES -- 4.4.6 Oracle9i backup issues -- Chapter 5. Implementing RAC over GPFS -- 5.1 Benefits of Oracle9i RAC implementation with GPFS -- 5.2 Oracle9i RAC overview -- 5.2.1 Oracle9i RAC Cache Fusion -- 5.2.2 Cluster interconnect network considerations -- 5.2.3 Dynamic System Global Area (SGA) -- 5.2.4 Program Global Area (PGA) aggregate target -- 5.2.5 Undo management -- 5.2.6 Redo log threads -- 5.2.7 Oracle DB_BLOCK_SIZE -- 5.2.8 Tablespace -- 5.2.9 Control files -- 5.2.10 Initialization parameters -- 5.3 Environment planning -- 5.3.1 pSeries hardware planning -- 5.3.2 AIX planning -- 5.3.3 Highly available RAC planning -- 5.3.4 GPFS planning -- 5.3.5 Oracle planning -- 5.3.6 Memory planning -- 5.3.7 Storage planning -- 5.4 Physical database design -- 5.4.1 Oracle Striped and Mirrored Everything (SAME) strategy -- 5.4.2 GPFS architecture is based on a similar concept as Oracle SAME -- 5.5 RAC basic implementation steps -- 5.6 RAC client side failover and load balancing -- 5.7 References -- Chapter 6. High availability test scenarios -- 6.1 Test objectives and procedure -- 6.1.1 Client setup -- 6.1.2 Test query -- 6.1.3 Test script -- 6.2 Database availability tests -- 6.2.1 Listener fails on one node -- 6.2.2 Database instance fails on one node -- 6.2.3 Interconnect network interface fails on one node -- 6.2.4 Client network interface fails on one node -- 6.2.5 Complete node fails -- 6.3 Platform availability tests -- 6.3.1 GPFS subsystem failure on one node -- 6.3.2 GPFS network interface failure on one node -- 6.4 Summary of tests -- Appendix A. Operating system fileset levels -- AIX 5.2 ML1 base operating system filesets -- RSCT 2.3.1 filesets -- GPFS 2.1 filesets -- HACMP 4.5 filesets -- Enterprise Storage Server (ESS) filesets.

Fibre Channel drivers filesets -- Java filesets -- Troubleshooting -- Check logs -- AIX related problems -- Network Related -- HACMP check issues -- GPFS check issues -- Oracle check issues -- AIX Tuning considerations -- Appendix B. Troubleshooting -- Check logs -- AIX-related problems -- Network-related problems -- HACMP check issues -- GPFS check issues -- Oracle check issues -- AIX tuning considerations -- Appendix C. HACMP cluster configuration output -- Cluster description (cllscf command) -- Cluster networks (cllsif command) -- Some useful AIX commands -- EtherChannel setup procedures -- Appendix D. Oracle9i RAC configuration files and sample scripts -- D.1 Sample of initialization parameters file -- D.2 Sample database creation script -- Oracle tuning considerations -- Network options tuning for Transparent Application Failover -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover.