Oracle® Database

Release Notes

11g Release 1 (11.1) for IBM AIX on POWER Systems

B32075-13

April 2011

This document contains important information that was not included in the platform-specific or product-specific documentation for this release. This document supplements Oracle Database Readme.

This document may be updated after it is released. To check for updates to this document and to view other Oracle documentation, refer to the Documentation section on the Oracle Technology Network (OTN) Web site:

http://www.oracle.com/technetwork/indexes/documentation/index.html

For additional information about this release, refer to the readme files located in the $ORACLE_HOME/relnotes directory.

Note:

The Database Quick Installation Guides are no longer available in printed format. These documents are available with the media in the same location as the software and on Oracle Technology Network.

This document contains the following topics:

1 Certification Information

The latest certification information for Oracle Database 11g Release 1 (11.1) is available on My Oracle Support (formerly OracleMetaLink) at:

https://support.oracle.com

AIX 6.1 Certification

AIX 6.1 (64-bit) is supported on Oracle Database 11g Release 1 (11.1.0.6). Refer to Preinstallation Requirements for more information.

ODBC Certification

Starting with Oracle Database 11g Release 1 (11.1.0.6), Oracle ODBC driver is supported on AIX. ODBC driver uses gcc 3.4.5 for compilation instead of the native compilers on AIX operating systems.

2 Unsupported Products

A list of unavailable features and products is available in Section 2, "Features Not Available or Restricted in This Release", in Oracle Database Readme.

3 Preinstallation Requirements

In addition to the information in the installation guides, the following section contains the system requirements for AIX 6.1:

Operating System Requirement

In addition to the supported operating systems listing in the installation guide, AIX 6L, version 6.1, 64-bit kernel is supported with service pack 04 or later.

Refer to Oracle Database Installation Guide for AIX 5L Based Systems (64-Bit) for additional information on operating system listings.

Operating System Filesets for AIX 6L

The following filesets are required for Oracle Database 11g Release 1 (11.1):

  • bos.adt.base

  • bos.adt.lib

  • bos.adt.libm

  • bos.perf.libperfstat

  • bos.perf.perfstat

  • bos.perf.proctools

  • xlC.aix61.rte:9.0.0.1 or later

  • xlC.rte:9.0.0.1 or later

Swap Space Guidance

Contact your operating system vendor for swap space allocation guidance for your server. The vendor guidelines supersede the swap space requirements listed in Oracle Database Installation Guide and Oracle Grid Infrastructure Installation Guide.

4 Software Contents in the Installation Media Pack

The media pack for this release consists of the following DVDs:

  • Oracle Database 11g Release 1 (11.1.0.6.0) for AIX 5L Based Systems (64-Bit) - This DVD contains the Oracle Database software, Oracle Database Installation Guide, Oracle Database Quick Installation Guide, and Oracle Database Release Notes for this platform.

  • Oracle Database 11g Release 1 Client (11.1.0.6.0) for AIX 5L Based Systems (64-Bit) - This DVD contains the Oracle Database Client software, Oracle Database Client Installation Guide, Oracle Database Client Quick Installation Guide, and Oracle Database Release Notes for this platform.

  • Oracle Clusterware 11g Release 1 (11.1.0.6.0) for AIX 5L Based Systems (64-Bit) - This DVD contains the Oracle Clusterware software, Oracle Cluster Installation Guide, Oracle Real Application Clusters Installation Guide, and Oracle Database Release Notes for this platform.

  • Oracle Database Documentation Library (11.1.0.6.0) - This DVD contains the documentation library for Oracle Database 11g.

5 Installation, Configuration, and Upgrade Issues

Review the following sections for information about issues that affect Oracle Database installation, configuration, and upgrade:

5.1 Latest Upgrade Information

