• Oracle Database 11 g R2 Oracle RAC 11 g R2 on IBM AIX


  •   
  • FileName: 11gR2-tips_August 25 2010.pdf [read-online]
    • Abstract: Introduction. There are many technical topics to consider when running Oracle Database 11g Release2 and Oracle ... My Oracle Support note 282036.1, \"Minimum Software Versions and Patches Required to Support. Oracle Products on IBM pSeries\" for the latest, up-to-date issues regarding Oracle Database 11g ...

Download the ebook

Oracle Database 11g R2
Oracle RAC 11g R2 on IBM AIX
Tips and Considerations
Ravisankar Shanmugam
IBM Oracle International Competency Center
August 2010
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
1
Table of contents
Abstract........................................................................................................................................3
Introduction .................................................................................................................................3
Terminology.................................................................................................................................3
IBM AIX.........................................................................................................................................4
AIX support .............................................................................................................................................. 5
C and C++ compilers ............................................................................................................................... 6
Oracle Database 11g Release 2 .................................................................................................6
Current certifications ................................................................................................................................ 7
Latest patch set........................................................................................................................................ 8
Virtualization for Oracle Database 11g Release 2................................................................................... 9
Oracle RAC 11g Release 2 .......................................................................................................10
Current certifications .............................................................................................................................. 10
Oracle Clusterware ................................................................................................................................ 11
IBM PowerHA (formerly High Availability Cluster Multi-Processing) .................................................... 12
General Parallel File System ................................................................................................................. 13
Virtualization for Oracle RAC 11g Release 2 ........................................................................................ 14
Network interconnects ........................................................................................................................... 16
Tuning tips.................................................................................................................................17
Automatic Storage Management ........................................................................................................... 17
Asynchronous I/O .................................................................................................................................. 17
Concurrent I/O and direct I/O................................................................................................................. 18
File system cache size........................................................................................................................... 18
RAC IPC ................................................................................................................................................ 19
General Parallel File System ................................................................................................................. 19
Oracle process memory footprint........................................................................................................... 19
Tuning resources ................................................................................................................................... 19
Summary....................................................................................................................................21
Appendix 1: Resources ............................................................................................................22
About the author .......................................................................................................................23
Trademarks and special notices..............................................................................................24
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
2
Abstract
This paper consolidates the information necessary for planning and implementing Oracle
Database 11g Release 2 (11.2) single node database or Oracle Real Application Clusters
(RAC) 11g Release 2 on the IBM AIX® operating system.
This paper summarizes the information available at the time of publication. It will be updated as
changes (eg. new certifications) occur.
This paper is written to a level of detail that assumes readers have an in-depth knowledge of
AIX, Oracle Database 11g Release2, Oracle RAC 11g Release 2 and the related products.
Introduction
There are many technical topics to consider when running Oracle Database 11g Release2 and Oracle
RAC 11g Release 2 on AIX such as: status of Oracle certifications, 11g Release 2 patch sets, AIX code
levels, tuning and related software components - just to name a few. The documentation for these topics
is spread across many websites, documents, presentations and forums. This paper consolidates that
information for easy reference.
This paper focuses on AIX 5.3 and AIX 6.1, since these are the AIX versions certified on Oracle Database
11g Release 2 and Oracle RAC 11g Release 2.
This is a companion paper to three other papers.
For 9i and 10gR1, Oracle 9i & 10gR1 on IBM AIX5L: Tips and Considerations,
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100556
For 10gR2, Oracle Database 10gR2 and Oracle RAC 10gR2 on IBM AIX: Tips and Considerations,
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101089
For 11g, Oracle Database 11g and Oracle RAC 11g on IBM AIX: Tips and Considerations,
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101176
Feedback is important; please send any comments about this paper to the IBM Oracle International
Competency Center at [email protected]
The IBM Oracle International Competency Center (ICC) works closely with the IBM Oracle Joint Solutions
Center (JSC) in Montpellier, France and the IBM Oracle Competency Center in Tokyo, Japan.
IBM Oracle Joint Solutions Center, Montpellier, France – [email protected]
IBM Oracle Competency Center, Tokyo, Japan – [email protected]
Terminology
In 2008, the System p™ and System i™ product families were combined to create the IBM Power™
Systems product family. The IBM Power Systems product family includes systems previously referred to
as System p, System p5™, eServer™ pSeries®, RS6000®, System i™, System i5™, eServer iSeries®
and AS/400®,.
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
3
The brand name of “AIX 5L™” is no longer used. The term “AIX 5L” will still appear in some places in this
document, mostly in document titles which have yet to be updated.
High Availability Cluster Multi-Processing (HACMP™) has been renamed to the PowerHA™ Cluster
Manager. This version of the document will continue to use the term and acronym of High Availability
Cluster Multi-Processing (HACMP).
IBM AIX
AIX is an open standards-based, UNIX operating system. AIX in combination with IBM's virtualization
offerings provides new levels of flexibility and performance to allow you to consolidate workloads on fewer
servers which can increase efficiency and conserve energy. AIX delivers high levels of security,
integration, flexibility and reliability—essential for meeting the demands of today's information technology
environments. AIX operates on IBM Systems based on Power Architecture technology. For more
information about AIX see this web page: http://www-03.ibm.com/systems/p/os/aix/.
IBM’s latest version of AIX is 6.1. It contains new features for virtualization, security, availability and
manageability. AIX 6.1 is binary compatible with AIX 5.x. For additional information about AIX 6.1, visit
this web page: http://www-03.ibm.com/systems/p/os/aix/v61/index.html.
Most of the new features of AIX 6.1 are available on earlier POWER™ platforms. However, the best
capabilities are delivered on systems based on POWER6™ and POWER7™ processors. The POWER6
processor has ultra high-frequency dual-core processor technology and two integrated hardware
accelerators. POWER7 processors built for Smarter Planet and automatically optimize work load
performance and capacity. POWER7 loaded with specific features such as TurboCore™ for maximum per
core performance for databases and MaxCore for high rate of parallelization and high capacity
throughput. For information about the POWER6 processor, see this web page:
http://www-03.ibm.com/systems/power/advantages/power.html.
In addition to POWER6 support in AIX 6.1, the POWER6 processor-based systems are also supported by
AIX 5.3 TL 6 or later.
POWER7 supports AIX 5.3 TL11 SP2 or later and AIX 6.1 TL04 SP3 or later. HMC level V7 R710 is
required.
IBM AIX 5.3 is planned to be supported on all models of POWER7 processor-based servers delivered in 2010
The minimum level of AIX Version 5.3 to support the POWER7 processor-based server is:
AIX 5.3 TL11 SP2 or later
The POWER7 750, 755, 770 and 780 also support these technology levels:
AIX 5.3 TL10 SP4 or later
AIX 5.3 TL9 SP7 or later
For IBM AIX 6.1 support of POWER7 processor-based servers, the minimum level requirements depend on the
server model:
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
4
POWER7 750 and 755: AIX 6.1 TL4 SP2 or later
POWER7 770 and 780: AIX 6.1 TL4 SP3 or later
IBM supports other technology levels on these models:
AIX 6.1 TL3 SP5 or later
AIX 6.1 TL2 SP8 or later
Starting with AIX 6.1 TL4 SP3, POWER7 mode is fully supported.
Note: AIX 6.1 TL5 SP1 is recommended for POWER7 for the issue -Threads are not being utilized
efficiently in SMT4 and Performance impact observed.
Obtain and Install the eFix IZ78005 for AIX 6.1 TL05 SP1 for the issue - PERFORMANCE
DEGRADATION IN IO WHEN AIO BUF SIZE IS > 128K
Power Systems with POWER7 processors requires minimum level of IBM SDK as specified in the
following link
http://www.ibm.com/developerworks/java/jdk/power7/index.html
IBM also produces benchmark reports that demonstrate the performance results of Power Systems
running AIX. These benchmarks are run using Oracle E-Business Suite, yet they provide valuable data
about Oracle Database and Oracle RAC. The benchmark results are published at
http://www.oracle.com/apps_benchmark/html/results.html.
IBM will also provide sizings estimations to help predict the system resources necessary to support a
given workload. To start the sizing process, visit this web page, http://www.ibm.com/erp/sizing.
Additional documentation resources for AIX can be found at:
IBM Power Systems and AIX Information Center,
http://publib16.boulder.ibm.com/pseries/index.htm
IBM developerWorks AIX,
http://www-128.ibm.com/developerworks/aix
IBM AIX Wiki,
http://www-941.ibm.com/collaboration/wiki/display/WikiPtype/Home
AIX support
The latest fixes and updates for your system’s hardware and operating system can be found at the Fix
Central web page: http://www-912.ibm.com/eserver/support/fixes/.
Be sure to review My Oracle Support note 282036.1, “Minimum Software Versions and Patches Required
to Support Oracle Products on IBM pSeries”, for the latest, up-to-date issues regarding AIX and Oracle
Database 11g. This My Oracle Support note is the primary mechanism used to broadcast any breaking
news, such as PTF’s or bug fixes, about AIX and Oracle Database 11g.
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
5
In general, the ICC recommends that you keep your TL’s and SP’s up to date for your AIX installation.
Monitor My Oracle Support note 282036.1 and Fix Central for the latest issues. Always perform thorough
testing on an OS update before deploying to production.
Recommended Code Levels
There are two tools to help determine the recommended code levels among AIX and Power Systems
related components.
1. The Fix Level Recommendation Tool (FLRT) can determine the recommended code levels
among a mixture of AIX, HMC, Server firmware, VIOS, GPFS™ and HACMP. The FLRT
web page is: http://www14.software.ibm.com/webapp/set2/flrt/home. Note, the FLRT
recommendation provides a minimum acceptable level of compatibility.
2. The POWER code matrix indicates the recommended code levels for the HMC and Server
firmware. The POWER code matrix web page is:
http://www14.software.ibm.com/webapp/set2/sas/f/power5cm/home.html. Note, the POWER
code matrix recommendation provides the maximum stability code combinations.
Service Strategy
To review the latest IBM AIX Operating System Service Strategy Details and Best Practices
document, see this website: http://www14.software.ibm.com/webapp/set2/sas/f/best/home.html.
C and C++ compilers
XL C/C++ is a standards-based, high performance C and C++ compiler with advanced optimizing and
debugging features. It gives you the ability to optimize and tune applications for optimal execution on
systems using PowerPC®, POWER3™, POWER4™, POWER5™, POWER6™ and the latest
POWER7™ processors from IBM. The compiler supports IBM Power Systems servers capable of
running IBM AIX 5.2, 5.3 and 6.1.
To determine the current certifications for compilers on 11g Release 2, please review My Oracle
Support note 43208.1, “Certified Compilers”. Currently, XL C/C++ 8.0 and 9.0 are certified for Oracle
Database 11g. If necessary, read My Oracle Support note 335569.1, “How to Find C or C++ version on
AIX Platform” to determine your XL C/C++ compiler version.
The XL C/C++ runtime environment is installed during the installation of base AIX. To update to the latest
runtime environment, go to the XL C/C++ web page,
http://www-306.ibm.com/software/awdtools/xlcpp/features/aix/ and click on the “Latest XL C/C++ Updates
(PTFs)” link. Then select the “Runtime Environment Components” in the AIX section.
If the XL C/C++ Enterprise Edition for AIX compiler is installed, to get the latest updates, visit the
product’s web page, http://www-306.ibm.com/software/awdtools/xlcpp/features/aix/ and click on the
“Latest XL C/C++ Updates (PTFs)” link and select the appropriate link in the AIX section.
Oracle Database 11g Release 2
This section contains the Oracle Database 11g non-RAC technical information that needs to be
considered in an AIX installation. Oracle 11g Release 2 introduces the Grid Infrastructure installation for
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
6
both stand alone and Real Application Cluster (RAC) databases. Grid Infrastructure is an option which
includes Automatic Storage Management (ASM), the listener, and oracle Restart. Oracle Restart is a new
feature that provides the ability to monitor, manage, and automatically restart the Oracle database
instance, ASM instance, and listeners.
Grid infrastructure is needed for the stand alone database server if the ASM is selected as a storage
option for the database files.
These are the basic documents to review for an Oracle Database 11g installation on AIX.
“Oracle Grid Infrastructure Installation Guide 11g Release 2 (11.2) for IBM AIX Based Systems
E10814-03 http://download.oracle.com/docs/cd/E11882_01/install.112/e10814/toc.htm
“Oracle Database Installation Guide 11g Release 2 for AIX on POWER Systems (64-bit)”, E10854-
05, http://download.oracle.com/docs/cd/E11882_01/install.112/e10854/toc.htm
“Oracle Database Release Notes 11g Release 2 (11.2) for AIX on POWER Systems (64-bit)”,
E10853-03, http://download.oracle.com/docs/cd/E11882_01/relnotes.112/e10853/toc.htm
My Oracle Support note 282036.1, “Minimum Software Versions and Patches Required to Support
Oracle Products on IBM pSeries” for the latest, up-to-date issues regarding Oracle Database 11g
Release 2 and AIX.
Oracle Database Editions and Options, http://www.oracle.com/database/product_editions.html
Note: Even though the first two Oracle documents referenced above indicate “AIX 5L” in the title, the
content applies equally well to AIX 6.1.
Current certifications
To determine the current certifications for Oracle Database 11g Release 2 on AIX,
Sign into Oracle’s My Oracle Support website at https://support.oracle.com/CSP/ui/flash.html and
click on “More..” and click on “Certifications”, fill the information to the fields shown in the “Search”
tab. For Example, Product Line as “Oracle Database Products”, Product Family as “Oracle
Database”, Product Area as “Oracle Database”, Product as “Oracle Server – Enterprise Editions”,
Product release as “11gR2”, Product Version as “11gR2”, Platform as “IBM AIX on Power Systems
(64 bit), Platform version Certification status as “Certified”.
This lists the information with Certification status for the above input. Highlight the output line and click
“Actions” and select “View”. It shows you more information with three Notes, “Certification Notes, Product
Notes and Platform Notes.
OS Product Status
AIX 5.3 TL09 SP01 or later
11g Release 2 64-bit Certified
AIX 6.1 TL02 SP01 or later
Table 1: Oracle Database Enterprise Edition 11g Release 2 certifications of AIX as of publication date.
The same certifications are in place for Standard Edition (SE) as Enterprise Edition (EE).
Here are some certification details to be aware of:
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
7
These products are certified for AIX 5.3 and 6.1 on all Power Systems servers supported by those
versions of AIX.
64-bit hardware is required for a 64-bit application such as Oracle Database 11g for AIX.
Servers capable of more than 4 processors are certified only for EE.
Logical Partitioning (LPARs), Dynamic Logical Partitioning (DLPARs) and Micro-Partitioning™ are
supported.
Virtual IO Server (VIOS) is supported.
Latest patch set
At the time of publication the base and the latest patch set is 11.2.0.1. To find the documentation for the
latest Oracle Database 11g Release 2 patch set, sign into Oracle’s My Oracle Support website at
https://support.oracle.com/CSP/ui/flash.html. In the Quick Find pulldown, specify “Document ID”. Then
specify Document Number 161818.1, “Oracle Server (RDBMS) Releases Support Status Summary”.
Then click on “11.2.0.X”, this will bring up My Oracle Support note 880782.1, “Support Status and Alerts
for Oracle 11g Release 2(11.2.0.X)”. Then go to the “IBM AIX 5L Based Systems (64-bit)” section and
locate the ReadMe (if any) for 11.2.0.1. Currently there is no web link mentioned for patch set for 11.2
while writing this document.
Also, check the Oracle Database 11g Release 2 release notes for AIX 5L Based Systems,
http://download.oracle.com/docs/cd/B28359_01/relnotes.111/b32075/toc.htm, for additional AIX-specific
information.
In general, the ICC recommends that you keep your patch set current for your Oracle Database 11g
Release 2 installation. Always perform thorough testing on a database update before deploying to
production. Monitor the My Oracle Support note 282036.1 and the Release Notes for AIX Based
Systems for the latest issues.
Critical Patch Update schedule
The Critical Patch Update (CPU) program is the method by which Oracle delivers security patch
updates and security fixes for all their products. A CPU is a collection of patches for multiple security
vulnerabilities. It also includes non-security fixes that are required (because of interdependencies) by
those security patches. Oracle provides CPUs for all product offerings on a quarterly schedule.
For more information about CPUs, read the page at
http://www.oracle.com/technology/deploy/security/cpu/cpufaq.htm - “Security Alerts and Critical
Patch Updates – Frequently Asked Questions”. Watch for Critical Patch Updates at this site:
http://www.oracle.com/technology/deploy/security/alerts.htm.
Patch Set Update (PSU)
Beginning with October 2009 Critical Patch Update release, Oracle delivers Patch Set Updates for all
platforms on the release date. PSUs are proactive cumulative patches containing recommended bug
fixes that are released on a regular and predictable schedule. PSUs are on the same quarterly
schedules as the Critical Patch Update (CPU). PSUs consist of CPU, generic patch bundles, RAC
patch bundle, and Data Guard patch bundles.
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
8
The current Patch Set Update at the time of publication of this document was 11.2.0.1.1 for database
Patch number for the update of database was 9352237. See My Oracle Support note 854428.1 or
1060989.1 “Critical patch Update April 2010 Patch Availability Document for Oracle Products” and
look for “oracle Database Patch Set Update” and download the Patch 9352237
“p9352237_112010_AIX64-5L.zip” .
Virtualization for Oracle Database 11g Release 2
As mentioned in the Current Certifications sub-section (see above) for Oracle Database 11g Release 2;
LPARs, Micro-Partitioning, Dynamic LPAR and VIOS are supported. LPARs, Micro-Partitioning, Dynamic
LPAR and VIOS are part of PowerVM™. PowerVM is the family of technologies, capabilities and
offerings that deliver industry-leading virtualization on IBM POWER processor-based systems. The
PowerVM capabilities supported in Oracle Database 11g Release 2 are:
Logical Partitions subdivide a computer's processors, memory, and hardware resources into
multiple environments so that each environment can be operated independently with its own
operating system and applications.
Dedicated processor partitions are LPARs that use dedicated processors.
Dedicated processors are whole physical processors that are assigned to a single
LPAR.
Shared Processor partitions are LPARs that use Micro-Partitioning in conjunction with a
shared processor pool.
Micro-Partitioning divides a physical processor’s computing power into fractions of a
processing unit and shares them among logical partitions. Processing capacity can be
configured in fractions of 1/100 of a processor. The minimum amount of processing
capacity that has to be assigned to a partition is 1/10 of a processor.
A shared processor pool is a group of physical processors that are not dedicated to any
LPAR.
Dynamic LPARs (DLPAR) are a shared or dedicated LPAR to which changes can be made to the
amount of processors, memory and virtual or physical adapters without requiring a reboot.
For dedicated processor partitions, it is only possible to dynamically add, move or remove
whole processors. When a processor is removed from a dedicated processor partition, it is
then assigned to the shared processor pool.
For a shared processor partition, it is also possible to dynamically change the shared
processor capacity, the weight of the uncapped attribute, virtual processors and
capped/uncapped mode.
Virtual I/O Server allows sharing of physical resources between logical partitions (LPARs) including
virtual SCSI and virtual networking. This allows more efficient utilization of physical resources through
sharing between LPARs and facilitates server consolidation. The VIOS Support web page is
http://www14.software.ibm.com/webapp/set2/sas/f/vios/home.html
These are some PowerVM features still being evaluated for support on Oracle RAC 11g Release 2
Workload Partition (WPAR) is a software-based virtualization feature. WPARs subdivide an AIX
instance into multiple environments, each hosting applications and providing isolation from
applications executing in other environments. Live Application Mobility allows you to relocate
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
9
running WPARs from one LPAR to another. For more information on WPARs, see the Introduction to
Workload Partition Management in IBM AIX Version 6.1 Redbook,
http://www.redbooks.ibm.com/abstracts/sg247431.html?Open
Live Partition Mobility allows you to migrate running AIX and Linux LPARs and their hosted
applications from one physical server to another without disrupting infrastructure services. The
migration transfers the entire partition state, including the processor context, memory, attached virtual
devices, and connected users. For more information on LPM, see the PowerVM Live Partition
Mobility on IBM System p Redbook, http://www.redbooks.ibm.com/abstracts/sg247460.html?Open
Customers should monitor the latest Oracle Certification information to be aware of the ongoing
certification of new features.
For additional, detailed PowerVM information, see these documents and websites:
PowerVM webpage,
http://www-03.ibm.com/systems/power/software/virtualization/index.html
PowerVM Virtualization on IBM System p: Introduction and Configuration Fourth Edition,
http://www.redbooks.ibm.com/abstracts/sg247940.html?Open
IBM System p PowerVM Best Practices,
http://www.redbooks.ibm.com/abstracts/redp4194.html?Open
Oracle RAC 11g Release 2
This section contains the Oracle RAC 11g technical information that needs to be considered in an AIX
installation. In Oracle 11g RAC Release 2, Grid Infrastructure includes Oracle Clusterware, Automatic
Storage Management and the listener. These are the basic documents to review for an Oracle RAC 11g
Release 2 installation on AIX.
“Oracle Grid Infrastructure Installation Guide 11g Release 2 (11.2) for IBM AIX Based Systems
E10814-03 http://download.oracle.com/docs/cd/E11882_01/install.112/e10814/toc.htm
“Oracle Real Application Clusters Installation Guide 11g Release 2 (11.2) for Linux and
UNIX”,E10813-06. http://download.oracle.com/docs/cd/E11882_01/install.112/e10813/toc.htm
My Oracle Support note 282036.1, “Minimum Software Versions and Patches Required to Support
Oracle Products on IBM pSeries” for the latest, up-to-date issues regarding Oracle Database 11g and
AIX.
Note, these documents apply equally well to AIX 5L version 5.3 and AIX 6.1.
Current certifications
To determine the current certifications for Oracle RAC 11g Release 2 on AIX,
Sign into Oracle’s My Oracle Support website at https://support.oracle.com/CSP/ui/flash.html and click on
“More..” and click “Certifications”, fill the information to the fields shown in the “Search” tab. For Example,
Product Line as “Oracle Database Products”, Product Family as “Oracle Database”, Product Area as
“Oracle Database”, Product as “Oracle Server – Enterprise Editions”, Product release as “11gR2 RAC”,
Product Version as “11gR2 RAC”, Platform as “IBM AIX on Power Systems (64 bit), Platform version as
“6.1”, Certification status as “Certified”.
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
10
This lists the information with Certification status for the above input. Click on the output for “Product”, For
example “Oracle Server –Enterprise Edition”, it shows more certification information.
.
OS Product Certified With Version Status
AIX 5.3 and 6.1 11gR2 64-bit Oracle Clusterware 11g Certified
HACMP
AIX 5.3 and 6.1 11gR2 64-bit This is for raw logical volume support. 5.4.1 SP1 Certified
See HACMP sub-section below.
IBM General Parallel File System
AIX 5.3 and 6.1 11gR2 64-bit 3.2 Certified
(GPFS)
Veritas Storage Foundation for
AIX 5.3 and 6.1 11gR2 64bit 5.0 Certified
Oracle RAC
Table 2: Oracle RAC 11g Release 2 certifications of AIX as of publication date.
Here are some certification details to be aware of:
These products are certified for AIX 5.3 and AIX 6.1 on all Power Systems servers supported by
those versions of AIX.
AIX on System i partitions are also supported.
64-bit hardware is required for Oracle RAC 11g Release 2.
AIX 64-bit is required for Oracle RAC 11g Release 2.
Logical Partitioning (LPARs), Dynamic Logical Partitioning (DLPARs) and Micro-Partitioning are
supported in Oracle RAC environments.
Virtual IO Server (VIOS) features:
See the Virtualization sub-section below for details.
By following the navigation instructions in the first paragraph of this sub-section, the RAC Technologies
Compatibility Matrix will also be visible. This matrix supplies details about storage technologies, network
interconnect technologies and other platform-specific information.
http://www.oracle.com/technology/products/database/clustering/certify/tech_generic_unix_new.html
Oracle Clusterware
In a RAC environment Oracle Clusterware provides the high availability functionality. This includes
monitoring or restarting the nodes of the cluster, for the database instances, for the listeners and for the
database services. Oracle Clusterware is required for Oracle RAC 11g Release 2. For more information
on Oracle Clusterware, visit: http://www.oracle.com/technology/products/database/clustering/index.html.
For AIX 6.1, to resolve Oracle Bug 7006789 “VIP does not failover when public network cables are
removed on one node”, follow this configuration recommendation.
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
11
Oracle RAC clusterware has strict timeout requirements for VIP address failover in case of a public
network failure. When DNS servers are unreachable due to a public network failure, DNS name
resolution calls such as getaddrinfo may hang for the default AIX query timeout duration of 5 minutes.
Name resolution calls made by Oracle processes can thus delay the VIP failover. To reduce such
delays, the DNS query timeout can be reduced to 1 minute, by adding the following options line in
/etc/resolv.conf for all RAC cluster nodes:
"options timeout:1"
No reboot is necessary to activate this change.
If you need even faster VIP failover the timeout can be further reduced to a value of 0; provided your
network infrastructure (network and DNS servers) has the speed to serve name queries within a few
(5-6) seconds. If you use a value of 0 for timeout and your DNS or network is slow to respond, DNS
name lookups will start to fail prematurely.
IBM PowerHA (formerly High Availability Cluster Multi-Processing)
Note: High Availability Cluster Multi-Processing (HACMP) has been renamed to the PowerHA Cluster
Manager. This version of the document will use the term PowerHA.
For Oracle RAC 11g Release 2, raw logical volumes are only supported when performing an upgrade
installation from oracle RAC 10g R2 or 11gR1. Raw logical volumes are not available when performing a
fresh install of Oracle RAC 11g Release 2.
Where customers desire raw logical volumes for their Clusterware files, database files or recovery files,
High Availability Cluster Multi-Processing (HACMP) will be required. The certification details for the
different versions of HACMP on Oracle RAC 11g are:
PowerHA 5.4.1
Certified on AIX 5.3 and AIX 6.1.
The certification notes for HACMP 5.4.1 and AIX 5.3 list the following requirements.
AIX 5.3 TL 6 or later, specifically bos.rte.lvm 5.3.0.60. 11g Release 2 requires TL09 SP01 or
later.
PowerHA 5.4.1, available in media or APAR IZ02620.
Reliable Scalable Cluster Technology (RSCT) 2.4.7.3, rsct.basic.rte and ifix for APAR
IZ01838. This APAR is incorporated into 2.4.8.1.
Patch 6718715 for rootpre.sh is required with HACMP during a fresh install of Oracle RAC
Clusterware or when upgrading to Oracle Database 11g Release 2.
The certification notes for PowerHA 5.4.1 and AIX 6.1 list the following requirements.
AIX 6.1 TL1 SP1 or later.
PowerHA 5.4.1, available in media or APAR IZ02620.
Patch 6718715 for rootpre.sh is required with HACMP during a fresh install of Oracle RAC
Clusterware or when upgrading to Oracle Database 11g Release 2.
To resolve Oracle Bug 7006789 “VIP does not failover when public when public network
cables are removed on one node”, follow this configuration recommendation.
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
12
Oracle RAC clusterware has strict timeout requirements for VIP address failover in case of a
public network failure. When DNS servers are unreachable due to a public network failure,
DNS name resolution calls such as getaddrinfo may hang for the default AIX query timeout
duration of 5 minutes. Name resolution calls made by Oracle processes can thus delay the
VIP failover. To reduce such delays, the DNS query timeout can be reduced to 1 minute, by
adding the following options line in /etc/resolv.conf for all RAC cluster nodes:
"options timeout:1"
No reboot is necessary to activate this change.
If you need even faster VIP failover the timeout can be further reduced to a value of 0;
provided your network infrastructure (network and DNS servers) has the speed to serve
name queries within a few (5-6) seconds. If you use a value of 0 for timeout and your DNS or
network is slow to respond, DNS name lookups will start to fail prematurely.
For more information, refer the My Oracle Support note 404474.1 “Status of Certification of Oracle
Clusterware with HACMP” and read the content in the topic “Using PowerHA and Oracle RAC
11gR2”.
PowerHA version compatibility matrix with AIX versions can be found in the link
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/TD101347
Multi-node Disk Heartbeat (MNDHB)
In order to reduce the likelihood of an unnecessary cluster partition failover, multiple IP networks and
at least one non-IP network are recommended for heart beating. The most convenient way of
configuring non-IP networks is to use disk heart beating, as it removes the problems of distance
associated with RS-232 networks. Refer to these documents for additional information on MNDHB:
PowerHA Best Practices,
http://www-03.ibm.com/systems/clusters/whitepapers/hacmp_bestpractices.html
My Oracle Support note 404474.1, “Status and Certification of Oracle Clusterware with
HACMP 5.3 & 5.4” for detailed MNDHB configuration instructions.
The HACMP web page is at http://www-03.ibm.com/systems/p/ha/.
General Parallel File System
If using a file system for your Oracle RAC 11g Release 2 data files (as opposed to raw logical volumes or
ASM), you’ll need to use a cluster file system (CFS). A CFS allows file system access by all members in
a cluster at the same time. That requirement precludes JFS and JFS2 from being used for Oracle RAC
11g data files. The IBM General Purpose File System (GPFS) is an Oracle RAC 11g certified CFS.
Oracle Database 11g Release 2 and Oracle RAC 11g Release 2 on IBM AIX – Tips and Considerations
http://www.ibm.com/support/techdocs
© Copyright 2010, IBM Corporation
13
GPFS is a high-performance shared-disk file system that can provide fast, reliable data access from all
nodes in a homogenous or heterogeneous cluster of IBM UNIX servers running either the AIX or the
Linux® operating system.
To determine the current certifications for GPFS on Oracle RAC, browse to the “General Notes for RAC
for Unix on IBM AIX based Systems (RAC only)” web page, as described in the beginning of the Current
Certifications sub-section (see above).
Refer the My Oracle support note 302806.1 for more information on GPFS for Oracle RAC.
The GPFS web site is http://www-03.ibm.com/systems/clusters/software/gpfs.html. Make sure to review
the current GPFS advisories in the GPFS FAQ available from


Use: 0.0103