From:
RAC环境patchset update安装
注意:patch的zip文件不要在windows下解压后上传到服务器,最好上传到服务器后再运行unzip命令来解压,否则patch里面shell和perl脚本的可执行权限就没有了,需要手动去添加,如果忘记添加,运行这些脚本的时候就会报错,带来不少麻烦。
在遇到bug后,DBA会安装针对这个bug的patch,这个patch叫做one-off patch,即一个patch修复一个bug。已经安装的one-off patch 不一定会被包含在patchset当中,可能会与patchset有冲突,也可能存在更新的版本。
安装patchset以前,先运行opatch命令检查one-off patch与patchset是否有冲突。
参数"-phBaseDir"表示patch所在的base路径,因此可以一次检查多个。
参数'"-ph"表示patch的路径,一次检查一个。
[oracle@rac01 patch]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch
[oracle@rac01 patch]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./9352164
patch的readme文件中可能会有对opatch工具版本的要求。如果版本不够,检查时会报类似下面的错误信息,可去metalink下载并更新,opatch工具的patch编号为6880880。按照其说明文档,直接解压缩到$ORACLE_HOME/OPatch路径下即可,文档中有提醒备份旧版本的opatch工具。RAC环境下CRS_HOME下面的opatch工具也要更新,后面会用到。
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" not executed
Unable to create Patch Object.
Exception occured : Patch ID is null.
如果没有冲突,直接安装patchset即可,one-off patch依然有效。
如果one-off patch与patchset冲突,且one-off patch没有被包含的patchset中,安装patchset时,one-off patch会被自动rollback。此时,DBA需要在metalink查找适应patchset版本的one-off patch,如果没有,可以提SR要求oracle开发。
如果one-off patch已经被包含在patchset中,也会被rollback,并重新安装。
可以参考metalink文档的相关内容。
Patch Set Updates - One-off Patch Conflict Resolution [ID 1061295.1]
实验环境:
Oracle Enterprise Linux 4.8 32bit,2节点RAC
Clusterware 10.2.0.4.0
Oracle Database 10.2.0.4.0 ,已安装one-off patch 6285480
9294403是CRS patchset release update 10.2.0.4.4
9352164是RDBMS patchset release update 10.2.0.4.4
[oracle@rac01 patch]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.9
OUI version : 10.2.0.4.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-04-16_20-51-35PM.log
Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
ZOP-40: The patch(es) has conflicts/supersets with other patches installed in the Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
Patches that can be applied now without any conflicts are :
9294403, 9352164
Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list :
6258480
Following patches will be rolled back from Oracle Home on application of the patches in the given list :
6258480
Conflicts/Supersets for each patch are:
Patch : 9352164
Bug Superset of 6258480
Super set bugs are:
6258480
OPatch succeeded.
[oracle@rac01 patch]$
如上面所示,opatch检查到one-off patch 628480已经被包含在patchset 9352164中,会被rollback。
RAC环境要先安装CRS的patchset,CRS的版本要大于等于DB的版本。
按照9294403的文档说明,在9294403目录下运行opatch auto命令,运行后会提示需要切换到root来执行。因此,注意要给root设置ORACLE_HOME和ORA_CRS_HOME的环境变量,以及ORACLE_HOME/OPatch和ORA_CRS_HOME/OPatch的环境变量,同时ORACLE_HOME和ORA_CRS_HOME的opatch工具版本都要满足patch文档的要求。OPatch也需要更新到所有节点。不然后面的过程中会报错。
在使用opatch auto命令时,会提示要求一个OCM response file。OCM是Oracle建议用户安装的Oracle Configuration Manager,我没有安装,根据9294403的文档的提示,在$ORA_CRS_HOME/OPatch/ocm/bin路径下运行emocmrsp,提示输入email时可跳过然后输入Y,然后会在当前路径下产生一个OCM response file。
/u01/app/oracle/product/10.2.0/crs_1/OPatch/ocm/bin
[oracle@rac01 bin]$ ll
total 12
-rwxr-xr-x 1 oracle oinstall 8486 Apr 16 21:24 emocmrsp
[oracle@rac01 bin]$ ./emocmrsp
OCM Installation Response Generator 10.3.1.2.0 - Production
Copyright (c) 2005, 2009, Oracle and/or its affiliates. All rights reserved.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
The OCM configuration response file (ocm.rsp) was successfully created.
[oracle@rac01 bin]$ ll
total 16
-rwxr-xr-x 1 oracle oinstall 8486 Apr 16 21:24 emocmrsp
-rw-r--r-- 1 oracle oinstall 623 Apr 16 21:35 ocm.rsp
[oracle@rac01 bin]$
现在已经建好OCM response file,切换到root用户,进入patch 9294403的路径执行opatch auto命令。
可以提前停掉database,instance,asm,因为脚本也会去停掉,但是不要停掉nodeapps,不然这个笨脚本停nodeapps的时候会报错。patch的日志太长,这里就不贴了。运行到最后,会提示root的ulimit设置打开文件数达到限制(一般为1024),这个问题可以忽略,这个时候patch已经安装完毕,最后那个运行的脚本是用来检查CRS进程的。可以从log中复制出来,自己手动执行看一下。
[root@rac01 ~]# /u01/patch/9294403/custom/scripts/postrootpatch.sh -crshome /u01/app/oracle/product/10.2.0/crs_1
Checking to see if Oracle CRS stack is already up...
Oracle CRS stack is already running.
[root@rac01 ~]#
一个节点patch完毕以后,该节点的crs会被重启,nodeapps,asm和instance等会被脚本启动。接下来重复上面的步骤,在在其他节点继续完成crs patchset update。
所有节点都安装完9294403以后,我用opatch和crsctl来检查CRS的版本,却没有看到期望中的10.2.0.4.4。我检查了patch log,并没有报错,说明patch过程没有问题。后来一个朋友告诉我,metalink上有篇文档ID 861152.1解释了,似乎只有11gR2以后才会正常显示最后一位版本号。
Does PSU Released For Oracle 10gR2 (10.2.0.4)and 11g R1 (11.10.7) Change The Database Version/Fifth Digit ? [ID 861152.1]
接下来停掉database,asm和listener,安装dbms patchset update 9352164,进入patch路径运行opatch apply开始安装RDBMS的patchset update。这个patchset支持rolling update,可以按照实际需求选择不同的策略。
节点1安装完毕后会提示,告诉你节点1已经可以启动了,由于安装完patch后还需要运行脚本,所以先不启动节点1。接着提示节点2是否可以开始patch了。输入Yes,opatch会将patch远程安装到节点2。
所有节点都完成patch以后,按照9352164文档说明,按步骤运行必要的脚本,完成patch后的操作,注意检查日志,看是否有报错。只要设置妥当,细心准备,安装过程中是不会出现问题的,如果出现问题,参考文档中Known Issues部分。
运行opatch可以看到one-off patch 6285480已经被回滚,2个patchset update都已经被安装。
[oracle@rac02 admin]$ opatch lsinventory -all
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.9
OUI version : 10.2.0.4.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-04-17_14-58-03PM.log
Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2010-04-17_14-58-03PM.txt
--------------------------------------------------------------------------------
List of Oracle Homes:
Name Location
OraCrs10g_home /u01/app/oracle/product/10.2.0/crs_1
OraDb10g_home1 /u01/app/oracle/product/10.2.0/db_1
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.
Interim patches (2) :
Patch 9352164 : applied on Sat Apr 17 03:13:33 CST 2010
Unique Patch ID: 12282671
Created on 1 Apr 2010, 11:18:07 hrs PST8PDT
Bugs fixed:
9377578, 6418420, 7835247, 7207654, 7592346, 6724797, 7936993, 7331867
9093300, 7535152, 7552067, 5879114, 8866013, 5457450, 8344348, 7272297
7136866, 7196894, 6258480, 7013124, 6512622, 6355586, 7196532, 8568395
8309587, 7557226, 5399699, 6509115, 8568397, 8568398, 7127618, 5701695
6052226, 7424804, 6817593, 7553884, 6741425, 7513673, 6783812, 8437213
6452766, 6469211, 7527650, 8309592, 8479537, 5991038, 5686407, 6945157
7639602, 9119226, 6403091, 7589862, 7552082, 6711853, 8304589, 6052169
8199266, 6327692, 5756769, 9352191, 7460818, 6268409, 8232056, 6687381
6972843, 8230457, 6800507, 7027551, 6778714, 6200820, 6645719, 7393804
6775231, 3934160, 6683178, 6650256, 5085288, 7528105, 7329252, 6378112
6151380, 6844866, 4723109, 8544896, 5126719, 5890312, 5934363, 7036453
7610362, 8426816, 8433026, 7270434, 7172531, 6451626, 8247855, 5497338
6324944, 6874522, 7175513, 6960489, 7341598, 8576156, 6797677, 8342923
5895190, 6756739, 7150470, 7593835, 7356443, 7044551, 8227106, 4695511
7298688, 5747462, 8556340, 7197445, 5348308, 7937113, 8341623, 7569205
8409848, 6053134, 6163771, 6851669, 6181488, 6375150, 6825866, 7210921
7295780, 6345573, 7033630, 6954722, 6824129, 7523475, 7457766, 7309458
8324577, 6840740, 6804746, 7375611, 8268054, 6981690, 6512811, 6988017
7375613, 8344399, 7340448, 8362683, 7375617, 8251247, 5933656, 6005347
9145204, 6599920, 7238230, 6379441, 6452375, 6352003, 6833965, 7136489
6610218, 7612639, 6392076, 7225204, 9119194, 5476236, 9442328, 7609057
7609058, 6605106, 6374297, 6193945, 4693355, 8217795, 7039896, 7432514
7330909, 6952701, 7190270, 8287155, 7587008, 7207932, 6802650, 7189447
8481935, 4598439, 9442331, 6615740, 7155655, 6749617, 9442335, 7159505
5868257, 5727166, 7173005, 6917874, 9442339, 7013768, 7691766, 7385253
7291739, 7225720, 7257770, 7363767, 7244238, 6941717, 8267348, 7710551
8354686, 7247217, 8328954, 7299153, 8909984, 6681695, 8702276, 9119284
8217011, 7661251, 6265559, 6823287, 6991626, 6954829, 5259835, 6500033
5923486, 7432601, 7022234, 8534387, 5147386, 7697802, 6653934, 7375644
6490140, 7662491, 8331466, 5623467, 6070225, 6635214, 7396409, 6638558
7038750, 6714608, 6838714, 6870937, 7219752, 7263842, 7278117, 6882739
5404871, 8836667, 8373286, 7393292, 6678845, 6903051, 7936793, 6600051
7155248, 4966512, 7155249, 7197637, 8836308, 8568402, 8568404, 8568405
8431487, 5704108, 6343150, 7280764, 6923450, 7643632, 6145177, 8836671
8310931, 6640411, 8347704, 8836675, 7155250, 7155251, 8836677, 7155252
8836678, 7155253, 8292378, 7155254, 6219529, 7411865, 8227091, 8340379
7276960, 6145687, 7659217, 5863926, 7022905, 6852598, 7123643, 6596564
6413089, 6851438, 8836681, 8836683, 8836684, 8836686, 7579469, 7494333
7315642, 8340383, 6786022, 8340387, 6926448, 7600026, 7462072, 6679303
8815639, 7197583, 7172752, 7326645, 7008262, 9173244, 9173248, 7573151
8490879, 7477934, 6725634, 6733655, 6799205, 6980597, 7499353, 6084232
6014513, 7140204, 7254987, 8833280, 6647480, 6120004, 7693128, 6760697
6051177, 8247215, 6858062, 7189645, 6844739, 6768251, 7196863, 5630796
7378661, 7378735, 5970301, 6705822, 8290506, 6658484, 7599944, 9173253
8309623, 7125408, 7257461, 6987790, 7568556, 6919819, 8886674, 5883691
6955744, 7801939, 6074620, 7149004, 6857917, 8283650, 6445948, 5929055
6110752, 7552042, 8210889, 8287504, 6506617, 7306915, 6271590, 5386204
6976005, 8330783, 7606362, 5377242, 7043989, 8309632, 7575925, 6870047
8309637, 5902053, 8309639, 7028176, 6827260, 7588384, 4726401, 6720712
5910650, 6752765, 6971433, 6024730, 8315482, 6628122, 8239142, 9352164
5695562, 4637902, 7345904, 8309642, 6994160, 8556586, 6404447, 8220734
6919764, 7597354, 7523787, 6029179, 5231155, 6455659
Patch 9294403 : applied on Sat Apr 17 01:11:48 CST 2010
Unique Patch ID: 12382307
Created on 18 Mar 2010, 23:15:41 hrs PST8PDT
Bugs fixed:
9294403
Rac system comprising of multiple nodes
Local node = rac02
Remote node = rac01
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac02 admin]$
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/230160/viewspace-664395/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/230160/viewspace-664395/