IBM Software Requirements and PTFs for AIX 5.3 support of Oracle Database 10g Release 2 (10.2.0.1 or higher)

最新推荐文章于 2024-11-03 22:34:49 发布

aicon

最新推荐文章于 2024-11-03 22:34:49 发布

阅读量7.7k

点赞数

分类专栏： Oracle EBS Oracle 文章标签： aix oracle database ibm command application

Oracle 同时被 2 个专栏收录

523 篇文章 0 订阅

订阅专栏

Oracle EBS

416 篇文章 0 订阅

订阅专栏

IBM Software Requirements and PTFs for AIX 5.3 support of Oracle Database 10g Release 2 (10.2.0.1 or higher):

Minimum Software Versions and Patches Required to Support Oracle Products on IBM Power Systems

[ID 282036.1]

--------------------------------------------------------------------------------

Modified 29-SEP-2010 Type BULLETIN Status PUBLISHED

Version 24: August 12, 2010

Overview

This is a dynamic document; users should check back for any document updates before installing or updating software. This document contains:

The latest required software versions and patches for both IBM and Oracle software to enable Oracle products using AIX 6 or AIX 5L on IBM System p servers.

The latest information about significant interoperability issues and frequently encountered problems.

The patches listed are the minimum required. For any IBM product, superseding AIX Technology Levels or individual patches can always be installed unless otherwise indicated below. For example: the minimum AIX requirement for Oracle 10gR1 is AIX V5.3 TL0 plus the patches listed below. Therefore for Oracle 10gR1, any technology level such as TL1 or TL2 which is higher than the minimum can be used instead.

POWER6 Support

The minimum AIX 5.x levels for POWER6 based models are AIX 5.2 TL10 and AIX 5.3 TL6. The POWER6 based models are fully exploited in AIX 6.1.

POWER7 Support

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:

? 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.

Generic Certifications

Certain certifications are executed once and when approved by Oracle cover all OS versions and system configurations that IBM supports.? 10 Gigabit Ethernet and IP over InfiniBand are supported with AIX as generic certifications. Customers should work with their IBM representative to confirm the combinations of NIC cards, switches and OS patches that are appropriate for their requirements.

10 Gigabit Ethernet

For the 10GE certification these configuration options were necessary, consider them in your 10GE infrastructure.

? LACP timeout: Use the ?long timeout? switch setting for the amount of time to wait before sending LACPDUs.?

? Flow control: Enable flow control at the switch port and on the server side ports (using HMC) for the 10GE adapter or 10GE HEA configuration.

? UDP tuning: The RAC interconnect uses UDP for interprocess communications.? Tune the udp_sendspace and udp_recvspace parameters until the ?netstat ?s? command indicates there are no ?socket buffer overflows?.? See the Network Tuning section of the ?Oracle Architecture and Tuning on AIX? document:
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100883

? Jumbo frames: Enable Jumbo frames on the RAC interconnect:

1. Configure Jumbo frames at the switch port.? In the certification project we set Jumbo frames to 9252 at the switch.

2. Configure Jumbo frames on the server side ports (using HMC) for the 10GE adapter or 10GE HEA configuration.

3. Configure Jumbo frames in the Etherchannel (network interface) definition.

Certified Offerings: support for optional configurations

Oracle and IBM have agreed that certain configuration options do not require individual certifications and can be used at the discretion of the customer, these include:

With certified VIOS combinations customers may use virtual SCSI (vSCSI) with or without N Port ID Virtualization (NPIV) to attach disk for data storage and associated raw disk-based Voting and OCR. This may be done for both ASM and GPFS. Customers must confirm IBM support of the configuration and install any required AIX and Oracle updates before using.?

When using Gigabit Ethernet, 10 Gigabit Ethernet and? IP over InfiniBand customers may configure the network routing using either EtherChannel or AIX virtual IP address (VIPA) based on their requirements.? Customers must confirm IBM support of the configuration and install any required AIX and Oracle updates before using.

VIPA on 11gR2

Users should monitor the status of these Oracle Bugs before deploying AIX VIPA on 11gR2.

? Bug 9585838 ? The VIPA interface does not support multicast.

? Bug 9554755 ? The VIPA interface does not have a MAC address associated with it.

Specific AIX PTFs (fixes) for APARs (problems), Technology Levels, Service Packs and Maintenance packages can be downloaded from:

http://www-912.ibm.com/eserver/support/fixes/fixcentral/main/pseries/aix

If a given PTF is not downloadable from this location, customers should request an iFix through AIX customer support.

Oracle availability on AIX 6 or AIX 5.3 implies support for any hardware that is supported by AIX 6 or AIX 5.3 respectively. Complete AIX hardware support details for the POWER7, POWER6, POWER5+ and POWER5 processor-based servers can be found at:

http://www-03.ibm.com/systems/power

Revision History

These are the latest updates to the document.

Summary of updates for Version 24 of this document

This is a minor revision. Updates include:

Add information about POWER7 support.

Add information about Generic Certification.

Add information about vSCSI and NPIV.

Add information about Etherchannel and AIX VIPA.

Add links to IBM Compiler support pages.

Add the latest Virtual I/O Server (VIOS), HACMP and GPFS certifications.

Add information about Oracle RAC 11gR2.

Summary of updates for Version 23 of this document

This is a major revision posted January 12, 2010. Updates include:

Add the latest General Parallel File System (GPFS) certifications.

Add the latest Virtual I/O Server (VIOS) certifications.

Add the latest Live Partition Mobility (LPM) cerifications.

Add the latest Workload Partition (WPAR) certification.

Change High Availability Cluster Multiprocessing (HACMP) product name to PowerHA for version 5.5.

Add SAP information.

Summary of updates for Version 22 of this document

This is a minor revision posted September 1, 2009. Updates include:

Changes to HACMP 5.4.1 support

Addition of HACMP 5.5 support with Oracle RAC 10gR2 on AIX 5.3 and 6.1

Summary of updates for Version 21 of this document

This is a minor revision posted May 6, 2009. Update includes:

Certification of AIX V5.3 Reliable Datagram Sockets (RDS) over InfiniBand for Oracle RAC 11g cluster interconnect.

Follow all the links below that apply to your AIX and Oracle configuration

IBM and Oracle fixes or issues related to a specific AIX release:

AIX 6.1

IBM Software requirements and PTFs for AIX 6.1 support of Oracle Database 11g Release 2 (11.2.0.1 or higher)

IBM Software requirements and PTFs for AIX 6.1 support of Oracle Database 11g Release 1 (11.1.0.6 or higher)

IBM Software requirements and PTFs for AIX 6.1 support of Oracle Database 10g Release 2 (10.2.0.1 or higher)

AIX 5.3

Note: All Oracle 9i and 10g Database customers who are running on AIX 5.3 TL5 (5300-05) must install the IBM AIX PTF for APAR IY89080. In addition, Oracle customers should contact Oracle support to obtain the fix for Oracle Bug 5496862.

IBM Software requirements and PTFs for AIX 5.3 support of Oracle Database 11g Release 2 (11.2.0.1 or higher)

IBM Software requirements and PTFs for AIX 5.3 support of Oracle Database 11g Release 1 (11.1.0.6 or higher)

IBM Software requirements and PTFs for AIX 5.3 support of Oracle Database 10g Release 2 (10.2.0.1 or higher)

IBM Software requirements for Oracle Database 10g Release 1 (10.1.0.x) or Oracle9i Database Release 2 (9.2.0.5 and following)

Oracle Software patches for AIX 5.3 interoperability:

for Oracle Database 10g Release 1 (10.1.0.2 and 10.1.0.3) or Oracle9i Database Release 2 (9.2.0.5 and 9.2.0.6)

for Oracle Application Server Release 10g (9.0.4.0.0)

Other Frequently Encountered Problems on AIX 5.3

Additional AIX 5.3 support information

AIX 5.2

IBM software requirements for Oracle Database 10g Release 2 (10.2.0.1)

IBM software requirements for Oracle Database 10g Release 1 (10.1.0.x) or Oracle 9i Database Release 2 (9.2.0.5 and following)

Oracle bug fixes for AIX 5.2 interoperability:

for Oracle Database 10g Release 1 and Release 2

Additional AIX 5.2 support information

Additional issues and fixes related to a specific Oracle product or release:

Oracle Database 11g

Oracle Database 11g Release 1 (11.1.0.6 – or higher)

Oracle Database 10g

Oracle Database 10g Release 2 (10.2.0.1 or higher)

Oracle Database 10g Release 1 (10.1.0.2, 10.1.0.3 or 10.1.0.4):

For Oracle Database 10g Release 1 (10.1.0.4 only) RAC

Oracle Database 9i

Oracle9i Database Rel 2 (9.2.0.4)

Oracle9i Database Rel 2 (9.2.0.5)

Oracle9i Database Rel 2 (9.2.0.6)

Oracle Applications

Oracle Applications 11i Rel (11.5.x) or 11.0.x

And other miscellaneous information:

Updates to information regarding other IBM products used with Oracle.

