solarisX86-64下ORACLE打11.2.0.3.8补丁之一波三折

程序员文章站 2023-12-25 14:53:33

solaris x86-64下oracle打11.2.0.3.8补丁：正确步骤： 1.bug6880880 ，opatch的补丁 2.bug16902043，11.2.0....

solaris x86-64下oracle打11.2.0.3.8补丁：
正确步骤：
1.bug6880880 ，opatch的补丁
2.bug16902043，11.2.0.3.8补丁

感慨就是要实践啊看着容易的事也一波三折--像opatch的版本问题在安装11.2.0.3.8补丁前有提示的，要细心唉。

mos还是很好用的哈哈。

安装过程：

1.环境检查

-bash-3.2$ ls
16902043 alert_byssolaris.log
desktop p16902043_112030_solaris86-64.zip
documents u01
-bash-3.2$ cd 16902043/
-bash-3.2$ ls
13343438 13923374 14727310 16619892 readme.html patchmd.xml
13696216 14275605 16056266 16902043 readme.txt

-bash-3.2$ ./opatch lsinventory cdetail
invoking opatch 11.2.0.1.7

oracle interim patch installer version 11.2.0.1.7
copyright (c) 2011, oracle corporation. all rights reserved.

oracle home : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1
central inventory : /export/home/oracle/u01/app/orainventory
from : /var/opt/oracle/orainst.loc
opatch version : 11.2.0.1.7
oui version : 11.2.0.3.0
log file location : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_16-18-52pm.log

lsinventory output file location : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-05-13_16-18-52pm.txt
--------------------------------------------------------------------------------
installed top-level products (1):
oracle database 11g 11.2.0.3.0
there are 1 products installed in this oracle home.
there are no interim patches installed in this oracle home.
--------------------------------------------------------------------------------
opatch succeeded.

-bash-3.2$ ls
16902043 alert_byssolaris.log
desktop p16902043_112030_solaris86-64.zip
documents u01
###########
-bash-3.2$ cd 16902043/
-bash-3.2$ pwd
/export/home/oracle/16902043/16902043
-bash-3.2$ opatch prereq checkconflictagainstohwithdetail -ph ./
invoking opatch 11.2.0.1.7

oracle interim patch installer version 11.2.0.1.7
copyright (c) 2011, oracle corporation. all rights reserved.

prereq session

oracle home : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1
central inventory : /export/home/oracle/u01/app/orainventory
from : /var/opt/oracle/orainst.loc
opatch version : 11.2.0.1.7
oui version : 11.2.0.3.0
log file location : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_16-21-21pm.log
invoking prereq "checkconflictagainstohwithdetail"
prereq "checkconflictagainstohwithdetail" passed.
opatch succeeded.

#####################################################

2.开始安装

-bash-3.2$ cd ..
-bash-3.2$ pwd
/export/home/oracle/16902043
-bash-3.2$ ls
13343438 13923374 14727310 16619892 readme.html patchmd.xml
13696216 14275605 16056266 16902043 readme.txt
-bash-3.2$ opatch apply
invoking opatch 11.2.0.1.7

oracle interim patch installer version 11.2.0.1.7
copyright (c) 2011, oracle corporation. all rights reserved.

oracle home : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1
central inventory : /export/home/oracle/u01/app/orainventory
from : /var/opt/oracle/orainst.loc
opatch version : 11.2.0.1.7
oui version : 11.2.0.3.0
log file location : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_16-27-02pm.log

verifying environment and performing prerequisite checks...
utilsession failed:

patch 13696216 requires opatch version 11.2.0.3.0.
patch 13923374 requires opatch version 11.2.0.3.0.
patch 14275605 requires opatch version 11.2.0.3.0.
patch 14727310 requires opatch version 11.2.0.3.0.
patch 16056266 requires opatch version 11.2.0.3.0.
patch 16619892 requires opatch version 11.2.0.3.0.
patch 16902043 requires opatch version 11.2.0.3.0.
the opatch version being used (11.2.0.1.7) doesn't meet the minimum version required by the patch(es). please download latest opatch from my oracle support.

log file location: /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_16-27-02pm.log

opatch failed with error code 73

从提示中可以看到：the opatch version being used (11.2.0.1.7) doesn't meet the minimum version required by the patch(es)
是opatch版本低。
opatch - where can i find the latest version of opatch? [video] (文档 id 224346.1)
文档最后找到：
for oracle11g release 2 (11.2.0.x),
select release "11.2.0.0.0" (description "opatch 11.2") and download
p6880880_112000_platform.zip
as of december 2013 the opatch release is 11.2.0.3.6
####下载补丁p6880880_112000_platform.zip -----其实这个在psu的readme的最开始就有：

2.1 opatch utility

you must use the opatch utility version 11.2.0.3.0 or later to apply this patch. oracle recommends that you use the latest released opatch version for 11.2, which is available for download from my oracle support patch 6880880 by selecting the 11.2.0.0.0 release.

for information about opatch documentation, including any known issues, see my oracle support document 293369.1 opatch documentation list.

3.安装opatch

在oracle_home下备份opatch目录：
-bash-3.2$ tar -cvf opatch.tar opatch/
解压p6880880_112000_platform.zip，将oracle_home下备份opatch目录文件删除，再移动解压目录。
-bash-3.2$ mv opatch/ /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/
-bash-3.2$ opatch -help
查看是否可用。
###############################

4.再次打补丁（关闭、监听关闭、dbconsole关闭）：

-bash-3.2$ opatch apply
日志中有warnings：
-bash-3.2$ tail /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_18-29-20pm_1.log
[may 13, 2014 6:52:15 pm] 1) oui-67215:
opatch found the word "warning" in the stderr of the make command.
please look at this stderr. you can re-run this make command.
stderr output:
ld: warning: option -yp appears more than once, first setting taken
ld: warning: option -q appears more than once, first setting taken
[may 13, 2014 6:52:15 pm] --------------------------------------------------------------------------------
[may 13, 2014 6:52:15 pm] oui-67008:opatch session completed with warnings.
[may 13, 2014 6:52:15 pm] finishing utilsession at tue may 13 18:52:15 cst 2014
[may 13, 2014 6:52:15 pm] log file location: /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_18-29-20pm_1.log

从mos上查询此报错：