Oracle® Database Patch Set Notes 10g Release 2 (10.2.0.5) Patch Set 4 for Linux x86 Part Number E15228-02 |
Patch Set Notes
10g Release 2 (10.2.0.5) Patch Set 4 for Linux x86
E15228-02
July 2010
These patch set notes accompany the Oracle Database release 10.2.0.5 patch set. This document contains the following sections:
Patch sets are a mechanism for delivering fully tested and integrated product fixes. Patch sets provide bug fixes only; they do not include new functionality and they do not require certification on the target system.
Patch sets include all of the libraries that have been rebuilt to implement the bug fixes in the set. All of the fixes in the patch set have been tested and are certified to work with each other. Because the patch set includes only low impact patches, it does not require you to certify applications or tools against the server.
You can apply the Oracle Database release 10.2.0.5 patch set to the following Oracle Database 10g release 2 installations:
Oracle Database
Oracle Real Application Clusters
Oracle Database Client
Oracle Database Companion CD
Oracle Clusterware
Oracle Database Vault
For a list of products included in this patch set, see the "Patch Set Components" section.
Review the latest Critical Patch Update information at http://www.oracle.com/technology/deploy/security/alerts.htm
.
The following are the updated components of this patch set:
Platform-specific bug fixes as listed in the "Fixed Platform-Specific Bugs" section
Generic bug fixes as listed in the List of Bugs Fixed document
Oracle Configuration Manager 10.3.2
See Also:
Oracle Configuration Manager Installation and Administration Guide Version 10.3.2 (part number B32294-10)This document may be updated after release. To check for updates to this document, see document 316900.1 on the My Oracle Support (formerly OracleMetaLink) Web site:
https://support.oracle.com
To locate document 316900.1:
Log on to My Oracle Support.
Set Article ID as the search source.
Enter 316900.1 in the search field, then click Search icon.
This patch set includes Oracle Universal Installer release 10.2.0.5, which is also installed when you install this patch set. This is to ensure that the Oracle home can be patched in the future. You should not use Oracle Universal Installer from the earlier maintenance release media or from an existing Oracle home.
This is not a complete software distribution. You must install it in an existing Oracle Database 10g (10.2.0.x) installation.
The Oracle Database List of Bugs Fixed, 10g release 2 (10.2.0.5) document is no longer available as a separate document that ships with the software. A mechanism for finding fixed bugs is available from document 316900.1, ALERT: Oracle 10g Release 2 (10.2) Support Status and Alerts.
There is a platform-specific document, Oracle Database Patch Set Notes, 10g release 2 (10.2.0.5) Patch Set, related to each platform for this release of the Oracle Database patch set. This document provides:
Information about how to install, reinstall, or remove the patch set.
A list of known issues relating to Oracle Database on the platform.
This document is included with the patch set software. In addition, this document and the mechanism for finding fixed bugs are available from document 316900.1, ALERT: Oracle 10g Release 2 (10.2) Support Status and Alerts on the My Oracle Support (formerly OracleMetaLink) Web site:
https://support.oracle.com
To locate document 316900.1:
Log on to My Oracle Support (formerly OracleMetaLink).
Set Article ID as the search source.
Enter 316900.1 in the search field, then click Search icon.
Check your platform-specific installation guide for a list of supported operating systems. For the latest information, check the Certifications link at My Oracle Support (formerly OracleMetaLink):
https://support.oracle.com
Complete the following preinstallation tasks before installing the patch set:
Review the information in the following sections. If any of the issues apply to the Oracle installation, follow the instructions before installing the patch set.
Upgrading Installations that use Physical or Logical Standby Databases
Upgrading Installations that use Java Virtual Machine or Oracle interMedia
Some of the prerequisite checks are not required when installing the 10.2.0.5 patch set in Oracle Clusterware, Oracle Client, or Oracle Gateways Oracle homes.
Workaround: Run Oracle Universal Installer using the ignoreSysPrereqs
flag which causes the installer to skip the prerequisite checks and continue with the installation:
./runinstaller -ignoreSysPrereqs
If you are an Oracle E-Business Suite customer and you want to upgrade the Oracle E-Business Suite release 11i database server to this patch set, then you must check the latest certification status and Interoperability Notes available on the My Oracle Support Web site:
https://support.oracle.com
Before applying this patch set to an Oracle Database 10.2.0.x installation that uses one or more physical or logical standby databases, review the following My Oracle Support documents:
For information about physical standby databases, review document 278641.1.
For information about logical standby databases, review document 278643.1.
These documents are available on the My Oracle Support (formerly OracleMetaLink) Web site:
https://support.oracle.com
If any of the databases use Java Virtual Machine or Oracle interMedia, then install the Oracle Database 10g Products installation type from the Oracle Database 10g Companion CD before installing the 10.2.0.5 patch set. For information about installing the Oracle Database 10g Products installation type from the Companion CD, see the Oracle Database Companion CD Installation Guide for the platform. This installation type includes the Natively Compiled Java Library files to improve Java performance. If you do not install the Natively Compiled Java Library files, the ORA-29558:
JAccelerator
(NCOMP)
not
installed
error occurs when a database that uses Java Virtual Machine is upgraded to the patch release.
See Also:
My Oracle Support (formerly OracleMetaLink) document 293658.1 for more information about theORA-29558:
JAccelerator
(NCOMP)
not
installed
errorThe Oracle Clusterware software must be at the same or newer level as the Oracle software in the Oracle RAC Oracle home. Therefore, you should always upgrade Oracle Clusterware before you upgrade Oracle RAC. This patch does not allow you to upgrade Oracle RAC before you upgrade Oracle Clusterware.
To apply this patch set, Oracle OLAP users should ensure that the base release is the Enterprise Edition of 10.2.0.x with the Oracle OLAP option installed. Oracle highly recommends the Data Warehouse configuration type to optimize the database for Oracle OLAP.
If you are moving the Oracle Database from a 32-bit operating system to a 64-bit operating system, either prior to applying the patch set or after applying the patch set, review document 352306.1 on the My Oracle Support (formerly OracleMetaLink) Web site:
https://support.oracle.com
To locate document 352306.1:
Log on to My Oracle Support.
Set Article ID as the search source.
Enter 352306.1 in the search field, then click Search icon.
In 10.2.0.5, Oracle Text uses Oracle Outside In HTML Export for document filtering instead of filtering technology licensed from Autonomy, Inc. Refer to the following sections in Oracle Text Reference (part number B28304-03) for more details:
Appendix B.1.3 for supported platforms for AUTO_FILTER
Appendix B.2 for supported document formats
Table B-4 in Appendix B.2.9 for formats that are no longer supported in 10.2.0.5
Note:
Table B-4 in Appendix B.2.9 refers to formats supported in release 11.1.0.6 but not in release 11.1.0.7. The same applies when you upgrade from release 10.2.0.4 to 10.2.0.5.Complete the steps in this section before upgrading Oracle Database Vault from 10.2.0.x to 10.2.0.5 or downgrading Oracle Database Vault from 10.2.0.5 to 10.2.0.x:
Re-create and replace the password file, in order to log in to an Oracle Database Vault instance as a SYS
user with SYSDBA
privilege:
$ orapwd file=$ORACLE_HOME/dbs/orapwsid password=syspasswd force=y nosysdba=n
Note:
TheSYS
connection as SYSDBA
is disabled in a default Oracle Database Vault installation. Without enabling SYSDBA
, you cannot unlock DVSYS
in step 5 that follows.Shut down the database:
For Oracle RAC:
$ srvctl stop database -d db_name
For Single Instance:
SQL> CONNECT SYS AS SYSOPER
Enter password: SYS_password
SQL> SHUTDOWN
Turn off Oracle Database Vault and relink the Oracle database software with dv_off
:
Note:
For Oracle RAC, you must run the following commands on all the nodes.$ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk dv_off $ cd $ORACLE_HOME/bin $ relink all
Start the database:
For Oracle RAC:
$ srvctl start database -d db_name
For Single Instance:
sqlplus /nolog
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
SQL> STARTUP
Unlock the DVSYS
account and set the password:
SQL> ALTER USER DVSYS ACCOUNT UNLOCK;
Disable the Oracle Database Vault triggers:
Run Oracle Database Vault Configuration Assistant (DVCA) by using the dvca -action disable
option. This disables the Database Vault triggers. Use the following syntax:
dvca -action disable -service service_name -owner_account DV_owner_account_name [-logfile ./dvca.log] [-nodecrypt] [-racnode host_name] Enter SYS password: SYS_password Enter owner password: owner_password
This is not a complete software distribution. You must install it in an existing Oracle Database 10g Oracle home. To identify Oracle home directories, view the /etc/oratab
file. Use Oracle Universal Installer to identify Oracle home directories. From the Welcome screen, click Installed Products, then click the Contents tab.
If you are installing this patch set on an existing Oracle Real Application Cluster 10g release 10.2.0.x installation, you must run Oracle Universal Installer from the same node from which the Oracle Database software was installed.
Before installing this patch set in a production environment, review document 316900.1, ALERT: Oracle 10g release 2 (10.2) Support Status and Alerts, available on the My Oracle Support (formerly OracleMetaLink) Web site:
https://support.oracle.com
To locate this document:
Log on to My Oracle Support.
Set Article ID as the search source.
Enter 316900.1 in the search field, then click Search icon.
This document is created by Oracle Support Services and provides information about the status of issues discovered after this patch set was released. If you are unable to access this site, then contact Oracle Support Services before installing this patch set in a production environment.
To download and extract the patch set installation software:
Download the p8202632_10205_LINUX.zip
patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.
The 10.2.0.5 patch set includes an update to the Oracle time zone definitions to Version 4. This version of the time zone definitions includes the changes to daylight saving time in the USA in 2007 and other updates.
In the Oracle database the TIMESTAMP
WITH
LOCAL
TIME
ZONE
(TSLTZ
) and TIMESTAMP
WITH
TIME
ZONE
(TSTZ
) data types and the TZ_OFFSET
function select the time zone information from the time zone files.
It may be necessary to take action on existing TIMESTAMP
WITH
LOCAL
TIME
ZONE
(TSLTZ
) and TIMESTAMP
WITH
TIME
ZONE
(TSTZ
) data or to reapply DST patches afterwards.
For full overview, see My Oracle Support (formerly OracleMetaLink) document 1086400.1 Actions for the DSTv4 update in the 10.2.0.5 patchset.
When patching from a lower 10.2 release or upgrading from 10.1.0.x directly to 10.2.0.5, check the current version of the Oracle time zone definitions with the following command:
SELECT version FROM v$timezone_file;
If this query reports version 4, no action is required.
If this reports a version lower or higher than 4, see My Oracle Support document 1086400.1 Actions for the DSTv4 update in the Release 10.2.0.5 patchset.
On upgrading from any release of Oracle9i to Release 10.2.0.5, see My Oracle Support document 1086400.1 Actions for the DSTv4 update in the 10.2.0.5 patchset.
On upgrading from Release 8.1.7 directly to Release 10.2.0.5, no action is required because Release 8.1.7 has no timezone data stored.
Shut down any existing Oracle Database instances with normal or immediate priority. On Oracle RAC systems, shut down all instances on each node.
If Oracle Automatic Storage Management (Oracle ASM) is running, shut down all databases that use Oracle ASM, then shut down the Oracle ASM instance on each node of the cluster.
Note:
If you are using Oracle Clusterware, you must shut down all Oracle Database instances on all cluster nodes before applying the patch set to the Oracle Clusterware installation. All Oracle database instances are restarted during the Oracle Clusterware patch set installation. After the Oracle Clusterware patch set installation is complete, you must shut down all Oracle Database and Oracle ASM instances running in the Oracle RAC Oracle home before patching the Oracle RAC Oracle home.Enter the following commands to set the ORACLE_HOME
and ORACLE_SID
environment variables:
Bourne, Bash, or Korn shell:
$ ORACLE_HOME=Oracle_home $ ORACLE_SID=sid $ PATH=$ORACLE_HOME/bin:$ORACLE_HOME/bin/OPatch:$PATH $ export ORACLE_HOME ORACLE_SID PATH
C shell:
% setenv ORACLE_HOME Oracle_home % setenv ORACLE_SID sid % setenv PATH $ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
In these examples, Oracle_home
is the Oracle home directory where the Oracle Database 10g installation that you want to upgrade is installed, and sid
is the system identifier of the database that you want to upgrade. For Oracle RAC installations, sid
is generally the sid
prefix and the instance number. For example, ORCL1
.
Go to the following sections based on the Oracle Database installation type:
See also:
Appendix F, "How to Stop Processes in an Existing Oracle Real Application Clusters Database, and How to Perform Oracle Clusterware Rolling Upgrades" in Oracle Database Oracle Real Application Clusters Installation GuideShut down the following Oracle Database 10g processes in the order specified before installing the patch set:
Shut down all processes in the Oracle home that might be accessing a database; for example, Oracle Enterprise Manager Database Control:
$ emctl stop dbconsole $ lsnrctl stop
Note:
Before you shut down all processes that are monitored by Oracle Enterprise Manager Grid Control, set a blackout in Grid Control for the processes that you intend to shut down. This is necessary so that the availability records for these processes indicate that the shutdown was planned downtime rather than an unplanned system outage.Shut down all database instances running in the Oracle home directory, where you need to install the patch set.
Shut down all listeners running in the Oracle home directory, where you need to install the patch set.
If there is an Automatic Storage Management instance present, then enter the following command to set the values for the environment variables $ORACLE_HOME
and $ORACLE_SID
:
Bourne, Bash, or Korn shell:
$ export ORACLE_SID=+ASM $ export ORACLE_HOME=ASM_HOME
C shell:
% setenv ORACLE_SID +ASM % setenv ORACLE_HOME ASM_HOME
Enter the following command to shut down the Automatic Storage Management instance:
cd $ORACLE_HOME/bin
$ ./sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
SQL> SHUTDOWN IMMEDIATE
For Automatic Storage Management, as the root
user enter the following command to shut down the Oracle Cluster Synchronization Services daemon:
# $ORACLE_HOME/bin/crsctl stop crs
This section contains the following information:
By default, Oracle supports rolling upgrade for Oracle Clusterware. Complete the following steps only on one node:
Stop iSQL*Plus on the primary node by issuing the following command:
isqlplusctl stop
Shut down all processes in the Oracle home on the node that might be accessing a database; for example, Oracle Enterprise Manager Database Control:
$ emctl stop dbconsole
$ lsnrctl stop listenername
Note:
isqlplusctl
stop
should be issued only on the primary node as isqplusctl
doesn't start on remote node.Note:
Before you shut down all processes that are monitored by Oracle Enterprise Manager Grid Control, set a blackout in Grid Control for the processes that you intend to shut down. This is necessary so that the availability records for these processes indicate that the shutdown was planned downtime rather than an unplanned system outage.Shut down all services in the Oracle home on the node that might be accessing a database:
$ srvctl stop service -d db_name [-s service_name_list [-i inst_name]]
Shut down all Oracle RAC instances on the node on which you intend to perform the rolling upgrade. To shut down Oracle RAC instances on individual nodes in the database, enter the following command where db_name
is the name of the database:
$ srvctl stop instance -d db_name -i inst_name
If an Automatic Storage Management instance is present, then shut down the Automatic Storage Management instance on the node on which you intend to perform the rolling upgrade. To shut down an Automatic Storage Management instance, enter the following command where node
is the name of the node where the Automatic Storage Management instance is running:
$ srvctl stop asm -n node
Stop all node applications on the node on which you intend to perform the rolling upgrade. To stop node applications running on a node, log in as the root
user and enter the following command, where node
is the name of the node where the applications are running:
# srvctl stop nodeapps -n node
Perform the steps mentioned in "Installation Tasks."
Note:
The following instructions are displayed on the Oracle Universal Installer screen.To complete the installation of this patch set, you must perform the following tasks on each node:
Log in as the root user.
As the root user, perform the following tasks:
Shutdown the CRS daemons by issuing the following command:
CRS_home/bin/crsctl stop crs
Run the shell script located at:
CRS_home/install/root102.sh
This script will automatically start the CRS daemons on the patched node upon completion.
After completing this procedure, proceed to the next node and repeat.
To upgrade the rest of the nodes, go to the next node and perform Steps 2 to 6 and then log in as the root
user and perform the following steps:
Enter the following command to shut down the Oracle Clusterware:
# CRS_home/bin/crsctl stop crs
Run the root102.sh
script to automatically start the Oracle Clusterware on the patched node:
# CRS_home/install/root102.sh
Note:
Rolling upgrade is not supported on shared Oracle home.For non rolling upgrade, Oracle Clusterware must be shut down completely.
Complete the following steps:
Note:
You must perform these steps in the order listed.Stop iSQL*Plus on the primary node by issuing the following command:
isqlplusctl stop
Shut down all processes in the Oracle home on each node that might be accessing a database; for example, Oracle Enterprise Manager Database Control:
$ emctl stop dbconsole $ lsnrctl stop listenername
Note:
Before you shut down all processes that are monitored by Oracle Enterprise Manager Grid Control, set a blackout in Grid Control for the processes that you intend to shut down. This is necessary so that the availability records for these processes indicate that the shutdown was planned downtime rather than an unplanned system outage.Shut down all services in the Oracle home on each node that might be accessing a database:
$ srvctl stop service -d db_name [-s service_name_list [-i inst_name]]
Shut down all Oracle RAC instances on all cluster nodes by entering the following command where db_name
is the name of the database:
$ srvctl stop database -d db_name
If Automatic Storage Management instance is present, then shut down Automatic Storage Management instances on all cluster nodes by entering the following command where node
is the name of the node where the Automatic Storage Management instance is running:
$ srvctl stop asm -n node
Stop all node applications on all cluster nodes by entering the following command as the root
user, where node
is the name of the node where the applications are running:
# srvctl stop nodeapps -n node
Shut down the Oracle Clusterware processes by entering the following command on all nodes as the root
user:
# CRS_home/bin/crsctl stop crs
Complete the steps mentioned in "Installation Tasks."
Note:
You cannot perform a rolling upgrade of your Oracle Clusterware if the software is installed on a shared partition. The following instructions regarding a non-rolling upgrade are displayed on the Oracle Universal Installer screen.To complete the installation of this patch set, you must perform the following tasks:
On each node, do the following:
Log in as the root user.
As root, shutdown the CRS daemons on the node using the following command:
# CRS_home/bin/crsctl stop crs
Repeat this step until the CRS daemons on all the nodes are shutdown.
After all the CRS daemons on all the nodes are shutdown, run the shell script located at: CRS_home/install/root102.sh
. This script will automatically start the CRS daemons on the patched node upon completion.
Wait until the script finishes and then proceed to the next node and repeat step 2.
Shut down the following Oracle Database 10g processes before installing the patch set:
Shut down all processes in the Oracle home on each node that might be accessing a database, for example Oracle Enterprise Manager Database Control or iSQL*Plus:
$ emctl stop dbconsole $ isqlplusctl stop
Note:
Before you shut down all processes that are monitored by Oracle Enterprise Manager Grid Control, set a blackout in Grid Control for the processes that you intend to shut down. This is necessary so that the availability records for these processes indicate that the shutdown was planned downtime rather than an unplanned system outage.Shut down all services in the Oracle home on each node that might be accessing a database:
$ srvctl stop service -d db_name [-s service_name_list [-i inst_name]]
Shut down all Oracle RAC instances on the nodes, which run from the Oracle home on which you are going to apply the patch set. To shut down all Oracle RAC instances for a database, enter the following command where db_name
is the name of the database:
$ srvctl stop database -d db_name
If Automatic Storage Management instance is present, then shut down all Automatic Storage Management instances on all nodes. To shut down an Automatic Storage Management instance, enter the following command where node
is the name of the node where the Automatic Storage Management instance is running:
$ srvctl stop asm -n node
This must be done only when patching the home from where Oracle ASM runs. It is recommended that Oracle ASM run from a different ORACLE_HOME
than the database.
Stop any listeners that are running from the Oracle home that you are patching on all nodes. To stop the listener running on a node, enter the following command, where node
is the name of the node where the listener is running:
$ srvctl stop listener -n node [-l listenername]
Note:
Using a logical standby database, you can upgrade Oracle Database software and patch sets with almost no downtime. Using Data Guard SQL Apply, you can perform a rolling upgrade of the Oracle Database software from the base 10.2.0.x release to the current patch set release. During a rolling upgrade, you can run different releases of Oracle Database on the primary and logical standby databases, while you upgrade them, one at a time, incurring minimal downtime on the primary database.See also:
Chapter 11, "Using SQL Apply to Upgrade the Oracle Database" of Oracle Data Guard Concepts and Administration.Oracle recommends that you create a backup of the Oracle Inventory, Oracle 10g home and Oracle 10g Database before you install the patch set. If you are planning to apply this patch to Oracle RAC, ensure that you create a backup of these components on all nodes before applying the patch. You must also ensure that the GID and UID of the CRS / Oracle User be less than 65536 bytes (ID username will provide the UID / GID for the user).
See also:
Oracle Database Backup and Recovery User's Guide for more informationYou can install the patch set either interactively or noninteractively. See one of the following sections for information about how to complete the installation:
Note:
If you also plan to apply this patch to Oracle Clusterware, ensure that you apply the patch to Oracle Clusterware before applying it to Oracle Database. This is because Oracle Clusterware should always be at the same or later version as the database.Note:
If you attempt to install this patch set in an Oracle home directory that does not contain an Oracle10g release 10.2.0.1 or higher installation, Oracle Universal Installer displays a warning dialog with the following error:OUI-10091: There are no patches that need to be applied from the patch set Oracle Database 10g Release 2 Patch Set 4 10.2.0.5
Oracle Universal Installer does not allow the installation to proceed. Click OK, then click Cancel to end the installation.
To install the Oracle Database 10g patch set interactively:
Log in as the oracle
user.
If you are not installing the software on the local computer, then run the following command on remote machine:
Bourne, Bash, or Korn shell:
$ export DISPLAY=localhost:0.0
C shell:
% setenv DISPLAY local_host:0.0
In this example, local_host
is the host name or IP address of the computer that you want to use to display Oracle Universal Installer.
Now to enable X applications, run the following command on the machine that you want to use to display Oracle Universal Installer:
$ xhost + [fully_qualified_remote_host_name]
Enter the following commands to start Oracle Universal Installer, where patchset_directory
is the directory where you unpacked the patch set software:
% cd patchset_directory/Disk1
% ./runInstaller
On the Welcome screen, click Next.
On the Specify Home Details screen, select the name of the Oracle home that you want to update, or select the Path that you want to update from the list, then click Next.
Enter your e-mail address and password for your My Oracle Support account to be informed of security issues, then click Next.
Note:
The registration and configuration can also be done manually after patch set installation.The OCM registration page appears only while applying 10.2.0.5 patch over existing Database instances alone.
If you are installing the patch set on an Oracle RAC cluster, click Next when the Selected Nodes screen appears.
On the Product-specific Prerequisite Checks screen, correct any reported errors, and click Next.
On the Summary screen, click Install.
This screen lists all of the patches available for installation.
When prompted, run the $ORACLE_HOME/root.sh
script as the root
user. If you are applying the patch set to an Oracle RAC installation, then run the root.sh
script on each node of the cluster.
On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.
Note:
If you are applying this patch set to an Oracle Clusterware installation, then complete all of the steps displayed on the Oracle Universal Installer screen.The Oracle Clusterware installation instructions displayed on the Oracle Universal Installer screen are also available in the CRS_home
/install/readme.txt
file.
When applying this patch set on an Oracle Clusterware home, Oracle Universal Installer prompts you to run the root102.sh
script from $ORACLE_HOME/install
. You must run this script as the root
user on all nodes.
To install the Oracle Database 10g patch set noninteractively:
Copy the response file template provided in the response
directory where you unpacked the patch set archive file.
Edit the values for all fields labeled as <Value Required>
as described by the comments and examples in the template.
Note:
For Oracle RAC installations, make sure theCLUSTER_NODES
variable specifies all of the nodes used in the original Oracle RAC installation.To run Oracle Universal Installer, enter a command similar to the following, where response_file
is the full path to the response file that you edited:
$ ./runInstaller -silent -responseFile response_file
After the installation, run the $ORACLE_HOME/root.sh
script as the root
user. If you are applying the patch set to an Oracle RAC installation, then run the root.sh
script on each node of the cluster.
Note:
If you are applying this patch set to an Oracle Clusterware installation, then complete all the steps in theCRS_home
/install/readme.txt
file. You must run this script as the root
user on all nodes.Review the information in this section before using the upgraded software. This section lists required and optional postinstallation tasks, depending on the installation type and the products that you want to use.
Upgrading Earlier Oracle Database to Oracle Database 10g Release 2 (10.2.0.5)
Running changePerm.sh Script on an Oracle Database Server Home
Configuring Oracle Configuration Manager in a Cloned Oracle Home
Upgrading Oracle Database 10g Release 10.2.0.x to Oracle Database 10g Release 10.2.0.5
Review the following sections before upgrading an earlier Database to Oracle Database 10g release 2 (10.2.0.5):
Upgrading Earlier Oracle Database Releases to Oracle Database 10g Release 2 (10.2.0.5)
Upgrading a Release 9.2 Database Not Using Oracle Label Security
For information about upgrading Oracle Databases from an earlier Oracle Database (Oracle8i, Oracle9i, or Oracle Database 10g), see Oracle Database Upgrade Guide.
If you are upgrading an Oracle RAC database, refer to Oracle Real Application Clusters Administration Guide as well.
To avoid errors when upgrading from release 9.2, Oracle Label Security should be installed. Use one of the following methods to check if Oracle Label Security is installed:
If the catnools.sql
script exists on the computer, Oracle Label Security is installed.
Check the inventory at the end of the installAction
log file for the base version installation (9.2). If Oracle Label Security is installed, Label Security
is listed in the inventory section of the log file.
Use the following commands to check if Oracle Label Security is installed with the 9.2 database:
$ sqlplus
SQL> CONNECT SYS AS SYSDBA
Enter password:password
SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';
To upgrade an Oracle9i release 9.2 preconfigured database, and you are not using Oracle Label Security, complete the following steps to avoid errors during the upgrade:
Use Oracle Universal Installer release 9.2 to install Oracle Label Security using the Custom installation type.
Run the catnools.sql
script, located in the /rdbms/admin
directory under the Oracle home, with the SYSDBA
privilege to remove Oracle Label Security components from the database.
When you upgrade Oracle Database 10g Release 1 (10.1.0.5) to Oracle Database 10g Release 2 (10.2.0.5), the diagnostics of the preupgrade utility script utlu102.sql
may indicate that some database components on the 10g Companion CD should be installed. You should install these components from the Oracle Database 10g Release 1 (10.1.0.5) Companion CD before applying this patch set. If the catupgrd.sql
script cannot upgrade a SERVER component because it was not installed from the Companion CD, then the status of the SERVER component in the patch.log
file is reported as NO SCRIPT
.
Note:
If the preupgrade script indicates the Server JAVA Virtual Machine's JAccelerator (NCOMP) or Oracle interMedia Image Accelerator should be installed, but they are not installed before applying the patch set, then thepatch.log
file contains the status of their parent components as successfully upgraded to Oracle Database 10g Release 2 (10.2.0.5) even though these components are still missing.If you find any component, which was identified as missing by the preupgrade utility script, was not installed before running the catupgrd.sql
script, then install the missing component from the Companion CD and run the catupgrd.sql
script again.
Based on the result you had in Section 8.5, "Update Oracle Time Zone Definitions" regarding the DST (Oracle time zone definitions):
If the DST version in 8.5 was 4, no action is required.
If f the DST version in 8.5 was higher than 4, reapply the version of DST patches as described in My Oracle Support (formerly OracleMetaLink) document 1086400.1 Actions for the DSTv4 update in the 10.2.0.5 patchset.
If the DST version in 8.5 was lower then 4, restore TSTZ data from backup (if any). For more information, see My Oracle Support document 1086400.1 Actions for the DSTv4 update in the 10.2.0.5 patchset.
If you are upgrading from Release 8.1.7 directly to Release 10.2.0.5, no action is required.
Important:
Oracle recommends using the most restrictive file permissions possible for the given implementation. Perform these optional steps only after considering all security ramifications and only if you need to share this installation.During patch set installation, all new files and directories are created with restricted access, by default. Users or third party applications with a different group identifier from that of the database, which try to access client-side utilities or libraries in the database home, will see permission errors when trying to access these files or directories. Perform the following steps to change the permissions:
Change to the install directory by using the following command:
$ cd $ORACLE_HOME/install
Run changePerm.sh
and specify the patched server Oracle home location, before accessing client-side utilities or libraries in the database home.
Note:
If you are applying patch to Oracle RAC home, then you must run this script on all the nodes.For installations with Oracle Database Vault, complete the following steps:
Restart the database:
For a single-instance database, use the following commands:
sqlplus SYS "AS SYSDBA" Enter password: SQL> SHUTDOWN IMMEDIATE SQL> STARTUP
For an Oracle Real Application Clusters (Oracle RAC) database, use the following commands:
$ORACLE_HOME/bin/srvctl stop database -d db_name $ORACLE_HOME/bin/srvctl start database -d db_name
Connect AS
SYSDBA
and run the following SQL statements:
SQL> DECLARE CURSOR stmt IS SELECT u.name, o.name, r.pname FROM user$ u, obj$ o, rls$ r WHERE u.user# = o.owner# AND r.obj# = o.obj# AND bitand(r.stmt_type,65536) > 0; object_schema VARCHAR2(32) := NULL; object_name VARCHAR2(32) := NULL; policy_name VARCHAR2(32) := NULL; BEGIN OPEN stmt; LOOP FETCH stmt INTO object_schema, object_name, policy_name; EXIT WHEN stmt%NOTFOUND; DBMS_RLS.DROP_POLICY( '"'||object_schema||'"', '"'||object_name||'"', '"'||policy_name||'"'); END LOOP; CLOSE stmt; END; /
Run DVCA to reconfigure Database Vault. Use the following syntax:
$ORACLE_HOME/bin/dvca -action option -oh oracle_home -jdbc_str jdbc_connection_string -owner_account DV_owner_account_name [-acctmgr_account DV_account_manager_account_name] [-logfile ./dvca.log] [-nodecrypt]
Where:
- action
: The action to perform. option creates the Database Vault schema objects, creates the DV_OWNER
account and the optional DV_ACCTMGR
account, and deploys the Database Vault Administrator application.
- oh
: The absolute path of the Oracle home for the database
- jdbc_str
: The JDBC connection string used to connect to the database. For example, jdbc:oracle:oci:@orcl1
, where orcl1
is the net service name in the tnsnames.ora
file ($ORACLE_HOME\network\admin\tnsnames.ora
).
- owner_account
: Oracle Database Vault Owner account name
- acctmgr_account
: (Optional) Oracle Database Vault Account Manager user
- logfile
: Optionally, specify a log file name and location. You can enter an absolute path or a path that is relative to the location of the ORACLE_BASE
\
ORACLE_HOME
\bin directory
- nodecrypt
: Reads plaintext passwords as passed on the command line. You must use this option if you are passing plaintext passwords to the command.
Note:
You are prompted to enter theSYS
, Database Vault Owner, and Database Vault Account Manager passwords.See Also:
Oracle Database Vault Installation Guide, Appendix C "Running DVCA After Creating a Database Vault Database" for more options available with thedvca -action
commandRun Oracle Database Vault Configuration Assistant (DVCA) by using the dvca
-action
enable
option. This enables the Database Vault triggers. Use the following syntax:
dvca -action enable -service service_name -owner_account DV_owner_account_name [-logfile ./dvca.log] [-nodecrypt] Enter SYS password: SYS_password Enter owner password: owner_password
Lock the DVSYS account. Use the following SQL statements:
SQL> CONNECT SYS "AS SYSDBA" Enter password: SQL> ALTER USER DVSYS ACCOUNT LOCK;
Shut down the database.
To stop a single-instance database, use the following commands:
sqlplus SYS "AS SYSDBA" Enter password: SQL> SHUTDOWN IMMEDIATE
For an Oracle RAC database, use the following command:
$ORACLE_HOME/bin/srvctl stop database -d db_name
Relink the Oracle executable to turn on the Oracle Database Vault option. Use the following commands:
Turn on Database Vault.
cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk dv_on cd $ORACLE_HOME/bin relink all
Note:
For an Oracle RAC database, you must repeat the preceding commands on all nodes.Start the database.
For a single-instance database, use the following commands:
sqlplus SYS "AS SYSDBA" Enter password: SQL> startup
For an Oracle RAC database, use the following command:
$ORACLE_HOME/bin/srvctl start database -d db_name
If you wish to disable connections with SYSDBA
privileges, then re-create the password file with the nosysdba=y
and force=y
flags. Use the following syntax:
orapwd file=$ORACLE_HOME/dbs/orapwSID password=password force=y nosysdba=y
Here SID
is the Oracle system identifier (SID) of the database, and password is the password for the SYS
account.
If you have installed and configured Oracle Configuration Manager in the original Oracle home directory, then complete the following procedure:
In the cloned Oracle home, remove all the subdirectories of the $ORACLE_HOME/ccr/hosts
directory to remove the previously configured hosts.
In the cloned Oracle home, run the following command:
$ configCCR -a
If you have installed Oracle Configuration Manager in the original Oracle home but have not configured it, then run the following command to configure it in the cloned Oracle home:
$ setupCCR
See one of the following sections for upgrading an Oracle Database 10g release 10.2.0.x to Oracle Database 10g release 10.2.0.5:
After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home:
Note:
If you do not run the Oracle Database Upgrade Assistant as described in this section, the following errors are displayed on attempting to start the database:ORA-01092: ORACLE instance terminated.
ORA-39700: database must be opened with UPGRADE option.
Log in as the Oracle software owner user.
Set the values for the environment variables $ORACLE_HOME
, $ORACLE_SID
and $PATH
.
For single-instance installations, if you are using Automatic Storage Management, start the Automatic Storage Management instance.
For Oracle single-instance installations, start the listener
as follows:
$ lsnrctl start listenername
Run Oracle Database Upgrade Assistant either in the interactive or noninteractive mode:
Interactive mode:
Enter the following command from the command prompt:
$ dbua
Note:
DBUA may edit initialization parameters in theinit.ora
file or net services in the tnsnames.ora
file of the current database. Back up init.ora
file and tnsnames.ora
file when upgrading to 10.2.0.5 with DBUA.Complete the following steps displayed in the Oracle Database Upgrade Assistant screen:
On the Welcome screen, click Next.
On the Databases screen, select the name of the Oracle Database that you want to update, then click Next.
Note:
For Oracle RAC, enter theSYS
password to do the upgrade.On the Recompile Invalid Objects screen, select the Recompile the invalid objects at the end of upgrade option, then click Next.
If you have not taken the back up of the database earlier, on the Backup
screen, select the I would like to take this tool to backup the database option, stipulate the Path, then click Next.
On the Summary screen, check the summary, then click Finish.
On the End of Database Upgrade Assistant's Upgrade Results screen, click Close to exit from Oracle Database Upgrade Assistant.
Note:
If you are upgrading a database where Oracle Database Control is configured in non-secure mode, then Oracle Database Control will run in secure mode after upgrade.If you are using the Oracle Recovery Manager catalog, enter the following command:
$ rman catalog username/password@alias RMAN> UPGRADE CATALOG;
For Oracle RAC installations, start any database services that you want to use by entering the following command:
$ srvctl start service -d db_name -s service_name
Noninteractive mode:
Enter the following command to upgrade Oracle Database using Oracle Database Upgrade Assistant in noninteractive mode:
$ dbua -silent -dbname $ORACLE_SID -oracleHome $ORACLE_HOME -sysDBAUserName UserName -sysDBAPassword SYS_password -recompile_invalid_objects true
Complete the following sections to upgrade an Oracle Database 10g release 10.2.0.x to Oracle Database 10g release 10.2.0.5:
If you are upgrading database manually, then you should analyze it by running the Pre-Upgrade Information Tool.
Running pre-upgrade utility tools (utlu102i
.sql
) is required for release upgrade (e.g 9.2.0.x to 10.2.0.x or 10.1.0.x to 10.2.0.x) and your database would open in NORMAL
mode for running the utlu102i
.sql
script for release upgrade. It is not required to run utlu102i
.sql
for patch set/version upgrade (for example, 10.2.0.x to 10.2.0.5) but it is recommended to run it. If you have installed 10.2.0.5 patch set on the top of the existing 10.2.0.x Oracle Home then the database must be open in UPGRADE
Mode only for running utlu102i
.sql
. The Pre-Upgrade Information Tool is a SQL script that ships with Oracle Database 10.2. Complete the following procedure to run the Pre-Upgrade Information Tool:
Start the database in the UPGRADE
mode:
SQL> STARTUP UPGRADE
Set the system to spool results to a log file for later analysis:
SQL> SPOOL upgrade_info.log
Run the Pre-Upgrade Information Tool:
SQL> @/rdbms/admin/utlu102i.sql
Turn off the spooling of script results to the log file:
SQL> SPOOL OFF
Check the output of the Pre-Upgrade Information Tool in the upgrade_info.log
file. The following is an example of the output generated by the Pre-Upgrade Information Tool:
Oracle Database 10.2 Upgrade Information Utility 02-04-2008 11:48:11 . ********************************************************************** Database: ********************************************************************** --> name: X102050 --> version: 10.2.0.1.0 --> compatible: 10.2.0.1 --> blocksize: 8192 . ********************************************************************** Tablespaces: [make adjustments in the current environment] ********************************************************************** --> SYSTEM tablespace is adequate for the upgrade. .... minimum required size: 505 MB .... AUTOEXTEND additional space required: 15 MB --> UNDOTBS1 tablespace is adequate for the upgrade. .... minimum required size: 401 MB .... AUTOEXTEND additional space required: 376 MB --> SYSAUX tablespace is adequate for the upgrade. .... minimum required size: 265 MB .... AUTOEXTEND additional space required: 15 MB --> TEMP tablespace is adequate for the upgrade. .... minimum required size: 58 MB .... AUTOEXTEND additional space required: 38 MB --> EXAMPLE tablespace is adequate for the upgrade. .... minimum required size: 69 MB . ********************************************************************** Update Parameters: [Update Oracle Database 10.2 init.ora or spfile] ********************************************************************** WARNING: --> "shared_pool_size" needs to be increased to at least 167772160 WARNING: --> "java_pool_size" needs to be increased to at least 67108864 . ********************************************************************** Components: [The following database components will be upgraded or installed] ********************************************************************** --> Oracle Catalog Views [upgrade] VALID --> Oracle Packages and Types [upgrade] VALID --> JServer JAVA Virtual Machine [upgrade] VALID --> Oracle XDK for Java [upgrade] VALID --> Oracle Java Packages [upgrade] VALID --> Oracle Text [upgrade] VALID --> Oracle XML Database [upgrade] VALID --> Oracle Workspace Manager [upgrade] VALID --> Oracle Data Mining [upgrade] VALID --> Messaging Gateway [upgrade] VALID --> OLAP Analytic Workspace [upgrade] VALID --> OLAP Catalog [upgrade] VALID --> Oracle OLAP API [upgrade] VALID --> Oracle interMedia [upgrade] VALID --> Spatial [upgrade] VALID --> Oracle Ultra Search [upgrade] VALID --> Oracle Label Security [upgrade] VALID --> Expression Filter [upgrade] VALID --> EM Repository [upgrade] VALID --> Rule Manager [upgrade] VALID PL/SQL procedure successfully completed.
The following sections describe the output of the Pre-Upgrade Information Tool.
Database
This section displays global database information about the current database, such as the database name and release number before the database is upgraded.
Tablespaces
This section displays a list of tablespaces in the current database. For each tablespace, the tablespace name and minimum required size is displayed. In addition, a message is displayed if the tablespace is adequate for the upgrade. If the tablespace does not have enough free space, then space must be added to the tablespace in the current database. Tablespace adjustments must be made before the database is upgraded.
Update/Obsolete/Deprecated Parameters
These sections display a list of initialization parameters in the parameter file of the current database that should be adjusted before the database is upgraded. The adjustments must be made to the Oracle Database 10.2 init.ora
or spfile
.
Components
This section displays a list of database components that are upgraded or installed when the current database is upgraded.
After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home:
Note:
If you do not run thecatupgrd.sql
script as described in this section and you start up a database for normal operation, then ORA-01092: ORACLE instance terminated. Disconnection forced
errors will occur and the error ORA-39700: database must be opened with UPGRADE option
will be in the alert log.Log in as the Oracle software owner user.
For Oracle RAC installations, start listener on each node of the cluster as follows:
$ srvctl start listener -n node
If you are using Automatic Storage Management, start the Automatic Storage Management instance.
For single-instance installations, start the listener
as follows:
$ lsnrctl start
For single-instance installations, use SQL*Plus to log in to the database as the SYS
user with SYSDBA
privileges:
$ sqlplus /nolog
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
Users of single-instance implementations should now bypass steps that apply to Oracle RAC installations.
For Oracle RAC installations:
Use SQL*Plus to log in to the database as the SYS
user with SYSDBA
privileges:
$ sqlplus /nolog
SQL> CONNECT SYS AS SYSDBA
Enter password: SYS_password
SQL> STARTUP NOMOUNT
Set the CLUSTER_DATABASE
initialization parameter to FALSE
:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
Shut down the database:
SQL> SHUTDOWN
Enter the following SQL*Plus commands:
SQL> STARTUP UPGRADE SQL> SPOOL patch.log SQL> @?/rdbms/admin/catupgrd.sql SQL> SPOOL OFF
Review the patch.log
file for errors and inspect the list of components that is displayed at the end of catupgrd.sql
script.
This list provides the version and status of each SERVER
component in the database.
If necessary, rerun the catupgrd.sql
script after correcting any problems.
Restart the database:
SQL> SHUTDOWN IMMEDIATE SQL> STARTUP
Run the utlrp.sql
script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> @?/rdbms/admin/utlrp.sql
Note:
When the 10.2.0.5 patch set is applied to an Oracle10g Standard Edition database, there may be 54 invalid objects after theutlrp.sql
script runs. These objects belong to the unsupported components and do not affect the database operation.
Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following:
BIN$4lzljWIt9gfgMFeM2hVSoA==$0
This issue is tracked with Oracle bug 9386364.
Run the following command to check the status of all the components after the upgrade:
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
In the output of the preceding command, the status of all the components should be VALID
for a successful upgrade.
If you are using the Oracle Recovery Manager catalog, enter the following command:
$ rman catalog username/password@alias RMAN> UPGRADE CATALOG;
For Oracle RAC installations:
Set the CLUSTER_DATABASE
initialization parameter to TRUE
:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;
Restart the database:
SQL> SHUTDOWN IMMEDIATE SQL> STARTUP
Start any database services that you want to use:
$ srvctl start service -d db_name -s service_name
To configure and secure Enterprise Manager follow these steps:
Ensure the database and Listener are operational.
In the case of a single instance, execute
emca -upgrade db
In the case of Oracle RAC, execute
emca -upgrade db -cluster
Note:
If you are upgrading a database where Oracle Database Control is configured in non-secure mode, then Oracle Database Control will run in secure mode after upgrade.If you have deployed Oracle Workflow Server, then you must redeploy it after installing the 10.2.0.5 patch set.
To redeploy the Oracle Workflow Server:
Stop Oracle Workflow Manager. Use the following command:
$ORACLE_HOME/wf/admin/wfmgrstop.sh
Back up the existing deploy_db_wf.ini
file. You can find this file at the following location:
$ORACLE_HOME/oc4j/j2ee/deploy_db_wf.ini
Modify the deploy_db_wf.ini
file to add the DEPLOYED=TRUE
keyword to the Listener and Mailer sections:
[application] CMP_NAME=OC4J_Workflow_Component_Container APP_DEPLOYMENT_NAME=WFALSNRSVCApp DEPLOYED=true .... [application] CMP_NAME=OC4J_Workflow_Component_Container APP_DEPLOYMENT_NAME=WFMLRSVCApp DEPLOYED=true
Deploy the new Oracle Workflow Manager ear
file:
$ORACLE_HOME/jdk/bin/java -classpath \ $ORACLE_HOME/oc4j/j2ee/home/oc4j.jar:$ORACLE_HOME/jlib/srvm.jar:\ $ORACLE_HOME/oc4j/j2ee/home/db_oc4j_deploy.jar \ oracle.j2ee.tools.deploy.DbOc4jDeploy -oraclehome \ $ORACLE_HOME -inifile $ORACLE_HOME/oc4j/j2ee/deploy_db_wf.ini
Start Oracle Workflow Manager:
$ORACLE_HOME/wf/admin/wfmgrstart.sh
If you are running Oracle Ultra Search from the upgraded Oracle home, then you must redeploy the ultrasearch_admin.ear
file to your oc4j
instance.
To redeploy ultrasearch_admin.ear
file, copy the $ORACLE_HOME
/ultrasearch/webapp/ultrasearch_admin.ear
file to the $ORACLE_HOME
/oc4j/j2ee/oc4j_applications/applications
directory.
Note:
This applies only if you have installed Oracle Ultra Search.Downgrading Oracle Database Vault from 10.2.0.5 to 10.2.0.x requires the following steps:
Follow the steps in section "Disabling Oracle Database Vault."
Follow the steps in section "Removing the Patch Set Software."
Follow the steps in section "Enabling Oracle Database Vault."
The catdwgrd.sql
script enables the user to restore the Oracle Database installation of the database back to the original 10.2 release that the user backed up before applying the patch set. The catdwgrd.sql
script is run in the 10.2.0.5 Oracle home to perform necessary downgrade actions. After the 10.2.0.x release is restored, the catrelod.sql
script is run from 10.2.0.x Oracle home to reload the 10.2.0.x release packages and views.
See one of the following sections for information about how to remove the patch set software based on the Oracle Database installation type:
Note:
Oracle Clusterware downgrade is not supported.
You can run a higher version of Oracle Clusterware software with a lower version of Oracle Database.
Perform the following steps for removing the patch set from the 10.2.0.5 patch release:
Use SQL*Plus to log in to the database as the SYS
user with SYSDBA
privileges:
$ sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
SQL> SHUTDOWN IMMEDIATE
SQL> EXIT
Take a backup of the following file in 10.2.0.5 Oracle home directory:
$ ORACLE_HOME/rdbms/admin/catrelod.sql $ ORACLE_HOME/network/admin/tnsnames.ora
Enter the following SQL*Plus commands:
$ cd $ORACLE_HOME/bin
$ ./sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
SQL> STARTUP DOWNGRADE
SQL> SPOOL downgrade.out
SQL> @?/rdbms/admin/catdwgrd.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
SQL> EXIT
Review the downgrade.out
file for errors.
Restore the Oracle10g installation and Central Inventory (see /etc/oraInst.loc
) that you backed up before applying the patch set.
After restoring the original Oracle home, copy the saved version of catrelod.sql
script into the restored Oracle home rdbms/admin
directory. Also copy the saved version of 10.2.0.5/network/admin/tnsnames.ora
directory into the restored Oracle home /network/admin/tnsnames.ora
directory, and then perform the following steps:
$ sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
SQL> STARTUP DOWNGRADE
SQL> SPOOL catrelod.out
SQL> @?/rdbms/admin/catrelod.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
Review the catrelod.out
file for errors.
Note:
Ignore the ORA-29844 and ORA-31085 errors found in thecatrelod.out
file. These errors are tracked with Oracle bugs 4758112 and 4425495 respectively.
After reloading a 10.2.0.2 release, the version number for Oracle Data Mining remain at 10.2.0.5. This issue is tracked with Oracle bug 4758695.
After reloading a 10.2.0.1 or a 10.2.0.2 release, the version number for Oracle OLAP Analytic Workspace remain at 10.2.0.5. This issue is tracked with Oracle bug 4751917.
Start the database and recompile the remaining invalid objects:
SQL> STARTUP SQL> @?/rdbms/admin/utlrp.sql
Cross-check the status of installed components with the following script:
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
Perform the following steps for removing the patch set from the 10.2.0.5 patch release:
Use SQL*Plus to log in to the database as the SYS
user with SYSDBA
privileges:
$ sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
Set the CLUSTER_DATABASE
initialization parameter to FALSE
:
Note:
If the system uses an initialization parameter file, change the value of theCLUSTER_DATABASE
initialization parameters to TRUE
in the initialization parameter file (init
sid
.ora
).SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
Exit SQL*Plus and shut down the database:
$ srvctl stop database -d db_name
Take a backup of the catrelod.sql
file and admin
folder in 10.2.0.5 Oracle home directory:
$ ORACLE_HOME/rdbms/admin/catrelod.sql $ ORACLE_HOME/network/admin
Enter the following SQL*Plus commands:
$ sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
SQL> STARTUP DOWNGRADE
SQL> SPOOL catdwgrd.out
SQL> @?/rdbms/admin/catdwgrd.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
SQL> EXIT
Restore the Oracle10g installation and Central Inventory (see /etc/oraInst.loc
) that you backed up before applying the patch set on both the nodes.
After restoring the original Oracle home, copy the saved version of catrelod.sql
script into the restored Oracle home rdbms/admin
directory. Also copy the saved version of 10.2.0.5/network/admin/tnsnames.ora
directory into the restored Oracle home /network/admin/tnsnames.ora
directory, and then perform the following steps:
$ sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
SQL> STARTUP DOWNGRADE
SQL> SPOOL catrelod.out
SQL> @?/rdbms/admin/catrelod.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
Review the catrelod.out
file for errors.
Note:
Ignore the ORA-29844 and ORA-31085 errors found in thecatrelod.out
file. These errors are tracked with Oracle bugs 4758112 and 4425495 respectively.
After reloading the 10.2.0.2 release, the version numbers for Oracle Data Mining and Oracle OLAP Analytic Workspace remain at 10.2.0.5. These issues are tracked with Oracle bugs 4758695 and 4751917.
Start the database and recompile the remaining invalid objects:
SQL> STARTUP SQL> @?/rdbms/admin/utlrp.sql
Cross-check the status of installed components with the following script:
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
Set the CLUSTER_DATABASE
initialization parameter to TRUE
:
Note:
If the system uses an initialization parameter file, change the value of theCLUSTER_DATABASE
initialization parameters to TRUE
in the initialization parameter file (init
sid
.ora
).SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;
SQL> SHUTDOWN
SQL> EXIT
Start the database:
$ srvctl start database -d db_name
Note:
Option for removing Oracle Clusterware patch set is not available in 10.2.0.5. This issue is tracked with Oracle bug 5598010.If you have installed CCR, then you should remove it manually. Complete the following steps to remove CCR, if it was configured manually after installing Oracle Database 10g Release 2 (10.2.0.5):
Create a response file with following entries:
oracle.sysman.ccr|b_localInstall=true oracle.sysman.ccr|b_acceptLicense=true
Change to the $ORACLE_HOME/oui/bin
directory.
Run the following command to remove the ccr
directory from the Oracle Database 10g Release 2 (10.2.0.5) Oracle home:
runConfig.sh ORACLE_HOME=OH ACTION=deconfigure MODE=perform RERUN=true COMPONENT_XML={ccr_xml} RESPONSE_FILE=rsp_file_location
In the preceding command, ccr_xml
is available in the $ORACLE_HOME/inventory/ContentsXML/ConfigXML
and the rsp_file_location
is the directory where the response file was created. To find the ccr_xml
file, run the ls oracle.sysman.ccr.10*.xml
command in $ORACLE_HOME/inventory/ContentsXML/ConfigXML
directory.
If necessary, you can reinstall a patch set that has been applied to an Oracle Database 10g installation. You must reinstall the patch set interactively.
To reinstall the patch set:
Log in as the oracle
user.
If you are not installing the software on the local computer, enter the following command to direct X applications to display on the local computer:
Bourne, Bash, or Korn shell:
$ DISPLAY=local_host:0.0 ; export DISPLAY
C shell:
% setenv DISPLAY local_host:0.0
In this example, local_host
is the host name or IP address of the computer that you want to use to display Oracle Universal Installer.
Enter the following commands to start Oracle Universal Installer, where patchset_directory
is the directory where you unpacked the patch set software:
$ cd patchset_directory/Disk1
$ ./runInstaller
On the Welcome screen, click Next.
In the Specify Home Details screen, select the name of the Oracle home that you want to update, or select the Path that you want to update from the list, then click Next.
If you are installing the patch set on an Oracle RAC cluster, click Next when the Selected Nodes screen appears.
Note:
If you are not sure of the name of the Oracle home, click Installed Products to determine the name of the Oracle home that you want to upgrade.The Available Product Component screen appears. This screen contains a list of all components that have been patched by the original patch set installation. These components are grayed out, indicating they cannot be selected for installation.
Expand the nodes for each component listed in the tree to display the patch that corresponds to each component.
Select the patches that you want to install.
When you select a patch, the Install Status column changes to Reinstall.
Repeat the process for each patch bundled in the patch set, then click Next.
On the Summary screen, verify the list of patches to be reinstalled, then click Install.
On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.
Review the following known issues after you apply the patch set:
The SYSMAN Related Errors Are Listed in the oraInstall.err File
Benign Entry in the Silent Log File After Cloning the Database
SETUPCCR Fails if Preset JAVA_HOME Points to an Invalid JDK Home
In Red Hat Enterprise Linux 5 Default Makefile Version does not Support Default DBNAME
Oracle Enterprise Manager Throws 500 Internal Server Error When Scheduler Job Is Created
500 Internal Server Error When Refreshing the View in Oracle Enterprise Manager
Use ASMCA to Administer Disk Groups for Older Database Versions
Error When Trying to Stop Oracle Ultra Search with searchctl stop Command
Non-ASCII Characters in Help Navigator Window May Be Displayed Improperly
Invalid Objects Seen After Upgrading Oracle Database from 9.2.0.8 to 10.2.0.5
If you are using an Oracle Database release 10.2.0.2 preconfigured Standard Edition database, then the database contains the following components that are not supported by the Standard Edition:
Oracle Data Mining
Oracle OLAP Catalog
Oracle OLAP Analytic Workspace
Oracle OLAP API
Oracle Spatial
The catupgrd.sql
script does not run the patch scripts for these components. It sets the component STATUS to OPTION OFF
in the DBA_REGISTRY
view. The original versions of the dictionary objects for the components remain in the database but the catupgrd.sql
script does not apply the patch to them.
During the postupgrade phase of DBUA, the following error might be seen:
ORA-00600: internal error code, arguments [LibraryCacheNotEmptyOnClose]
Workaround:
Click the Ignore button to continue upgrade. User can safely ignore this error.
This issue is tracked with Oracle bug 4483084.
When you use Oracle Universal Installer to remove Oracle Database 10g Release 2 (10.2.0.4), some sysman related errors are listed in the oraInstall.err
file.
Workaround:
These are benign errors and can be ignored.
This issue is tracked with Oracle bug 6363210.
An entry similar to the following is logged in the silent log file immediately after you clone the database:
File not found: $ Cloned_Oracle_home/ccr/new_ccr/ccr/bin/setupCCR
Workaround:
This entry in the log file is not a error and can be ignored.This issue is tracked with Oracle bug 6721838.
To enable a new native full outer join implementation in the database, a user has to set the following underscore parameter:
_optimizer_native_full_outer_join =force
You can set this parameter for the system or for a specific session.
Besides dramatically improving the performance of a full outer join, the new implementation fixes a variety of issues, for examples a variety of ORA-942
(table or view doesn't exists) and ORA-4331
(unable to allocate string bytes of shared memory) errors.
This issue is tracked with Oracle bug 6322672.
When CCR is manually configured using setupCCR
from a terminal on which JAVA_HOME
is predefined and if it points to an invalid location or JRE_HOME
instead of a valid JDK_HOME
, the command fails.
Workaround:
Unset JAVA_HOME
and reinvoke setupCCR
.
The default Makefile version present in a Red Hat 5 computer is make 3.81. With this version, the default dbname
is not recognized by those Oracle clients which are directly called from the Makefile.
Workaround:
You can use either of the following approaches:
Use Makefile version 3.79
Use @dbname
whenever username/password
is used in the Makefile
When creating scheduler jobs, clicking the OK button while in the Options tab triggers an Internal Server Error.
Workaround: Switch to a different tab before clicking the OK button. The job will be created properly in line with what has been entered in the Options tab.
This issue is tracked by Oracle bug 6863977.
After submitting a workload capture job with the database restart option enabled, viewing or refreshing some other Oracle Enterprise Manager pages from the page which shows that the message for job submission succeeded may cause Oracle Enterprise Manager to display the following error:
500 Internal Server Error
Workaround:
Close the existing Oracle Enterprise Manager session. After the database is fully restarted, open a new Oracle Enterprise Manager session to view the workload capture job.
This issue is tracked by Oracle bug 6498607. Note that this bug was uncovered in an Oracle RAC environment, and may or may not apply to single instance implementations.
When upgrading CRS from release 10.2.0.1 to 10.2.0.2 to 10.2.0.5, the ONS process goes offline.
This issue is tracked with Oracle bug 8925749.
The following Oracle Spatial error may be seen in the catrelod.out
file when downgrading from 10.2.0.5 to 10.2.0.4:
ORA-29844: duplicate operator name specified
Workaround:
Ignore this error.
This issue is tracked with Oracle bug 9023792.
If you install Oracle Clusterware 11.2 and Oracle RAC 10.2, then use Oracle ASM Configuration Assistant (ASMCA) to create and modify disk groups. Starting with 11g Release 2, Oracle ASM is installed as part of a grid infrastructure installation, with Oracle Clusterware. You can no longer use Database Configuration Assistant (DBCA) to perform administrative tasks on Oracle ASM.
When you try to run the searchctl stop
command to stop Oracle Ultra Search, the following error may occur:
java.io.IOException: Server protocol was not ORMI
This issue is tracked with Oracle bug 9448941.
Non-ASCII characters in the Help Navigator window may not be displayed properly and appear to be distorted for most Java GUI conventional components, such as Oracle Database Configuration Assistant, Oracle Database Upgrade Assistant, Oracle Net Configuration Assistant, Oracle Net Manager, Oracle Directory Manager, Oracle Work Manager, and Locale Builder. The issue appears when the operating system locale includes a character encoding other than the one used to encode the help files. For example, the problem is visible when the UTF-8 encoding is used. The issue slightly impacts five translated European languages and severely impacts Chinese and Korean languages. Japanese language is not affected. This issue only affects the help navigation tree and has no effects on the help topic window.
Workaround:
You should change the operating system locale to one from the following list to see the Help Navigator contents properly:
de_DE.iso88591 for German
fr_FR.iso88591 for French
it_IT.iso88591 for Italian
es_ES.iso88591 for Spanish
pt_BR.iso88591 for Brazilian Portuguese
zh_CN.gb2312 for Simplified Chinese
zh_TW.big5 for Traditional Chinese
ko_KR.euckr for Korean
Complete one of the following tasks to change the locale:
Run the following commands to alter the locale in a terminal session temporarily:
In sh
and related shell programs:
$ LANG=locale
$ export LANG
In csh
and related shell programs:
$ setenv LANG locale
Use this terminal session to start the components to see only the help topics. You should start components for other tasks in other terminals that have the default locale.
Create shell files to start the affected components with the required locale. For example, create the following file to run Oracle Database Configuration Assistant with Simplified Chinese locale:
#!/bin/sh LANG=zh_CN.gb2312; export LANG; dbca
Name the file, for example, dbca_zh_CN
, place it in your path, set its executable bit, and use it to start the component.
Note:
This workaround does not apply when the component is called from a different program, such as Oracle Universal Installer.To alter the system default locale as the operating system administrator, change the encoding entry to one of the suggested encodings in the /etc/sysconfig/i18n
file. Then restart the computer.
To alter the locale in the user login environment file, such as .bash_profile
, add one of the following set of lines, depending on the file:
LANG=locale
export LANG
or
setenv LANG locale
With the modified operating system locale encoding, the file system related operations that use non-ASCII characters are affected. For example, creating a file with non-ASCII file name generates a different name depending on the locale used. A file created under one encoding cannot be opened with the same name under another encoding as the internal binary representation of the name differs. If you want to assure integrity of file system operations, do not use non-ASCII characters in file names when the workaround third or fourth is applied. Apply the first workaround to see only the help in the changed locale. If you want to apply the second workaround, do not use non-ASCII characters in file names processed by the affected Oracle components.
The change of the operating system locale may also cause a mismatch between the configuration of character terminals and the output of translated operating system utilities and third-party applications. You should either reconfigure the terminals to match the changed encoding or use the first and the second workarounds only.
This issue is addressed in Oracle Database 11g (11.1.0.6). Therefore, Oracle recommends you to alter the system default locale or the locale in the user login environment file back to the default encoding (UTF-8) after release 10.2.x is upgraded to release 11.1.x.
This is tracked with Oracle bug 6503286.
After you upgrade Oracle database from release 9.2.0.8 to release 10.2.0.5 using the Database Upgrade Assistant from 10.2.0.5 Oracle RAC home, the following invalid components are seen:
WK_UTIL
WK_CRW
WKDS_ADM
WK_ERR
Workaround: Install these components from the 10.2 Companion CD before applying the 10.2.0.5 patch set.
This issue is tracked with Oracle bug 9351000.
After installing 10.2.0.5 patch set, the version number for Oracle Partitioning Patch component does not change to 10.2.0.5.
This issue is tracked with Oracle bug 9909729.
The following table lists platform-specific bugs that have been fixed.
Fixed in Release | Bug Number | Description |
---|---|---|
10.2.0.4 | 4698310 |
ODBC CAUSES UNDEFINED SYMBOL SLEEP ERROR WHEN FAILOVER HAPPENS |
10.2.0.3 | 5218245 |
REMAP_FILE_PAGES SUPPORT IN 10.2 IS MISSING CHANGES FROM 9I AND 10.1 |
10.2.0.3 | 4966320 |
OCRDUMP -BACKUPFILE FAILED WITH PROT-302 |
10.2.0.3 | 4930898 |
FLOATING POINT CALCULATIONS GIVE DIFFERENT RESULTS WHEN CONNECTED TO 10G DB |
10.2.0.3 | 4517854 |
INITIALIZATION OF INTERNAL RECOVERY MANAGER PACKAGE FAILED ORA-01031 |
10.2.0.2 | 4747264 |
WRONG PERMISSIONS AFTER CLIENT INSTALL OF 10GR2 (10.2.0.1) |
10.2.0.2 | 4516865 |
WRONG PERMISSIONS AFTER INSTALLATION IN OH AND SUBSEQUENT DIRECTORIES |
The following table provides a list of patch set components:
Component | Version |
---|---|
Advanced Queuing (AQ) API | 10.2.0.5 |
Advanced Queuing (AQ) API Demos | 10.2.0.5 |
Advanced Replication | 10.2.0.5 |
Agent Required Support Files | 10.2.0.5 |
Assistant Common Files | 10.2.0.5 |
Authentication and Encryption | 10.2.0.5 |
Authentication and Encryption 32-bit | 10.2.0.5 |
CSS Single-instance Common Files | 10.2.0.5 |
Character Set Migration Utility | 10.2.0.5 |
Clusterware | 10.2.0.5 |
DBJAVA Required Support Files | 10.2.0.5 |
Data Management Services Common Files | 10.2.0.5 |
Data Mining Scoring Engine | 10.2.0.5 |
Database Configuration Assistant | 10.2.0.5 |
Database SQL Scripts | 10.2.0.5 |
Database Upgrade Assistant | 10.2.0.5 |
Database Vault | 10.2.0.5 |
Database Verify Utility | 10.2.0.5 |
Enterprise Manager Agent | 10.2.0.5 |
Enterprise Manager Common Files | 10.2.0.5 |
Enterprise Manager Repository | 10.2.0.5 |
Enterprise Manager plugin Common Files | 10.2.0.5 |
Export/Import | 10.2.0.5 |
External Naming: NIS | 10.2.0.5 |
Generic Connectivity Common Files | 10.2.0.5 |
Generic Connectivity Using ODBC (32-bit and 64-bit) | 10.2.0.5 |
HAS component of Oracle Clusterware install | 10.2.0.5 |
Installation Common Files | 10.2.0.5 |
iSQL*Plus | 10.2.0.5 |
JAccelerator (NCOMP) | 10.2.0.5 |
JDBC Common Files | 10.2.0.5 |
JDBC/OCI Common Files | 10.2.0.5 |
JDBC/OCI Common Files for Instant Client | 10.2.0.5 |
LDAP Required Support Files | 10.2.0.5 |
New Database ID | 10.2.0.5 |
Object Type Translator | 10.2.0.5 |
Oracle C++ Call Interface | 10.2.0.5 |
Oracle C++ Call Interface Demos | 10.2.0.5 |
Oracle C++ Call Interface for Instant Client | 10.2.0.5 |
Oracle Call Interface (OCI) | 10.2.0.5 |
Oracle Call Interface (OCI) Demos | 10.2.0.5 |
Oracle Client | 10.2.0.5 |
Oracle Client Required Support Files | 10.2.0.5 |
Oracle Common Schema Demos | 10.2.0.5 |
Oracle Configuration Manager | 10.3.2.1 |
Oracle Connection Manager | 10.2.0.5 |
Oracle Containers for Java | 10.2.0.5 |
Oracle Containers for Java Demos | 10.2.0.5 |
Oracle Text Knowledge Bases | 10.2.0.5 |
Oracle Core Required Support Files | 10.2.0.5 |
Oracle Data Mining | 10.2.0.5 |
Oracle Data Mining Demos | 10.2.0.5 |
Oracle Database 10G | 10.2.0.5 |
Oracle Database 10G Companion Products | 10.2.0.5 |
Oracle Database 10G Products | 10.2.0.5 |
Oracle Database Demos | 10.2.0.5 |
Oracle Database Utilities | 10.2.0.5 |
Oracle Enterprise Manager Console DB | 10.2.0.5 |
Oracle Globalization Support | 10.2.0.5 |
Oracle Globalization Support Demos | 10.2.0.5 |
Oracle Instant Client | 10.2.0.5 |
Oracle Instant Client Required Support Files | 10.2.0.5 |
Oracle interMedia Annotator | 10.2.0.5 |
Oracle interMedia Client Demos | 10.2.0.5 |
Oracle interMedia Common Files | 10.2.0.5 |
Oracle interMedia Client Compatibility Files | 10.2.0.5 |
Oracle interMedia Image | 10.2.0.5 |
Oracle interMedia Image Accelerator | 10.2.0.5 |
Oracle interMedia Java Advanced Imaging | 10.2.0.5 |
Oracle interMedia Locator | 10.2.0.5 |
Oracle Internet Directory Client | 10.2.0.5 |
Oracle Internet Directory Client Common Files | 10.2.0.5 |
Oracle Internet Directory Tools | 10.2.0.5 |
Oracle JDBC Development Drivers | 10.2.0.5 |
Oracle JDBC Development Drivers Demos | 10.2.0.5 |
Oracle JDBC Development Drivers for Instant Client | 10.2.0.5 |
Oracle JDBC Thin Driver for JDK 1.2 | 10.2.0.5 |
Oracle JDBC Thin Driver for JDK 1.4 | 10.2.0.5 |
Oracle JDBC Thin Driver for JDK 1.4 for Instant Client | 10.2.0.5 |
Oracle JVM | 10.2.0.5 |
Oracle Java Tools | 10.2.0.5 |
Oracle Label Security | 10.2.0.5 |
Oracle Label Security Demos | 10.2.0.5 |
Oracle Locale Builder | 10.2.0.5 |
Oracle Net | 10.2.0.5 |
Oracle Net Configuration Assistant | 10.2.0.5 |
Oracle Net Listener | 10.2.0.5 |
Oracle Net Manager | 10.2.0.5 |
Oracle Net Required Support Files | 10.2.0.5 |
Oracle OLAP Analytic Workspace | 10.2.0.5 |
Oracle OLAP API | 10.2.0.5 |
Oracle OLAP Catalog | 10.2.0.5 |
Oracle Partitioning | 10.2.0.5 |
Oracle RAC Required Support Files | 10.2.0.5 |
Oracle RAC Required Support Files-HAS | 10.2.0.5 |
Oracle Real Application Clusters | 10.2.0.5 |
Oracle SQLJ | 10.2.0.5 |
Oracle Spatial | 10.2.0.5 |
Oracle Spatial Demos | 10.2.0.5 |
Oracle Starter Database | 10.2.0.5 |
Oracle Text | 10.2.0.5 |
Oracle Text Samples | 10.2.0.5 |
Oracle Transparent Gateway for IBM DRDA | 10.2.0.5 |
Oracle Ultra Search Middle-Tier | 10.2.0.5 |
Oracle Ultra Search Server | 10.2.0.5 |
Oracle Wallet Manager | 10.2.0.5 |
Oracle Workspace Manager | 10.2.0.5 |
Oracle XML Developer's Kit | 10.2.0.5 |
Oracle XML SQL Utility | 10.2.0.5 |
Oracle 10g Real Application Clusters Common Files | 10.2.0.5 |
PL/SQL | 10.2.0.5 |
PL/SQL Embedded Gateway | 10.2.0.5 |
PL/SQL Required Support Files | 10.2.0.5 |
Parser Generator Required Support Files | 10.2.0.5 |
Precompiler Common Files | 10.2.0.5 |
Precompiler Required Support Files | 10.2.0.5 |
Pro*C/C++ Demos | 10.2.0.5 |
Pro*COBOL (32-bit and 64-bit) | 10.2.0.5 |
Pro*COBOL Demos | 10.2.0.5 |
Pro*FORTRAN (32-bit) | 10.2.0.5 |
Pro*FORTRAN Demos | 10.2.0.5 |
RDBMS Required Support Files | 10.2.0.5 |
Recovery Manager | 10.2.0.5 |
Replication API | 10.2.0.5 |
SQL*Loader | 10.2.0.5 |
SQL*Plus | 10.2.0.5 |
SQL*Plus Demos | 10.2.0.5 |
SQL*Plus Required Support Files | 10.2.0.5 |
SQLJ Runtime | 10.2.0.5 |
SRVM component of Oracle Clusterware install | 10.2.0.5 |
SSL Required Support Files | 10.2.0.5 |
SSL Required Support Files for Instant Client | 10.2.0.5 |
Sample Schema | 10.2.0.5 |
Secure Socket Layer | 10.2.0.5 |
Utilities Common Files | 10.2.0.5 |
XDK Required Support Files | 10.2.0.5 |
XML | 10.2.0.5 |
XML Class Generator for C++ | 10.2.0.5 |
XML Class Generator for Java | 10.2.0.5 |
XML Parser for C | 10.2.0.5 |
XML Parser for C++ | 10.2.0.5 |
XML Parser for C++ Demos | 10.2.0.5 |
XML Parser for Java | 10.2.0.5 |
XML Transviewer Bean | 10.2.0.5 |
XML Transx | 10.2.0.5 |
XSQL Servlet | 10.2.0.5 |
XSQL Servlet Demos | 10.2.0.5 |
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 Patch Set Notes 10g Release 2 (10.2.0.5) Patch Set 4 for Linux x86
E15228-02
Copyright © 2009, 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.