MetaLink notes addressing AIX FAQs:

IBM Software Requirements and PTFs for AIX 6.1 support of Oracle Database 11g Release 2 (11.2.0.1 or higher)

The requirements for the software products certified on Oracle Database 11gR2 with AIX 6.1 are described in this section. AIX 6.1 is certified on Oracle Database 11gR2 using AIX 6.1 TL3 SP1 or higher. The 64 bit kernel is required for all Oracle Database 11gR2 installations.

VIOS

VIOS 2.1 is certified on Oracle RAC 11gR2 with AIX 6.1. The Virtual LAN feature supports both the public network and private RAC interconnect. The Virtual SCSI feature supports Clusterware (OCR and Vote disks) and ASM storage.? These are the certified code levels, use these code levels or higher:

? VIOS 2.1:

o VIOS 2.1.2.10 FP 22

o Oracle RAC 11.2.0.1

o AIX 6.1 TL3 SP1

For information about VIOS combined with other products such as GPFS or PowerHA, see the product-specific sections within this document.

Users should review the VIOS support site for the latest VIOS information:

http://www14.software.ibm.com/webapp/set2/sas/f/vios/home.html

HACMP

For AIX 6.1 and Oracle RAC 11gR2, HACMP 5.4.1 is certified.

Users should review MetaLink Note 404474.1 for the software version or patches required and the latest PowerHA information. The detailed software requirements for PowerHA are documented only in MetaLink Note 404474.1. PowerHA is the new name for HACMP.

GPFS

For AIX 6.1 and Oracle RAC 11gR2, GPFS 3.2 is certified.

? GPFS 3.2, these are the certified code levels, use these code levels or higher:

o GPFS 3.2.1.14

o Oracle RAC 11.2.0.1

o AIX 6.1 TL3 SP1

o VIOS 2.1.0.10 FP 20.1?

Users should review MetaLink Note 302806.1 for the software version or patches required and the latest GPFS information.

Use of Persistent Reserve

For GPFS 3.2, the introduction of Persistent Reserve improves failover functionality and allows for the Oracle OCR and Voting disks to be placed on the GPFS filesystem. If Persistent Reserve is not used, the Oracle OCR and Voting disks must be on raw devices.

In the event of SAN connection failures across multiple nodes, if the second and any subsequent SAN failure occurs while GPFS recovery is already in progress then the total GPFS recovery time may exceed the default Oracle CSS misscount and result in additional node evictions. To protect against this multiple SAN failure scenario, customers can choose to locate the Oracle OCR and Voting disks on raw devices, instead of on a GPFS filesystem.

IBM Software Requirements and PTFs for AIX 6.1 support of Oracle Database 11g Release 1 (11.1.0.6 or higher)

The requirements for the software products certified on Oracle Database 11gR1 with AIX 6.1 are described in this section. AIX 6.1 is certified on Oracle Database 11gR1 using AIX 6.1 TL0 SP4 or higher. The 64 bit kernel is required for all Oracle Database 11gR1 installations.

HACMP

For AIX 6.1 and Oracle RAC 11gR1, HACMP 5.4.1 is certified.

HACMP with VIOS

VIOS 1.5 is certified for CRS and Database storage contained in a concurrent logical volume group managed by HACMP. Review MetaLink Note 404474.1 for switch configuration guidelines to enable VIOS and HACMP with Oracle RAC. These are the certified code levels, use these code levels or higher:

? HACMP 5.4.1 SP3

? VIOS 1.5.2.1 FP 11.1

? Oracle RAC 11.1.0.7

? AIX 6.1 TL1 SP2

Users should review MetaLink Note 404474.1 for the software versions or patches required and the latest PowerHA information. The detailed software requirements for PowerHA are documented only in MetaLink Note 404474.1. PowerHA is the new name for HACMP.

GPFS

For AIX 6.1 and Oracle RAC 11gR1, GPFS 3.2 is certified.

? GPFS 3.2, these are the certified code levels, use these code levels or higher:

o GPFS 3.2.1.4

? Do NOT use GPFS 3.2.1.5, migrate to 3.2.1.6 or higher

o Oracle RAC 11.1.0.6

o AIX 6.1 TL1 SP2

Users should review MetaLink Note 302806.1 for the software version or patches required and the latest GPFS information.

Use of Persistent Reserve

VIOS

VIOS 1.5 and 2.1 are certified on Oracle RAC 11gR1 with AIX 6.1. The Virtual LAN feature supports both the public network and private RAC interconnect. The Virtual SCSI feature supports Clusterware (OCR and Vote disks) and ASM storage. These are the certified code levels, use these code levels or higher:

? VIOS 2.1:

o VIOS 2.1.0.10 FP 20.1

o Oracle RAC 11.1.0.7

o AIX 6.1 TL2 SP2

? VIOS 1.5:

o VIOS 1.5.2.5 FP 11.1 SP1

o Oracle RAC 11.1.0.7

o AIX 6.1 TL2 SP2

For information about VIOS combined with other products such as GPFS or PowerHA, see the product-specific sections within this document.

Users should review the VIOS support site for the latest VIOS information:

http://www14.software.ibm.com/webapp/set2/sas/f/vios/home.html

Reliable Datagram Sockets (RDS) over InfiniBand for Oracle RAC 11gR1 interconnect

The use of RDS over InfiniBand for the RAC cluster interconnect is certified on Oracle RAC 11gR1 with AIX 6.1 TL4 SP1 plus APAR IZ64144, or higher.

When planning an implementation please review the RDS Readme file found with the RDS AIX installation media. The RDS Readme file can also be found here:

http://www14.software.ibm.com/webapp/set2/sas/f/networkmanager/rds/home.html

Note this Oracle RAC 11gR1 patch is necessary:

For 11.1.0.7, the patch for Oracle Bug 8693613 is required and is available on MetaLink.

Compilers

For AIX 6.1 and Oracle 11gR1 the following compilers are certified:

XL C/C++ 8.0 and 9.0:

http://www-01.ibm.com/software/awdtools/xlcpp/aix/library/

XL FORTRAN 9.1 and 12.1:

http://www-01.ibm.com/software/awdtools/fortran/xlfortran/aix/library/

Micro Focus Server Express 5.0

OC Systems PowerAda 5.3+

Users should review MetaLink Note 43208.1, Certified Compilers, for the latest patch information and references to compiler-specific MetaLink notes. The Certified Compilers MetaLink Note contains the complete list of compilers certified for the various versions of AIX and Oracle.

IBM Software Requirements and PTFs for AIX 6.1 support of Oracle Database 10g Release 2 (10.2.0.1 or higher)

The requirements for the software products certified on Oracle Database 10gR2 with AIX 6.1 are described in this section.

Use AIX 6.1 Service Pack 1 (AIX 6100-00-01) or higher, make sure to include the fix for the following APAR:

IZ10223: OLSON TIMEZONE SETTINGS IS NOT WORKING FOR 64BIT APPLICATIONS. APPLIES TO AIX 6100-00

The AIX 6.1 64 bit kernel is required for all Oracle Database 10gR2 installations – both RAC and non-RAC.

Oracle Database 10gR2 (10.2.0.3) CRS or higher is recommended for all RAC configurations.

HACMP

For AIX 6.1 and Oracle RAC 10gR2, HACMP 5.4.1 and PowerHA 5.5 are certified.

GPFS

For AIX 6.1 and Oracle RAC 10gR2, GPFS 3.2 is certified.

? GPFS 3.2, these are the certified code levels, use these code levels or higher:

o GPFS 3.2.1.4

? Do NOT use GPFS 3.2.1.5, migrate to 3.2.1.6 or higher

o Oracle RAC 10.2.0.4

o AIX 6.1 TL1 SP2

GPFS with VIOS

VIOS 2.1 is certified on Oracle RAC 10gR2 with GPFS 3.2. These are the certified code levels, use these code levels or higher:

? VIOS 2.1.1.10 FP21

? GPFS 3.2.1.14

? Oracle RAC 10.2.0.4

? AIX 6.1 TL3 SP1

Users should review MetaLink Note 302806.1 for the software version or patches required and the latest GPFS information.

Use of Persistent Reserve

However, in the event of SAN connection failures across multiple nodes, if the second and any subsequent SAN failure occurs while GPFS recovery is already in progress then the total GPFS recovery time may exceed the default Oracle CSS misscount and result in additional node evictions. To protect against this multiple SAN failure scenario, customers can choose to locate the Oracle OCR and Voting disks on raw devices, instead of on a GPFS filesystem.

VIOS

VIOS 1.5 and 2.1 are certified on Oracle RAC 10gR2 with AIX 6.1. The Virtual LAN feature supports both the public network and private RAC interconnect. The Virtual SCSI feature supports Clusterware (OCR and Vote disks) and ASM storage. These are the certified code levels, use these code levels or higher:

? VIOS 2.1:

o VIOS 2.1.0.10 FP 20.1

o Oracle RAC 10.2.0.4

o AIX 6.1 TL2 SP2

