| Oracle® Database Release Notes 10g Release 2 (10.2) for AIX Part Number B19074-12 |
|
| View PDF |
| Oracle® Database Release Notes 10g Release 2 (10.2) for AIX Part Number B19074-12 |
|
| View PDF |
Release Notes
10g Release 2 (10.2) for AIX
B19074-12
November 2009
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 and 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/technology/documentation/
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:
The latest certification information for Oracle Database 10g release 2 (10.2) is available on OracleMetaLink at:
JDK 5 Certification
Starting with Oracle Database10g release 2 (10.2.0.2), JDK 5 is supported for JDBC applications.
AIX 6.1 Certification
Starting with Oracle Database 10g release 2 (10.2.0.3), AIX 6.1 (64 bit) operating system is supported. Refer to "Preinstallation Requirements" for more information
The latest information on patches and support for this release is available in OracleMetaLink document 282036.1.
ODBC Certification
Starting with Oracle Database 10g release 2 (10.2.0.4), ODBC driver is supported on AIX operating systems.
The following products are not supported with Oracle Database 10g release 2 (10.2):
Grid Control Support
Oracle Database 10g release 2 (10.2) can be managed as a target by Grid Control 10.1.0.4. However, Oracle Database 10g release 2 is not supported by Grid Control 10.1.0.4 as a repository.
JDBC 1.2 driver
JDBC 1.2 driver is not supported on AIX 5.3
Radius with the CHAP protocol
Network Attached Storage (NAS) Devices
The following products and documentation are located on the first DVD:
Oracle Database 10g release 2 (10.2) software and documentation
Oracle Database Companion Products 10g release 2 (10.2) software and documentation
Oracle Database 10g release 2 (10.2) Documentation Library
The following products and documentation are located on the second DVD:
Oracle Clusterware 10g release 2 (10.2) software and documentation
Oracle Database Client 10g release 2 (10.2) software and documentation
Oracle Gateway 10g release 2 (10.2) software and documentation
Oracle Database 10g release 2 (10.2) Documentation Library
In addition to the information in the installation guides, the following section contains the system requirements for AIX 6.1.
You must review the following sections before installing Oracle Database on AIX 6L:
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 01 (6100-00-01) or later.
Refer to Oracle Database Installation Guide for AIX 5L Based Systems (64-Bit) for additional information on operating system listings.
The following filesets are supported on Oracle Database 10g release 2:
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
xlC.rte:9.0.0.1
Installing on AIX 6L requires the following installations:
Oracle patch 6613550
Oracle Database 10g release 2 (10.2.0.1)
Oracle Database patch set 10g release 2 (10.2.0.3)
Oracle Database 10g Release 2 (10.2) supports 32-bit kernel for single-instance databases but does not support 32-bit kernel for Oracle Real Application Cluster (RAC).
Unlimited shell values must be set for both the Oracle installation owner (oracle) and the root user. The root user requirement for unlimited is needed because the Oracle Clusterware daemon (crsd) runs as root.
Configure the shell limits setting to unlimited either by using the smit utility or by editing the /etc/security/limits file. Add the following lines to the limits file:
rss = -1 data = -1
This requirement supplements the description of shell limits in "Section 2.4.1, Configure Shell Limits" in Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for AIX Based Systems 10g Release 2 (10.2).
Review the following sections for information about issues that affect Oracle Database installation, configuration, and upgrade:
Upgrading of Oracle9i to Oracle Database 10g Release 2 on Raw Devices
Upgrading Oracle Cluster Ready Services (CRS) from Release 10.1.0.2
Installing Standard Edition on Automated Storage Management (ASM)
Installing Oracle Database Client into an Existing Oracle Home
For late-breaking updates and best practices about preupgrades, postupgrades, compatibility, and interoperability discussions refer to note 466181.1 on OracleMetaLink (https://metalink.oracle.com/) that links to "10g Upgrade Companion" page.
Oracle RAC on AIX 5.3 requires a 64-bit kernel. Refer to OracleMetaLink Note 169426.1 for instructions for switching between the 32-bit and 64-bit AIX kernels.
The list of supported installation options and supported storage types for Oracle Clusterware, Oracle RAC, and vendor clusterware are described in this section. Oracle plans to support additional Oracle Clusterware and Oracle RAC configurations in the future. Please check for updates to this document for the latest list of supported installation scenarios on the OTN Web site at:
http://www.oracle.com/technology/documentation/
Note:
Environment variablesTMP and TMPDIR should not point to a shared file system. These variables must point to a local file system. Similar behavior exists in Oracle Database 10g release 1. This issue is tracked with Oracle bug 4553122.Use the following upgrade process if the database files are created on plain raw devices not using Logical Volume Manager (LVM). These steps are needed due to the skip offset differences between Oracle9i release 2 and Oracle Database 10g release 2. The skip offset for Oracle9i release 2 is 4k bytes. Starting with Oracle Database 10g release 2, the skip offset is 0 bytes.
Back up the database.
Back up each of the database file on the plain raw disks to a file using following command:
# dd if=db_disk_name of=backup_file_name bs=512 skip=8
Restore the backed up database file to the disk using following commands:
# dd if=backup_file_name of=db_disk_name bs=512
Follow the manual upgrade steps documented in Oracle Database Upgrade Guide.
To install Oracle Security Manager, install Oracle Client and then select the Administrator installation type.
This section lists the additional steps required when running the preupdate and rootupgrade scripts:
When upgrading Oracle Cluster release 10.1 to 10.2, run the following command as the root user after running the preupdate.sh script and then complete the Oracle Clusterware release 10.2 installation:
/usr/sbin/slibclean
When upgrading Oracle Clusterware release 10.1.0.2, activate the volume group before running the rootupgrade script. Use the following command to activate the volume group:
/usr/sbin/vgchange -a s vg1
where vg1 is the volume group that stores the OCR and voting disks.
When installing Standard Edition and the starter database on Oracle Automated Storage Management (ASM), the Email enabled notification check box on the Select Database Management Option page is disabled.
This issue is tracked with Oracle bug 4553151.
To enable the extjob executable to locate required libraries, the $ORACLE_HOME/lib directory and all of its parent directories must have execute permissions for group and other.
When modifying the name, IP address, or netmask of an existing virtual IP address (VIP) resource, use the srvctl modify nodeapps command and include the existing interfaces for the VIP in the -A argument. For example:
srvctl modify nodeapps -n mynode1 -A 100.200.300.40/255.255.255.0/eth0
This issue is tracked with Oracle bug 4500688.
If you have downloaded Oracle Database 11g release 1 prior to 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/technology/software/products/database/oracle11g/111060_aixsoft.html
You must install Oracle Database Patch 6613550, Oracle Database 10.2.0.1, and Oracle Database Patch set 10.2.0.3 to proceed with the installation on AIX 6L. The following section lists all the installation steps:
Download patch 6613550:
Log on to OracleMetaLink. You must have a valid OracleMetaLink Support Identifier (CSI) for it. Refer to https://metalink.oracle.com/ for more information.
Enter 6613550 in the Quick Find field, click Go.
Download patch 6613550 into a temporary directory on your computer.
Switch user to root:
$ su - password: #
Unzip the files of this patch into /temp folder:
cd /temp
Run the rootpre.sh script as follows:
# ./rootpre.sh
Set the LANG parameter to C for the remaining steps, as follows:
Bourne shell (sh), or Korn shell (ksh), or Bash shell (bash):
$LANG=C
C shell (csh):
% setenv LANG C
Install Oracle Database 10.2.0.1:
Run Oracle Universal Installer with -ignoreSysPrereqs option:
$ ./runInstaller -ignoreSysPrereqs
In the Select Installation Type screen, select Enterprise Edition installation type.
In the Product-specific Prerequisites Checks page, check the following errors as user specified to continue with the installation:
Checking operating system requirements
Checking recommended operating system patches
In the Select Configuration Option screen, select Install Database Software only option.
To install Patch Set Release 10.2.0.3, run Oracle Universal Installer with -ignoreSysPrereqs option as follows:
$ ./runInstaller -ignoreSysPrereqs
You must refer to patch set release note for preinstall, install, postinstall, and other known issues. Refer to metalink note 316900.1 for more information.
Create a database:
Run Oracle Database Configuration Assistant as follows:
$ORACLE_HOME/bin/dbca
Select General Purpose Database to create a starter database.
Note:
IfLang=Ja_JP, then Enterprise Manager Database Control fails to configure. To reconfigure Enterprise Manager Database Control, use the following steps:
% export LANG=C
% emca -deconfig dbcontrol db
% emca -repos drop
% emca -repos create
% export ORACLE_HOSTNAME=hostname
% emca -config dbcontrol db
% emctl start dbconsole
This issue is tracked with the Oracle bugs 4711923, 6278227, 4997291.
Oracle Database Client can be installed in the same Oracle Database home if both products are at the same release level. For example, you can install Oracle Database Client 10g Release 2 (10.2) into an existing Oracle Database 10g Release 2 (10.2) home. If you apply a patch set before installing the client, then you must apply the patch set again.
If you perform a Custom installation, then ensure that you install only the components covered by your license. You can not install Standard Edition using Custom installation.
The following sections contain information about issues related to Oracle Database 10g and associated products:
There is a performance issue with Generic Connectivity (hsodbc). On the first query of a new connection, there could be significant delay up to several minutes. All subsequent SQL issued through the same dblink session will proceed without delay.
Check Oracle bug 4549924 for patch availability.
Oracle Wallet Manager will fail to recognize the user certificate as valid if you capture the user certificate contents from the Oracle Certificate Authority site and save this as a flat file. This is because when saving as a flat file, all the lines of the user certificate are run together with no line breaks.
Workaround: Edit the user certificate. Insert a new line after -----BEGIN CERTIFICATE----- and a new line before -----END CERTIFICATE-----.
Do not remove the key values for the wait class metrics. Doing so removes them permanently and currently there is no easy way to recover them.
This issue is tracked with Oracle bug 4602952.
If you use Hitachi HDLM (dmlf devices) for storage, then automatic storage instances do not automatically identify the physical disk. Instead, the instances identify only the logical volume manager (LVM). This is because the physical disks can only be opened by programs running as root.
Physical disks have path names similar to the following:
/dev/rdlmfdrv8
/dev/rdlmfdrv9
Note:
To use ASM with HDLM, refer to Hitachi Dynamic Link Manager (HDLM) documentation or Hitachi support.This section lists the following corrections to the installation guides for AIX 5L- based Systems (64-Bit):
In Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide, Chapter 2, "Preinstallation," in the section "Oracle Clusterware Home Directory," it incorrectly lists the path /u01/app/oracle/product/crs as a possible Oracle Clusterware home (or CRS home) path. This is incorrect. A default Oracle base path is /u01/app/oracle, and the Oracle Clusterware home must never be a subdirectory of the Oracle base directory.
A possible CRS home directory is in a path outside of the Oracle base directory. for example, if the Oracle base directory is u01/app/oracle, then the CRS home can be an option similar to one of the following:
u01/crs/ /u01/crs/oracle/product/10/crs /crs/home
This issue is tracked with Oracle bug 5843155.
The following text of the section 2.6.1, "IP Address Requirements," in Chapter 2, "Pre-Installation Tasks," of Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide states that the virtual IP address (VIP) should respond to a ping command:
During installation, Oracle Universal Installer uses the ping command to ensure that the VIP is reachable.
The preceding statement is incorrect. Before installation, the VIP address should be configured in DHCP or /etc/hosts, or both, but it must not be assigned to a server that can respond to a ping command.
This issue is tracked with Oracle bug 6017001.
Appendix H, "Database Limits" of Oracle Database Administrator's Reference for UNIX-Based Operating Systems states the incorrect maximum value (63) for the MAXINSTANCES variable. The correct maximum limit for the variable is 1055.
The following values documented in the section 2.2.3, "Disk Space Requirements," in Chapter 2, "Pre-Installation Tasks," of Oracle Database Installation Guide for AIX 5L Based Systems (64-Bit) is incorrect. The updated values are as follows:
Enterprise Edition 3.82 GB
Standard Edition 3.78 GB
Custom Install 3.95 GB
In Oracle documentation, Oracle inventory group is represented as oinstall. However, it is not mandatory to use the same name, you can enter a different name for this group.
In section 7, bullet 9, "Configuring the oracle User's Environment" in Oracle Database Client Quick Installation Guide for 10g Release 2 (10.2) AIX 5L Based Systems (64-Bit), the document says:
Add one of the following lines to the file to set the AIXTHREAD_SCOPE environment variable to S (system-wide thread scope):
Bourne shell (sh), Bash shell (bash), or Korn shell (ksh):
AIXTHREAD_SCOPE=S; export AIXTHREAD_SCOPE
C shell (csh or tcsh):
setenv AIXTHREAD_SCOPE S
This is incorrect. You don't need to set AIXTHREAD_SCOPE environment variable to S.
This issue is tracked with Bug 7243007.
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.
Deaf/Hard of Hearing Access to Oracle Support Services
To reach Oracle Support Services, use a telecommunications relay service (TRS) to call Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Information about TRS is available at http://www.fcc.gov/cgb/consumerfacts/trs.html, and a list of phone numbers is available at http://www.fcc.gov/cgb/dro/trsphonebk.html.
Oracle Database Release Notes, 10g Release 2 (10.2) for AIX
B19074-12
Copyright © 2006, 2009, 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.