溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
最近生產上要給Oracle數據庫打11g最新的補丁，這里先做一個測試記錄一下。
Oracle數據庫所有補丁的MOS文檔ID 1922396.1下載地址：https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=242245405602967&id=1577380.1&_afrWindowMode=0&_adf.ctrl-state=zv36z4hoo_53這個下載需要有MOS賬號
Oracle數據庫的補丁有幾種：PSU、SPU、CPU等，這次打的PSU24006111 (11.2.0.4.161018)
平臺：OS Linux6.7 x86-64+Oracle 11.2.0.4.0單實例
升級方法已經在補丁包里的README.html文檔里寫的很清楚了，這里只是做個演示。
1、下載最新的的PSU包和最新的OPatch包，上傳到服務器上
p24006111_112040_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip
2、解壓壓縮包，并把OPatch替換原ORACLE_HOME里的OPatch目錄
[oracle@rhel6 psu]$ unzip p24006111_112040_Linux-x86-64.zip [oracle@rhel6 psu]$ unzip p6880880_112000_Linux-x86-64.zip [oracle@rhel6 psu]$ ls -l |grep ^d drwxrwxr-x 14 oracle oinstall 4096 Aug 26 21:56 24006111 drwxr-x--- 10 oracle oinstall 4096 Aug 18 2015 OPatch [oracle@rhel6 psu]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak [oracle@rhel6 psu]$ mv OPatch/ $ORACLE_HOME
3、配置OPatch的環境變量
[oracle@rhel6 psu]$ vi ~/.bash_profile #添加 export PATH=$PATH:$ORACLE_HOME/OPatch [oracle@rhel6 psu]$ source ~/.bash_profile [oracle@rhel6 psu]$ which opatch /u02/app/oracle/product/11.2.4/db1/OPatch/opatch #查看當前數據庫的補丁情況 [oracle@rhel6 psu]$ opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u02/app/oracle/product/11.2.4/db1 Central Inventory : /u01/app/oraInventory from : /u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch3016-12-20_10-45-47AM_1.log Lsinventory Output file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-20_10-45-47AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: rhel6 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded.
4、升級前檢查是否有沖突
[oracle@rhel6 psu]$ cd 24006111/ [oracle@rhel6 24006111]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u02/app/oracle/product/11.2.4/db1 Central Inventory : /u01/app/oraInventory from : /u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch3016-12-20_10-49-53AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
5、安裝Patch包，單實例的數據庫按如下方法打patch就可以了，如果是RAC則需要詳細查看README.html
[oracle@rhel6 psu]$ cd 24006111/ [oracle@rhel6 24006111]$ opatch apply Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u02/app/oracle/product/11.2.4/db1 Central Inventory : /u01/app/oraInventory from : /u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch3016-12-20_10-53-13AM_1.log Verifying environment and performing prerequisite checks... Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following executables are active : /u02/app/oracle/product/11.2.4/db1/bin/oracle /u02/app/oracle/product/11.2.4/db1/lib/libclntsh.so.11.1 UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. Log file location: /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch3016-12-20_10-53-13AM_1.log OPatch failed with error code 73 #打補丁報錯，查看日志 [oracle@rhel6 24006111]$ more /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch3016-12-20_10-53-13AM_1.log ...... [Dec 20, 2016 10:53:21 AM] Following executables are active : /u02/app/oracle/product/11.2.4/db1/bin/oracle /u02/app/oracle/product/11.2.4/db1/lib/libclntsh.so.11.1 [Dec 20, 2016 10:53:21 AM] Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following executables are active : /u02/app/oracle/product/11.2.4/db1/bin/oracle /u02/app/oracle/product/11.2.4/db1/lib/libclntsh.so.11.1 ...... #這個錯誤的意思是檢測到有命令正在運行，不能進行升級，停止數據庫和監聽 [oracle@rhel6 24006111]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 20 10:57:16 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options sys@ORCL>shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. sys@ORCL>exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@rhel6 24006111]$ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-DEC-2016 10:58:32 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) The command completed successfully [oracle@rhel6 24006111]$ ps -ef |grep ora root 2361 2342 0 10:11 pts/0 00:00:00 su - oracle oracle 2362 2361 0 10:11 pts/0 00:00:01 -bash oracle 3409 2362 0 10:59 pts/0 00:00:00 ps -ef oracle 3410 2362 0 10:59 pts/0 00:00:00 grep ora #重新打補丁 [oracle@rhel6 24006111]$ opatch apply Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u02/app/oracle/product/11.2.4/db1 Central Inventory : /u01/app/oraInventory from : /u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch3016-12-20_11-18-32AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u02/app/oracle/product/11.2.4/db1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '17478514' to OH '/u02/app/oracle/product/11.2.4/db1' ...... Composite patch 24006111 successfully applied. Log file location: /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch3016-12-20_11-18-32AM_1.log OPatch succeeded.
6、升級數據字典并重新編譯無效對象
[oracle@rhel6 24006111]$ sqlplus / as sysdba idle>startup ...... idle>@?/rdbms/admin/catbundle.sql psu apply ....... idle>SPOOL off idle>SET echo off Check the following log file for errors: /u02/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_APPLY_2016Dec20_11_30_47.log #檢查日志沒有報錯 #編譯失效對象 sys@ORCL>@?/rdbms/admin/utlrp.sql #檢查升級情況 sys@ORCL>col action_time for a30 sys@ORCL>col action for a10 sys@ORCL>col namespace for a20 sys@ORCL>col version for a20 sys@ORCL>col bundle_series for a30 sys@ORCL>col comments for a30 sys@ORCL>select * from dba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS ------------------------------ ---------- -------------------- -------------------- ---------- ------------------------------ ------------------------------ 24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0 07-JUL-16 11.03.29.165250 AM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0 20-DEC-16 11.32.28.671654 AM APPLY SERVER 11.2.0.4 161018 PSU PSU 11.2.0.4.161018 #使用opatch命令查看補丁情況 [oracle@rhel6 24006111]$ opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u02/app/oracle/product/11.2.4/db1 Central Inventory : /u01/app/oraInventory from : /u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch3016-12-20_11-52-01AM_1.log Lsinventory Output file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-20_11-52-01AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: rhel6 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (1) : Patch 24006111 : applied on Tue Dec 20 11:24:30 CST 2016 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免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
