Installation guide

Table of Contents
INTRODUCTION......................................... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....6
64-bit Architecture..................................................................................................................................6
PACKAGES REQUIRED FOR ORACLE 10GR2 (10.2) INSTALLATION.........................................................................................7
KERNEL UPGRADES.................................................................................................................................................7
KERNEL BOOT PARAMETERS.......................................................................................................................................7
General..................................................................................................................................................7
I/O Scheduler..........................................................................................................................................8
RHEL5 Running as a VMware Guest........................................................................................................9
MEMORY USAGE AND PAGE CACHE..............................................................................................................................9
Checking Memory Usage........................................................................................................................9
Tuning Page Cache ..............................................................................................................................10
Summary of Recommended Virtual Memory Management Settings.......................................................11
SWAP SPACE......................................................................................................................................................12
General................................................................................................................................................12
Swap Size Recommendations...............................................................................................................12
Checking Swap Space Size and Usage .................................................................................................13
LARGE MEMORY OPTIMIZATION (HUGEPAGES)...............................................................................................................14
Huge Pages in RHEL5............................................................................................................................14
Usage of Huge Pages in Oracle 10g......................................................................................................15
Sizing Huge Pages................................................................................................................................15
Checking Shared Memory Before Starting Oracle Databases.................................................................15
Configuring Huge Pages in RHEL5.........................................................................................................15
SETTING SHARED MEMORY......................................................................................................................................17
Setting SHMMAX Parameter .................................................................................................................17
Setting SHMMNI Parameter ..................................................................................................................18
Setting SHMALL Parameter ..................................................................................................................19
Removing Shared Memory....................................................................................................................20
Summary of Recommended Huge Pages & Shared Memory Settings....................................................21
SETTING SEMAPHORES............................................................................................................................................22
The SEMMSL Parameter .......................................................................................................................22
The SEMMNI Parameter ........................................................................................................................22
The SEMMNS Parameter ......................................................................................................................22
The SEMOPM Parameter ......................................................................................................................23
Setting Semaphore Parameters ...........................................................................................................23
Example for Semaphore Settings..........................................................................................................23
SETTING FILE HANDLES..........................................................................................................................................24
ADJUSTING NETWORK SETTINGS................................................................................................................................25
Changing Network Kernel Settings........................................................................................................25
Flow Control on NICs and Network Switches..........................................................................................26
Network Interface Bonding ...................................................................................................................27
Changing Network Adapter Settings .....................................................................................................28
SETTING SHELL LIMITS FOR THE ORACLE USER...............................................................................................................29
Limiting Maximum Number of Open File Descriptors for the Oracle User ..............................................29
Limiting Maximum Number of Processes for the Oracle User ................................................................30
Increasing Maximum Size of Per-Processes Locked Memory..................................................................30
ENABLING ASYNCHRONOUS I/O AND DIRECT I/O SUPPORT................................................................................................31
Enabling Asynchronous I/O in Oracle 10g..............................................................................................31
Checking Asynchronous I/O Usage........................................................................................................32
STORAGE CONFIGURATION FOR ORACLE 10G RAC AND STANDALONE SERVER.........................................................................33
Configuring Storage Access with Device Mapper Multipath...................................................................35
Optimization of Disk Partitions on RAID.................................................................................................36
Configuring Raw Devices for Oracle 10g RAC........................................................................................37
Issues with Oracle 10gR2 Clusterware Installation on RHEL5.................................................................40
Configuring Storage for ASM.................................................................................................................41
4 | www.redhat.com