oralce 升级文档参考（10.2.0.X)待续

因为要解决oracle的bug,需要经常对各种版本的数据库进行升级，因此整理下补丁包的readme，方便今后参考：

 

Oracle® Database

Patch Set Notes

10g Release 2 (10.2.0.5) Patch Set 4 for HP-UX Itanium  补丁集的版本和支持的平台

E15234-01

May 2010 发表日期

 

1 Patch Set Overview 补丁集的介绍

You can apply the Oracle Database release 10.2.0.5 patch set to the following Oracle Database 10g release 2 installations:（补丁集针对的产品:集群件，客户端，RAC等）

• Oracle Database

• Oracle Real Application

• Oracle Database Client

• Oracle Database Companion CD

• Oracle Clusterware

• Oracle Database Vault

3 Components of This Patch Set 补丁集的组成

  3.1 提供了该补丁集可以修复的bug清单

 

The following table lists platform-specific bugs that have been fixed.

Fixed in ReleaseBug NumberDescription10.2.0.46603978FILES MISSING FROM THE PERL COMPONENT PACKED IN THE CLIENT INSTALL KIT10.2.0.46822813LMS O/S PRIORITY 154 SAME AS OTHER PROCESSES10.2.0.45401791LOT OF PSTAT CALLS WHEN CONNECTING ON 10.2.0/HP-UX ITANIUM MAY LEAD TO SLOWDOWN10.2.0.45010657QUERY OF V$OSSTAT RETURNS NO ROWS ON VPARS/HP-UX10.2.0.45593621MANY ORA-7445[_KILL()+48]HAPPENED AFTER ADDING CPUS USING VPAR WHICH HP PROVIDES10.2.0.45500535ERRORS IN FILES: WARNING:ORACLE PROCESS RUNNING OUT OF OS KERNEL I/O RESOURCES10.2.0.45169475SLRAC() IS UNRELIABLE ON HPUX - FALSE KGHU ERRORS AND KGH MESSAGES10.2.0.46058758INSTANCE STARTUP SLOW10.2.0.45401791LOT OF PSTAT CALLS WHEN CONNECTING ON 10.2.0/HP-UX ITANIUM MAY LEAD TO SLOWDOWN10.2.0.45500535ERRORS IN FILES: WARNING:ORACLE PROCESS RUNNING OUT OF OS KERNEL I/O RESOURCES10.2.0.45631422DEPLOY FAIL WHEN SET ACTION IS ''UPGRADE'' - /USR/LIB/HPUX32/DLD.SO: UNABLE TO F10.2.0.46474976OUI OVERWRITE /OPT/NMAPI/NMAPI2/LIB/HPUX32/LIBNMAPI2.SO.1 WHEN OUI UNINSTALL DB10.2.0.35363442SLRAC ERRORS ARE PREVENTING DUMP OF ERRORSTACK ON INTERNAL ERRORS10.2.0.34729565ORA-600 [12235] AND SKGPSPAWN FAILED ERROR 27143 ORA-0060010.2.0.35363442SLRAC ERRORS ARE PREVENTING DUMP OF ERRORSTACK ON INTERNAL ERRORS10.2.0.24674108SRV: ORA-7445 STACK TRACE SEEMS INCOMPLETE10.2.0.24709673ORA-27061, CAN'T STARTUP DB WHEN BIG SGA(30GB) IS SET10.2.0.57043108PROCOB32 DOESN'T BE UPDATED BY APPLYING PSR 10.2.0.4 FOR HP-UX ITANIUM10.2.0.57174782THE SYMBOL NAMES IN HP-UX ITANIUM CLIENT SHARED LIBRARY DO NOT EXIST10.2.0.59239724ORACLE 10.2.0.4 INSTALLS ON HPIA IS MISSING 64-BIT LIBCLNTSH_NOPTHREAD.SO*10.2.0.57570273PATCH 6394739 CAN'T APPLY TO HP-UX ITANIUM10.2.0.55233770PROCOB32 DOESN'T BE GENERATED AFTER INSTALL CLIENT 10.2.0 ON HP-UX IPF10.2.0.57537050OCRCHECK GENERATES TRACE FILE HAVING UTSZ:3: IOCTL DKIOCGAPART FAILED.ERRNO [2510.2.0.57371912ORA-7445 [$COLD_EVACPY()+1328] [SIGILL] {REGISTER NAT CONSUMPTION]10.2.0.57324434ORA-1115 ORA-27091 ORA 27072 AND HP-UX ERROR:4 SOMETIMES OCCUR10.2.0.58236874ORA-1115 REPRODUCED AFTER PATCH FOR BUG 732443410.2.0.58642800GENAGTSH INVOKES THE SYSTEM BINARY "BASENAME" WITHOUT ABSOLUTE PATH

 

 

 

5 Oracle Universal Installer Version Requirements

补丁集的安装环境

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.该补丁集只能在10.2.0.X版本的数据库产品上安装

 

 

7 System Requirements 操作系统需求

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

 

他的意思是你得查 oraclemetalink了

 

 

 

8 Preinstallation Task 预安装任务

Complete the following preinstallation tasks before installing the patch set:

 

• Review Known Preinstallation Issues

  举例：Upgrading Oracle Clusterwares

 

The 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.（升级rac之前升级crs)

• Identify the Oracle Database Installation

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.

 

必须在oracle home已经安装的情况才能升级，好像是废话啊！

 

• Check Postrelease Updates

• Download and Extract the Installation Software

To download and extract the patch set installation software:

Download the p8202632_10205_HPUX-IA64.zip patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.

不能在ORACLE_HOME或者是oracle用户的主目录下,不理解！

 

       Update Oracle Time Zone Definitions

 

For full overview, see My Oracle Support (formerly OracleMetaLink) document 1086400.1 Actions for the DSTv4 update in the 10.2.0.5 patchset.

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

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

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

    他的意思是如果数据库的版本低于10.2或者是10.1.0.x   ,必须执行如下命令

    SELECT version FROM v$timezone_file;当version低于或者高于4的时候需要升级time_zone。

 

       Shut Down Oracle Databases

 

         

 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.

 

 举例2： Stopping All Processes for an Oracle Clusterware Installation

 

 

• Rolling Upgrade 在线升级

      应用无需停机，补丁一次应用到一个节点，不影响其他节点的正常运行和操作，滚动升级只能升级单个补丁，而不是补丁集

• Non Rolling Upgrade离线升级

      停机升级，所有节点必须停掉，影响应用正常运行

 

 

 

 

 

 

 

 

• Set the ORACLE_HOME and ORACLE_SID Environment Variables

• Stop All Processes

• Back Up the System