? VIOS 1.5:

o VIOS 1.5.2.5 FP 11.1 SP1

o Oracle RAC 10.2.0.4

o AIX 6.1 TL2 SP2

For information about VIOS combined with other products such as GPFS or PowerHA, see the product-specific sections within this document.

Users should review the VIOS support site for the latest VIOS information:

http://www14.software.ibm.com/webapp/set2/sas/f/vios/home.html

LPM

For AIX 6.1 and Oracle Database 10gR2, Live Partition Mobility (LPM) is certified for non-RAC environments.? These are the certified code levels, use these code levels or higher:

? AIX 6.1 TL2 SP3

? Oracle Database 10.2.0.4

? VIOS 1.5.2.1 (Fix Pack 11.1)

? HMC V7R3.4.0

? Firmware E*320

LPM is a feature of PowerVM. Users should review the PowerVM website for the latest LPM information:

http://www14.software.ibm.com/webapp/set2/sas/f/pm/home.html

WPAR

For AIX 6.1 and Oracle Database 10gR2, Workload Partition (WPAR) is certified for non-RAC environments.? These are the certified code levels, use these code levels or higher:

AIX 6.1 TL2 SP2

Installation of APAR fixes for IZ52319 and IZ54871 are required

Oracle Database 10.2.0.4

Users should review MetaLink Note 889220.1, IBM AIX Workload Partition (WPAR) Installation, for the latest WPAR installation information.

WPAR is a feature of PowerVM. Users should review the PowerVM website for the latest WPAR information:

http://www-03.ibm.com/systems/power/software/virtualization/

SAP

To run SAP on Oracle RAC 10gR2 refer to the following document for software versions.

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/FQ127343

The document also lists SAP notes which have additional software level and configuration information.

Compilers

For AIX 6.1 and Oracle 10gR2 the following compilers are certified:

XL C/C++ 7.0.0.2, 8.0 and 9.0:

http://www-01.ibm.com/software/awdtools/xlcpp/aix/library/

XL FORTRAN 8.1, 9.1 and 12.1:

http://www-01.ibm.com/software/awdtools/fortran/xlfortran/aix/library/

IBM COBOL for AIX 3.1:

http://www-01.ibm.com/software/awdtools/cobol/aix/library/

Micro Focus Server Express 4.0 SP1

ACUCOBOL-GT 6.1

OC Systems PowerAda 5.3+

Additional AIX 6.1 Issues in Oracle Database 10gR2

The Oracle 10gR2 OUI and configuration assistant programs do not recognize AIX 6 V6.1 as a supported release.

Resolution:

For the OUI program, use the ‘-ignoreSysPrereqs’ option as in the command:

‘ ./runInstaller –ignoreSysPrereqs’

For the configuration assistant program, select the skip validation option and continue to verify other errors.

The Oracle 10gR2 “rootpre.sh” program displays unnecessary error messages related to AIX AIO.

Problem description:

When running the ‘rootpre.sh’ program, messages like the following will be displayed:

Configuring Asynchronous I/O....

Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Configuring POSIX Asynchronous I/O....

Posix Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Resolution:

A replacement ‘rootpre.sh’ is available for download from Oracle MetaLink, reference Oracle Patch 6718715, “Support for HACMP 5.4 in rootpre.sh script”. Even though Patch 6718715 targets HACMP 5.4 it contains the changes for AIX 6.1 AIO. Patch 6718715 supersedes Patch 6613550, which was previously recommended. Make sure to download the 10.2.0.3 version of Patch 6718715

AIX 6.1 will issue an error message when attempting to create a volume group with a disk that is formatted by Oracle ASM.

Problem Description:

This additional checking by AIX was to prevent accidentally overwriting an Oracle ASM disk.

The error message from the ‘mkvg’ command will be similar to the following:

0516-1339 /usr/sbin/mkvg: Physical volume contains some 3rd party volume group.

0516-1397 /usr/sbin/mkvg: The physical volume hdisk1, will not be added to the volume group.

0516-862 /usr/sbin/mkvg: Unable to create volume group.

Resolution:

The force option (-f) on the ?mkvg? command will not work for an ASM disk. The AIX ?dd? command can be used to clear the Oracle ASM information for the disk. The ?dd? command will overwrite the existing data on the ASM disk. The following is a sample command:

dd if=/dev/zero/ of=/dev/rhdisk1 bs=1024 count=10

Use the ?dd? command only if you are absolutely sure it is safe to overwrite the existing data on the ASM disk. Once overwritten, the original data will no longer be retrievable.

< Return to 6.1 list >

Other frequently encountered problems when using AIX 6.1

Performance degradation when AIO buffer size is greater than 128KB

Asynchronous IO (AIO) fastpath can trigger lock contention in the disk layer when the AIO buffer size is greater than 128KB.? This can result in significant performance degradation.?

See APARs: IZ74245, IZ75040, IZ76490 or IZ78005 (depending on your AIX 6.1 TL) for details.

Pinned files can be leaked when using AIO fastpath for CIO

When using AIO fastpath for CIO, pinned files used for read operations can be leaked. The pinned memory in the kernel heap can increase gradually and the system may eventually run out of pinned memory.

See these APARs for AIX 6.1:

? AIX 6.1 TL2, IZ10478

? AIX 6.1 TL1, IZ08916

? AIX 6.1 TL0 SP3, IZ13250

AIX may page out computational pages by mistake in some rare instances

When real memory is exhausted on a Power5+ or Power6 machine with the 64-bit kernel, AIX page replacement may page out computational 64K pages instead of non-computational file cache pages in some rare cases.? This can lead to an increase in paging space consumption even when there is sufficient file cache available for page replacement.

See this APAR for AIX 6.1:

? AIX 6.1 TL1, IZ17835

Oracle RAC 11gR2 installation error: INS-13001 Environment does not meet minimum requirements

See metalink note 986657.1.? This is the root cause of the Oracle Universal Installer errors:

# /bin/oslevel

6.1.4.0

# /bin/oslevel ?s

6100-04-01-0944

In this case, the first command should return:

# /bin/oslevel

6.1.0.0

See this APAR for AIX 6.1:

? AIX 6.1 TL1, IZ71798

? AIX 6.1 TL3, IZ64439

? AIX 6.1 TL4, IZ64508

? AIX 6.1 TL5, IZ 61760

< Return to 6.1 list >

IBM Software Requirements and PTFs for AIX 5.3 support of Oracle Database 11g Release 2 (11.2.0.1 or higher)

The requirements for the software products certified on Oracle Database 11gR2 with AIX 5.3 are described in this section. AIX 5.3 is certified on Oracle Database 11gR2 using AIX 5.3 TL10 SP1 or higher. The 64 bit kernel is required for all Oracle Database 11gR2 installations.

VIOS

VIOS 2.1 is certified on Oracle RAC 11gR2 with AIX 5.3. The Virtual LAN feature supports both the public network and private RAC interconnect. The Virtual SCSI feature supports Clusterware (OCR and Vote disks) and ASM storage. These are the certified code levels, use these code levels or higher:

? VIOS 2.1:

o VIOS 2.1.0.10 FP 20.1

o Oracle RAC 11.2.0.1

o AIX 5.3 TL10 SP1

For information about VIOS combined with other products such as GPFS or PowerHA, see the product-specific sections within this document.

Users should review the VIOS support site for the latest VIOS information:

http://www14.software.ibm.com/webapp/set2/sas/f/vios/home.html

HACMP

For AIX 5.3 and Oracle RAC 11gR2, HACMP 5.4.1 is certified.

GPFS

For AIX 5.3 and Oracle RAC 11gR2, GPFS 3.2 is certified.

? GPFS 3.2, these are the certified code levels, use these code levels or higher:

o GPFS 3.2.1.14

o Oracle RAC 11.2.0.1

o AIX 5.3 TL9 SP2

o VIOS 2.1.0.10 FP 20.1?

Users should review MetaLink Note 302806.1 for the software version or patches required and the latest GPFS information.

Use of Persistent Reserve

IBM Software Requirements and PTFs for AIX 5.3 support of Oracle Database 11g Release 1 (11.1.0.6 or higher)

The requirements for the software products certified on Oracle Database 11gR1 with AIX 5.3 are described in this section.

Use AIX 5.3 TL 05 or higher, make sure to include the fixes for the following APARS:

IY89080 ORA-600 ERRORS IN THE ORACLE ALERT LOGS

IY92037 EINVAL RETURNED ON LARGE AIO WRITE TO RHDISK

IY94343 MKLV -TO ON BIG VOLUME GROUPS FAILS TO PUT SOME LV INFORMATION

IZ01060 GETADDRINFO() DOESN'T HONOR HINTS COMPLETELY

IZ03260 LIO_LISTIO FAILS TO UPDATE AIO CONTROL BLOCKS ON ERROR

IY84564 CPU BRINGUP IS SLOW (If performing DLPAR operations with Oracle RAC configurations.)

