Oracle怎么打小补丁
一、当前环境
平台 | 版本 | 模式 |
Linux 32bit | Oracle 10.2.0.3 | 单实例 |
二、 目的
修复CPU bug
即Patch 7369190:
三、 下载补丁
登陆metalink网站
查找对应补丁
四、 安装补丁
将下载下来的补丁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/opatch3011-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
