Oracle 11.2.0.4打PSU補丁到 11.2.0.4.161018

Oracle數據庫的補丁有幾種：CPU、SPU、PSU、等，這次打的PSU24006111 (11.2.0.4.161018)

先解釋一下這三種補丁

CPU，是Critical Patch Update的縮寫，意為緊急補丁更新。每季度發布一次，是用來修復安全方面的一些補丁，是累積型的。自2012年10月已經更名為Security Patch Update (SPU)

PSU,是Patch Set Update的縮寫，意為補丁集更新。Oracle 選取在每個季度用戶下載數量最多，并且得到驗證具有較低風險的補丁放入到每個季度的PSU中，修復比較嚴重的一些問題，包含每個季度的CPU，是累積型的。

平臺：Linux DB 2.6.32-573.el6.x86_64+Oracle 11.2.0.4.0單實例

1、下載最新的的PSU包和最新的OPatch包，上傳到服務器上

p6880880_112000_Linux-x86-64.zip

p24006111_112040_Linux-x86-64.zip

2、解壓壓縮包，并把OPatch替換原ORACLE_HOME里的OPatch目錄

[root@DB  src]$unzip p24006111_112040_Linux-x86-64.zip
[root@DB  src]$ unzip p6880880_112000_Linux-x86-64.zip
[root@DB  src]$mv $ORACLE_HOME/OPatch  $ORACLE_HOME/OPatch_bak
[root@DB  src]$ mv OPatch/   $ORACLE_HOME

3、配置OPatch的環境變量

[root@DB  src]$vi ~/.bash_profile

#添加
export PATH=$PATH:$ORACLE_HOME/OPatch

[root@DB  src]$source ~/.bash_profile 

#查看當前數據庫的補丁情況

4、升級前檢查是否有沖突

[root@DB  src]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2017, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home      : /u01/app/oracle/product/11.2.4/dbhome_1
Central Inventory : /u01/app/oraInventory
  from          : /u01/app/oracle/product/11.2.4/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch3017-02-23_00-49-34上午_1.log

Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.

5、安裝Patch包，單實例的數據庫按如下方法打patch就可以了，如果是RAC則需要詳細查看README.html

[oracle@DB OPatch]$ ./opatch apply  /usr/local/src/24006111

Oracle 中間補丁程序安裝程序版本 11.2.0.3.12

版權所有 (c) 2017, Oracle Corporation。保留所有權利。

Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.12

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/24006111_Feb_21_2017_05_50_53/apply2017-02-21_05-50-53上午_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   24006111  

是否繼續? [y|n]

y

User Responded with: Y

All checks passed.

提供電子郵件地址以用于接收有關安全問題的通知, 安裝 Oracle Configuration Manager 并啟動它。如果您使用 My Oracle

Support 電子郵件地址/用戶名, 操作將更簡單。

有關詳細信息, 請訪問 http://www.oracle.com/support/policies.html。

電子郵件地址/用戶名: 

請提供 My Oracle Support 口令以通過 My Oracle Support 帳戶接收安全更新。

口令口令 (可選):       

遇到無法恢復的網絡配置錯誤。

peer not authenticated

無法與 Oracle 建立網絡連接。請按以下格式指定 Oracle Support Hub 的 URL:

    http[s]://<OracleSupportHubHost>:<OracleSupportHubPort>

如果不希望通過 Oracle Support Hub 配置 OCM, 請輸入 NONE

Oracle Support Hub URL: NONE

無法與 Oracle 建立網絡連接。如果您的系統需要代理服務器來建立出站 Internet 連接, 請按以下格式輸入代理服務器詳細信息:

    [<proxy-user>@]<proxy-host>[:<proxy-port>]

如果不希望收到有關配置中的嚴重安全問題的通知, 請輸入“NONE”

代理規范: NONE

請關閉本地系統上在此 ORACLE_HOME 之外運行的 Oracle 實例。

(Oracle 主目錄 = '/u01/app/oracle/product/11.2.0/dbhome_1')

本地系統是否已準備打補丁? [y|n]

Y

User Responded with: Y

Backing up files...

Applying interim patch '24006111' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