IY91120 ERROR RECOVERY STORM WITH LARGE NUMBER OF MPIO PATHS (For any Oracle RAC on AIX environment using SDD or MPIO/SDDPCM based storage such as DS8000.)

The AIX 5.3 64 bit kernel is required for all Oracle Database 10gR2 installations – both RAC and non-RAC.

HACMP

For AIX 5.3 and Oracle RAC 11gR1, HACMP 5.3 and 5.4.1 are certified.

GPFS

For AIX 5.3 and Oracle RAC 11gR1, GPFS 3.1 and 3.2 are certified.

? GPFS 3.2, these are the certified code levels, use these code levels or higher:

o GPFS 3.2.1.4

? Do NOT use GPFS 3.2.1.5, migrate to 3.2.1.6 or higher

o Oracle RAC 11.1.0.6

o AIX 5.3 TL8 SP4

? GPFS 3.1, use GPFS 3.1.0.9 or higher.

Users should review MetaLink Note 302806.1 for the software version or patches required and the latest GPFS information.

GPFS 3.2 includes new features that provide fast failover with improved recovery times. This makes GPFS 3.2 a good choice for Oracle RAC 11gR1.

Use of Persistent Reserve

VIOS

VIOS 1.5 and 2.1 are certified on Oracle RAC 11gR1 with AIX 5.3. The Virtual LAN feature supports both the public network and private RAC interconnect. The Virtual SCSI feature supports Clusterware (OCR and Vote disks) and ASM storage. These are the certified code levels, use these code levels or higher:

? VIOS 2.1:

o VIOS 2.1.0.10 FP 20.1

o Oracle RAC 11.1.0.6

o AIX 5.3 TL9 SP2

? VIOS 1.5:

o VIOS 1.5.2.5 FP 11.1 SP1

o Oracle RAC 11.1.0.6

o AIX 5.3 TL9 SP2

For information about VIOS combined with other products such as GPFS or PowerHA, see the product-specific sections within this document.

Users should review the VIOS support site for the latest VIOS information:

http://www14.software.ibm.com/webapp/set2/sas/f/vios/home.html

Reliable Datagram Sockets (RDS) over InfiniBand for Oracle RAC 11gR1 interconnect

The use of RDS over InfiniBand for the RAC cluster interconnect is certified on Oracle RAC 11gR1 with AIX 5.3 TL8 SP4 or higher.

When planning an implementation please review the RDS Readme file found with the RDS AIX installation media. The RDS Readme file can also be found here:

http://www14.software.ibm.com/webapp/set2/sas/f/networkmanager/rds/home.html

Note these Oracle RAC 11gR1 patches are necessary:

For 11.1.0.6, the patch for Oracle Bug 6643259 is required and is available on MetaLink.

For 11.1.0.7, the patch for Oracle Bug 8693613 is required and is available on MetaLink.

Compilers

For AIX 5.3 and Oracle 11gR1 the following compilers are certified:

XL C/C++ 8.0 and 9.0:

http://www-01.ibm.com/software/awdtools/xlcpp/aix/library/

XL FORTRAN 9.1:

http://www-01.ibm.com/software/awdtools/fortran/xlfortran/aix/library/

Micro Focus Server Express 5.0

OC Systems PowerAda 5.3+

< Return to AIX V5.3 list >

IBM Software Requirements and PTFs for AIX 5.3 support of Oracle Database 10g Release 2 (10.2.0.1 or higher)

The requirements for the software products certified on Oracle Database 10gR2 with AIX 5.3 are described in this section.

Use AIX 5.3 TL 02 or higher, make sure to include the fixes for the following APARs:

IY68989: “WRITE TO MMAPPED SPACE HANGS”

IY68874: An application that is run with mandatory large page data (LDR_CNTRL=LARGE_PAGE_DATA=M) may core-dump on the AIX V5.3 64-bit kernel in a LPAR environment.

IY70031: “CORRUPTION FROM SIMULTANEOUS CIO WRITES WITH O_DSYNC ON JFS2” If using the IBM Journal File System Version 2 (JFS2) for Oracle Database files.

NOTE: All Oracle 9i Database and Oracle 10g Database customers who are running on AIX 5.3 TL 05 must install the IBM AIX PTF for APAR IY89080. In addition, Oracle customers should contact Oracle support to obtain the fix for Oracle Bug 5496862.

IZ03260: LIO_LISTIO FAILS TO UPDATE AIO CONTROL BLOCKS ON ERROR APPLIES TO AIX 5300-06 (for AIX V5.3 TL06 customers ).

IZ03475: LIO_LISTIO FAILS TO UPDATE AIO CONTROL BLOCKS ON ERROR APPLIES TO AIX 5300-07 (for AIX V5.3 TL07 customers).

HACMP

For AIX 5.3 and Oracle RAC 10gR2, HACMP 5.3, 5.4.1 and PowerHA 5.5 are certified.

GPFS

For AIX 5.3 and Oracle RAC 10gR2, GPFS 2.3, 3.1 and 3.2 are certified.

? GPFS 3.2, these are the certified code levels, use these code levels or higher:

o GPFS 3.2.1.4

? Do NOT use GPFS 3.2.1.5, migrate to 3.2.1.6 or higher

o Oracle RAC 10.2.0.4

o AIX 5.3 TL8 SP4

? GPFS 3.1, use GPFS 3.1.0.9 or higher:

o Oracle 10.2.0.3 RAC is the minimum level for GPFS 3.1 configurations.

? GPFS 2.3, use GPFS 2.3.0.3 (GPFS 2.3.0.0 plus IY63969) and these APAR fixes:

o IY69911

o IY70276

o IY70277

o IY74097

GPFS with VIOS

VIOS 2.1 is certified on Oracle RAC 10gR2 with GPFS 3.2. These are the specific code levels that are certified, use these code levels or higher:

? VIOS 2.1.1.10 FP21

? GPFS 3.2.1.14

? Oracle RAC 10.2.0.4

? AIX 5.3 TL9 SP4

Users should review MetaLink Note 302806.1 for the software version or patches required and the latest GPFS information.

GPFS 3.2 includes new features that provide fast failover with improved recovery times. This makes GPFS 3.2 a good choice for Oracle RAC 10gR2.

Use of Persistent Reserve

VIOS

VIOS 1.5 and 2.1 are certified on Oracle RAC 10gR2 with AIX 5.3. The Virtual LAN feature supports both the public network and private RAC interconnect. The Virtual SCSI feature supports Clusterware (OCR and Vote disks) and ASM storage. These are the certified code levels, use these code levels or higher:

o VIOS 2.1:

o VIOS 2.1.0.10 FP 20.1

o Oracle RAC 10.2.0.4

o AIX 5.3 TL9 SP2

o VIOS 1.5:

o VIOS 1.5.2.5 FP 11.1 SP1

o Oracle RAC 10.2.0.4

o AIX 5.3 TL9 SP2

For information about VIOS combined with other products such as GPFS or PowerHA, see the product-specific sections within this document.

Users should review the VIOS support site for the latest VIOS information:

http://www14.software.ibm.com/webapp/set2/sas/f/vios/home.html

LPM

For AIX 5.3 and Oracle Database 10gR2, Live Partition Mobility (LPM) is certified for non-RAC environments.? These are the code levels that are certified, use these code levels or higher:

o AIX 5.3 TL8 SP4

o Oracle RAC 10.2.0.4

o VIOS 1.5.2.1 (Fix Pack 11.1)

o HMC V7R3.4.0

o Firmware E*320

LPM is a feature of PowerVM. Users should review the PowerVM website for the latest LPM information:

http://www14.software.ibm.com/webapp/set2/sas/f/pm/home.html

SAP

To run SAP on Oracle RAC 10gR2 refer to the following document for software versions.

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/FQ127343

The document also lists SAP notes which have additional software level and configuration information.

Compilers

For AIX 5.3 and Oracle 10gR2 the following compilers are certified:

XL C/C++ 7.0.0.2, 8.0 and 9.0:

http://www-01.ibm.com/software/awdtools/xlcpp/aix/library/

XL FORTRAN 8.1 and 9.1:

http://www-01.ibm.com/software/awdtools/fortran/xlfortran/aix/library/

IBM COBOL for AIX 3.1:

http://www-01.ibm.com/software/awdtools/cobol/aix/library/

Micro Focus Server Express 4.0 SP1

ACUCOBOL-GT 6.1

OC Systems PowerAda 5.3+

Note: Oracle Database 10g Release 2 RAC on AIX 5.3 requires the 64-bit kernel

AIX 5L supports both 32 and 64 bit applications running on the 64-bit kernel, including Oracle 8i and 9i client code. See the following MetaLink notes for details on related questions:

MetaLink note 169426.1 provides the steps to change between the AIX5L 32-bit and 64-bit kernel.

MetaLink note 231901.1 provides the details on enabling your 32 bit 8i and 9i clients on AIX5L with the 64-bit kernel.

< Return to AIX V5.3 list >

IBM Software Requirements and PTFs for AIX 5.3 support of Oracle Database 10g Release 1 or Oracle9i (9.2.0.8)

