Oracle® Database

Release Notes

10g Release 2 (10.2) for HP-UX PA-RISC (64-Bit)

B19067-12

February 2012

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/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:

- Certification Information

- Unsupported Products

- Software Contents on Installation Media

- Preinstallation Requirements

- Installation, Configuration, and Upgrade Issues

- Other Known Issues

- Documentation Corrections and Additions

- Documentation Accessibility

1 Certification Information

The latest certification information for Oracle Database 10g Release 2 (10.2) is available on My Oracle Support (formerly OracleMetaLink) at:

https://support.oracle.com

HP-UX 11.31 Certification

Starting with Oracle Database 10g Release 2 (10.2.0.2), in addition to the supported operating systems listing in the installation guide, HP-UX 11i V3 (11.31) is supported.

Refer to Oracle Database Installation Guide for HP-UX PA-RISC (64-Bit) for additional information on operating system listings.

Refer to "Preinstallation Requirements" for the list of patches, and compilers supported on Oracle Database 10g Release 2.

2 Unsupported Products

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.

- Radius with the CHAP protocol

- Network Attached Storage (NAS) devices
NAS devices are not supported on HP-UX 11.11.

- Oracle ODBC Driver

- Hyper-Messaging Protocol (HMP) is not supported for Oracle Clusterware and Oracle RAC 10g Release 2.

3 Software Contents on Installation Media

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

4 Preinstallation Requirements

In addition to the information in the installation guides, the following sections contain the system requirements for HP-UX 11.31:

- Operating System Filesets for HP-UX 11.31

- Compiler Requirements

- Oracle Messaging Gateways

- Java Development Kit

- ncsize Kernel Parameter

4.1 Operating System Filesets for HP-UX 11.31

The following patches are supported on Oracle Database 10g Release 2:

- PHKL_35900: 11.31 evacd performance, kvaddr leak panic

- PHKL_36248: 11.31 esctl cumulative patch

- PHKL_36249: 11.31 esdisk cumulative patch

- PHKL_35936: 11.31 call to read(2) or write(2) may incorrectly return -1

4.2 Compiler Requirements

The following compilers are supported on Oracle Database 10g Release 2:

- A.06.12 (HP C/aC++ Swlist Bundle - C.11.31.01) - February 2007 A.06.12 is the certified C++ Compiler.

- HP FORTRAN/90 - Feb 2007 is the certified compiler for Fortran 90.

4.3 Oracle Messaging Gateways

Oracle Messaging Gateway supports the integration of Oracle Streams Advanced Queuing (AQ) with the following software:

- WebSphere MQ (Server) 6.0

- Websphere MQ (Client) 6.0

4.4 Java Development Kit

The following JDKs are supported on Oracle Database 10g Release 2:

You can use HP JDK 5.0.07 with the Oracle Java Database Connectivity and Oracle Call Interface drivers. Ensure that you install the patch PHKL_35029 to use JDK 5.0.07.

4.5 ncsize Kernel Parameter

For Oracle Database 10g Release 2 (10.2), the recommended formula for calculating the ncsize kernel parameter is (8*nproc+3072).

5 Installation, Configuration, and Upgrade Issues

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

- Latest Upgrade Information

- Oracle Real Application Clusters (Oracle RAC) Support

- Adding a Node to a Shared Oracle Clusterware Configuration

- Installing Enterprise Security Manager

- Upgrading Cluster Ready Services (CRS) from Release 10.1.0.2

- extjob Executable Required Directory Permissions

- Modifying a Virtual IP Address Node Application

- Network Attached Storage for Oracle RAC Databases

- Installing Oracle Database Client into an Existing Oracle Home

- Database Installation Types

- Upgrading to Oracle Clusterware 10.2

- Oracle Storage Compatibility Program Obsolete

5.1 Latest Upgrade Information

