一、环境说明
作者环境为一套Oracle 12.1.0.2.0 2节点RAC,操作系统为Red Hat Enterprise Linux Server release 6.5 (Santiago),未打任何版本的PSU补丁,本次要安装的PSU补丁号为
(12.1.0.2.160119)
二、要安装该版本的PSU补丁,opatch版本必须 12.1.0.1.7 or later 的版本
下面是MOS中opatch程序的下载地址
-
https://support.oracle.com/epmos/faces/PatchDetail?requestId=13915373&_afrLoop=345520978061394&patchId=6880880&_afrWindowMode=0&_adf.ctrl-state=1b9dlul7to_53
三、到MOS中下载PSU补丁
从MOS中的
文档 ID 1454618.1中可以下载到各版本的补丁和PSU
四、上传psu和opatch程序到服务器中,在此我将psu和opatch介质上传到/soft目录下
五、替换grid组件opatch程序
-
[root@node2 soft]# unzip p6880880_121010_Linux-x86-64.zip
-
[root@node2 soft]# cd /u01/app/12.1.0/grid/
-
[root@node2 grid]# mv OPatch/ OPatchbak0223
-
[root@node2 grid]# mv /soft/OPatch/ .
-
[root@node2 grid]# chown -R grid:oinstall OPatch
验证opatch程序版本是否更新
-
[root@node2 db_1]# su - grid
-
[grid@node2 ~]$ opatch version
-
OPatch Version: 12.1.0.1.10
-
-
OPatch succeeded.
六、替换oracle用户rdbms组件opatch程序
-
[root@node2 grid]# cd /soft/
-
[root@node2 soft]# unzip p6880880_121010_Linux-x86-64.zip
-
[root@node2 soft]# cd /u01/app/oracle/product/12.1.0/db_1/
-
[root@node2 db_1]# mv OPatch/ OPatchbak0223
-
[root@node2 db_1]# mv /soft/OPatch/ .
-
[root@node2 db_1]# chown -R oracle:oinstall OPatch
验证rdmbs程序是否更新
-
[root@node2 db_1]# su - oracle
-
[oracle@node2 ~]$ opatch version
-
OPatch Version: 12.1.0.1.10
-
-
OPatch succeeded.
七、解压psu补丁,并更改权限
-
[root@node1 soft]# unzip p22191349_121020_Linux-x86-64.zip
-
[root@node1 /]# chown -R grid:oinstall /soft/
-
[root@node1 /]# chmod -R 775 /soft/
八、以grid用户生成OCM文件
-
[grid@node2 bin]$ ./emocmrsp -no_banner -output /soft/gridocm.rsp
-
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
-
The OCM configuration response file (/soft/gridocm.rsp) was successfully created.
九、使用-analyze命令预安装psu补丁,确认所有环境都是否准备OK
-
[root@node2 soft]# export PATH=$PATH:/u01/app/12.1.0/grid/OPatch
-
[root@node2 soft]# opatchauto version
-
OPatchauto version: 12.1.0.1.10
-
OPlan version: 12.1.0.2.2
-
OsysModel build: Thu Oct 08 06:25:14 PDT 2015
-
-
opatchauto succeeded.
-
[root@node2 soft]# opatchauto apply /soft/22191349/ -analyze -ocmrf /soft/gridocm.rsp
-
OPatch Automation Tool
-
Copyright (c)2014, Oracle Corporation. All rights reserved.
-
-
OPatchauto Version : 12.1.0.1.10
-
OUI Version : 12.1.0.2.0
-
Running from : /u01/app/12.1.0/grid
-
-
opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-02-24_05-06-30_analyze.log
-
-
NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system.
-
-
-
OCM RSP file has been ignored in analyze mode.
-
-
Parameter Validation: Successful
-
-
Configuration Validation: Successful
-
-
Patch Location: /soft/22191349
-
Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
-
DB Patch(es): 21948344 21948354
-
-
Patch Validation: Successful
-
Grid Infrastructure home:
-
/u01/app/12.1.0/grid
-
DB home(s):
-
/u01/app/oracle/product/12.1.0/db_1
-
-
-
Analyzing patch(es) on "/u01/app/oracle/product/12.1.0/db_1" ...
-
Patch "/soft/22191349/21948344" successfully analyzed on "/u01/app/oracle/product/12.1.0/db_1" for apply.
-
Patch "/soft/22191349/21948354" successfully analyzed on "/u01/app/oracle/product/12.1.0/db_1" for apply.
-
-
Analyzing patch(es) on "/u01/app/12.1.0/grid" ...
-
Patch "/soft/22191349/21436941" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
-
Patch "/soft/22191349/21948341" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
-
Patch "/soft/22191349/21948344" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
-
Patch "/soft/22191349/21948354" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
-
-
SQL changes, if any, are analyzed successfully on the following database(s): cdb
-
-
Apply Summary:
-
Following patch(es) are successfully analyzed:
-
GI Home: /u01/app/12.1.0/grid: 21436941,21948341,21948344,21948354
-
DB Home: /u01/app/oracle/product/12.1.0/db_1: 21948344,21948354
-
-
opatchauto succeeded.
十、安装GI和RDBMS的补丁
-
[root@node2 soft]# opatchauto apply /soft/22191349/ -ocmrf /soft/gridocm.rsp
-
OPatch Automation Tool
-
Copyright (c)2014, Oracle Corporation. All rights reserved.
-
-
OPatchauto Version : 12.1.0.1.10
-
OUI Version : 12.1.0.2.0
-
Running from : /u01/app/12.1.0/grid
-
-
opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-02-24_07-04-56_deploy.log
-
-
Parameter Validation: Successful
-
-
Configuration Validation: Successful
-
-
Patch Location: /soft/22191349
-
Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
-
DB Patch(es): 21948344 21948354
-
-
Patch Validation: Successful
-
Grid Infrastructure home:
-
/u01/app/12.1.0/grid
-
DB home(s):
-
/u01/app/oracle/product/12.1.0/db_1
-
-
-
Performing prepatch operations on CRS Home... Successful
-
-
Applying patch(es) to "/u01/app/oracle/product/12.1.0/db_1" ...
-
Patch "/soft/22191349/21948344" successfully applied to "/u01/app/oracle/product/12.1.0/db_1".
-
Patch "/soft/22191349/21948354" successfully applied to "/u01/app/oracle/product/12.1.0/db_1".
-
-
Applying patch(es) to "/u01/app/12.1.0/grid" ...
-
Patch "/soft/22191349/21436941" successfully applied to "/u01/app/12.1.0/grid".
-
Patch "/soft/22191349/21948341" successfully applied to "/u01/app/12.1.0/grid".
-
Patch "/soft/22191349/21948344" successfully applied to "/u01/app/12.1.0/grid".
-
Patch "/soft/22191349/21948354" successfully applied to "/u01/app/12.1.0/grid".
-
-
Performing postpatch operations on CRS Home... Successful
-
-
SQL changes, if any, are applied successfully on the following database(s): cdb
-
-
Apply Summary:
-
Following patch(es) are successfully installed:
-
GI Home: /u01/app/12.1.0/grid: 21436941,21948341,21948344,21948354
-
DB Home: /u01/app/oracle/product/12.1.0/db_1: 21948344,21948354
-
-
opatchauto succeeded.
另外一个节点,按照上述操作步骤操作即可
十一、验证opatch lsinventory
-
[root@node2 soft]# su - oracle
-
[oracle@node2 ~]$ opatch lsinventory
-
Oracle Interim Patch Installer version 12.1.0.1.10
-
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.1.0.1.10
-
OUI version : 12.1.0.2.0
-
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-02-24_07-47-26AM_1.log
-
-
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-02-24_07-47-26AM.txt
-
-
--------------------------------------------------------------------------------
-
Local Machine Information::
-
Hostname: node2
-
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 21948354 : applied on Wed Feb 24 07:12:05 CST 2016
-
Unique Patch ID: 19553095
-
Patch description: "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
-
Created on 20 Dec 2015, 23:39:33 hrs PST8PDT
-
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:
-
19189525, 19075256, 19141838, 19865345, 19791273, 19280225, 18845653
-
20951038, 19243521, 19248799, 21756699, 18988834, 19238590, 21281532
-
20245930, 18921743, 18799063, 19134173, 19571367, 20476175, 20925795
-
19018206, 20509482, 20387265, 20588502, 19149990, 18849537, 18886413
-
17551063, 19183343, 19703301, 19001390, 18202441, 19189317, 19644859
-
19358317, 19390567, 19279273, 19706965, 19068970, 19619732, 20348653
-
18607546, 18940497, 19670108, 19649152, 18948177, 19315691, 19676905
-
18964978, 19035573, 20165574, 19176326, 20413820, 20558005, 19176223
-
19532017, 20134339, 19074147, 18411216, 20361671, 20425790, 18966843
-
20294666, 19307662, 19371175, 19195895, 19154375, 19468991, 19174521
-
19520602, 19382851, 21875360, 19326908, 19658708, 20093776, 20618595
-
21787056, 17835294, 19791377, 19068610, 20048359, 20746251, 19143550
-
19185876, 19627012, 20281121, 19577410, 22092979, 19001359, 19518079
-
18610915, 19490948, 18674024, 18306996, 19309466, 19081128, 19915271
-
20122715, 21188532, 20284155, 18791688, 20890311, 21442094, 18973548
-
19303936, 19597439, 20235511, 18964939, 19430401, 19044962, 19409212
-
19879746, 20657441, 19684504, 19024808, 18799993, 20877664, 19028800
-
19065556, 19723336, 19077215, 19604659, 21421886, 19524384, 19048007
-
18288842, 19689979, 20446883, 18952989, 16870214, 19928926, 21526048
-
19180770, 19197175, 19902195, 20318889, 19730508, 19012119, 19067244
-
20074391, 19512341, 19841800, 14643995, 20331945, 19587324, 19547370
-
19065677, 19637186, 21225209, 20397490, 18967382, 19174430, 18674047
-
19054077, 19536415, 19708632, 19289642, 20869721, 19335438, 17365043
-
18856999, 19869255, 20471920, 19468347, 21620471, 16359751, 18990693
-
17890099, 19439759, 19769480, 19272708, 19978542, 20101006, 21300341
-
20402832, 19329654, 19873610, 21668627, 21517440, 19304354, 19052488
-
20794034, 19291380, 18681056, 19896336, 19076343, 19561643, 18618122
-
20440930, 18456643, 19699191, 18909599, 19487147, 18250893, 19016730
-
18743542, 20347562, 16619249, 18354830, 19687159, 19174942, 20424899
-
19989009, 20688221, 20441797, 19157754, 19032777, 19058490, 19399918
-
18885870, 19434529, 19018447, 18417036, 20919320, 19022470, 19284031
-
20474192, 20173897, 22062026, 19385656, 19501299, 17274537, 20899461
-
19440586, 16887946, 19606174, 18436647, 17655240, 19023822, 19178851
-
19124589, 19805359, 19597583, 19155797, 19393542, 19050649
-
-
Patch 21948344 : applied on Wed Feb 24 07:10:23 CST 2016
-
Unique Patch ID: 19577088
-
Patch description: "OCW Patch Set Update : 12.1.0.2.160119 (21948344)"
-
Created on 13 Jan 2016, 10:24:27 hrs PST8PDT
-
Bugs fixed:
-
19701617, 21339083, 18589889, 20768643, 19139608, 19280860, 19061429
-
19133945, 19341538, 19521169, 20011424, 18946768, 19135521, 18604143
-
19361757, 19187207, 19627476, 19302350, 19130141, 19530755, 20317221
-
20177779, 19699720, 19168690, 19266658, 18899171, 19244316, 19653795
-
18330979, 19471722, 18634372, 19027351, 21227730, 19536337, 18707416
-
19184188, 19131709, 21113068, 19925992, 20235486, 20160490, 20006646
-
20995001, 18439295, 18991776, 19380733, 21245437, 20552947, 18943696
-
19591984, 19163425, 18135723, 19550195, 20014326, 18849021, 19524857
-
18890943, 18861196, 19154753, 17940721, 19522313, 18748932, 18835283
-
19184765, 19499021, 20923930, 19046190, 14851828, 19051385, 19050688
-
19682695, 19831611, 20598625, 19226141, 19053891, 18871287, 18998228
-
18980002, 18922918, 18956780, 19683886, 19325604, 19026993, 18777835
-
17338864, 18261648, 18945906, 19513650, 20185476, 18952577, 19702758
-
18882642, 19414274, 17447588, 19262534, 20752167, 19147513, 21242118
-
19473088, 20758997, 19178517, 18729269, 19529729, 19659885, 19455563
-
20877072, 19319904, 18703978, 20340620, 18536826, 19700256, 19703246
-
19292605, 20467806, 19192901, 21527118, 20660273, 20011635, 17592037
-
19147751, 19479503, 19029647, 19179158, 18901356, 19140712, 20012766
-
21232394, 18964974, 18835366, 19184276, 19013789, 19207286, 20510208
-
20001507, 18950232, 20079414, 19680763, 19259765, 19148791, 19556820
-
19449737, 18962892, 21646169, 19187515, 19513888, 14661880, 19230771
-
21519340, 20795241, 20218012, 21222147, 19453778, 19853036, 19551830
-
21616278, 19068333, 18843572, 18520351, 18945435, 19185148, 19232454
-
20775015, 18541110, 19319192, 18834955, 19204743, 20839581, 19178629
-
19304104, 19140891, 18747335, 20676340, 19457575, 19270660, 21297657
-
19069755, 19021575, 18715884, 18798573, 19584688, 19018001, 19812592
-
19325701, 19270956, 19292272, 20877003, 18700893, 19222693, 19662663
-
21276514, 18406774, 19684131, 19010177, 21082737, 19272663, 18907170
-
18910576, 19426384, 9372680, 20883009, 19700294, 19164099, 20289828
-
19331454, 19155350, 20119857, 19703199, 18955644, 18508710, 19908346
-
18798432, 19146822, 21123424, 19589221, 19471836, 19537762, 16286734
-
20669114, 18762843, 19045143, 18945249, 19146980, 19184799, 19601003
-
19205086, 20099624, 19351363, 21378016, 20091753, 18862203, 19537547
-
19281106, 19031737, 19079087, 18968981, 19148367, 19150517, 20231741
-
19954372, 19217019, 18730096, 18235274, 18975620, 19205617, 19513351
-
20219458, 18843054, 19150313, 18708349, 19332386, 18953639, 21423055
-
21259359, 19067804, 19371270, 19203996, 18747382, 20038431, 19054979
-
19209951, 19318983, 19154673, 18752378, 19370846, 19150088, 19013444
-
21053036, 19234177, 18998379, 20157569, 18999857, 19273577, 19075747
-
19367276, 19632437, 19612597, 19874047, 19288396, 18990354, 19557558
-
19427050, 19127078, 18910443, 20053557, 19315567, 20033787, 19444471
-
19148982, 18290252, 18813323, 19915945, 19500293, 19777496, 18643483
-
19134098, 18523468, 19277814, 20562133, 21420753, 19071526, 18965694
-
19226858, 18850051, 19591356, 19602208, 20061168, 18417590, 19370739
-
18920408, 18636884, 19609388, 20136892, 18776786, 18989446, 19148793
-
19043795, 19585454, 20746507, 18260170, 18317489, 19955755, 18919682
-
19059053, 19807548, 19124972, 18678829, 19617592, 18910748, 18849896
-
19147509, 19076165, 18953878, 19273758, 19319357, 19498411, 18999195
-
19704993, 18759724, 19459023, 20634511, 21474380, 19066844, 20276459
-
17208793, 19234907, 13843841, 20290467, 19538714, 19649640, 19383028
-
19062675, 19513969, 18859710, 20862812, 19504641, 19341481, 19343245
-
18304090, 19986391, 20293730, 19314048, 19473851, 18834934, 19241655
-
19470791, 19458082, 18242738, 18894342, 18372060, 20649573, 19522067
-
18953889, 18827679, 19023430, 19140711, 19259290, 19045388, 20186278
-
19241857, 19522571, 19076778, 18875012, 19709663, 19066699, 18861564
-
19273760, 19225265, 20853464, 21696068, 18819158, 19068003, 18937186
-
21394146, 19049721, 19916737, 19368917, 19635215, 20408163, 18868829
-
22024217, 20783416, 19315522, 19141785, 19163887, 19885321, 19820247
-
18852058, 18715868, 20363708, 19538241, 19804032
-
-
-
-
Rac system comprising of multiple nodes
-
Local node = node2
-
Remote node = node1
-
-
--------------------------------------------------------------------------------
-
-
OPatch succeeded.
-
[root@node2 soft]# su - grid
-
[grid@node2 ~]$ opatch lsinventory
-
Oracle Interim Patch Installer version 12.1.0.1.10
-
Copyright (c) 2016, Oracle Corporation. All rights reserved.
-
-
-
Oracle Home : /u01/app/12.1.0/grid
-
Central Inventory : /u01/app/oraInventory
-
from : /u01/app/12.1.0/grid/oraInst.loc
-
OPatch version : 12.1.0.1.10
-
OUI version : 12.1.0.2.0
-
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2016-02-24_07-48-30AM_1.log
-
-
Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2016-02-24_07-48-30AM.txt
-
-
--------------------------------------------------------------------------------
-
Local Machine Information::
-
Hostname: node2
-
ARU platform id: 226
-
ARU platform description:: Linux x86-64
-
-
Installed Top-level Products (1):
-
-
Oracle Grid Infrastructure 12c 12.1.0.2.0
-
There are 1 products installed in this Oracle Home.
-
-
-
Interim patches (4) :
-
-
Patch 21948354 : applied on Wed Feb 24 07:25:54 CST 2016
-
Unique Patch ID: 19553095
-
Patch description: "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
-
Created on 20 Dec 2015, 23:39:33 hrs PST8PDT
-
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:
-
19189525, 19075256, 19141838, 19865345, 19791273, 19280225, 18845653
-
20951038, 19243521, 19248799, 21756699, 18988834, 19238590, 21281532
-
20245930, 18921743, 18799063, 19134173, 19571367, 20476175, 20925795
-
19018206, 20509482, 20387265, 20588502, 19149990, 18849537, 18886413
-
17551063, 19183343, 19703301, 19001390, 18202441, 19189317, 19644859
-
19358317, 19390567, 19279273, 19706965, 19068970, 19619732, 20348653
-
18607546, 18940497, 19670108, 19649152, 18948177, 19315691, 19676905
-
18964978, 19035573, 20165574, 19176326, 20413820, 20558005, 19176223
-
19532017, 20134339, 19074147, 18411216, 20361671, 20425790, 18966843
-
20294666, 19307662, 19371175, 19195895, 19154375, 19468991, 19174521
-
19520602, 19382851, 21875360, 19326908, 19658708, 20093776, 20618595
-
21787056, 17835294, 19791377, 19068610, 20048359, 20746251, 19143550
-
19185876, 19627012, 20281121, 19577410, 22092979, 19001359, 19518079
-
18610915, 19490948, 18674024, 18306996, 19309466, 19081128, 19915271
-
20122715, 21188532, 20284155, 18791688, 20890311, 21442094, 18973548
-
19303936, 19597439, 20235511, 18964939, 19430401, 19044962, 19409212
-
19879746, 20657441, 19684504, 19024808, 18799993, 20877664, 19028800
-
19065556, 19723336, 19077215, 19604659, 21421886, 19524384, 19048007
-
18288842, 19689979, 20446883, 18952989, 16870214, 19928926, 21526048
-
19180770, 19197175, 19902195, 20318889, 19730508, 19012119, 19067244
-
20074391, 19512341, 19841800, 14643995, 20331945, 19587324, 19547370
-
19065677, 19637186, 21225209, 20397490, 18967382, 19174430, 18674047
-
19054077, 19536415, 19708632, 19289642, 20869721, 19335438, 17365043
-
18856999, 19869255, 20471920, 19468347, 21620471, 16359751, 18990693
-
17890099, 19439759, 19769480, 19272708, 19978542, 20101006, 21300341
-
20402832, 19329654, 19873610, 21668627, 21517440, 19304354, 19052488
-
20794034, 19291380, 18681056, 19896336, 19076343, 19561643, 18618122
-
20440930, 18456643, 19699191, 18909599, 19487147, 18250893, 19016730
-
18743542, 20347562, 16619249, 18354830, 19687159, 19174942, 20424899
-
19989009, 20688221, 20441797, 19157754, 19032777, 19058490, 19399918
-
18885870, 19434529, 19018447, 18417036, 20919320, 19022470, 19284031
-
20474192, 20173897, 22062026, 19385656, 19501299, 17274537, 20899461
-
19440586, 16887946, 19606174, 18436647, 17655240, 19023822, 19178851
-
19124589, 19805359, 19597583, 19155797, 19393542, 19050649
-
-
Patch 21948344 : applied on Wed Feb 24 07:24:16 CST 2016
-
Unique Patch ID: 19577088
-
Patch description: "OCW Patch Set Update : 12.1.0.2.160119 (21948344)"
-
Created on 13 Jan 2016, 10:24:27 hrs PST8PDT
-
Bugs fixed:
-
19701617, 21339083, 18589889, 20768643, 19139608, 19280860, 19061429
-
19133945, 19341538, 19521169, 20011424, 18946768, 19135521, 18604143
-
19361757, 19187207, 19627476, 19302350, 19130141, 19530755, 20317221
-
20177779, 19699720, 19168690, 19266658, 18899171, 19244316, 19653795
-
18330979, 19471722, 18634372, 19027351, 21227730, 19536337, 18707416
-
19184188, 19131709, 21113068, 19925992, 20235486, 20160490, 20006646
-
20995001, 18439295, 18991776, 19380733, 21245437, 20552947, 18943696
-
19591984, 19163425, 18135723, 19550195, 20014326, 18849021, 19524857
-
18890943, 18861196, 19154753, 17940721, 19522313, 18748932, 18835283
-
19184765, 19499021, 20923930, 19046190, 14851828, 19051385, 19050688
-
19682695, 19831611, 20598625, 19226141, 19053891, 18871287, 18998228
-
18980002, 18922918, 18956780, 19683886, 19325604, 19026993, 18777835
-
17338864, 18261648, 18945906, 19513650, 20185476, 18952577, 19702758
-
18882642, 19414274, 17447588, 19262534, 20752167, 19147513, 21242118
-
19473088, 20758997, 19178517, 18729269, 19529729, 19659885, 19455563
-
20877072, 19319904, 18703978, 20340620, 18536826, 19700256, 19703246
-
19292605, 20467806, 19192901, 21527118, 20660273, 20011635, 17592037
-
19147751, 19479503, 19029647, 19179158, 18901356, 19140712, 20012766
-
21232394, 18964974, 18835366, 19184276, 19013789, 19207286, 20510208
-
20001507, 18950232, 20079414, 19680763, 19259765, 19148791, 19556820
-
19449737, 18962892, 21646169, 19187515, 19513888, 14661880, 19230771
-
21519340, 20795241, 20218012, 21222147, 19453778, 19853036, 19551830
-
21616278, 19068333, 18843572, 18520351, 18945435, 19185148, 19232454
-
20775015, 18541110, 19319192, 18834955, 19204743, 20839581, 19178629
-
19304104, 19140891, 18747335, 20676340, 19457575, 19270660, 21297657
-
19069755, 19021575, 18715884, 18798573, 19584688, 19018001, 19812592
-
19325701, 19270956, 19292272, 20877003, 18700893, 19222693, 19662663
-
21276514, 18406774, 19684131, 19010177, 21082737, 19272663, 18907170
-
18910576, 19426384, 9372680, 20883009, 19700294, 19164099, 20289828
-
19331454, 19155350, 20119857, 19703199, 18955644, 18508710, 19908346
-
18798432, 19146822, 21123424, 19589221, 19471836, 19537762, 16286734
-
20669114, 18762843, 19045143, 18945249, 19146980, 19184799, 19601003
-
19205086, 20099624, 19351363, 21378016, 20091753, 18862203, 19537547
-
19281106, 19031737, 19079087, 18968981, 19148367, 19150517, 20231741
-
19954372, 19217019, 18730096, 18235274, 18975620, 19205617, 19513351
-
20219458, 18843054, 19150313, 18708349, 19332386, 18953639, 21423055
-
21259359, 19067804, 19371270, 19203996, 18747382, 20038431, 19054979
-
19209951, 19318983, 19154673, 18752378, 19370846, 19150088, 19013444
-
21053036, 19234177, 18998379, 20157569, 18999857, 19273577, 19075747
-
19367276, 19632437, 19612597, 19874047, 19288396, 18990354, 19557558
-
19427050, 19127078, 18910443, 20053557, 19315567, 20033787, 19444471
-
19148982, 18290252, 18813323, 19915945, 19500293, 19777496, 18643483
-
19134098, 18523468, 19277814, 20562133, 21420753, 19071526, 18965694
-
19226858, 18850051, 19591356, 19602208, 20061168, 18417590, 19370739
-
18920408, 18636884, 19609388, 20136892, 18776786, 18989446, 19148793
-
19043795, 19585454, 20746507, 18260170, 18317489, 19955755, 18919682
-
19059053, 19807548, 19124972, 18678829, 19617592, 18910748, 18849896
-
19147509, 19076165, 18953878, 19273758, 19319357, 19498411, 18999195
-
19704993, 18759724, 19459023, 20634511, 21474380, 19066844, 20276459
-
17208793, 19234907, 13843841, 20290467, 19538714, 19649640, 19383028
-
19062675, 19513969, 18859710, 20862812, 19504641, 19341481, 19343245
-
18304090, 19986391, 20293730, 19314048, 19473851, 18834934, 19241655
-
19470791, 19458082, 18242738, 18894342, 18372060, 20649573, 19522067
-
18953889, 18827679, 19023430, 19140711, 19259290, 19045388, 20186278
-
19241857, 19522571, 19076778, 18875012, 19709663, 19066699, 18861564
-
19273760, 19225265, 20853464, 21696068, 18819158, 19068003, 18937186
-
21394146, 19049721, 19916737, 19368917, 19635215, 20408163, 18868829
-
22024217, 20783416, 19315522, 19141785, 19163887, 19885321, 19820247
-
18852058, 18715868, 20363708, 19538241, 19804032
-
-
Patch 21948341 : applied on Wed Feb 24 07:21:39 CST 2016
-
Unique Patch ID: 19577084
-
Patch description: "ACFS Patch Set Update : 12.1.0.2.160119 (21948341)"
-
Created on 2 Dec 2015, 05:52:43 hrs PST8PDT
-
Bugs fixed:
-
19452723, 18900953, 21208140, 19844362, 19526234, 18951113, 18899600
-
20923224, 19517835, 18185024, 19013966, 19195735, 19001684, 19509898
-
19053182, 20438706, 19593769, 19610001, 19475588, 19811784, 18957085
-
19279106, 20098064, 19184398, 20140148, 21519796, 19450090, 19859183
-
19502657, 18877486, 18915417, 18955907, 19060056, 19078259, 19919907
-
19127216, 20010980, 18934139, 19335268, 21555038, 20681968, 18851012
-
19149476, 19526283, 19428756, 19183802, 19051391, 19690653, 19355146
-
20314907, 20402287, 19644505, 19353057, 19201087, 19270227, 21233961
-
21124596, 19901825, 19610022, 19446719, 19649858, 18321597, 19557156
-
19469788, 18510745, 19528981, 21369858, 19134464
-
-
Patch 21436941 : applied on Wed Feb 24 07:16:53 CST 2016
-
Unique Patch ID: 19245012
-
Patch description: "WLM Patch Set Update: 12.1.0.2.5 (21436941)"
-
Created on 13 Aug 2015, 04:00:40 hrs PST8PDT
-
Bugs fixed:
-
20075154, 20641027, 20548410, 19016964, 19582630
-
-
-
-
Patch level status of Cluster nodes :
-
-
Patching Level Nodes
-
-------------- -----
-
2278979115 node1,node2
-
-
--------------------------------------------------------------------------------
-
-
OPatch succeeded.
十二、将打好的PSU信息导入到数据库中
-
[root@node2 soft]# su - oracle
-
[oracle@node2 ~]$ sqlplus / as sysdba
-
-
SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 07:51:44 2016
-
-
Copyright (c) 1982, 2014, Oracle. All rights reserved.
-
-
-
Connected to:
-
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
-
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
-
Advanced Analytics and Real Application Testing options
-
-
SQL> show pdbs
-
-
CON_ID CON_NAME OPEN MODE RESTRICTED
-
---------- ------------------------------ ---------- ----------
-
2 PDB$SEED READ ONLY NO
-
3 PDB MOUNTED
-
SQL> alter pluggable database all open;
-
-
Warning: PDB altered with errors.
-
-
SQL> show pdbs
-
-
CON_ID CON_NAME OPEN MODE RESTRICTED
-
---------- ------------------------------ ---------- ----------
-
2 PDB$SEED READ ONLY NO
-
3 PDB READ WRITE YES
-
SQL> exit
-
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
-
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
-
Advanced Analytics and Real Application Testing options
-
[oracle@node2 ~]$ cd /u01/app/oracle/product/12.1.0/db_1/OPatch
-
[oracle@node2 OPatch]$ ./datapatch -verbose
-
SQL Patching tool version 12.1.0.2.0 on Wed Feb 24 07:54:27 2016
-
Copyright (c) 2015, Oracle. All rights reserved.
-
-
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_5516_2016_02_24_07_54_27/sqlpatch_invocation.log
-
-
Connecting to database...OK
-
Note: Datapatch will only apply or rollback SQL fixes for PDBs
-
that are in an open state, no patches will be applied to closed PDBs.
-
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
-
(Doc ID 1585822.1)
-
Bootstrapping registry and package to current versions...done
-
Determining current state...done
-
-
Current state of SQL patches:
-
Bundle series PSU:
-
ID 160119 in the binary registry and ID 160119 in PDB CDB$ROOT, ID 160119 in PDB PDB$SEED
-
-
Adding patches to installation queue and performing prereq checks...
-
Installation queue:
-
For the following PDBs: CDB$ROOT PDB$SEED
-
Nothing to roll back
-
Nothing to apply
-
For the following PDBs: PDB
-
Nothing to roll back
-
The following patches will be applied:
-
21948354 (Database Patch Set Update : 12.1.0.2.160119 (21948354))
-
-
Installing patches...
-
Patch installation complete. Total patches installed: 1
-
-
Validating logfiles...
-
Patch 21948354 apply (pdb PDB): SUCCESS
-
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/21948354/19553095/21948354_apply_CDB_PDB_2016Feb24_07_58_11.log (no errors)
-
SQL Patching tool complete on Wed Feb 24 07:58:50 2016
十三、验证
-
[oracle@node2 OPatch]$ sqlplus / as sysdba
-
-
SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 08:34:10 2016
-
-
Copyright (c) 1982, 2014, Oracle. All rights reserved.
-
-
-
Connected to:
-
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
-
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
-
Advanced Analytics and Real Application Testing options
-
-
SQL> desc dba_registry_sqlpatch
-
Name Null? Type
-
----------------------------------------- -------- ----------------------------
-
PATCH_ID NOT NULL NUMBER
-
PATCH_UID NOT NULL NUMBER
-
VERSION NOT NULL VARCHAR2(20)
-
FLAGS VARCHAR2(10)
-
ACTION NOT NULL VARCHAR2(15)
-
STATUS VARCHAR2(15)
-
ACTION_TIME NOT NULL TIMESTAMP(6)
-
DESCRIPTION VARCHAR2(100)
-
BUNDLE_SERIES VARCHAR2(30)
-
BUNDLE_ID NUMBER
-
BUNDLE_DATA CLOB
-
LOGFILE VARCHAR2(500)
-
-
SQL> set linesize 300
-
SQL> col DESCRIPTION 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
-
---------- ---------- -------------------- --------------- --------------- --------------------------------------------------------------------------- ------------------------------
-
21948354 19553095 12.1.0.2 APPLY SUCCESS 23-FEB-16 02.19.02.241087 PM Database Patch Set Update : 12
-
.1.0.2.160119 (21948354)
阅读(1512) | 评论(0) | 转发(0) |