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

還不算暈發表於2014-05-13
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.

----至此安裝完成。

相關文章