本文档提供了Oracle 10g Release 2 (10.2.0.5) 版本补丁集4的升级指南，包括了针对HP-UX Itanium平台的补丁说明。概述了补丁集可以修复的关键问题，详细列出了补丁集的组成部分，并提供了安装前的准备任务指导。
因为要解决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 Release | Bug Number | Description |
|---|---|---|
| 10.2.0.4 | 6603978 | FILES MISSING FROM THE PERL COMPONENT PACKED IN THE CLIENT INSTALL KIT |
| 10.2.0.4 | 6822813 | LMS O/S PRIORITY 154 SAME AS OTHER PROCESSES |
| 10.2.0.4 | 5401791 | LOT OF PSTAT CALLS WHEN CONNECTING ON 10.2.0/HP-UX ITANIUM MAY LEAD TO SLOWDOWN |
| 10.2.0.4 | 5010657 | QUERY OF V$OSSTAT RETURNS NO ROWS ON VPARS/HP-UX |
| 10.2.0.4 | 5593621 | MANY ORA-7445[_KILL()+48]HAPPENED AFTER ADDING CPUS USING VPAR WHICH HP PROVIDES |
| 10.2.0.4 | 5500535 | ERRORS IN FILES: WARNING:ORACLE PROCESS RUNNING OUT OF OS KERNEL I/O RESOURCES |
| 10.2.0.4 | 5169475 | SLRAC() IS UNRELIABLE ON HPUX - FALSE KGHU ERRORS AND KGH MESSAGES |
| 10.2.0.4 | 6058758 | INSTANCE STARTUP SLOW |
| 10.2.0.4 | 5401791 | LOT OF PSTAT CALLS WHEN CONNECTING ON 10.2.0/HP-UX ITANIUM MAY LEAD TO SLOWDOWN |
| 10.2.0.4 | 5500535 | ERRORS IN FILES: WARNING:ORACLE PROCESS RUNNING OUT OF OS KERNEL I/O RESOURCES |
| 10.2.0.4 | 5631422 | DEPLOY FAIL WHEN SET ACTION IS ''UPGRADE'' - /USR/LIB/HPUX32/DLD.SO: UNABLE TO F |
| 10.2.0.4 | 6474976 | OUI OVERWRITE /OPT/NMAPI/NMAPI2/LIB/HPUX32/LIBNMAPI2.SO.1 WHEN OUI UNINSTALL DB |
| 10.2.0.3 | 5363442 | SLRAC ERRORS ARE PREVENTING DUMP OF ERRORSTACK ON INTERNAL ERRORS |
| 10.2.0.3 | 4729565 | ORA-600 [12235] AND SKGPSPAWN FAILED ERROR 27143 ORA-00600 |
| 10.2.0.3 | 5363442 | SLRAC ERRORS ARE PREVENTING DUMP OF ERRORSTACK ON INTERNAL ERRORS |
| 10.2.0.2 | 4674108 | SRV: ORA-7445 STACK TRACE SEEMS INCOMPLETE |
| 10.2.0.2 | 4709673 | ORA-27061, CAN'T STARTUP DB WHEN BIG SGA(30GB) IS SET |
| 10.2.0.5 | 7043108 | PROCOB32 DOESN'T BE UPDATED BY APPLYING PSR 10.2.0.4 FOR HP-UX ITANIUM |
| 10.2.0.5 | 7174782 | THE SYMBOL NAMES IN HP-UX ITANIUM CLIENT SHARED LIBRARY DO NOT EXIST |
| 10.2.0.5 | 9239724 | ORACLE 10.2.0.4 INSTALLS ON HPIA IS MISSING 64-BIT LIBCLNTSH_NOPTHREAD.SO* |
| 10.2.0.5 | 7570273 | PATCH 6394739 CAN'T APPLY TO HP-UX ITANIUM |
| 10.2.0.5 | 5233770 | PROCOB32 DOESN'T BE GENERATED AFTER INSTALL CLIENT 10.2.0 ON HP-UX IPF |
| 10.2.0.5 | 7537050 | OCRCHECK GENERATES TRACE FILE HAVING UTSZ:3: IOCTL DKIOCGAPART FAILED.ERRNO [25 |
| 10.2.0.5 | 7371912 | ORA-7445 [$COLD_EVACPY()+1328] [SIGILL] {REGISTER NAT CONSUMPTION] |
| 10.2.0.5 | 7324434 | ORA-1115 ORA-27091 ORA 27072 AND HP-UX ERROR:4 SOMETIMES OCCUR |
| 10.2.0.5 | 8236874 | ORA-1115 REPRODUCED AFTER PATCH FOR BUG 7324434 |
| 10.2.0.5 | 8642800 | GENAGTSH 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)
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已经安装的情况才能升级，好像是废话啊！
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.
-
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.
他的意思是如果数据库的版本低于10.2或者是10.1.0.x ,必须执行如下命令
SELECT version FROM v$timezone_file;当version低于或者高于4的时候需要升级time_zone。
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 在线升级
应用无需停机，补丁一次应用到一个节点，不影响其他节点的正常运行和操作，滚动升级只能升级单个补丁，而不是补丁集
停机升级，所有节点必须停掉，影响应用正常运行
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
