共计 9249 个字符,预计需要花费 24 分钟才能阅读完成。
写在前面:
- 1.Oracel 打每个补丁的操作有时存在差异,所以不管多熟悉,都应该在打任何补丁之前阅读新补丁中附带的 readme。
- 2.Oracle 每季度都会更新一个最新的 PSU,本文最新指的是当前最新(即 0719 发布的 PSU)。
- 3. 之前整理的完整记录一则 Oracle 11.2.0.4 单实例打 PSU 补丁的过程由于旨在体验打补丁的整个过程,粘贴了所有过程输出,篇幅很长,不利于快速参考,本次旨在可以用来快速参考,并增加了 OJVM PSU 的修补部分。如果对本文的简要命令有疑问,可以反过来参考之前的文章做对比。
本次环境: RHEL 6.5 + Oracle 11.2.0.4 单实例
目前最新的 PSU: 补丁程序 23054359: DATABASE PATCH SET UPDATE 11.2.0.4.160719
目前最新的 OJVM PSU: 补丁程序 23177551: OJVM PATCH SET UPDATE 11.2.0.4.160719
- 1.OPatch 更新
- 2. 应用 PSU 补丁
- 3. 应用 OJVM PSU 补丁
- 4. 检查补丁应用情况
1.OPatch 更新
打补丁一定要确保 OPatch 的版本符合 readme 中的要求,一般下载对应数据库版本最新的 OPath 覆盖即可。
此环节主要命令如下:
echo $ORACLE_HOME | |
cd $ORACLE_HOME | |
mv OPatch OPatch_bak | |
unzip /your_patch_dir/p6880880_112000_Linux-x86-64.zip | |
$ORACLE_HOME/OPatch/opatch version |
Tips:your_patch_dir 这里是代指你补丁介质存放的绝对目录.
2. 应用 PSU 补丁
2.1 数据库软件应用补丁:
此环节主要命令如下:
cd /your_patch_dir | |
unzip p23054359_112040_Linux-x86-64.zip | |
cd 23054359 | |
export PATH=$ORACLE_HOME/OPatch:$PATH | |
opatch prereq CheckConflictAgainstOHWithDetail -ph ./ | |
-- 关闭监听和数据库等相关服务 | |
lsnrctl stop | |
SQL> shutdown immediate | |
opatch apply |
2.2 数据库应用补丁:
此环节主要命令如下:
cd $ORACLE_HOME/rdbms/admin | |
sqlplus /nolog | |
SQL> CONNECT / AS SYSDBA | |
SQL> STARTUP | |
SQL> @catbundle.sql psu apply | |
SQL> QUIT |
3. 应用 OJVM PSU 补丁
3.1 数据库软件应用补丁:
此环节主要命令如下:
unzip -d <PATCH_TOP_DIR> p23177551_11204_<PLATFORM_NAME>.zip | |
cd <PATCH_TOP_DIR>/23177551 | |
opatch prereq CheckConflictAgainstOHWithDetail -ph ./ | |
-- 关闭数据库 | |
SQL> shutdown immediate | |
cd <PATCH_TOP_DIR>/23177551 | |
opatch apply | |
opatch lsinventory |
3.2 数据库应用补丁:
此环节主要命令如下:
-- 加载改动的 SQL 文件到数据库 | |
cd $ORACLE_HOME/sqlpatch/23177551 | |
sqlplus /nolog | |
SQL> CONNECT / AS SYSDBA | |
SQL> startup upgrade | |
SQL> @postinstall.sql | |
SQL> shutdown | |
SQL> startup | |
-- 重新编辑无效对象 | |
cd $ORACLE_HOME/rdbms/admin | |
sqlplus /nolog | |
SQL> CONNECT / AS SYSDBA | |
SQL> @utlrp.sql | |
-- 最后启动监听 | |
lsnrctl start | |
SQL> alter system register; |
4. 检查补丁应用情况
4.1 opatch 检查
$ORACLE_HOME/OPatch/opatch lspatches;
$ORACLE_HOME/OPatch/opatch lsinventory;
正常输出如下:
$ $ORACLE_HOME/OPatch/opatch lspatches; | |
23177551;OJVM PATCH SET UPDATE 11.2.0.4.160719 | |
23054359;Database Patch Set Update : 11.2.0.4.160719 (23054359) | |
OPatch succeeded. | |
$ $ORACLE_HOME/OPatch/opatch lsinventory; | |
Oracle 中间补丁程序安装程序版本 11.2.0.3.14 | |
版权所有 (c) 2016, 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.14 | |
OUI version : 11.2.0.4.0 | |
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-09-22_10-41-49 上午_1.log | |
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-09-22_10-41-49 上午.txt | |
-------------------------------------------------------------------------------- | |
Local Machine Information:: | |
Hostname: langchao01 | |
ARU platform id: 226 | |
ARU platform description:: Linux x86-64 | |
已安装的顶级产品 (1): | |
Oracle Database 11g 11.2.0.4.0 | |
此 Oracle 主目录中已安装 1 个产品。中间补丁程序 (2) : | |
Patch 23177551 : applied on Thu Sep 22 09:51:13 CST 2016 | |
Unique Patch ID: 20351577 | |
Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.160719" | |
Created on 27 Jun 2016, 12:28:29 hrs PST8PDT | |
Bugs fixed: | |
23727132, 18933818, 19176885, 17201047, 14774730, 19153980, 21911849 | |
18166577, 17056813, 21811517, 19909862, 22675136, 19895326, 22253904 | |
17804361, 19231857, 17528315, 19058059, 19554117, 19007266, 17285560 | |
22670385, 18458318, 19187988, 23265914, 19006757, 19374518, 19223010 | |
22118835, 19852360, 20408829, 21047766, 21566944 | |
Patch 23054359 : applied on Thu Sep 22 09:37:04 CST 2016 | |
Unique Patch ID: 20226193 | |
Patch description: "Database Patch Set Update : 11.2.0.4.160719 (23054359)" | |
Created on 15 Jun 2016, 16:08:35 hrs PST8PDT | |
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: | |
17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944 | |
13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498 | |
17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856 | |
21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210 | |
17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317 | |
18747196, 18641419, 17036973, 17811789, 14285317, 16542886, 18009564 | |
16618694, 8322815, 16692232, 18247991, 22507234, 17570240, 17848897 | |
17441661, 14034426, 17465741, 16596890, 17437634, 20506706, 21343897 | |
21453153, 18339044, 22321741, 17951233, 18430495, 21787056, 22380919 | |
20506715, 17811429, 19721304, 18230522, 19554106, 19458377, 17612828 | |
22092979, 22321756, 17040527, 17811438, 18641461, 14657740, 13364795 | |
21387964, 17588480, 17346671, 18235390, 17889549, 19309466, 16472716 | |
20596234, 18331850, 18641451, 17344412, 21179898, 17546761, 18203835 | |
18964939, 18203838, 18203837, 17313525, 22195457, 18139690, 22296366 | |
14106803, 16837842, 17842825, 21352646, 20657441, 16360112, 22195441 | |
17389192, 14565184, 17205719, 14354737, 22195448, 14764829, 13944971 | |
16571443, 21868720, 17186905, 17080436, 18673342, 17027426, 19972569 | |
19972568, 19972566, 17282229, 19972564, 16870214, 19615136, 17390431 | |
18762750, 16613964, 18098207, 17957017, 18471685, 19730508, 21538485 | |
18264060, 17323222, 17754782, 17600719, 18317531, 17852463, 17596908 | |
17655634, 20074391, 16228604, 19972570, 18996843, 19854503, 16042673 | |
17835627, 20334344, 20861693, 18000422, 17393683, 17551709, 20506699 | |
19006849, 18456514, 18277454, 17258090, 17174582, 17242746, 16399083 | |
17824637, 17762296, 17397545, 16450169, 12364061, 20067212, 18856999 | |
19211724, 19463893, 21343775, 19463897, 17853456, 18673304, 20004021 | |
21668627, 16194160, 17477958, 16538760, 12982566, 20296213, 18293054 | |
17610798, 19699191, 18135678, 17311728, 16785708, 10136473, 17786518 | |
18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014 | |
16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838 | |
18554871, 23177648, 18051556, 20803583, 18282562, 17922254, 15990359 | |
21972320, 16855292, 16668584, 21343838, 20299015, 17446237, 18093615 | |
17694209, 17288409, 17274537, 13955826, 16934803, 17634921, 17501491 | |
16315398, 22683212, 17006183, 13829543, 18191164, 17655240, 19393542 | |
18384391, 21538567, 16198143, 21847223, 17892268, 20142975, 19584068 | |
17165204, 18508861, 21756699, 18554763, 16901385, 18189036, 17443671 | |
17385178, 17936109, 14829250, 20925795, 17478514, 16850630, 13951456 | |
16595641, 15861775, 14054676, 16912439, 17299889, 17297939, 18619917 | |
16833527, 17798953, 17816865, 18607546, 17571306, 21286665, 17341326 | |
17851160, 20558005, 17586955, 19049453, 21051840, 17587063, 16956380 | |
18328509, 14133975, 18061914, 21051833, 18522509, 18765602, 18199537 | |
17332800, 13609098, 18384537, 22502493, 14338435, 17945983, 21067387 | |
16392068, 17752995, 21051862, 17237521, 16863422, 18244962, 19544839 | |
17156148, 18973907, 17877323, 17449815, 18180390, 17088068, 17037130 | |
20004087, 19466309, 11733603, 21051858, 18084625, 18674024, 21051852 | |
18091059, 18306996, 16306373, 19915271, 18193833, 17787259, 20631274 | |
16344544, 14692762, 18614015, 17346091, 18228645, 17721717, 18436307 | |
11883252, 21756677, 17891943, 22353199, 16384983, 19121551, 12816846 | |
17982555, 17761775, 17265217, 17071721, 16721594, 21756661, 18262334 | |
15913355, 17891946, 17672719, 17602269, 17239687, 17042658, 17238511 | |
17811456, 17284817, 17752121, 17394950, 16579084, 17011832, 22195465 | |
14602788, 18325460, 12611721, 16903536, 17006570, 16043574, 18783224 | |
16494615, 21526048, 19197175, 16069901, 17811447, 17308789, 22195477 | |
17865671, 19013183, 17343514, 18316692, 17325413, 16180763, 17348614 | |
14368995, 21983325, 17393915, 16285691, 20331945, 17883081, 17705023 | |
17614227, 22195485, 14084247, 13645875, 16777840, 19727057, 14852021 | |
18744139, 18674047, 17716305, 18482502, 19289642, 17622427, 22195492 | |
14458214, 18723434, 17767676, 19258504, 17786278, 17082983, 21351877 | |
13498382, 18331812, 16065166, 18031668, 22893153, 16943711, 21517440 | |
17649265, 13866822, 18094246, 14245531, 17783588, 17082359, 20448824 | |
18280813, 23330119, 16268425, 17302277, 18018515, 17215560, 19271443 | |
17016369, 20777150, 23330124, 20441797, 19769489, 17545847, 18260550 | |
13853126, 23536835, 17227277, 9756271, 18868646, 17614134, 17546973 | |
19680952, 18704244, 18828868, 18273830, 17050888, 17360606, 16992075 | |
17375354, 12905058, 18362222, 17571039, 17468141, 18436647, 17235750 | |
21168487, 16220077, 16929165 | |
-------------------------------------------------------------------------------- | |
OPatch succeeded. | |
$ |
4.2 SQL> select * from dba_registry_history;
SQL> select * from dba_registry_history;
SQL> set linesize 1000 | |
SQL> r | |
1* 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 | |
22-JUL-16 04.04.17.767881 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0 | |
22-SEP-16 09.41.41.199208 AM APPLY SERVER 11.2.0.4 160719 PSU PSU 11.2.0.4.160719 | |
22-SEP-16 09.55.50.902876 AM jvmpsu.sql SERVER 11.2.0.4.160719OJVMPSU 0 RAN jvmpsu.sql | |
22-SEP-16 09.55.50.941558 AM APPLY SERVER 11.2.0.4.160719OJVMPSU 0 OJVM PSU post-install | |
22-SEP-16 09.55.50.943907 AM APPLY 23177551 Patch 23177551 applied | |
6 rows selected. |
至此,Oracle 11.2.0.4 单实例打 PSU,OJVM PSU 补丁 (160719) 已完成。
更多 Oracle 相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12
本文永久更新链接地址:http://www.linuxidc.com/Linux/2016-09/135435.htm
