Skip Headers
Oracle® Database Release Notes
10g Release 2 (10.2) for Solaris Operating System (SPARC 64-Bit)
Part Number B15689-13
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Contact Us
  PDF · Mobi · ePub

Oracle® Database

Release Notes

10g Release 2 (10.2) for Solaris Operating System (SPARC 64-Bit)

B15689-13

April 2010

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.

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

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

Oracle C++ Call Interface STLPort4 Certification

Starting Oracle Database 10g Release 2 (10.2.0.3) STLPort4 libraries for OCCI are supported on this platform. These libraries are available at the following location:

$ORACLE_HOME/lib/libocci_stlport4.so.10.1

If you want to use STLPort4 libraries with OCCI, then you must create a soft link $ORACLE_HOME/lib/libocci.so pointing to $ORACLE_HOME/lib/libocci_stlport4.so.10.1.

2 Unsupported Products

The following products are not supported with Oracle Database 10g Release 2 (10.2):

JDBC 1.2 driver is not supported on Solaris 10.

Verity filters used for Oracle Text are not supported on Solaris 10.

3 Preinstallation Requirements

3.1 Required UDLM Package for Sun Cluster on SPARC

If you plan to use Sun Cluster with Solaris Operating System (SPARC 64-bit), then install ORCLudlm 64-Bit reentrant 3.3.4.10. This requirement supersedes the UDLM version listed in Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Solaris Operating System.

This issue is tracked with Oracle bug 8795539.

3.2 Displaying and Modifying Resource Control Settings on Solaris 10

On Solaris 10, use the following procedure to display the current value specified for resource controls, and to change them if necessary:

  1. To display the current values of the resource control, enter the following commands:

    $ id -p // to verify the project id
uid=100(oracle) gid=100(dba) projid=1 (group.dba)
$ prctl -n project.max-shm-memory -i project group.dba
$ prctl -n project.max-sem-ids -i project group.dba

  2. If you must change any of the current values, then:

    1. To modify the value of max-shm-memory to 6 GB:

      # prctl -n project.max-shm-memory -v 6gb -r -i project group.dba

    2. To modify the value of max-sem-ids to 256:

      # prctl -n project.max-sem-ids -v 256 -r -i project group.dba

Note:

When you use the prctl command (Resource Control) to change system parameters, you do not need to restart the system for these parameter changes to take effect. However, the changed parameters do not persist after a system restart.

Use the following procedure to modify the resource control project settings, so that they persist after a system restart:

  1. By default, Oracle instances are run as the oracle user of the dba group. A project with the name group.dba is created to serve as the default project for the oracle user. Run the command id to verify the default project for the oracle user:

    # su - oracle
$ id -p
uid=100(oracle) gid=100(dba) projid=100(group.dba)
$ exit

  2. To set the maximum shared memory size to 2 GB, run the projmod command:

    # projmod -sK "project.max-shm-memory=(privileged,2G,deny)" group.dba

    Alternatively, add the resource control value project.max-shm-memory=(privileged,2147483648,deny) to the last field of the project entries for the Oracle project.

  3. After these steps are complete, check the values for the /etc/project file using the following command:

    # cat /etc/project

    The output should be similar to the following:

    system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
group.dba:100:Oracle default
project:::project.max-shmmemory=(privileged,2147483648,deny)

  4. To verify that the resource control is active, check process ownership, and run the commands id and prctl, as in the following example:

    # su - oracle
$ id -p
uid=100(oracle) gid=100(dba) projid=100(group.dba)
$ prctl -n project.max-shm-memory -i process $$
process: 5754: -bash
NAME                    PRIVILEGE     VALUE     FLAG     ACTION    RECIPIENT
project.max-shm-memory  privileged    2.00GB     -       deny

    Note:

    The value for the maximum shared memory depends on the SGA requierments and should be set to a value greater than the SGA size.

    For additional information, refer to the Solaris Tunable Parameters Reference Manual.

3.3 Configure Shell Limits

Oracle recommends that you set shell limits and system configuration parameters as described in this section.

The ulimit settings determine process memory related resource limits. Verify that the shell limits displayed in the following table are set to the values shown:

Shell Limit Recommended Value
TIME -1 (Unlimited)
FILE -1 (Unlimited)
DATA Minium value: 1048576
STACK Minium value: 32768
NOFILES Minium value: 4096
VMEMORY Minium value: 4194304

To display the current value specified for these shell limits enter the following commands:

ulimit -t
ulimit -f
ulimit -d
ulimit -s
ulimit -n
ulimit -v

4 Installation, Configuration, and Upgrade Issues

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

4.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://metalink.oracle.com/) that links to "10g Upgrade Companion" page.

4.2 Determining Size of Configured Swap Space

To determine the size of the configured swap space, enter the following command:

# /usr/sbin/swap -l

Note:

The output of this command shows the total/available swap blocks, where each block is equal to 512 bytes and not 1 KB.

Oracle Storage Compatibility Program (OSCP) is no longer valid. Disregard the OSCP content in the section C.1, "General Configuration Guidelines for NAS Devices" of Appendix C, " Using NAS Devices" in Oracle Database Installation Guide for Solaris Operating System (SPARC 64-Bit).

4.3 Installing Enterprise Security Manager

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

