Deploying Oracle 9iRAC on IBM e-server Cluster 1600 with GPFS / [Octavian Lascu ... et al.].

Format:

Book

Contributor:

Lascu, Octavian.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database design.

Web servers.

Oracle (Computer file).

Physical Description:

xii, 248 p. : ill.

Edition:

1st ed.

Place of Publication:

Poughkeepsie, NY : IBM, International Technical Support Organization, c2003.

Language Note:

English

Contents:

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

AIX-related problems

Network-related problems

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.

Notes:

"SG24-6954-00."

The "e" in "eserver" is printed as the symbol for electronic.

"October 2003."

Includes bibliographical references (p. 241-242) and index.

OCLC:

939263498