一、准备工作
1,数据库环境
操作系统版本 : Redhat 6.8 x64
数据库版本 : Oracle 12.1.0.2 x64 RAC
Grid : 12.1.0.2
Oracle database: 12.1.0.2
2,准备内容
GI PSU : p24412235_121020_Linux-x86-64.zip
OPatch : p6880880_122010_Linux-x86-64.zip
DB PSU : p24006101_121020_Linux-x86-64.zip 仅oracle12c单机使用。
OPatch下载地址:
https://updates.oracle.com/download/6880880.html
升级过程及说明:
(1) GI PSU包括DB PSU,CPU。
(2) 先升级节点1 grid,再升级节点2 grid,再升级节点1 database,后升级节点2 database。
二、更新OPatch
说明:分别在两个节点更新database以及grid OPatch版本。
1. 更新OPatch版本,OPatch直接压缩替换就可以了。
(1) 上传p6880880_122010_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限。
(2) root用户下将原OPatch目录改名。
mv /u01/app/12.1.0/grid/OPatch /u01/app/12.1.0/grid/OPatchbk
mv /u01/app/oracle/product/12.1.0/db_1/OPatch /u01/app/oracle/product/12.1.0/db_1/OPatchBK
2. grid目录OPatch替换
(1) root用户
cd /u01/software/;chown grid:oinstall p6880880_122010_Linux-x86-64.zip
(2) grid用户
cd /u01/software/; unzip p6880880_122010_Linux-x86-64.zip
(3) root用户
cd /u01/software/ ;mv OPatch /u01/app/12.1.0/grid/
(4) grid用户测试
su - grid
/u01/app/12.1.0/grid/OPatch/opatch version
OPatch Version: 12.2.0.1.8
OPatch succeeded.
3. oracle目录OPatch替换
(1) root用户
cd /u01/software/;chown oracle:oinstall p6880880_122010_Linux-x86-64.zip
(2) oracle用户
cd /u01/software/ ; unzip p6880880_122010_Linux-x86-64.zip
(3) root用户
cd /u01/software/; mv OPatch /u01/app/oracle/product/12.1.0/db_1/
(4) oracle用户测试
su - oracle
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatch version
OPatch Version: 12.2.0.1.8
OPatch succeeded.
三、开始升级GI PSU
说明:
(1) 升级过程会自动关闭和启动集群。
(2) 先升级节点1 grid,再升级节点2 grid。
1. grid用户下解决GI PSU补丁包
(1) root用户操作
cd /u01/software/;chown grid:oinstall p24412235_121020_Linux-x86-64.zip
(2) grid用户操作
# su - grid
$ cd /u01/software/;unzip p24412235_121020_Linux-x86-64.zip
2. root用户下使用-analyze命令预安装psu,测试兼容性(必须要在root用户下,否则报错)
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/software/24412235 -oh /u01/app/12.1.0/grid -analyze
过程如下:
----------------------------------------------------------------------
OPatchauto session is initiated at Thu Dec 8 22:16:11 2016
System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-12-08_10-16-15PM.log.
会话日志文件是/u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2016-12-08_10-16-31PM.log
此会话的 ID 为 DH2L
Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid
Patch applicablity verified successfully on home /u01/app/12.1.0/grid
Verifying patch inventory on home /u01/app/12.1.0/grid
Patch inventory verified successfully on home /u01/app/12.1.0/grid
OPatchAuto 成功。
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:db1
CRS Home:/u01/app/12.1.0/grid
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/software/24412235/21436941
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-08_22-16-39下午_1.log
Patch: /u01/software/24412235/23854735
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-08_22-16-39下午_1.log
Patch: /u01/software/24412235/24006101
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-08_22-16-39下午_1.log
Patch: /u01/software/24412235/24007012
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-08_22-16-39下午_1.log
OPatchauto session completed at Thu Dec 8 22:18:36 2016
Time taken to complete the session 2 minutes, 26 seconds
----------------------------------------------------------------------
3. root用户下安装grid psu
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/software/24412235 -oh /u01/app/12.1.0/grid
过程如下:
----------------------------------------------------------------------
OPatchauto session is initiated at Tue Dec 13 11:59:50 2016
System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-12-13_11-59-56AM.log.
会话日志文件是/u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2016-12-13_12-00-19PM.log
此会话的 ID 为 UUNB
Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid
Patch applicablity verified successfully on home /u01/app/12.1.0/grid
Verifying patch inventory on home /u01/app/12.1.0/grid
Patch inventory verified successfully on home /u01/app/12.1.0/grid
Bringing down CRS service on home /u01/app/12.1.0/grid
Prepatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_db1_2016-12-13_12-03-32AM.log
CRS service brought down successfully on home /u01/app/12.1.0/grid
Start applying binary patch on home /u01/app/12.1.0/grid
Binary patch applied successfully on home /u01/app/12.1.0/grid
Starting CRS service on home /u01/app/12.1.0/grid
Postpatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_db1_2016-12-13_12-19-53AM.log
CRS service started successfully on home /u01/app/12.1.0/grid
Verifying patches applied on home /u01/app/12.1.0/grid
Patch verification completed with warning on home /u01/app/12.1.0/grid
OPatchAuto 成功。
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:db1
CRS Home:/u01/app/12.1.0/grid
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/software/24412235/21436941
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_12-05-29下午_1.log
Patch: /u01/software/24412235/23854735
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_12-05-29下午_1.log
Patch: /u01/software/24412235/24006101
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_12-05-29下午_1.log
Patch: /u01/software/24412235/24007012
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_12-05-29下午_1.log
OPatchauto session completed at Tue Dec 13 12:31:24 2016
Time taken to complete the session 31 minutes, 34 seconds
----------------------------------------------------------------------
4. 两节点检查升级情况
# su - grid
$ORACLE_HOME/OPatch/opatch lsinv
-----------------------------------------------
记录略..
Patch level status of Cluster nodes :
Patching Level Nodes
-------------- -----
2919480821 db1,db2
-----------------------------------------------
$ORACLE_HOME/OPatch/opatch lspatches
24007012;ACFS Patch Set Update : 12.1.0.2.161018 (24007012)
24006101;Database Patch Set Update : 12.1.0.2.161018 (24006101)
23854735;OCW Patch Set Update : 12.1.0.2.161018 (23854735)
21436941;WLM Patch Set Update: 12.1.0.2.5 (21436941)
OPatch succeeded.
四、开始升级database
说明:
(1) 升级过程会自动关闭和启动集群。
(2) 先升级节点1 database,再升级节点2 database。
1. root用户操作用户升级GI PSU补丁包
cd /u01/software/;chown -R oracle:oinstall 24412235
2. root用户下使用-analyze命令预安装psu,测试兼容性
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/software/24412235 -oh /u01/app/oracle/product/12.1.0/db_1 -analyze
过程如下:
----------------------------------------------------------------------
OPatchauto session is initiated at Tue Dec 13 14:38:33 2016
System initialization log file is /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchautodb/systemconfig2016-12-13_02-38-40PM.log.
会话日志文件是/u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/opatchauto2016-12-13_02-39-17PM.log
此会话的 ID 为 ZHB2
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/db_1
Patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying patch inventory on home /u01/app/oracle/product/12.1.0/db_1
Patch inventory verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying SQL patch applicablity on home /u01/app/oracle/product/12.1.0/db_1
SQL patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0/db_1
OPatchAuto 成功。
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:db1
RAC Home:/u01/app/oracle/product/12.1.0/db_1
==Following patches were SKIPPED:
Patch: /u01/software/24412235/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/software/24412235/24007012
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/software/24412235/23854735
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_14-39-32下午_1.log
Patch: /u01/software/24412235/24006101
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_14-39-32下午_1.log
OPatchauto session completed at Tue Dec 13 14:41:16 2016
Time taken to complete the session 2 minutes, 44 seconds
----------------------------------------------------------------------
3. root用户下安装 database psu
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/software/24412235 -oh /u01/app/oracle/product/12.1.0/db_1
过程如下:
----------------------------------------------------------------------
OPatchauto session is initiated at Tue Dec 13 14:47:31 2016
System initialization log file is /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchautodb/systemconfig2016-12-13_02-47-36PM.log.
会话日志文件是/u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/opatchauto2016-12-13_02-47-57PM.log
此会话的 ID 为 VR4U
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/db_1
Patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying patch inventory on home /u01/app/oracle/product/12.1.0/db_1
Patch inventory verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying SQL patch applicablity on home /u01/app/oracle/product/12.1.0/db_1
SQL patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Preparing to bring down database service on home /u01/app/oracle/product/12.1.0/db_1
Successfully prepared home /u01/app/oracle/product/12.1.0/db_1 to bring down database service
Bringing down database service on home /u01/app/oracle/product/12.1.0/db_1
Following database(s) and/or service(s) are stopped and will be restarted later during the session: orcl
Database service successfully brought down on home /u01/app/oracle/product/12.1.0/db_1
Performing prepatch operation on home /u01/app/oracle/product/12.1.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/db_1
Start applying binary patch on home /u01/app/oracle/product/12.1.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.1.0/db_1
Performing postpatch operation on home /u01/app/oracle/product/12.1.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/db_1
Starting database service on home /u01/app/oracle/product/12.1.0/db_1
Database service successfully started on home /u01/app/oracle/product/12.1.0/db_1
Preparing home /u01/app/oracle/product/12.1.0/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.1.0/db_1 successfully after database service restarted
Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0/db_1
SQL patch applied successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying patches applied on home /u01/app/oracle/product/12.1.0/db_1
Patch verification completed with warning on home /u01/app/oracle/product/12.1.0/db_1
OPatchAuto 成功。
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:db1
RAC Home:/u01/app/oracle/product/12.1.0/db_1
Summary:
==Following patches were SKIPPED:
Patch: /u01/software/24412235/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/software/24412235/24007012
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /u01/software/24412235/23854735
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_14-50-30下午_1.log
Patch: /u01/software/24412235/24006101
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_14-50-30下午_1.log
OPatchauto session completed at Tue Dec 13 15:00:23 2016
Time taken to complete the session 12 minutes, 53 seconds
----------------------------------------------------------------------
4. 两节点检查升级情况
# su - oracle
$ORACLE_HOME/OPatch/opatch lsinv
-----------------------------------------------
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-12-13_15-05-33PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-13_15-05-33PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: db1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 24006101 : applied on Tue Dec 13 14:54:11 CST 2016
Unique Patch ID: 20683584
Patch description: "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Created on 1 Oct 2016, 12:33:50 hrs PST8PDT
Sub-patch 23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
19791273, 19243521, 20951038, 19908836, 21281532, 19238590, 24577566
21184223, 19134173, 20387265, 19149990, 21263635, 18886413, 17551063
22160989, 22507210, 19703301, 19366375, 19001390, 18202441, 20267166
19358317, 19706965, 18549238, 19068970, 18797519, 22148226, 20825533
19649152, 19670108, 18940497, 18948177, 18964978, 19035573, 19176326
20413820, 19176223, 20904530, 20134339, 19074147, 20868862, 18411216
21322887, 22507234, 20425790, 18966843, 21329301, 19333670, 19468991
20124446, 19883092, 19658708, 19591608, 19402853, 20618595, 21787056
22380919, 21266085, 17835294, 19721304, 19791377, 19068610, 22178855
22173980, 20746251, 20048359, 20898391, 19185876, 20281121, 20907061
6599380, 19577410, 22092979, 20603378, 19001359, 19490948, 21387964
20832516, 17532734, 19309466, 19081128, 20627866, 20844426, 21188532
18791688, 21442094, 20890311, 20596234, 18973548, 21296029, 19303936
19461270, 21479753, 20936905, 20235511, 21220620, 18964939, 19430401
22296366, 21153266, 19409212, 22657942, 20657441, 19879746, 19684504
20528052, 19024808, 20977794, 18799993, 20466322, 18740837, 19662635
20228093, 19065556, 20212067, 19524384, 17722075, 20446883, 18952989
16870214, 19928926, 19835133, 21629064, 20466628, 24386767, 19931709
19730508, 18819908, 23124895, 19188927, 20074391, 20356733, 14643995
19547370, 19065677, 21960504, 21225209, 20397490, 18967382, 19174430
21241829, 19536415, 19171086, 22465352, 22168163, 19335438, 20447445
18856999, 20471920, 19869255, 21620471, 18990693, 17890099, 18990023
20101006, 21300341, 20848335, 21744290, 20897759, 21668627, 19304354
19052488, 20794034, 23260854, 18681056, 20952966, 19896336, 18618122
20328248, 20440930, 18456643, 19699191, 19201867, 22865673, 18743542
20798891, 20347562, 22551446, 19777862, 19687159, 21373076, 19174942
20424899, 21899588, 18899974, 20598042, 19032777, 19058490, 22815955
19399918, 19434529, 21273804, 19018447, 22757364, 18851894, 19284031
19022470, 18043064, 20173897, 22062026, 20475845, 17274537, 19440586
16887946, 22374754, 17319928, 20708701, 17655240, 16439813, 19805359
19155797, 20859910, 19393542, 22024071, 17210525, 21847223, 19189525
21649497, 19075256, 22762046, 22075064, 19280225, 18845653, 20560611
19248799, 21756699, 18988834, 20245930, 18921743, 18799063, 20373598
20476175, 19571367, 20925795, 19018206, 20509482, 20711718, 20588502
18849537, 19183343, 21917884, 19189317, 19644859, 19390567, 19279273
20669434, 16863642, 22528741, 19619732, 18607546, 20348653, 19315691
19676905, 20165574, 17867700, 20558005, 20734332, 19532017, 20922010
19450314, 22353346, 20361671, 20009833, 22366558, 20294666, 18191823
19307662, 19371175, 19195895, 20043616, 19154375, 18914624, 20139391
21291274, 19174521, 19520602, 19382851, 21875360, 19676012, 19326908
20217801, 20093776, 21097043, 21246723, 21665897, 19143550, 20428621
19627012, 14283239, 19518079, 18610915, 18674024, 18306996, 19524158
19915271, 20122715, 20284155, 20017509, 19363645, 19597439, 21239530
19888853, 20880215, 21756677, 19534363, 19354335, 19044962, 19639483
22353199, 22243719, 22916353, 20378086, 21756661, 21260431, 22923409
20877664, 19028800, 20879889, 19723336, 19077215, 21421886, 19604659
19308965, 19048007, 18288842, 19689979, 21526048, 19180770, 19197175
19902195, 20318889, 19013183, 19012119, 20464614, 19067244, 21632821
19512341, 19841800, 20331945, 19587324, 24316947, 19578350, 19637186
18674047, 19054077, 20898997, 19708632, 21091431, 19289642, 20869721
19258504, 17365043, 19468347, 21373473, 16359751, 19439759, 19769480
19272708, 19978542, 20402832, 19329654, 19873610, 23229229, 21517440
13542050, 19291380, 21915719, 19076343, 19561643, 19990037, 19487147
18909599, 20831538, 18250893, 19016730, 16619249, 18354830, 21188584
19989009, 17414008, 20688221, 20704450, 20441797, 19157754, 18885870
21785691, 21450666, 18893947, 18705806, 22223463, 16923858, 18417036
20919320, 20474192, 22046677, 19385656, 19501299, 20920911, 20899461
21387128, 21315084, 18122373, 20581111, 19606174, 18436647, 19023822
19178851, 19124589, 19597583, 18499088, 19050649
Patch 23854735 : applied on Tue Dec 13 14:51:03 CST 2016
Unique Patch ID: 20511532
Patch description: "OCW Patch Set Update : 12.1.0.2.161018 (23854735)"
Created on 29 Sep 2016, 23:50:00 hrs PST8PDT
Bugs fixed:
21339083, 18589889, 20768643, 19061429, 19133945, 19341538, 19521169
20011424, 19361757, 19187207, 19302350, 19130141, 19530755, 19699720
19620918, 19168690, 18899171, 19244316, 19653795, 18634372, 19471722
19536337, 19184188, 19131709, 20160490, 20995001, 21131037, 19380733
20985167, 18943696, 20552947, 19591984, 18135723, 18461246, 20014326
19524857, 18890943, 19154753, 19499021, 19046190, 20923930, 20028666
19051385, 19050688, 19682695, 19831611, 21607972, 18922918, 21087799
18956780, 19683886, 23757020, 19026993, 20110156, 21269977, 18261648
18362971, 19558324, 22651583, 20185476, 18882642, 19478119, 19414274
17447588, 19262534, 20752167, 19147513, 22475834, 21242118, 19514085
20758997, 19659885, 19319904, 18703978, 23079844, 19700256, 19703246
20467806, 19192901, 21527118, 19479503, 19147751, 18901356, 21232394
18964974, 22162062, 18835366, 19013789, 19207286, 18950232, 22583325
19148791, 19556820, 16505171, 22261732, 22135419, 19449737, 21878613
21646169, 19187515, 19230771, 20795241, 19453778, 19853036, 18843572
18520351, 21430567, 19185148, 19232454, 21220597, 18541110, 18834955
19204743, 20175174, 19140891, 18747335, 20676340, 19270660, 19325701
20877003, 19222693, 19662663, 19684131, 19010177, 19272663, 18910576
18907170, 19426384, 9372680, 20737462, 19700294, 20289828, 19331454
22568500, 20278216, 20827053, 20119857, 19703199, 22456393, 20588164
18955644, 20991879, 18508710, 19908346, 19589221, 18952857, 19537762
21152052, 16286734, 20669114, 18762843, 18945249, 19184799, 19205086
19351363, 20091753, 19031737, 19079087, 19148367, 18968981, 19150517
20231741, 19217019, 18730096, 18975620, 19067804, 21259359, 19054979
19209951, 19318983, 18747382, 19154673, 18752378, 22905714, 19150088
19013444, 19234177, 18999857, 19075747, 19367276, 19612597, 19874047
19677813, 23049292, 19427050, 18910443, 20033787, 19148982, 19777496
20730170, 18523468, 19277814, 20562133, 19071526, 21420753, 18850051
20433932, 20061168, 19370739, 20822591, 19609388, 18776786, 20136892
18989446, 19148793, 19585454, 18317489, 19955755, 19059053, 19807548
19124972, 22229116, 18910748, 19147509, 18849896, 19617592, 19398098
22840085, 19076165, 19498411, 19704993, 21294273, 19459023, 20634511
21229744, 21474380, 21484367, 20276459, 17208793, 19234907, 19538714
22867050, 19383028, 19513969, 22195657, 23111368, 19986391, 19314048
18834934, 19473851, 19458082, 18894342, 19522067, 18116578, 19241857
19076778, 19066699, 19068003, 18937186, 20267877, 19916737, 19770543
22863466, 19635215, 19613533, 21057239, 20783416, 19315522, 19141785
19163887, 19885321, 18715868, 18852058, 19701617, 19280860, 19139608
21453435, 18946768, 19135521, 18604143, 19627476, 20568884, 20317221
20177779, 19266658, 24522717, 18330979, 19027351, 21227730, 18707416
21118157, 21113068, 19925992, 20235486, 20006646, 15922206, 18439295
18991776, 21245437, 23170839, 19163425, 19550195, 18849021, 18861196
17940721, 18524834, 19287706, 19522313, 18835283, 18748932, 19184765
21639478, 14851828, 20598625, 19226141, 19053891, 18871287, 18998228
18980002, 19682778, 19325604, 18777835, 17338864, 18945906, 19513650
19702758, 18952577, 19473088, 19178517, 18729269, 19529729, 19455563
20877072, 23275930, 20340620, 18536826, 19292605, 22264951, 20920711
20660273, 20011635, 17592037, 18935857, 22989069, 19029647, 19179158
22302421, 23076471, 19140712, 20012766, 23049301, 19184276, 20510208
20001507, 20079414, 19680763, 19259765, 18962892, 19513888, 14661880
21519340, 21222147, 20218012, 19551830, 21616278, 19068333, 18945435
20775015, 19319192, 20839581, 19178629, 21694237, 19304104, 19284357
22594310, 20725084, 19457575, 21297657, 19069755, 19021575, 18715884
19584688, 18798573, 19812592, 19018001, 19292272, 19270956, 21967791
21794779, 23055224, 18700893, 21276514, 20467377, 18406774, 20607821
21976167, 21082737, 21694632, 20115586, 20883009, 19164099, 18283792
19155350, 19884033, 19146822, 18798432, 21123424, 19471836, 20936562
18750781, 19045143, 22483804, 19146980, 19601003, 20099624, 21378016
19537547, 19281106, 18862203, 19954372, 18235274, 19205617, 19513351
20219458, 19150313, 18843054, 18708349, 19332386, 18953639, 21423055
19371270, 19203996, 20038431, 19370846, 21053036, 18998379, 20157569
21357522, 19273577, 24709351, 22113170, 19632437, 18990354, 19288396
20620581, 19557558, 19127078, 21792881, 20900588, 20053557, 22088198
22664609, 19315567, 19444471, 19154933, 20953798, 18290252, 18813323
19915945, 19500293, 18643483, 19134098, 23034352, 18965694, 19226858
19591356, 19602208, 22884308, 20069197, 18417590, 18920408, 18636884
22289350, 19043795, 20746507, 18260170, 18919682, 18678829, 19319357
19273758, 18953878, 18999195, 18759724, 19066844, 13843841, 20290467
22934855, 19649640, 19062675, 21924910, 18859710, 20862812, 19504641
23101611, 19341481, 20293730, 19343245, 18304090, 19241655, 19470791
18242738, 20649573, 18372060, 18953889, 18827679, 19140711, 19023430
19259290, 19045388, 20186278, 19522571, 19709663, 18875012, 18861564
19273760, 19225265, 15885689, 20853464, 21696068, 18819158, 21394146
19049721, 19368917, 21255373, 22393909, 20408163, 20579351, 18868829
20350915, 21327402, 22024217, 23101338, 19820247, 20363708, 19538241
19804032
Rac system comprising of multiple nodes
Local node = db1
Remote node = db2
--------------------------------------------------------------------------------
OPatch succeeded.
-----------------------------------------------
$ORACLE_HOME/OPatch/opatch lspatches
24006101;Database Patch Set Update : 12.1.0.2.161018 (24006101)
23854735;OCW Patch Set Update : 12.1.0.2.161018 (23854735)
OPatch succeeded.
五、注册PSU信息到数据库
1. 注册PSU到数据库
[root@db1 ~]# su - oracle
[oracle@db1 ~]$ cd /u01/app/oracle/product/12.1.0/db_1/OPatch
[oracle@db1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Tue Dec 13 15:37:19 2016
Copyright (c) 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_17776_2016_12_13_15_37_19/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 161018 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
24006101 (Database Patch Set Update : 12.1.0.2.161018 (24006101))
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 24006101 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/24006101/20683584/24006101_apply_HIGOV_2016Dec13_15_37_36.log (no errors)
SQL Patching tool complete on Fri Dec 13 15:37:04 2016
2. 查看数据库补丁记录
oracle12c(12.1.0.2起采用dba_registry_sqlpatch如下方式查看数据库补丁记录)
SQL> set linesize 300
SQL> col DESCRIPTION for a30
SQL> col ACTION_TIME for a30
SQL> select PATCH_ID, PATCH_UID,VERSION,ACTION, STATUS,ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch;
PATCH_ID PATCH_UID VERSION ACTION STATUS ACTION_TIME DESCRIPTION
---------- ---------- -------------------- --------------- --------------- ------------------------------ ------------------------------
24006101 20683584 12.1.0.2 APPLY SUCCESS 13-DEC-16 03.25.58.300240 PM Database Patch Set Update : 12.1.0.2.161018 (24006101)
SQL>
转载于:https://blog.51cto.com/koumm/1882307