Oracle® Database

Release Notes

11g Release 1 (11.1) for Oracle Solaris

B32067-14

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:

- Certification Information

- Unsupported Products

- 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 11g Release 1 (11.1) is available on My Oracle Support (formerly OracleMetaLink) at:

https://support.oracle.com

Oracle ODBC Certification

Starting with Oracle Database 11g release 1 (11.1.0.6), Oracle ODBC driver is supported on Solaris SPARC. Oracle ODBC driver uses gcc 3.4.5 for compilation instead of the native compilers on Solaris SPARC 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

Refer to the installation guides for the preinstallation requirements. However, the following section contains additional preinstallation requirements:

- Required UDLM Package for Sun Cluster on SPARC

- Required Update for Oracle Solaris on SPARC (64-Bit)

- Swap Space Guidance

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 Clusterware Installation Guide for Solaris Operating System.

This issue is tracked with Oracle bug 8795539.

3.2 Required Update for Oracle Solaris on SPARC (64-Bit)

On trying to install Oracle Database 11g release 1 on Oracle Solaris on SPARC (64-Bit) with update 5 or lower installed, Oracle Universal Installer reports the following error:

The 11g compatible version of operating system update is not present.

To workaround this issue, perform the following steps:

- Install Solaris 9 update 6 or higher on Oracle Solaris on SPARC (64-Bit):

% cat /etc/release | grep s9s
Solaris 9 9/04 s9s_u6wos_04a SPARC

In the output of the command, _u6 refers to update 6 of Solaris 9.

- Ensure the required version of Solaris package is installed:

% /bin/pkginfo -l SUNWsolnm | grep VERSION
VERSION: 9,REV=2004.03.22.13.18

If the revision date is prior to the date provided, order a newer version of the package, and install it on the server.

- Install Oracle Database 11g release 1.

3.3 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 Clusterware Installation Guide.

4 Installation, Configuration, and Upgrade Issues

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

- Latest Upgrade Information

- New Installation Media to Install Oracle HTTP Server

- Determining Size of Configured Swap Space

- 32-bit Java Refers to the 64-bit libocijdbc11.so Library

- Database Instance Fails to Start After Upgrading From Oracle Database 10g Release 1

- Database Upgrade Assistant Fails to Stop Oracle9i Database

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

- Oracle Database Configuration Assistant Fails to Start

- Help Button is not Working in Oracle Database Installation

- Oracle Enterprise Manager Configuration Fails During Data Guard Rolling Upgrade

- Oracle Enterprise Manager Database Control Fails During Database Upgrade

- Oracle Universal Installer Displays a Warning Message

- The /var/opt/oracle/oratab File Lists Multiple Automatic Storage Management Instances

- The *.err File is Created While Removing Automatic Storage Management with Database

4.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 11g Upgrade Companion" page.

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

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

4.4 32-bit Java Refers to the 64-bit libocijdbc11.so Library

32-bit Java refers to the 64-bit $ORACLE_HOME/lib/libocijdbc11.so library and displays an exception.

Workaround: Set the LD_LIBRARY_PATH variable to $ORACLE_HOME/lib32.

This issue is tracked with Oracle bug 5507215.

4.5 Database Instance Fails to Start After Upgrading From Oracle Database 10g Release 1

When you upgrade Oracle Database 10g Release 1 (10.1.0.4) to Oracle Database 11g, the database instance fails to start after the rootupgrade.sh script is run and an error message is displayed.

Workaround: Complete one of the following options to address this issue:

- One each node, complete the following procedure:

1. Open the racgwrap script available under 10.1.0.4 RAC_home in an editor, such as vi editor.

2. Add the following lines to the script:

LD_LIBRARY_PATH_64=$ORACLE_HOME/lib:$LD_LIBRARY_PATH_64
export LD_LIBRARY_PATH_64

- Attempt the upgrade from Oracle Database 10g Release 1 (10.1.0.5) to Oracle Database 11g.

4.6 Database Upgrade Assistant Fails to Stop Oracle9i Database

When upgrading Oracle9i database to Oracle Database 11g, Database Upgrade Assistant fails to stop the Oracle9i database on Oracle Clusterware.

Workaround: Complete the following procedure to resolve this issue:

1. Run the following commands on each node in Oracle Clusterware:

$CRSHome/bin/crsuser add Oracle_92_user_domain/Oracle_92_username
$CRSHome/bin/crs_setperm ora.node_name.gsd -o Oracle_92_user_domain/Oracle_92_username

2. From any node in the cluster, run the following commands for each node configured in the cluster:

$CRSHome/bin/crs_stop -f ora.node_name.gsd
$CRSHome/bin/crs_start ora.node_name.gsd

Note:
To find the list of nodes in the cluster, run the $CRSHome\bin\olsnodes command.

This issue is tracked with Oracle bug 6499906.

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

4.8 Help Button is not Working in Oracle Database Installation

When installing Oracle Database 11g, if you click Help, then Oracle Universal Installer does not display the help page for the Run Root.sh screen.

This issue is tracked with Oracle bug 6503397.

4.9 Oracle Database Configuration Assistant Fails to Start

When installing Oracle Database 11g (11.1.0.6.0) software with create or upgrade database option, Oracle Database Configuration Assistant fails to start and Oracle Universal installer displays the OUI-25301 error message.

When running Oracle Database Configuration Assistant after the installation, the following error message is displayed:

