您好,登錄后才能下訂單哦!
Oracle數(shù)據(jù)庫的補(bǔ)丁有幾種:CPU、SPU、PSU、等,這次打的PSU24006111 (11.2.0.4.161018)
先解釋一下這三種補(bǔ)丁
CPU,是Critical Patch Update的縮寫,意為緊急補(bǔ)丁更新。每季度發(fā)布一次,是用來修復(fù)安全方面的一些補(bǔ)丁,是累積型的。自2012年10月已經(jīng)更名為Security Patch Update (SPU)
PSU,是Patch Set Update的縮寫,意為補(bǔ)丁集更新。Oracle 選取在每個(gè)季度用戶下載數(shù)量最多,并且得到驗(yàn)證具有較低風(fēng)險(xiǎn)的補(bǔ)丁放入到每個(gè)季度的PSU中,修復(fù)比較嚴(yán)重的一些問題,包含每個(gè)季度的CPU,是累積型的。
平臺(tái):Linux DB 2.6.32-573.el6.x86_64+Oracle 11.2.0.4.0單實(shí)例
1、下載最新的的PSU包和最新的OPatch包,上傳到服務(wù)器上
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的環(huán)境變量
[root@DB src]$vi ~/.bash_profile
#添加
export PATH=$PATH:$ORACLE_HOME/OPatch
[root@DB src]$source ~/.bash_profile
#查看當(dāng)前數(shù)據(jù)庫的補(bǔ)丁情況
4、升級(jí)前檢查是否有沖突
[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包,單實(shí)例的數(shù)據(jù)庫按如下方法打patch就可以了,如果是RAC則需要詳細(xì)查看README.html
[oracle@DB OPatch]$ ./opatch apply /usr/local/src/24006111
Oracle 中間補(bǔ)丁程序安裝程序版本 11.2.0.3.12
版權(quán)所有 (c) 2017, Oracle Corporation。保留所有權(quán)利。
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
是否繼續(xù)? [y|n]
y
User Responded with: Y
All checks passed.
提供電子郵件地址以用于接收有關(guān)安全問題的通知, 安裝 Oracle Configuration Manager 并啟動(dòng)它。如果您使用 My Oracle
Support 電子郵件地址/用戶名, 操作將更簡(jiǎn)單。
有關(guān)詳細(xì)信息, 請(qǐng)?jiān)L問 http://www.oracle.com/support/policies.html。
電子郵件地址/用戶名:
請(qǐng)?zhí)峁?My Oracle Support 口令以通過 My Oracle Support 帳戶接收安全更新。
口令口令 (可選):
遇到無法恢復(fù)的網(wǎng)絡(luò)配置錯(cuò)誤。
peer not authenticated
無法與 Oracle 建立網(wǎng)絡(luò)連接。請(qǐng)按以下格式指定 Oracle Support Hub 的 URL:
http[s]://<OracleSupportHubHost>:<OracleSupportHubPort>
如果不希望通過 Oracle Support Hub 配置 OCM, 請(qǐng)輸入 NONE
Oracle Support Hub URL: NONE
無法與 Oracle 建立網(wǎng)絡(luò)連接。如果您的系統(tǒng)需要代理服務(wù)器來建立出站 Internet 連接, 請(qǐng)按以下格式輸入代理服務(wù)器詳細(xì)信息:
[<proxy-user>@]<proxy-host>[:<proxy-port>]
如果不希望收到有關(guān)配置中的嚴(yán)重安全問題的通知, 請(qǐng)輸入“NONE”
代理規(guī)范: NONE
請(qǐng)關(guān)閉本地系統(tǒng)上在此 ORACLE_HOME 之外運(yùn)行的 Oracle 實(shí)例。
(Oracle 主目錄 = '/u01/app/oracle/product/11.2.0/dbhome_1')
本地系統(tǒng)是否已準(zhǔn)備打補(bǔ)丁? [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 打補(bǔ)丁...
正在為組件 oracle.rdbms.rsf, 11.2.0.4.0 打補(bǔ)丁...
正在為組件 oracle.sdo, 11.2.0.4.0 打補(bǔ)丁...
正在為組件 oracle.sysman.agent, 10.2.0.4.5 打補(bǔ)丁...
正在為組件 oracle.xdk, 11.2.0.4.0 打補(bǔ)丁...
正在為組件 oracle.rdbms.dbscripts, 11.2.0.4.0 打補(bǔ)丁...
正在為組件 oracle.sdo.locator, 11.2.0.4.0 打補(bǔ)丁...
正在為組件 oracle.nlsrtl.rsf, 11.2.0.4.0 打補(bǔ)丁...
正在為組件 oracle.xdk.rsf, 11.2.0.4.0 打補(bǔ)丁...
正在為組件 oracle.rdbms.rman, 11.2.0.4.0 打補(bǔ)丁...
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、升級(jí)數(shù)據(jù)字典并重新編譯無效對(duì)象
[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
#檢查日志看有沒有報(bào)錯(cuò)
#編譯失效對(duì)象
SQL> @?/rdbms/admin/utlrp.sql
……
#檢查升級(jí)情況
[oracle@DB /]$ opatch lsinventory
Oracle 中間補(bǔ)丁程序安裝程序版本 11.2.0.3.12
版權(quán)所有 (c) 2017, Oracle Corporation。保留所有權(quán)利。
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
已安裝的頂級(jí)產(chǎn)品 (1):
Oracle Database 11g 11.2.0.4.0
此 Oracle 主目錄中已安裝 1 個(gè)產(chǎn)品。
中間補(bǔ)丁程序 (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、升級(jí)失敗回滾
opatch rollback -id 24006111
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。