For late-breaking updates and best practices about preupgrades, postupgrades, compatibility, and interoperability discussions refer to note 466181.1 on My Oracle Support (https://support.oracle.com) (formerly OracleMetaLink) that links to "10g Upgrade Companion" page.

5.2 Oracle Real Application Clusters (Oracle RAC) Support

The list of supported installation options and supported storage types for Oracle Clusterware, Oracle Real Application Clusters, 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/technetwork/indexes/documentation/index.html

Note:
NAS is supported on HP-UX 11.23 only.

5.3 Adding a Node to a Shared Oracle Clusterware Configuration

Before running root.sh in the first node of a shared Oracle Clusterware home, add the following line in the $ORA_CRS_HOME/opmn/conf/ons.config file:

usesharedinstall=true

This issue is tracked with Oracle bug 4454562.

5.4 Installing Enterprise Security Manager

To install Oracle Security Manager, install Oracle Database Client and then select the Administrator installation type.

5.5 Upgrading Cluster Ready Services (CRS) from Release 10.1.0.2

When upgrading Cluster Ready Services Release 10.1.0.2, activate the volume group before running the rootupgrade script. Use the following command to activate the volume group:

vgchange -a s vg1

where vg1 is the volume group that stores the OCR and voting disks.

5.6 extjob Executable Required Directory Permissions

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.

5.7 Modifying a Virtual IP Address Node Application

When modifying the name, IP address, or netmask of an existing virtual IP address (VIP) resource, use the following command:

srvctl modify nodeapps

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.

5.8 Network Attached Storage for Oracle RAC Databases

NAS is supported on HP 11.23 as a shared storage for Oracle RAC. To use NAS as a shared storage for Oracle RAC, apply the PHNE_32055 patch.

5.9 Installing Oracle Database Client into an Existing Oracle Home

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.

5.10 Database Installation Types

If you perform a Custom installation, then ensure that you install only the components covered by your license. You cannot install Standard Edition using Custom installation.

5.11 Upgrading to Oracle Clusterware 10.2

Due to an error in the preupdate.sh file, the CRS_home/lib/libskgxn2.so library located on the local node may be updated with the system kernel generic interface node membership (skgxn) that is used with Oracle Universal Installer.

Workaround:

To upgrade to Oracle Clusterware 10.2, perform the following steps:

1. Run preupdate.sh script from the Oracle Clusterware installation media on all the nodes.

2. Log in as root user to run the command chown -R root:root /CRS_home /lib on the local node.

3. As root, run the command chmod 755 /CRS_home /lib/lib* on the local node, where CRS_home is the Oracle Clusterware home path.
For example:

chmod 755 /u02/ocluster/lib/lib*

4. Verify that the files under /CRS_home/lib are owned by root.

5. Proceed with the 10.2 upgrade.

5.12 Oracle Storage Compatibility Program Obsolete

Oracle Storage Compatibility Program (OSCP) is no longer valid. Disregard any content about OSCP in the Oracle Database Installation Guide for HP-UX PA-RISC (64-Bit).

6 Other Known Issues

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

- Cluster Verification Utility

- Importing a User Certificate Into Oracle Wallet Using Oracle Wallet Manager

- Patch for libc:siglongjmp()

- Removing Metrics for Wait Classes Removes Them Permanently

- Service Failure Over the Network

- MAX_IDLE_BLOCKER_TIME Does Not Work in Oracle RAC Environment

- Oracle Universal Installer Warnings

- Vendor Clusterware Restrictions for Node Names

- Patch for HP-UX Error in Alert Log

6.1 Cluster Verification Utility

Review the following topics before using Cluster Verification Utility.

Third Party Clusterware

If the deployment environment does not use ServiceGuard, ignore the ServiceGuard version, ServiceGuard extension version, and patch PHSS_32732 errors reported by Cluster Verification Utility (CVU).

On HP-UX 11.11:

- M/C service guard 11.16.00 :: ServiceGuard A.11.16.00

- Clusterware patches: PHSS_32732, ServiceGuard Extension for Oracle RAC Bundle A.11.16.00 :: SG-NMAPI, A.11.16.00

On HP-UX 11.23:

- M/C service guard 11.16.00

- Clusterware Patches: PHSS_32740, ServiceGuard Extension for Oracle RAC Bundle A.11.16.00

Check Kernel Parameter Settings

CVU does not check kernel parameter settings.

This issue is tracked with Oracle bug 4565046.

Raw Devices Shared Storage

Cluster Verification Utility validates the readiness of a cluster to install Oracle Clusterware and Oracle RAC, and create databases. It also helps verify the integrity of individual cluster components. CVU does not discover raw disks, or perform shared checks for raw disks.

Note:
Cluster Verification Utility does not provide formatted output for the GoldApps patches. It lists the individual patches in a single line.

6.2 Importing a User Certificate Into Oracle Wallet Using Oracle Wallet Manager

Oracle Wallet Manager fails 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-----.

6.3 Patch for libc:siglongjmp()

Oracle recomends that you use the PHCO_33711 patch for the JAGaf71110 defect. Contact HP support to get this patch.

6.4 Removing Metrics for Wait Classes Removes Them Permanently

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.

6.5 Service Failure Over the Network

To tolerate a complete public network failure, services must be specified in the /etc/nsswitch.conf file. If the services are not specified in this file, you will be dependent on the network timeouts. For example, VIP failover could happen after the network/system timeouts.

This issue is tracked with Oracle bug 5988744.

6.6 MAX_IDLE_BLOCKER_TIME Does Not Work in Oracle RAC Environment

Setting a value for MAX_IDLE_BLOCKER_TIME feature of Resource manager does not work as expected in Oracle RAC environment.

Workaround: Set a value for MAX_IDLE_TIME instead of setting a value for MAX_IDLE_BLOCKER_TIME.

This issue is tracked with Oracle bug 6114355.

6.7 Oracle Universal Installer Warnings

If you encounter the following Oracle Universal Installer warning when you are installing Oracle Database 10g Release 2, then you can ignore them:

- If you have installed a compiler version later than the one listed in Oracle database prerequisite checks, then the Oracle Universal Installer displays a non compatibility warning message. This message can be ignored, if the newer versions of the compilers installed are displayed on the vedors site.

- ANSI/C is one of the certified compiler for Pro* C/C++, Oracle Call Interface, Oracle C++ Call Interface and Oracle XML Developer's Kit. If you have installed other certified compilers, then you can ignore the warning message.

6.8 Vendor Clusterware Restrictions for Node Names

If you use a vendor clusterware with Oracle Clusterware and Oracle Real Application Clusters, then you must use the node names and host names registered with that vendor clusterware you have installed.

6.9 Patch for HP-UX Error in Alert Log

Oracle recommends that you install patch PHCO_34275 for HP-UX 11i V1 (11.11), and patch PHCO_35744 for HP-UX 11i v2 (11.23) to avoid the HP-UX related error in the alert log.

Contact HP support for more details.

7 Documentation Corrections and Additions

This section lists the following corrections to the installation guides for HP-UX PA-RISC (64-Bit):

- In Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide, Chapter 1, section "Cloning Oracle Clusterware Homes," step 4 requires that the Oracle Clusterware tar file is uncompressed as a root user. Instead, uncompress the tar file as the oracle user.

- In Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide, Chapter 2, "Preinstallation," section "Oracle Clusterware Home Directory," incorrectly lists the path /u01/app/oracle/product/crs as a possible Oracle Clusterware home path. 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 Oracle Clusterware 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 Oracle Clusterware home can be an option similar to one of the following:

u01/crs/
/u01/crs/oracle/product/10/crs
/crs/home

- In Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide, Chapter 2, "Pre-Installation Tasks," section 2.6.1, "IP Address Requirements," 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.

- In Oracle Database Administrator's Reference for UNIX-Based Operating Systems Appendix H, "Database Limits," states the incorrect maximum value (63) for the MAXINSTANCES variable. The correct maximum limit for the variable is 1055.

- In Oracle Database 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 the group.

- In Oracle Database Administrator's Reference for UNIX-Based Operating Systems, Appendix B, "Large Memory Allocations and Oracle Database Tuning," incorrectly states the default value for CURSOR_SPACE_FOR_TIME initialization parameter as true. The correct default value for CURSOR_SPACE_FOR_TIME initialization parameter is false.

- In Oracle Database Administrator's Reference for UNIX-Based Operating Systems, Appendix H, "Database Limits," states the incorrect value for control files as 20000 database blocks. The correct value is 25000 control file blocks with a block size of 4096 bytes.

- In Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for HP-UX, section 2.8.1, "Software Requirements List for HP-UX PA-RISC (64-Bit) Platforms," incorrectly lists patch set PHSS_31849 for HP-UX 11.23 packages and bundles. The correct patch set is PHSS_35979.

- In Oracle Database Installation Guide for HP-UX PA-RISC (64-Bit), Chapter 4, section, "Installing Oracle Database 10g Products from the Companion CD," erroneously states that JPublisher and Oracle SQLJ are installed. The correct information is that JPublisher is not a part of Companion CD and Oracle SQLJ Demos are installed with the Companion CD instead of Oracle SQLJ.

- In Oracle Database Companion CD Installation Guide for HP-UX PA-RISC (64-Bit), Chapter 1, section, "Products Available in the Oracle Database 10g Products Installation Type," erroneously states that JPublisher and Oracle SQLJ are installed. The correct information is that JPublisher is not a part of Companion CD and Oracle SQLJ Demos are installed with the Companion CD instead of Oracle SQLJ.

Note:
The SQLJ Demos are installed if Oracle SQLJ was installed before running the Companion CD installation.

8 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Oracle Database Release Notes, 10g Release 2 (10.2) for HP-UX PA-RISC (64-Bit)

B19067-12

Copyright © 2008, 2012, 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 is software or related documentation that 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 America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware 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 that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware 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.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2016, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

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.

Warranty Disclaimer

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.

Restricted Rights Notice

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

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware 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 that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about 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 unless otherwise set forth in an applicable agreement between you and Oracle. 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, except as set forth in an applicable agreement between you and Oracle.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Alpha and Beta Draft Documentation Notice

If this document is in private preproduction status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your beta trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.