4.4 Installing Oracle Database on a Computer That has an Automatic Storage Management Instance

Oracle Universal Installer displays an error message that reads 0. This message is displayed after you specify the database home and path in the Specify Home Details screen and click Next. Ignore the error message whenever it is displayed, and continue the installation.

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

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

To use NAS as a shared storage for RAC, apply the following patches:

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

4.8 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 Other Known Issues

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

5.1 Cluster Verification Utility

Third Party Clusterware

If your deployment environment does not use SunCluster, ignore the SunCluster version, ORCLUdlm version, and patch 113800-06 errors reported by Cluster Verification Utility (CVU).

If your deployment environment is Solaris 9, then the expected patch for SunCluster is 113801 instead of patch 113800-06. In addition, ignore kernel parameter SHMMIN and SHMSEG errors reported by Cluster Verification Utility (CVU).

Missing Patch Error Message

When CVU finds a missing patch, it reports a xxxx patch is unknown error. This should be read as xxxx patch is missing.

This issue is tracked with Oracle bug 4566437.

Raw Devices Shared Storage and Veritas Logical Volumes

Cluster Verification Utility validates the readiness of a cluster to install Oracle Clusterware and RAC, and create databases. It also helps verify the integrity of individual cluster components. CVU discovers raw disks, and performs shared checks for raw disks and Veritas logical volumes by verifying the unique "storage signature" across all nodes. However, it does not check whether the device is actually writeable or readable by the oracle user.

5.2 Materialized View and Partition Change Tracking Rewrite

When the query has single column in-lists, the materialized view has ranges, and partition change tracking rewrite is used, you might get stale results with Query Rewrite. Turn off the fresh partition containment rewrite to avoid this problem by using the following command:

SQL> alter session set "_query_rewrite_fpc" = false;

5.3 Host-Based Mirroring

The host-based mirroring is not supported with ASM. Note that there is no issue with resilvering for storage based mirroring.

Workaround: Use ASM redundancy.

This issue is tracked with Oracle bug 4466206.

5.4 Oracle ODBC Driver Limitations

Oracle ODBC driver for Solaris does not work if you use the REAL data type for a column and the application tries to retrieve data as native double or float data type through PL/SQL stored procedure.

Workaround: Instead of the REAL data type, use the NUMBER(s,p) data type while creating a table.

This issue is tracked with Oracle bug 4551566.

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

5.6 Preventing Loss of Quorum

If a storage area network (SAN) device is used to provide access to a shared storage and IO Multi-pathing (MPxIO) is enabled, then you must install the following patches on all the nodes of the cluster.

  • 119374-13

  • 119715-10

  • 119375-13

  • 119716-10

Without these patches, a node can lose access to the shared storage being accessed through the physical link that gets disconnected or fails.

5.7 Increasing the CSS misscount Parameter

When the Solaris fiber channel port driver senses that a link is down, it gives two minutes timeout period before offlining the LUN path associated with the port. The purpose of this delay is to prevent a premature fail over in as a result of a transient link failure. If there are alternate active paths to the LUNs and SCSI reservations are not active, then within this timeout MPxIO automatically reconfigures to use the alternate path.

However, during this timeout period the port failure is not perceived by CRS because the path is not offlined. If the node is evicted during this timeout period, the CRS daemons fail to reboot the node and services will not fail over to other nodes. In this case, the node will reboot only until the link is up again. After the reboot, all services belonging to the node will be up.

To avoid this problem the misscount parameter must be set to a value greater than 120 seconds. As a result, the eviction and reboot process is not affected by the Solaris timeout period. The node is evicted, it reboots and its services fail over to other nodes as expected.

After CRS installation is complete, you can change the misscount parameter by completing the following steps:

  1. On any node run the $CRS_HOME/bin/crsctl set css misscount 130 command.

  2. On all nodes run the $CRS_HOME/bin/crsctl stop crs command.

  3. On all nodes run the $CRS_HOME/bin/crsctl start crs command.

The default value for the misscount parameter is 27. Increasing the value of this parameter increases the time the node takes to fail over. Therefore, the service level of the cluster reduces for a longer period of time. It is up to the user to decide if a longer fail over time is acceptable. Solaris has a mechanism in place to allow applications to be notified immediately of a link down.

In this release, Oracle is not using this mechanism but work is in progress to make use of this mechanism. In a future Oracle release this workaround will no longer be needed.

5.8 Invalid Link to Monitor in Memory Access Mode Feature

Do not click the link to the Monitor in Memory Access Mode feature in the database screen. This feature is not available in Enterprise Manager Database Control 10.2.0.2 release. Clicking this link may stop an agent from responding.

This issue is tracked with Oracle bug 4866231.

5.9 Oracle Clusterware Private IP Addresses with Sun Cluster

If you are using a Sun Cluster, then do not enter the private interconnect in the /etc/hosts file, but instead use clusternodeX-priv to indicate the private interconnect for Oracle Clusterware and Oracle RAC.

This issue is tracked with bug 6238217.

5.10 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 Documentation Corrections and Additions

This section lists the following corrections to the installation guides for Solaris operating System (SPARC 64-Bit):

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

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 Solaris Operating System (SPARC 64-Bit)

B15689-13

Copyright © 2006, 2010, 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.

 
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Contact Us