一、当前环境

平台

版本

模式

Linux 32bit

Oracle 10.2.0.3

单实例

 

二、    目的

修复CPU bug

即Patch 7369190:

三、    下载补丁

登陆metalink网站

查找对应补丁

clip_image002clip_image004clip_image006

四、    安装补丁

将下载下来的补丁p7369190_10203_LINUX.zip上传到数据库服务器上

按照补丁自带的说明文档升级

4.1 检查补丁

oracle@linux-o154:~> /opt/oracle/product/10.2.0/db_1/OPatch/opatch lsinventory

Invoking OPatch 10.2.0.3.0

 

Oracle interim Patch Installer version 10.2.0.3.0

Copyright (c) 2005, Oracle Corporation.  All rights reserved..

 

 

Oracle Home       : /opt/oracle/product/10.2.0/db_1

Central Inventory : /opt/oracle/oraInventory

   from           : /etc/oraInst.loc

OPatch version    : 10.2.0.3.0

OUI version       : 10.2.0.3.0

OUI location      : /opt/oracle/product/10.2.0/db_1/oui

Log file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2011-04-20_21-21-24PM.log

 

Lsinventory Output file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2011-04-20_21-21-24PM.txt

 

--------------------------------------------------------------------------------

Installed Top-level Products (2):

 

Oracle Database 10g                                                  10.2.0.1.0

Oracle Database 10g Release 2 Patch Set 2                            10.2.0.3.0

There are 2 products installed in this Oracle Home.

 

 

Interim patches (2) :

 

Patch  5556081      : applied on Sat Oct 30 10:48:31 EDT 2010

   Created on 9 Nov 2006, 22:20:50 hrs PST8PDT

   Bugs fixed:

     5556081

 

Patch  5557962      : applied on Sat Oct 30 10:48:22 EDT 2010

   Created on 9 Nov 2006, 23:23:06 hrs PST8PDT

   Bugs fixed:

     4269423, 5557962, 5528974

 

4.2          安装补丁

?  解压补丁

$unzip p7369190_10203_LINUX.zip

 

?  关闭数据库实例

SQL> shutdown immediate;

 

?  安装补丁

按照补丁自带说明文件执行

$cd 7369190

$opatch napply -skip_subset -skip_duplicate

备注：Oracle 10.2.0.3版本的opath不带napply参数，需要下载p6741493_10203_GENERIC.zip补丁，将p6741493补丁解压缩，使用p6741493补丁解压缩路径的opatch命令，执行以下命令安装7369190补丁：

oracle@linux-o154:~/7369190/7369190> /opt/oracle/OPatch/opatch napply -skip_subset -skip_duplicate

 

?  执行sql

按照文档说明，执行sql

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @/opt/oracle/7369190/7369190/files/cpu/CPUOct2008/catcpu.sql

 

If catcpu.sql reports any Invalid Objects, run the following commands:

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql 

 

SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS= 'INVALID';

 

no rows selected