The requirements for the software products certified on Oracle Database 9i with AIX 5.3 are described in this section.

Ensure the fixes for the following AIX 5.3 APARs are installed:

IY58143 "REQUIRED UPDATE FOR AIX 5.3"

IY59386 "libdepend.mk files are all empty"

IY60930 Unable to delete network routes

IY66513 and IY70159: This should be applied to AIX 5L V5.3 for any application where the “LDR_CNTRL” environment variable is explicitly set. For example, 8.1.7 32bit Database users may specify “LDR_CNTRL=MAXDATA=0x80000000”. See Oracle Bug 4150457 for a detailed problem description.

IY68989: This PTF is mandatory for all Oracle customers running on AIX V5.3 ML01 or ML02. This fix address a critical problem introduced in ML01. The symptoms can vary from an Oracle application hang to unexplained corruption of Oracle jar files or Oracle Application Forms.

APAR IY68874: An application that is run with mandatory large page data (LDR_CNTRL=LARGE_PAGE_DATA=M) may core-dump on the AIX 5.3 64-bit kernel in a LPAR environment.

IY70031: “CORRUPTION FROM SIMULTANEOUS CIO WRITES WITH O_DSYNC ON JFS2” If using the IBM Journal File System Version 2 (JFS2) for Oracle Database files.

NOTE: All Oracle 9i Database and Oracle 10g Database customers who are running on AIX 5L V5.3 Technology Level 5 (TL 5300-05) must install the IBM AIX PTF for APAR IY89080. In addition, Oracle customers should contact Oracle support to obtain the fix for Oracle Bug 5496862.

HACMP

For AIX 5.3 and Oracle RAC 9i or 10gR1, HACMP 5.1 and 5.2 are certified.

Note: HACMP is only required for Oracle RAC configurations where:

Oracle RAC 9i is used, or

Oracle RAC 10g or 11g is used and the Oracle data files reside on concurrent raw logical volumes (CLVM).

For either HACMP 5.2 or HACMP 5.1, apply these APAR fixes:

IY61034: INCORRECT GW ADDR FOR DEFAULT ROUTE AFTER ALIAS DELETE

IY61770: MISC SERVICE UPDATES

IY62191: THREADS BLOCKED IN _GLOBAL_LOCK_COMMON

For HACMP V5.2 only, apply this APAR fix:

IY60759: "ODM PERMISSION CHANGES REQUIRED TO SUPPORT ORACLE 9i"

For HACMP V5.1 only, apply this APAR fix:

U498114 and all co-requisite PTFs.

GPFS

For AIX 5.3 and Oracle RAC 9i or 10gR1, GPFS 2.3 and 3.1 are certified.

o GPFS 3.1, use GPFS 3.1.0.9 or higher

o For Oracle 9i (9.2.0.8) clusters.

o GPFS 2.3, use GPFS 2.3.0.3 (GPFS 2.3.0.0 plus IY63969) and these APAR fixes:

o IY69911

o IY70276

o IY70277

o IY74097

Users should review MetaLink Note 302806.1 for the software version or patches required and the latest GPFS information.

PSSP

Not Required.

JDK

IBM JDK 1.3.1.11(32 bit) IY47055

IBM JDK 1.4.1.2 (32 bit) IY47536

IBM JDK 1.4.1.1 (64 bit) IY47538

C/C++ Compiler

VAC 6 C and C++ for AIX July PTF (6.0.0.4) U489726

Required AIX filesets

The following filesets must be installed and committed:

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.libperfstat

bos.perf.perfstat

bos.perf.proctool

< Return to AIX V5.3 list >

Oracle bug fixes for AIX 5.3 interoperability:

For Oracle Database 10g Release 1 (10.1.0.2 and 10.1.0.3) or Oracle9i Database Rel 2 (9.2.0.5 and 9.2.0.6) on AIX 5.3

When running the Oracle Universal Installer (OUI) the following message or similar may appear:

"OUI-18001: The operating system “AIX Version 5300.0x” is not supported."

The circumvention is to run the OUI as follows:

"./runInstaller -ignoreSysPrereqs "

For Oracle Application Server Release 10g (9.0.4.0.0) on AIX 5.3

Configuration Assistants failing with "ENOEXEC" error

Problem Description:

Two (2) of the configuration assistants may fail while installing via the OUI during the following install type:

Product to Install: "OracleAS Infrastructure 10g 9.0.4.0.0 "

Installation Type: "Identity Management and OracleAS Metadata Repository"

Another configuration assistant may fail during the "Mid-Tier" installation after selecting the following options:

Product to Install: " Oracle Application Server 10g 9.0.4.0.0"

Installation Type: " Business Intelligence and Forms "

Configuration Options selected:

"OracleAS Portal"

"OracleAS Wireless"

"OracleAS Discoverer"

"OracleAS Reports Services"

"OracleAS Forms Services"

In all 3 cases, a pop-up window containing the following message is displayed:

"Error:*** Alert: Some of the configuration assistants failed. It is strongly recommended that you retry the configuration assistants at this time. Not successfully running any "Recommended" assistants means your system will not be correctly configured. Select the failed assistants and click the “Retry” button to retry them.-"

The solution for all of the 3 problems is:

Users running Oracle Application Server Release 10g (9.0.4.0.0) on AIX 5L V5.3 should request the IBM PTFs for both APAR IY66513 and IY70159. If the formal PTFs are not available, customers should request an iFix containing the fixes for both APARs from IBM support.

The previously documented workaround is no longer required but is included below in Appendix A to help identify any occurrences of the original problem. See also MetaLink Note 339916.1 for patching 9.0.4.X on ML03.

Extra processes may be spawned after installation has completed and system may exhibit insufficient memory behavior

Problem Description:

After the application server has been installed and started, running the command:

“ps | wc -l”

at regular intervals will show a steady increment in the number of processes as invalid processes are created. Perform the following steps to resolve:

See MetaLink Note: 298175.1 for information about other similar problems requiring the following solution.

Solution:

Shutdown all application processes using the following commands:

“opmnctl stopall”

“emctl stop em”

If necessary, use “kill “ to kill all remaining application processes.

When all application processes have been removed, continue with the following steps:

“cd $ORACLE_HOME/bin/”

Save the current version of reports.sh: “cp reports.sh reports.sh.orig”

edit $ORACLE_HOME/bin/reports.sh and comment out the following line as follows

## MALLOCTYPE=3.1; export MALLOCTYPE

Save the file and restart using the commands:

“emctl start em”

“opmnctl startall”

Use the “ps | wc -l” command to verify that additional process are not spawned.

< Return to AIX V5.3 list >

Other frequently encountered problems when using AIX 5.3

Long User Names:

AIX 5.3 introduces support of user names up to a length of 256 bytes. However, Oracle usernames must not exceed 30 bytes in order to guarantee uniqueness within Oracle.

For Oracle RAC installations, the UID for the Oracle user must be less than 65536.

The ?dbconsole? may not start after doing an install through the Oracle Enterprise Manager (OEM) and selecting a database.

The solution is to:

Edit the file: ${ORACLE_HOME}/_${ORACLE_SID}/sysman/config/emd.properties

Locate the entry where the EMD_URL is set.

This entry should have the format:

EMD_URL=http://:%EM_SERVLET_PORT%/emd/main

If you see the string: %EM_SERVLET_PORT% in the entry, then replace the complete string with an unused port number that is not defined in the "/etc/services" file. If this string is missing and no port number is in its place, then insert an unused port number that is not defined in the "/etc/services" file in between the "http://:" and the "/emd/main" strings.

Use the command ?emctl start dbconsole? to start the dbconsole after making this change.

For example:

EMD_URL=http://myhostname.us.oracle.com:5505/emd/main

Stack Execution Disable option

Oracle users running on AIX 5.3 TL03 or higher may encounter problems if the new Stack Execution Disable (SED) option is enabled.

AIX 5.3 TL3, introduced a new feature called "Stack Execution Disable" or SED. This prevents buffer overflow attacks, by disabling any data to be executed as code. More information about this feature can be found here: http://publib.boulder.ibm.com/infocenter/pseries/index.jsp?topic=/com.ibm.aix.doc/aixbman/security/stack_exec_disable.htm

However, Java's Just-In-Time (JIT) compiler executes the compiled bytecodes, so if SED is enabled on an AIX system, the Java processes will be terminated. This information is mentioned here: http://publib.boulder.ibm.com/infocenter/pseries/topic/com.ibm.aix.doc/aixbman/security/stack_exec_disable_issues.htm

Note that by default, AIX is shipped with SED in ?select? mode which would not enable SED for the JIT.