For late-breaking updates and best practices about preupgrade, post-upgrade, compatibility, and interoperability discussions, refer to Note 601807.1 on My Oracle Support (formerly OracleMetaLink) (https://support.oracle.com) that links to "Oracle 11gR1 Upgrade Companion" page.

5.2 New Installation Media to Install Oracle HTTP Server

Use the Oracle Fusion Middleware Web Tier Utilities 11g (11.1.1.2.0) media to install Oracle HTTP Server.

5.3 Error in Copying Files While Upgrading Oracle Database 10g Release 2 to Oracle Database 11g

When you start upgrading second node from Oracle Database 10g Release 2 to Oracle Database 11g, an error message is displayed while copying files during the upgrade process.

Workaround: Run the upgrade session from the node on which you initially installed Oracle RAC.

This issue is tracked with Oracle bug 6501871.

5.4 Restarting the Listener for the Remote Node Displays an Error

Oracle database instance and listeners are not started after the installation is complete if you perform any of the following tasks:

  • Oracle 11g Database installation or upgrade on a cluster into an existing ORACLE_BASE directory that has other Oracle home(s)

  • Custom installation to install additional components in an existing Oracle RAC database home on Oracle Clusterware

You can run the Oracle_home/bin/srvctl command to display the status of Oracle database instance and listeners. When you try to start the listener for the remote node, the following error message is displayed:

TNS-01151: Missing listener name, LISTENER_NODE_NAME, in LISTENER.ORA

Workaround: Complete the following procedure for the remote node(s) on which the listener displayed an error message:

  1. Note the list of nodes on which the additional component installation is being performed. Write down the list of nodes selected in the Node Selection Page in Oracle Universal Installer.

  2. For each node selected in step 1, use the following command to backup Oracle_home/network/admin to Oracle_home/network/admin.orig before proceeding with the installation:

    $ cp -R Oracle_home/network/admin Oracle_home/network/admin.orig
    
  3. For each node selected in step 1, use the following command to restore Oracle_home/network/admin.orig to Oracle_home/network/admin after completing the installation:

    $ cp -R Oracle_home/network/admin.orig Oracle_home/network/admin
    
  4. Run the following command on local node for each nodes selected in step 1:

    $ Oracle_home/bin/srvctl start listener -n node_name
    
  5. If the Oracle Database instance for the remote node is down because of the listener, then start the Oracle database an instances that are down using the following command:

    $ Oracle_home/bin/srvctl start databse -d database_name
    

These issues are tracked with Oracle bugs 6412150 and 6612571.

5.5 The /etc/oratab File Lists Multiple Automatic Storage Management Instances

If you install Oracle Clusterware on share Oracle home, the /etc/oratab file lists multiple Automatic Storage instances.

Workaround: Oracle Universal Installer detects this issue during the pre-requisition checks. You can either edit the /etc/oratab file or ignore the error during installation.

The issue is tracked with Oracle bug 5942123.

5.6 Rootpre_aix.zip File Location

If you have downloaded Oracle Database 11g Release 1 before January 18, 2008 from Oracle Technology Network or media and were prompted to execute the rootpre.sh script, then you must install the rootpre_aix.zip file available on Oracle Technology Network:

http://download.oracle.com/otn/aix/oracle11g/rootpre_aix.zip

New customers do not have to download the rootpre_aix.zip file. You can directly download the Oracle Database 11g release 1 software available on Oracle Technology Network:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

5.7 Oracle Clusterware Upgrade Error

When upgrading Oracle Clusterware from release 10.2.0.4 to release 11.1.0.6, the rootupgrade script gives the following error:

Failed to retrieve VIP details.

In addition, the output of crs_stat -t shows that the Oracle Notification Service resource is offline on one or more nodes.

Workaround:

Rename CRS_HOME/jdk/jre/bin/sovvm to CRS_HOME/jdk/jre/bin/sovvm.bak before running the the rootupgrade script.

This issue is tracked with Oracle bug 7034395.

6 Other Known Issues

The following sections contain information about issues related to Oracle Database 11g and associated products:

6.1 Intermittent Errors While Using Oracle 11g Release 1 Direct NFS Client

When using Oracle 11g Release 1 Direct NFS client, the ORA-494 errors are displayed intermittently under certain load conditions.

Workaround: Oracle recommends that you apply the patch mentioned in the Oracle bug 6530092 to Oracle Database 11g Release 1 installation. The Oracle bug contains the details of the patch and application instructions.

This issue is tracked with Oracle bug 6530092.

6.2 Performance Graphs are not Shown in the Memory Access Mode

Monitoring in Memory Access Mode is not supported for this release on this platform. This option is disabled by default. If you enable this option, then the performance charts are not displayed and an error connection to collector memory is displayed at times.

Workaround: Use SQL Mode monitoring instead of Memory Access Mode.

This issue is tracked with Oracle bug 6498439.

6.3 Reactivate the OC4JADMIN User for Oracle Ultra Search

The OC4JADMIN user is deactivated during the Oracle Database 11g installation process. After the installation is complete, you must modify the $ORACLE_HOME/oc4j/j2ee/OC4J_SEARCH/config/system-jazn-data.xml file. Replace the following content of the file:

<user deactivated="true">
<name>oc4jadmin</name>
<display-name>OC4J Administrator</display-name>
<description>OC4J Administrator</description>

with:

<user>
<name>oc4jadmin</name>
<display-name>OC4J Administrator</display-name>
<description>OC4J Administrator</description>

Use the following commands to restart the Oracle Ultra Search middle tier in the Oracle Database:

$ $ORACLE_HOME/bin/searchctl stop
$ $ORACLE_HOME/bin/searchctl start

6.4 Oracle Clusterware Node Addition in Vendor Cluster Environment

When adding a node to the Oracle Clusterware in a vendor cluster environment that uses host names with fully qualified domain names, the rootaddnode.sh utility displays the following error message:

PRKO-2006 : Invalid node name: NODE_NAME

Workaround: For each node that is being added to the Oracle Clusterware, run the following command:

srvctl add nodeapps -n node_name_without_fully_qualified_ domain_name -A node-vip/netmask/Interfaces

Note:

To find the node name and virtual IP address/netmask/interface to be used for the newly added nodes, you can refer to values set for the following variables in the rootaddnode.sh script:
CRS_NEW_NODE_NAME_LIST=
CRS_NEW_NODEVIPS=
NETMASK=
NETIFs=

To find if the vendor clusterware is configured, run the $ORA_CRS_HOME/bin/lsnodes command. The lsnodes command displays the list of nodes in this case.

You can refer to rootaddnode.sh for the value that ORA_CRS_HOME is set to.

This issue is tracked with Oracle bug 6617499.

6.5 Missing Help Content When Running Assistants in a zh_TW Environment

Due to a JDK bug, online help pages appear blank when running Java applications such as, Oracle Database Configuration Assistant or Oracle Database Upgrade Assistant in a zh_TW environment (Chinese, Taiwan locale).

This issue is tracked with Oracle bug 7408773.

6.6 Oracle Database Configuration Assistant Fails to Re-register Oracle Database

Due to an IBM JDK issue, Oracle Database Configuration Assistant fails to re-register Oracle Database with Oracle Internet Directory, resulting in one of the following error:

  • Wallet Exception - Could not open wallet - Check password

    OR

  • Unable to create database entry in directory service - Wallet Exception - ArrayIndexOutOfBoundsException. error.

Workaround: Make a copy of the Oracle Database Configuration Assistant script, then edit the last line of the script to pass -Xjit:disableTreeSimplification flag to Java command line.

This issue is tracked with Oracle bug 7443504

7 Documentation Corrections and Additions

This section lists the following correction to the installation guide for AIX:

7.1 Incorrect Operating System Requirements

The "Operating System Requirements" section in chapter 2 of the Oracle Database Installation Guide for AIX 5L Based Systems (64-Bit), lists incorrect value AIX 5L version 5.3, TL 05, Service Pack 06.

The correct value is AIX 5L version 5.3, TL 05, Service Pack 06 or later.

7.2 Incorrect Control Size Value

Appendix H, "Database Limits" of Oracle Database Administrator's Reference for Linux and UNIX guide states incorrect value for control files as 10000 database blocks. The correct value is 25000 control file blocks with a block size of 4096 bytes.

7.3 TAPE_ASYNCH_IO and BACKUP_TAPE_IO_SLAVES Correction

The last two paragraphs of Appendix A.2.4, "Input-Output Slaves" of Oracle Database Administrator's Reference for Linux and UNIX guide have been modified as follows:

There are times when you must turn off asynchronous I/O. For example, if instructed to do so by Oracle Support for debugging. You can use the DISK_ASYNCH_IO and TAPE_ASYNCH_IO parameters to switch off asynchronous I/O for disk or tape devices. TAPE_ASYNCH_IO support is only available when the Media Manager software supports it and for Recovery Manager, if BACKUP_TAPE_IO_SLAVES is true.

Set the DBWR_IO_SLAVES parameter to greater than 0 only if the DISK_ASYNCH_IO parameter is set to false. Otherwise, the database writer process becomes a bottleneck. In this case, the optimal value on AIX for the DBWR_IO_SLAVES parameter is 4.

8 Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/support/contact.html or visit http://www.oracle.com/accessibility/support.html if you are hearing impaired.


Oracle Database Release Notes, 11g Release 1 (11.1) for IBM AIX on POWER Systems

B32075-13

Copyright © 2011, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.