正在為組件 oracle.rdbms, 11.2.0.4.0 打補丁...

正在為組件 oracle.rdbms.rsf, 11.2.0.4.0 打補丁...

正在為組件 oracle.sdo, 11.2.0.4.0 打補丁...

正在為組件 oracle.sysman.agent, 10.2.0.4.5 打補丁...

正在為組件 oracle.xdk, 11.2.0.4.0 打補丁...

正在為組件 oracle.rdbms.dbscripts, 11.2.0.4.0 打補丁...

正在為組件 oracle.sdo.locator, 11.2.0.4.0 打補丁...

正在為組件 oracle.nlsrtl.rsf, 11.2.0.4.0 打補丁...

正在為組件 oracle.xdk.rsf, 11.2.0.4.0 打補丁...

正在為組件 oracle.rdbms.rman, 11.2.0.4.0 打補丁...

Patch 24006111 successfully applied.

Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/24006111_Feb_21_2017_05_50_53/apply2017-02-21_05-50-53上午_1.log

OPatch succeeded.

6、升級數據字典并重新編譯無效對象

[root@DB  src]$ sqlplus / as sysdba

[root@DB  src]$ startup

>@?/rdbms/admin/catbundle.sql psu apply

……

SQL> SPOOL off

SQL> SET echo off

Check the following log file for errors:

/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_RMS_APPLY_2017Feb23_00_05_13.log

#檢查日志看有沒有報錯

#編譯失效對象

SQL> @?/rdbms/admin/utlrp.sql

……

#檢查升級情況

[oracle@DB /]$ opatch lsinventory

Oracle 中間補丁程序安裝程序版本 11.2.0.3.12

版權所有 (c) 2017, Oracle Corporation。保留所有權利。

Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.12

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch3017-02-23_01-23-52上午_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-02-23_01-23-52上午.txt

--------------------------------------------------------------------------------

Local Machine Information::

Hostname: DB

ARU platform id: 226

ARU platform description:: Linux x86-64

已安裝的頂級產品 (1):

Oracle Database 11g                                                  11.2.0.4.0

此 Oracle 主目錄中已安裝 1 個產品。

中間補丁程序 (1) :

Patch  24006111     : applied on Tue Feb 21 06:31:54 CST 2017

Unique Patch ID:  20508568