java.lang.UnsatisfiedLinkError: $ORACLE_HOME/lib/libOsUtils.so

Workaround: To resolve this issue, complete the following procedure before starting Oracle Universal Installer or Oracle Database Configuration Assistant:

1. Run the following command to set the JAVA64FLAG variable:

$ export JAVA64FLAG="-d64"

2. Start Oracle Universal Installer or Oracle Database Configuration Assistant.

This issue is tracked with Oracle bug 6628285.

4.10 Oracle Enterprise Manager Configuration Fails During Data Guard Rolling Upgrade

When performing Data Guard rolling upgrade from Oracle Database 10g Release 2 (10.2.0.3) using Oracle Database Upgrade Assistant, Oracle Enterprise Manager displays an error message.

This issue is tracked with Oracle bug 6597505.

4.11 Oracle Enterprise Manager Database Control Fails During Database Upgrade

When performing upgrade from Oracle Database 10g Release 1 (10.1.0.4), Oracle Enterprise Manager Database Control fails and displays the following error message:

QUEUE SYSMAN.MGMT_NOTIFY_Q does not exist

Workaround: To resolve this issue, run the following SQL command as SYSMAN user before performing the upgrade:

SQL> BEGIN
SQL>  DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table =>
SQL>  'SYSMAN.MGMT_NOTIFY_QTABLE', queue_payload_type =>
SQL>  'SYSMAN.MGMT_NOTIFY_NOTIFICATION', multiple_consumers => TRUE);
SQL>   DBMS_AQADM.CREATE_QUEUE (queue_name => 'SYSMAN.MGMT_NOTIFY_Q',
SQL>   queue_table => 'SYSMAN.MGMT_NOTIFY_QTABLE');
SQL>   DBMS_AQADM.START_QUEUE (queue_name => 'SYSMAN.MGMT_NOTIFY_Q');
SQL> END;

This issue is tracked with Oracle bug 5508403.

4.12 Oracle Universal Installer Displays a Warning Message

Oracle Universal Installer displays the following warning message:

Warning: Cannot convert string
"-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-1" to type FontStruct

sh: sysdef: not found
sh: sysdef: not found

Workaround: This is a benign message and you can ignore it. Click Ok to continue with the installation process.

This issue is tracked with Oracle bug 6145402.

4.13 The /var/opt/oracle/oratab File Lists Multiple Automatic Storage Management Instances

If you install Oracle Clusterware on shared Oracle home, the /var/opt/oracle/oratab file lists multiple Automatic Storage instances.

When Automatic Storage Management Oracle home is installed in shared file system to create Automatic Storage Management instances from Oracle Universal Installer, multiple Automatic Storage Management instances are listed in the /var/opt/oracle/oratab file.

Workaround: Oracle Universal Installer detects this issue during the prerequisite checks. You can edit the /var/opt/oracle/oratab file in each node and remove the entries that are not part of that node. The alternative is to install the software, run the root.sh script on all nodes and create Automatic Storage Management instance by running Database Configuration Assistant.

The issue is tracked with Oracle bug 5942123.

4.14 The *.err File is Created While Removing Automatic Storage Management with Database

When you remove Automatic Storage Management with database, the *.err log file is created under the under the $ORACLE_BASE\oraInventory\logs. directory. This file shows that some error was generated when removing Automatic Storage Management with database.

This issue is tracked with Oracle bug 6369645.

5 Other Known Issues

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

- Reactivate the OC4JADMIN User for Oracle Ultra Search

- Same Location for Symbolic links to Oracle Instant Client Libraries Does not Work

- Oracle Clusterware Node Addition in Vendor Cluster Environment

5.1 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

5.2 Same Location for Symbolic links to Oracle Instant Client Libraries Does not Work

If you keep Oracle Instant Client libraries in different directories and create symbolic links to these libraries in the same directory, then the Oracle Instant Client mode is not turned on.

Workaround: All the Oracle Instant Client libraries must physically reside in the same directory.

This issue is tracked with Oracle bug 6504887.

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

This section lists the following corrections to the Solaris installation guides:

- Incorrect Operating System Patches

- Incorrect Compiler Name

- Incorrect Control Size Value

6.1 Incorrect Operating System Patches

The " Patch Requirements" section in chapter 2 of Oracle Database Installation Guide for Solaris Operating System, lists the following incorrect values for Pro*C/C++, Pro*FORTRAN, Oracle Call Interface, Oracle C++ Call Interface, and Oracle XML Developer's Kit (XDK). The following values are invalid:

- Patches for Solaris 9 :
112760-05, C 5.5: Patch for S1S8CC C compiler

- Patches For Solaris 10:

- 117837-05: C++ compiler optimizer patch

- 117846-08: C++ compiler Optimization patch

- 118682-01

6.2 Incorrect Compiler Name

Section 2.3.3, "Compiler Requirements" in Chapter 2 of Oracle Database Installation Guide for Solaris Operating System, Oracle Database Client Installation Guide for Solaris Operating System, and the respective Quick Installation Guides incorrectly mention the compiler name as Sun One Studio 11.

Chapter 2 of Oracle Clusterware Installation Guide for Solaris Operating System also incorrectly mentions Sun One Studio 11.

The correct compiler name is Sun Studio 11.

6.3 Incorrect Control Size Value

Appendix H, "Database Limits" of Oracle Database Administrator's Reference for Linux and UNIX guide 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.

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.

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 Oracle Solaris

B32067-14

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

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.