程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> solarisX86-64下ORACLE打11.2.0.3.8補丁之一波三折

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

編輯:Oracle教程

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上查詢此報錯:

Opatch Warning During Patch Apply : "ld: warning: option -YP appears more than once, first setting taken" (文檔 ID 1571550.1)
可以忽略:
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)

Cause

Make warnings caused due to Options for ld command appears more than once.
Solution

These warnings are safely ignorable.
----至此安裝完成。

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved