Oracle Real Application Clusters on IBM AIX - Best practices for system stability

839

32页

2次

2019-08-09

5墨值下载

A white paper prepared with Oracle and IBM technical collaboration

Version 1.4

Oracle Real Application Clusters on IBM AIX –

Best practices in memory tuning and configuring

for system stability

Oracle White Paper — Oracle Real Application Clusters on IBM AIX - Best practices for system stability

Executive Overview ........................................................................... 3

Introduction ....................................................................................... 3

Problem Validation ........................................................................ 4

Examining the AIX Error Logs........................................................ 4

For Oracle RAC 10g Release 2 and Oracle RAC 11g Release 1: ......... 4

For Oracle RAC 11g Release 2: ............................................................. 5

Oracle logs indicating a reboot initiated by Oracle ......................... 6

For Oracle RAC 10g Release 2 and Oracle RAC 11g Release 1: ......... 6

For Oracle RAC 11g Release 2: ............................................................. 6

Recommendations for System Stability ............................................. 8

1. Implement AIX tuning recommendations for Oracle ................... 8

2. Modify the Oracle ‘diagwait’ parameter .................................... 10

For Oracle RAC 10g Release 2 and Oracle RAC 11g Release 1: ....... 10

For Oracle RAC 11g Release 2: ........................................................... 11

3. Install the required updates and patches ................................. 12

Required patches and updates for Oracle RAC: .................................. 12

Required patch set and updates for AIX: ............................................. 13

4. Validating the Oracle process configuration ............................. 14

For Oracle RAC 10g Release 2 and Oracle RAC 11g Release 1: ....... 14

For Oracle RAC 11g Release 2: ........................................................... 17

5. Pin the AIX Kernel Memory...................................................... 22

For Oracle RAC 10g Release 2 to 11g Release 2: .............................. 22

of 32

5墨值下载

关注