Patch description:  "Database Patch Set Update : 11.2.0.4.161018 (24006111)"

   Created on 26 Aug 2016, 05:54:48 hrs PST8PDT

Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"

Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"

Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"

Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"

Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"

Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"

Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"

Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"

Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"

Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"

Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"

   Bugs fixed:

     17288409, 21051852, 24316947, 17811429, 18607546, 17205719, 20506699

     17816865, 17922254, 23330119, 17754782, 16934803, 13364795, 17311728

     17441661, 17284817, 16992075, 17446237, 14015842, 19972569, 21756677

     17375354, 20925795, 21538558, 17449815, 19463897, 13866822, 17235750

     17982555, 17478514, 18317531, 14338435, 18235390, 20803583, 13944971

     20142975, 17811789, 16929165, 18704244, 20506706, 17546973, 20334344

     14054676, 17088068, 17346091, 18264060, 17343514, 21538567, 19680952

     18471685, 19211724, 13951456, 21847223, 16315398, 18744139, 16850630

     23177648, 19049453, 18673304, 17883081, 19915271, 18641419, 18262334

     17006183, 16065166, 18277454, 16833527, 10136473, 18051556, 17865671

     17852463, 18554871, 17853498, 18334586, 17551709, 17588480, 19827973

     17344412, 17842825, 18828868, 17025461, 11883252, 13609098, 17239687

     17602269, 19197175, 22195457, 18316692, 17313525, 12611721, 19544839

     18964939, 17600719, 18191164, 19393542, 17571306, 20777150, 18482502

     19466309, 22243719, 17040527, 17165204, 18098207, 16785708, 17465741

     17174582, 16180763, 16777840, 12982566, 19463893, 22195465, 22148226

     16875449, 12816846, 17237521, 6599380, 19358317, 17811438, 17811447

     17945983, 21983325, 18762750, 16912439, 17184721, 18061914, 17282229

     18331850, 18202441, 17082359, 18723434, 21972320, 19554106, 14034426

     18339044, 19458377, 17752995, 20448824, 17891943, 17258090, 17767676

     16668584, 18384391, 17040764, 17381384, 15913355, 18356166, 14084247

     20596234, 20506715, 21756661, 13853126, 18203837, 14245531, 16043574

     21756699, 22195441, 17848897, 17877323, 21453153, 17468141, 20861693

     17786518, 17912217, 17037130, 16956380, 18155762, 17478145, 17394950

     18641461, 18189036, 18619917, 17027426, 21352646, 16268425, 24476274

     22195492, 19584068, 18436307, 22507210, 17265217, 17634921, 13498382

     21526048, 19258504, 20004087, 17443671, 22195485, 18000422, 22321756

     20004021, 17571039, 21067387, 16344544, 18009564, 14354737, 21286665

     18135678, 18614015, 20441797, 18362222, 17835048, 16472716, 17936109

     17050888, 17325413, 14010183, 18747196, 17761775, 16721594, 17082983

     20067212, 21179898, 17302277, 18084625, 15990359, 18203835, 17297939

     17811456, 22380919, 16731148, 21168487, 14133975, 13829543, 17215560

     17694209, 17385178, 18091059, 8322815, 17586955, 17201159, 17655634

     18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614

     17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317

     19289642, 14764829, 18328509, 17622427, 16943711, 22195477, 14368995

     22502493, 17346671, 18996843, 17783588, 21343838, 16618694, 17672719

     18856999, 18783224, 17851160, 17546761, 17798953, 18273830, 22092979

     16596890, 19972566, 16384983, 17726838, 22296366, 17360606, 22321741

     13645875, 18199537, 16542886, 21787056, 17889549, 14565184, 17071721

     17610798, 20299015, 21343897, 22893153, 20657441, 17397545, 18230522

     16360112, 19769489, 12905058, 18641451, 12747740, 18430495, 17016369

     17042658, 14602788, 17551063, 19972568, 21517440, 18508861, 19788842

     14657740, 17332800, 13837378, 19972564, 17186905, 18315328, 19699191

     17437634, 22353199, 18093615, 19006849, 19013183, 17296856, 18674024

     17232014, 16855292, 17762296, 14692762, 21051840, 17705023, 22507234

     19121551, 21330264, 19854503, 21868720, 19309466, 18681862, 20558005

     18554763, 17390160, 18456514, 16306373, 13955826, 18139690, 17501491

     17752121, 21668627, 17299889, 17889583, 18673325, 19721304, 18293054

     17242746, 17951233, 18094246, 17649265, 19615136, 17011832, 16870214

     17477958, 18522509, 20631274, 16091637, 17323222, 16595641, 16524926

     18228645, 18282562, 17596908, 18031668, 17156148, 16494615, 22683225

     17545847, 17655240, 24528741, 17614134, 13558557, 17341326, 17891946

     17716305, 22657942, 16392068, 19271443, 21351877, 18092127, 17614227

     18440047, 16903536, 14106803, 18973907, 18673342, 19032867, 17389192

     17612828, 16194160, 17006570, 17721717, 17390431, 17570240, 16863422

     18325460, 19727057, 16422541, 19972570, 17267114, 18244962, 21538485

     18765602, 18203838, 16198143, 17246576, 14829250, 17835627, 18247991

     14458214, 21051862, 16692232, 17786278, 17227277, 24476265, 16042673

     16314254, 16228604, 16837842, 17393683, 23536835, 17787259, 20331945

     20074391, 15861775, 16399083, 18018515, 22683212, 18260550, 21051858

     17080436, 16613964, 17036973, 16579084, 24433711, 18384537, 18280813

     20296213, 16901385, 15979965, 23330124, 18441944, 16450169, 9756271

     17892268, 11733603, 16285691, 17587063, 21343775, 18180390, 16538760

     18193833, 21387964, 21051833, 17238511, 17824637, 16571443, 18306996

     14852021, 17853456, 18674047, 12364061, 22195448

--------------------------------------------------------------------------------

OPatch succeeded.

7、升級失敗回滾

opatch rollback -id 24006111