Future versions and refreshes of Java (Java 1.3.1 SR3, Java 1.4.2 refresh after SR3, Java 5) set the "SED exempt" bit, so they will not be affected by this change. As an interim measure, the ?sedmgr? command (see: http://publib.boulder.ibm.com/infocenter/pseries/topic/com.ibm.aix.doc/cmds/aixcmds5/sedmgr.htm ) can be used to mark any process, including Java, as "exempt".

Performance Degradation when AIO buffer size is greater than 128KB

Asynchronous IO (AIO) fastpath can trigger lock contention in the disk layer when the AIO buffer size is greater than 128KB.? This can result in significant performance degradation.?

See APAR IZ59538 for details.

Pinned files can be leaked when using AIO fastpath for CIO

See these APARs for AIX 5.3:

? AIX 5.3 TL9, IZ10713

? AIX 5.3 TL8, IZ09025

? AIX 5.3 TL7 SP2, IZ11807

? AIX 5.3 TL6 SP5, IZ05462

Using msync() on anonymous memory region causes page out activity

Using msync() on an anonymous memory region can cause page out activity.? This can cause a noticeable performance degradation when starting Java 5 or Java 6 programs.

See these APARs for AIX 5.3:

? AIX 5.3 TL11, IZ52284

? AIX 5.3 TL10 SP2, IZ61049

? AIX 5.3 TL9 SP5, IZ60343

? AIX 5.3 TL8 SP8, IZ42991

? AIX 5.3 TL7 SP10, IZ61498

AIX may page out computational pages by mistake in some rare instances

See these APARs for AIX 5.3:

? AIX 5.3 TL9, IZ08649

? AIX 5.3 TL8, IZ15692

Oracle RAC 11gR2 installation error: INS-13001 Environment does not meet minimum requirements

See metalink note 986657.1.? This is the root cause of the Oracle Universal Installer errors:

# /bin/oslevel

5.3.9.0

# /bin/oslevel ?s

5300-09-02-0849

In this case, the first command should return:

# /bin/oslevel

5.3.0.0

See these APARs for AIX 5.3:

? AIX 5.3 TL8, IZ69573? AIX 5.3 TL9, IZ69389? AIX 5.3 TL10, IZ69221? AIX 5.3 TL11, IZ65067

< Return to AIX V5.3 list >

Additional AIX 5.3 support information:

If using AIX 5.3 TL 03 for any Oracle product, install the PTF for APAR IY76140.

Note: AIX 5.3 will be the last AIX 5L release that is certified for Oracle Applications E-Business Suite 11.0.3 deployments.

< Return to AIX V5.3 list >

IBM Software Requirements and PTFs for AIX 5.2 support of Oracle Database 10g Release 2 (10.2.0.1):

The requirements for the software products certified on Oracle Database 10gR2 with AIX 5.2 are described in this section.

Use AIX 5.3 ML 04 or higher, make sure to include the fixes for the following APARs:

IY63133

IY64978

IY63366

IY64691

IY65001

IY64737

IY75901, if IY69518 was previously installed.

IY70029: “CORRUPTION FROM SIMULTANEOUS CIO WRITES WITH O_DSYNC ON JFS2” If using the IBM Journal File System Version 2 (JFS2) for Oracle Database files.

HACMP

For AIX 5.2 and Oracle RAC 10gR2, HACMP 5.2 is certified.

HACMP 5.2 plus

IY60759: "ODM PERMISSION CHANGES REQUIRED TO SUPPORT ORACLE"

GPFS

For AIX 5.2 and Oracle RAC 10gR2, GPFS 2.3 is certified.

GPFS 2.3, use GPFS 2.3.0.3 (GPFS 2.3.0.0 plus IY63969) and these APAR fixes:

IY69911

IY70276

IY70277

IY74097

Users should review MetaLink Note 302806.1 for the software version or patches required and the latest GPFS information.

JDK

SDK 1.4 64-bit 1.4.2.1 IY63533

SDK 1.4 32-bit 1.4.2.2 IY65305

SDK 1.3.1.16 32-bit IY58350

C/C++ Compiler

May 2005 XL C/C++ Enterprise Edition V7.0 for AIX PTF (7.0.0.2)

This can be downloaded from:

http://www-1.ibm.com/support/docview.wss?uid=swg24009787

Or by downloading the PTFs and all prerequisites and corequisites for the following APARS:

IY65361

IY65362

Required AIX filesets

The following filesets must be installed:

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.libperfstat

bos.perf.perfstat

bos.perf.proctools

rsct.basic.rte (For RAC configurations only)

rsct.compat.clients.rte (For RAC configurations only)

xlC.aix50.rte:7.0.0.4 (See the following note)

xlC.rte:7.0.0.1 (See the following note)

These 2 required xlC file sets are provided by the installation of the “IBM XL C/C++ Enterprise Edition V7.0” compiler or the “IBM XL C/C++ Enterprise Edition V7.0 for AIX Runtime Environment Component”. Note also that the “VisualAge C++ V6.0 Runtime Environment for AIX” is installed by default since it is packaged with the current distributions of AIX 5L V5.3 and V5.2.

Therefore, Oracle Database 10g Release 2 users who do not install the “IBM XL C/C++ Enterprise Edition V7.0” compiler must install the “IBM XL C/C++ Enterprise Edition V7.0 for AIX Runtime Environment Component”. This can be easily downloaded, with no license requirement from:

http://www-1.ibm.com/support/docview.wss?uid=swg24009788

< Return to AIX 5.2 list >

IBM Software Requirements and PTFs for AIX 5.2 support of Oracle Database 10g Release 1 (10.1.0.x) or Oracle9i Database Release 2 (9.2.0.5 or higher)

The requirements for the software products certified on Oracle Database 10gR1 or 9i Release 2 with AIX 5.2 are described in this section.

Use AIX 5.3 ML 04 or higher, make sure to include the fixes for the following APARs.

Note: Maintenance Level 04 (ML04) contains both:

Recommended maintenance updates for all AIX 5L V5.2 installations.

Support code for POWER5 processor-based servers.

IY64978
Possible system hang while concurrently renaming and unlinking under JFS.

This APAR is currently available from the Fix Central download Web site located at:

http://www-1.ibm.com/servers/eserver/support/pseries/aixfixes.html

IY63366
Loader may fail to find symbol even though the symbol is present in the symbol table. This can cause applications that use dynamically loaded modules to fail. Prior to APAR availability, an emergency fix is available at:

ftp://service.software.ibm.com/aix/efixes/iy63366/

IY59082
Heavily loaded systems running JFS2 file systems may hang.

AIX 5.2 systems with the kernels filesets (bos.mp, bos.mp64, bos.up) at the 5.2.0.40 level, and using JFS2 file systems should apply the fix for this APAR.

IY75901
If the PTF for IY69518 has been previously installed, the PTF for IY75901 must be installed to correct a regression introduced in the PTF for IY69518.

IY70029
“CORRUPTION FROM SIMULTANEOUS CIO WRITES WITH O_DSYNC ON JFS2” If using the IBM Journal File System Version 2 (JFS2) for Oracle Database files.

In addition, customers may need to install one or more of the following emergency fixes:

Systems running bos.rte.lvm 5.2.0.41 or later should install APAR IY64691. APAR IY64691 fixes a problem with the “chvg-B” command that can cause data corruption on Big volume groups which were converted from normal volume groups. Prior to APAR availability, obtain the emergency fix for APAR IY64691 from: ftp://service.software.ibm.com/aix/efixes/iy64691/

Systems running bos.rte.lvm 5.2.0.50 should install APAR IY65001. APAR IY65001 fixes a possible corruption issue with mirrored logical volumes. This APAR also contains the fix for APAR IY64691. Prior to APAR availability, obtain the emergency fix for APAR IY65001 from:ftp://service.software.ibm.com/aix/efixes/iy65001/

Systems running bos.rte.aio 5.2.0.50 should install APAR IY64737. APAR IY64737 fixes a problem where applications that use Asynchronous I/O (AIO) can cause a system hang. Prior to APAR availability, obtain the emergency fix for APAR IY64737 from: ftp://service.software.ibm.com/aix/efixes/iy64737/

HACMP

For AIX 5.2 and Oracle RAC 9i or 10gR1, HACMP 5.1 and 5.2 are certified.

HACMP V5.2 plus:

IY60759: "ODM PERMISSION CHANGES REQUIRED TO SUPPORT ORACLE 9i"

HACMP V5.1 plus:

U498114 and all co-requisite PTFs.

GPFS

For AIX 5.2 and Oracle RAC 9i or 10gR1, the following versions of GPFS are certified:

GPFS 3.1.0.9 or higher:

For Oracle 9i (9.2.0.8) clusters on AIX

GPFS 2.3.0.1 (GPFS 2.3 plus APAR IY63969 - or later) plus:

PTFs for APARs IY69911, IY70276, IY70277 and IY74097.

For Oracle 9i clusters and 10gR1 RAC

GPFS 2.3.0.1 (GPFS 2.3 plus APAR IY63969 - or later) plus:

PTFs for APARs IY69911, IY70276, IY70277 and APAR IY74097

For Oracle 9i clusters and 10gR1 RAC

All new Oracle and GPFS customers on AIX 5L V5.2 should use GPFS 2.3.0.1 – or later.

Current GPFS 2.1 and 2.2 customers are encouraged to upgrade to GPFS 2.3.0.1 – or later.

GPFS 2.2.1.1 (GPFS PTF 6)

For Oracle 9i clusters and 10gR1 RAC

GPFS 2.1 plus:

U489058, U496347, U496395, IY52454

For Oracle 9i clusters and 10gR1 RAC

Users should review MetaLink Note 302806.1 for the software version or patches required and the latest GPFS information.

PSSP

PSSP 3.4 or PSSP 3.5

JDK

IBM JDK 1.3.1.11 (32 bit) IY47055

IBM JDK 1.4.1.2 (32 bit) IY47536

IBM JDK 1.4.1.1 (64 bit) IY47538

C/C++ Compiler

VAC 6 C and C++ for AIX July PTF (6.0.0.4) U489726

Required AIX filesets

The following filesets must be installed and committed:

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.libperfstat

bos.perf.perfstat

bos.perf.proctools

< Return to AIX 5.2 list >

Oracle bug fixes for AIX 5.2 interoperability:

For Oracle Database 10g Release 1 or Release 2:

If using the Automatic Storage Management (ASM) feature in Oracle Database 10g.

For optimal performance when using raw hdisks (/dev/rhdisk), the PTF for APAR IY57148 should be installed. Note: This PTF is included in AIX 5.2 ML04 and AIX 5.3.

Oracle Database 10g RAC users using AIX 5.2 ML04 who are not using HACMP should install the PTF for APAR IY63133 or upgrade to ML05.

< Return to AIX 5.2 list >

Additional AIX 5.2 support information:

If using AIX 5.2 Maintenance Level 7 (ML07) for any Oracle product, install the PTF for APAR IY76141.

< Return to AIX 5.2 list >

Important fixes or issues not specific to an AIX release:

For Oracle Database 11g Release 1 (11.1.0.6 or higher)

Bug 6782569: 11g Install AIX VIPS do not start.

This fix is required when using the IBM Logical Host Ethernet Adapter (LHEA) for the Oracle RAC Public or VIP interfaces.

< Return to list >

For Oracle Database 10g Release 2 (10.2.0.1 or higher)

Using medium or large pages in 10.2.0.4
The fix for bug 7226548 is necessary for large (16MB) pages and for medium (64KB) pages to work correctly on Oracle RAC 10.2.0.4.? The information that patch 7226548 is necessary for medium pages to work correctly is left out of the bug documentation.

Bug 8725020: VIP WONT RUN (LHEA) ADAPTER

The entstat output for the logical Host Ethernet Adapter (LHEA) is different from a regular adapter.? The racgvip script uses entstat ouput to determine if the interface is up or not.? See MetaLink Note 959746.1 for details.

Bug 6608472: RACGVIP IN RAC FOR AIX FAILS EVEN THOUGH THE PUBLIC INTERFACE IS UP

This fix is required when using the IBM Logical Host Ethernet Adapter (LHEA) for the Oracle RAC Public or VIP interfaces.? See MetaLink Note 567286.1 for details.

Bug 5005135 and Note 358365.1: Possible Corruption in the OCR after installing 10.2.0.1 on AIX.

The fix is recommended for all Oracle 10.2.0.1 RAC customers. The error messages are documented in MetaLink note 358365.1. Note: If this patch is installed then the PTF for APAR IY73570: " Aug 2005 IBM C++ Runtime Environment for AIX" or higher, must also be installed.

Bug 4455512: Oracle Database 10gR2 patch for slow Oracle instance startup when using Oracle ASM.

This is only required if using the ASM feature of Oracle Database 10gR2.

Bug 4635088: Oracle Database 10gR2 PARALLEL LOAD HANGS DURING LOAD CREATE TABLE AS SELECT FROM EXTERNAL TABLE

All Oracle Database 10gR2 RAC customers should install this fix since it also contains other important RAC fixes.

Bug 4437469: RACGVIP NOT WORKING ON SERVER WITH ETHERNET VIRTUALISATION

This is only required if using AIX Virtual Interfaces for the Oracle Database 10.2.0.1 RAC public network.

< Return to list >

For Oracle Database 10g Release 1 (10.1.0.2 and 10.1.0.3)

Oracle cluster interconnect may not be correctly defined after the Oracle CRS install

After CRS installation is completed, verify that the public and cluster interconnect have been set to the desired values by entering the following commands as root:

Note: oifcfg is found in the /bin/oifcfg

$ oifcfg getif

This command should return values for global “public” and global “cluster_interconnect”; for example:

en0 144.25.68.0 global public

en5 192.168.100.0 global cluster_interconnect

If the command does not return a value for global cluster_interconnect, enter the following commands:

# oifcfg delif -global

# oifcfg setif -global /:public

# oifcfg setif –global /:cluster_interconnect

For example:

# oifcfg delif -global

# oifcfg setif -global en0/144.25.68.0:public

# oifcfg setif -global en5/192.168.100.0:cluster_interconnect

Enter the following command to verify the new settings:

# oifcfg getif

< Return to list >

Oracle Universal Installer (OUI) for Oracle Database 10g Release 1 CRS will not display more than 3 network interfaces. This issue only applies to 10gR1 (10.1.0.2 and following)

Problem: if you install Oracle Database 10g on a system with more than 3 network interfaces, not all of the interfaces are displayed in the menu used to select the public and private interconnect. If the 3 interfaces displayed include all the ones that you are planning to use, proceed with the normal OUI configuration. If the 3 interface displayed do not include all the desired interfaces, use the following workaround:

Select the most appropriate public and private interconnect from the 3 interfaces which are listed in the menu.

Complete the installation.

After the installation, change the interconnects by entering the following commands as root:

Note: oifcfg is found in the /bin/oifcfg

If the command does not return a value for global cluster_interconnect, enter the following commands:

# oifcfg delif -global

# oifcfg setif -global /:public

# oifcfg setif –global /:cluster_interconnect

For example:

# oifcfg delif -global

# oifcfg setif -global en0/144.25.68.0:public

# oifcfg setif -global en5/192.168.100.0:cluster_interconnect

Enter the following command to verify the new settings:

# oifcfg getif

For Oracle Database 10g Release 1 (10.1.0.4 only) RAC

All Oracle 10.1.0.4 RAC customers should install the Oracle patches for bugs 4332858 and 4277281.

All Oracle 10.1.0.4 RAC customers using GPFS should also install the Oracle patch for bug 4487491.

Bug 4437469: RACGVIP NOT WORKING ON SERVER WITH ETHERNET VIRTUALISATION

This is only required if using AIX Virtual Interfaces for the Oracle 10.1.0.4 RAC public network.

< Return to list >

For Oracle9i Database Rel 2 (9.2.0.4)

Oracle Bug 3284426: Oracle 9.2.0.4 customers using jfs2 must install this patch to avoid severe performance degradation.

Note: This was previously listed in this document as Oracle Bug 3224502: “IDENTIFYING A JFS2 FILE SYSTEM TYPE AS A MMFS” however, using the 3284426 bug number will make the patch easier to find.

< Return to list >

For Oracle9i Database Rel 2 (9.2.0.5)

Oracle Bug 3393861: "GSD does not start on AIX 5L"

In a non RAC environment, OPATCH may fail indicating missing AIX libraries.

The installation of the Oracle 9.2.0.5 patch (bug 2997330) using the OPATCH utility may fail in a non RAC environment with error messages indicating missing RAC related libraries such as:

" ha_gs_64_r and ha_em_r "

In a non RAC environment, these libraries are not needed.

Proceed with the following steps to resolve this problem by recreating the correct executable:

Using your oracle user id: " cd $ORACLE_HOME/rdbms/lib "

and then issue the following commands

“ make -f ins_rdbms.mk rac_off “

“ make -f ins_rdbms.mk ioracle “

SQL*PLUS command will show a default value of "async" for the “filesystemio_options” parameter instead of the correct "asynch" value

After installing patchset 9.2.0.5, the v$parameter view and the `show parameter filesystemio_options` SQL*PLUS command will show a default value of "async" for filesystemio_options parameter instead of the correct "asynch" value. This will not affect the behavior of your database, which will correctly use asynchronous I/O by default, even though the view and command show the incorrect value.

When setting the “filesystemio_options” parameter in the init.ora file, continue to use the documented values, not "async".

< Return to list >

For Oracle9i Database Rel 2 (9.2.0.6)

Customers upgrading to 9.2.0.6 should prepare to immediately address the following 2 issues.

MetaLink Note 294658.1: Wrong Platform ID during patch application after applying the 9.2.0.6 patchset.

Oracle OPatch will fail when attempting to apply any additional patches after the 9.2.0.6 upgrade. MetaLink Note 294658.1 provides the manual instructions to fix this problem. NOTE: This fix must be implemented before any additional patches can be applied.

Oracle Bug 4081980: AFTER APPLYING THE 9206 PATCHSET YOU CAN NO LONGER CREATE A DATABASE

The ORACLE_HOME/rdbms/admin/prvtfile.plb becomes 0 bytes after the 9.2.0.6 upgrade. The patch for bug 4081980 will restore the prvtfile.plb file.

Oracle9i Database RAC users may also want to apply the fix for the following issue.

Oracle Bug 4074633: AIX5L - Higher CPU usage in RAC background processes in 9.2.0.6

< Return to list >

For Oracle Applications 11i Rel (11.5.x) and 11.0.x

All Oracle Application users with Oracle Forms 6i (6.0.8.x.y) or 4.5 (4.5.10.22) should apply the following Oracle Forms patch.

The problem will most likely be seen after applying Maintenance Level 3 (ML03) for AIX 5L V5.3 but can also occur on any AIX 5L version and maintenance level.

When a form is obtaining a long “list of values”, the operation may fail and the following two Oracle Forms error messages will be displayed.

FRM-40815 : Variable GLOBAL.LLL10 does not exist

FRM-40502 : Oracle error : unable to read list of values.

The current Oracle bugs associated with this problem are as follows; be sure to specify your Oracle Forms version to obtain the correct patch:

Bug 4670400: This is the main bug for the above problem. Patch for this bug is for Forms version 6.0.8.25.x (Patch 16) only.

Bug 4689213: Backport for Forms 6.0.8.24.x (Patch 15)

Bug 4689364: Backport for Forms 6.0.8.26.x (Patch 17)

Bug 4950777: Backport for Forms 4.5.10.22 (with Oracle Applications 11.0.x)

Only 32 bit JDK should be used for Oracle Applications 11i or 11.0.x.

When performing the RapidWiz installation for Oracle Applications 11i Rel (11.5.x) or 11.0.x, the user should only enter the path for the supported 32 bit JDK. Example: “usr/java131/”. 64 bit JDK may be installed for use by other products but can not be used for Oracle Applications.

< Return to Master list >

Important information regarding IBM products used with Oracle

Customers using the IBM FlashCopy feature should refer to MetaLink note 300225.1 for updated information.

For customers who link their Oracle Database 10g Release 1 or Oracle9i Database user applications with libocci.a and have upgraded to the “IBM XL C/C++ Enterprise Edition V7.0” runtime environment.

In this environment, some C++ string operations (For example: “operator+”) will not work properly.

The work around is to make sure that “libC.a” precedes “libocci.a” in your user application link line by changing the "-locci" to "-lC -locci" at the link line. See the following example:

A sample application ‘mytest.cpp’ requires libocci.a at link time in order to resolve few symbols. The typical compile and link line may look like:

$ xlC mytest.cpp -locci

To work around the problem, change the compile/link line to:

$ xlC mytest.cpp -lC -locci

Note: The following commands can be used to check the current version of the C/C++ runtime environment:

$ lslpp -l | grep xlC.rte

xlC.rte 7.0.0.1 COMMITTED C Set ++ Runtime

$ lslpp -l | | grep xlC.aix50.rte

xlC.aix50.rte 7.0.0.3 COMMITTED C Set ++ Runtime for AIX 5.0

< Return to list >

MetaLink notes addressing AIX FAQs

Note 559365.1 Using Diagwait as a diagnostic to get more information for diagnosing Oracle Clusterware Node evictions

Note 454507.1 Oracle 11g Release 1 (11.1) Support Status and Alerts

Note 404474.1: Status of Certification of Oracle Clusterware with HACMP

Note 302806.1: IBM General Parallel File System (GPFS) and Oracle RAC

Note 183340.1: FAQ about the CLUSTER_INTERCONNECTS Parameter in 9i.

Note 295142.1: AIX RAC Using Public Service IP Label/Address results in 2nd instance startup hang

Note 279054.1: RAC on AIX: Number of Serviceable Networks Detected Is Less Than 2

Note 316817.1: CLUSTER VERIFICATION UTILITY FAQ

Note 43208.1: Certified Compilers

Note 169706.1: Oracle Database on Unix AIX, HP-UX, Linux, Mc OS X, Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

< Return to list >

Appendix A: Previous manual workarounds for Configuration Assistants failing with "ENOEXEC" error:

The solution for the each is to:

Click ?OK? on the error pop-up and leave the main Configuration Assistant window up and running.

Identify the command that failed by:

Editing the OUI install log /.../oraInventory/logs/installActions.log

Finding the ENOEXEC error message in the log for the failed configuration assistant

scroll back a few lines from the ENOXEC error message to find the text "The command being spawned is: " and note the complete path for the command.

Edit the actual command that was spawned and insert the fix.

Click the ?retry? button on the Configuration Assistant to continue.

Failure 1 Example: ?Delegated Administration Service Configuration Assistant?

Example of contents of /.../oraInventory/logs/installActions.log for this failure:

Launched configuration assistant 'Delegated Administration Service Configuration

Assistant'

Tool type is: Recommended.

The command being spawned is: '/iasinst/install/bin/oidca mode=DAS sslport=3130

sudn=cn=orcladmin oidhost=jade supwd=058d47ace90a48a1650f984e40d0726c987b4ec8fce

dac7021 -silent apachehost=jade apacheport=7780 -crypto'

< .... lines deleted ... >

Exception in thread "main" java.lang.UnsatisfiedLinkError: /iasinst/install/lib3

2/libjmisc.so: load ENOEXEC on shared library(s) /iasinst/install/lib32/libjmisc.so

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

Therefore, the command spawned is "/iasinst/install/bin/oidca"

Save a copy of the original script: "cp /iasinst/install/bin/oidca /iasinst/install/bin/oidca_orig"

Edit /iasinst/install/bin/oidca and insert the line "unset LDR_CNTRL" at the top of the script, as in the following example:

#!/bin/ksh

unset LDR_CNTRL

export ORACLE_HOME=/iasinst/install

Click the ?retry? button on the Configuration Assistant to continue.

Failure 2 Example: ?Single Sign-On Configuration Assistant?

Example of contents of /.../oraInventory/logs/installActions.log

Launched configuration assistant 'Single Sign-On Configuration Assistant'

Tool type is: Recommended.

The command being spawned is: '/iasinst/install/sso/bin/ssoca config /iasinst/in

stall "cn=orcladmin" 058d47ace90a48a1650f984e40d0726c987b4ec8fcedac7021 "AMERICA

N_AMERICA.WE8ISO8859P1" http jade 7780 en'

Start output from spawned processes

Therefore, the command spawned is "/iasinst/install/sso/bin/ssoca"

Save a copy of the original script: ?cp /iasinst/install/sso/bin/ssoca /iasinst/install/sso/bin/ssoca_orig?

Edit /iasinst/install/sso/bin/ssoca and insert the line "unset LDR_CNTRL" in the script, as in the following example:

# Define ORACLE_HOME -> OH

OH=/iasinst/install

export OH

unset LDR_CNTRL

ORACLE_HOME=$OH

Click the ?retry? button on the Configuration Assistant to continue.

Failure 3 Example: "Portal Configuration Assistant"

Note: The "ENOEXEC" error will not appear in the /.../oraInventory/logs/installActions.log

Example of contents of /.../oraInventory/logs/installActions.log for this failure:

Launched configuration assistant 'Portal Configuration Assistant'

Tool type is: Recommended.

The command being spawned is: '/iasinst/install/assistants/opca/launch.sh'

Start output from spawned process:

----------------------------------

Portal Configuration Assistant failed. Refer to /iasinst/install/assistants/opca/install.log for details.

End output from spawned process.

----------------------------------

Configuration assistant "Portal Configuration Assistant" failed

Portal Configuration Assistant failed. Refer to /iasinst/install/assistants/opca/install.log for details.

Result code for launching of configuration assistant is: 1

The "/iasinst/install/assistants /opca/install.log" will contain the following entries or similar:

Ultrasearch Middle tier configuration

INSTALL_ERROR : Ultrasearch Configuration Assistant throws exception : /iasinst/

install/lib32/libjmisc.so: load ENOEXEC on shared library(s) /iasinst/install/l

ib32/libjmisc.so

Portal configuration aborted.... "

Therefore, perform the following steps:

cd /iasinst/install/assistants/opca/

cp launch.sh launch.sh.orig

mv launch.sh launchts.sh

Edit to create a new "launch.sh" with the following contents:

#!/bin/ksh

unset LDR_CNTRL

/$ORACLE_HOME/assistants/opca/launchts.sh

Save and set execute permissions on the new "launch.sh" to match those on "launch.sh.orig".

Click the ?retry? button on the Configuration Assistant to continue.

--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------

Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
Keywords
--------------------------------------------------------------------------------
JAVA.LANG.UNSATISFIEDLINKERROR; UPGRADE~TO~2.3.0.1; UPGRADE~TO~9.2.0.6
Errors
--------------------------------------------------------------------------------
FRM-40502; FRM-40815; 91120 ERROR; 600 ERROR; OUI-18001; INS-13001

Rate this document

Article Rating
Rate this document
Excellent
Good
Poor

Did this document help you?
Yes
No
Just browsing

How easy was it to find this document?
Very easy
Somewhat easy
Not easy
Comments
Provide some feedback

Cancel