Chinaunix首页 | 论坛 | 博客
  • 博客访问: 25097
  • 博文数量: 18
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 180
  • 用 户 组: 普通用户
  • 注册时间: 2015-11-02 14:00
文章分类

全部博文(18)

文章存档

2016年(4)

2015年(14)

我的朋友

分类: Oracle

2016-02-24 16:48:29

一、环境说明

作者环境为一套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程序的下载地址

点击(此处)折叠或打开

  1. 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程序

点击(此处)折叠或打开

  1. [root@node2 soft]# unzip p6880880_121010_Linux-x86-64.zip
  2. [root@node2 soft]# cd /u01/app/12.1.0/grid/
  3. [root@node2 grid]# mv OPatch/ OPatchbak0223
  4. [root@node2 grid]# mv /soft/OPatch/ .
  5. [root@node2 grid]# chown -R grid:oinstall OPatch

验证opatch程序版本是否更新

点击(此处)折叠或打开

  1. [root@node2 db_1]# su - grid
  2. [grid@node2 ~]$ opatch version
  3. OPatch Version: 12.1.0.1.10

  4. OPatch succeeded.



六、替换oracle用户rdbms组件opatch程序

点击(此处)折叠或打开

  1. [root@node2 grid]# cd /soft/
  2. [root@node2 soft]# unzip p6880880_121010_Linux-x86-64.zip
  3. [root@node2 soft]# cd /u01/app/oracle/product/12.1.0/db_1/
  4. [root@node2 db_1]# mv OPatch/ OPatchbak0223
  5. [root@node2 db_1]# mv /soft/OPatch/ .
  6. [root@node2 db_1]# chown -R oracle:oinstall OPatch

验证rdmbs程序是否更新

点击(此处)折叠或打开

  1. [root@node2 db_1]# su - oracle
  2. [oracle@node2 ~]$ opatch version
  3. OPatch Version: 12.1.0.1.10

  4. OPatch succeeded.

七、解压psu补丁,并更改权限

点击(此处)折叠或打开

  1. [root@node1 soft]# unzip p22191349_121020_Linux-x86-64.zip
  2. [root@node1 /]# chown -R grid:oinstall /soft/
  3. [root@node1 /]# chmod -R 775 /soft/

八、以grid用户生成OCM文件

点击(此处)折叠或打开

  1. [grid@node2 bin]$ ./emocmrsp -no_banner -output /soft/gridocm.rsp
  2. Provide your email address to be informed of security issues, install and
  3. initiate Oracle Configuration Manager. Easier for you if you use your My
  4. Oracle Support Email address/User Name.
  5. Visit http://www.oracle.com/support/policies.html for details.
  6. Email address/User Name:

  7. You have not provided an email address for notification of security issues.
  8. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
  9. The OCM configuration response file (/soft/gridocm.rsp) was successfully created.

九、使用-analyze命令预安装psu补丁,确认所有环境都是否准备OK

点击(此处)折叠或打开

  1. [root@node2 soft]# export PATH=$PATH:/u01/app/12.1.0/grid/OPatch
  2. [root@node2 soft]# opatchauto version
  3. OPatchauto version: 12.1.0.1.10
  4. OPlan version: 12.1.0.2.2
  5. OsysModel build: Thu Oct 08 06:25:14 PDT 2015

  6. opatchauto succeeded.
  7. [root@node2 soft]# opatchauto apply /soft/22191349/ -analyze -ocmrf /soft/gridocm.rsp
  8. OPatch Automation Tool
  9. Copyright (c)2014, Oracle Corporation. All rights reserved.

  10. OPatchauto Version : 12.1.0.1.10
  11. OUI Version : 12.1.0.2.0
  12. Running from : /u01/app/12.1.0/grid

  13. opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-02-24_05-06-30_analyze.log

  14. NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system.


  15. OCM RSP file has been ignored in analyze mode.

  16. Parameter Validation: Successful

  17. Configuration Validation: Successful

  18. Patch Location: /soft/22191349
  19. Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
  20. DB Patch(es): 21948344 21948354

  21. Patch Validation: Successful
  22. Grid Infrastructure home:
  23. /u01/app/12.1.0/grid
  24. DB home(s):
  25. /u01/app/oracle/product/12.1.0/db_1


  26. Analyzing patch(es) on "/u01/app/oracle/product/12.1.0/db_1" ...
  27. Patch "/soft/22191349/21948344" successfully analyzed on "/u01/app/oracle/product/12.1.0/db_1" for apply.
  28. Patch "/soft/22191349/21948354" successfully analyzed on "/u01/app/oracle/product/12.1.0/db_1" for apply.

  29. Analyzing patch(es) on "/u01/app/12.1.0/grid" ...
  30. Patch "/soft/22191349/21436941" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
  31. Patch "/soft/22191349/21948341" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
  32. Patch "/soft/22191349/21948344" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
  33. Patch "/soft/22191349/21948354" successfully analyzed on "/u01/app/12.1.0/grid" for apply.

  34. SQL changes, if any, are analyzed successfully on the following database(s): cdb

  35. Apply Summary:
  36. Following patch(es) are successfully analyzed:
  37. GI Home: /u01/app/12.1.0/grid: 21436941,21948341,21948344,21948354
  38. DB Home: /u01/app/oracle/product/12.1.0/db_1: 21948344,21948354

  39. opatchauto succeeded.

十、安装GI和RDBMS的补丁


点击(此处)折叠或打开

  1. [root@node2 soft]# opatchauto apply /soft/22191349/ -ocmrf /soft/gridocm.rsp
  2. OPatch Automation Tool
  3. Copyright (c)2014, Oracle Corporation. All rights reserved.

  4. OPatchauto Version : 12.1.0.1.10
  5. OUI Version : 12.1.0.2.0
  6. Running from : /u01/app/12.1.0/grid

  7. opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-02-24_07-04-56_deploy.log

  8. Parameter Validation: Successful

  9. Configuration Validation: Successful

  10. Patch Location: /soft/22191349
  11. Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
  12. DB Patch(es): 21948344 21948354

  13. Patch Validation: Successful
  14. Grid Infrastructure home:
  15. /u01/app/12.1.0/grid
  16. DB home(s):
  17. /u01/app/oracle/product/12.1.0/db_1


  18. Performing prepatch operations on CRS Home... Successful

  19. Applying patch(es) to "/u01/app/oracle/product/12.1.0/db_1" ...
  20. Patch "/soft/22191349/21948344" successfully applied to "/u01/app/oracle/product/12.1.0/db_1".
  21. Patch "/soft/22191349/21948354" successfully applied to "/u01/app/oracle/product/12.1.0/db_1".

  22. Applying patch(es) to "/u01/app/12.1.0/grid" ...
  23. Patch "/soft/22191349/21436941" successfully applied to "/u01/app/12.1.0/grid".
  24. Patch "/soft/22191349/21948341" successfully applied to "/u01/app/12.1.0/grid".
  25. Patch "/soft/22191349/21948344" successfully applied to "/u01/app/12.1.0/grid".
  26. Patch "/soft/22191349/21948354" successfully applied to "/u01/app/12.1.0/grid".

  27. Performing postpatch operations on CRS Home... Successful

  28. SQL changes, if any, are applied successfully on the following database(s): cdb

  29. Apply Summary:
  30. Following patch(es) are successfully installed:
  31. GI Home: /u01/app/12.1.0/grid: 21436941,21948341,21948344,21948354
  32. DB Home: /u01/app/oracle/product/12.1.0/db_1: 21948344,21948354

  33. opatchauto succeeded.

另外一个节点,按照上述操作步骤操作即可

十一、验证opatch lsinventory

点击(此处)折叠或打开

  1. [root@node2 soft]# su - oracle
  2. [oracle@node2 ~]$ opatch lsinventory
  3. Oracle Interim Patch Installer version 12.1.0.1.10
  4. Copyright (c) 2016, Oracle Corporation. All rights reserved.


  5. Oracle Home : /u01/app/oracle/product/12.1.0/db_1
  6. Central Inventory : /u01/app/oraInventory
  7.    from : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
  8. OPatch version : 12.1.0.1.10
  9. OUI version : 12.1.0.2.0
  10. Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-02-24_07-47-26AM_1.log

  11. Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-02-24_07-47-26AM.txt

  12. --------------------------------------------------------------------------------
  13. Local Machine Information::
  14. Hostname: node2
  15. ARU platform id: 226
  16. ARU platform description:: Linux x86-64

  17. Installed Top-level Products (1):

  18. Oracle Database 12c 12.1.0.2.0
  19. There are 1 products installed in this Oracle Home.


  20. Interim patches (2) :

  21. Patch 21948354 : applied on Wed Feb 24 07:12:05 CST 2016
  22. Unique Patch ID: 19553095
  23. Patch description: "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
  24.    Created on 20 Dec 2015, 23:39:33 hrs PST8PDT
  25. Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
  26. Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
  27. Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
  28. Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
  29.    Bugs fixed:
  30.      19189525, 19075256, 19141838, 19865345, 19791273, 19280225, 18845653
  31.      20951038, 19243521, 19248799, 21756699, 18988834, 19238590, 21281532
  32.      20245930, 18921743, 18799063, 19134173, 19571367, 20476175, 20925795
  33.      19018206, 20509482, 20387265, 20588502, 19149990, 18849537, 18886413
  34.      17551063, 19183343, 19703301, 19001390, 18202441, 19189317, 19644859
  35.      19358317, 19390567, 19279273, 19706965, 19068970, 19619732, 20348653
  36.      18607546, 18940497, 19670108, 19649152, 18948177, 19315691, 19676905
  37.      18964978, 19035573, 20165574, 19176326, 20413820, 20558005, 19176223
  38.      19532017, 20134339, 19074147, 18411216, 20361671, 20425790, 18966843
  39.      20294666, 19307662, 19371175, 19195895, 19154375, 19468991, 19174521
  40.      19520602, 19382851, 21875360, 19326908, 19658708, 20093776, 20618595
  41.      21787056, 17835294, 19791377, 19068610, 20048359, 20746251, 19143550
  42.      19185876, 19627012, 20281121, 19577410, 22092979, 19001359, 19518079
  43.      18610915, 19490948, 18674024, 18306996, 19309466, 19081128, 19915271
  44.      20122715, 21188532, 20284155, 18791688, 20890311, 21442094, 18973548
  45.      19303936, 19597439, 20235511, 18964939, 19430401, 19044962, 19409212
  46.      19879746, 20657441, 19684504, 19024808, 18799993, 20877664, 19028800
  47.      19065556, 19723336, 19077215, 19604659, 21421886, 19524384, 19048007
  48.      18288842, 19689979, 20446883, 18952989, 16870214, 19928926, 21526048
  49.      19180770, 19197175, 19902195, 20318889, 19730508, 19012119, 19067244
  50.      20074391, 19512341, 19841800, 14643995, 20331945, 19587324, 19547370
  51.      19065677, 19637186, 21225209, 20397490, 18967382, 19174430, 18674047
  52.      19054077, 19536415, 19708632, 19289642, 20869721, 19335438, 17365043
  53.      18856999, 19869255, 20471920, 19468347, 21620471, 16359751, 18990693
  54.      17890099, 19439759, 19769480, 19272708, 19978542, 20101006, 21300341
  55.      20402832, 19329654, 19873610, 21668627, 21517440, 19304354, 19052488
  56.      20794034, 19291380, 18681056, 19896336, 19076343, 19561643, 18618122
  57.      20440930, 18456643, 19699191, 18909599, 19487147, 18250893, 19016730
  58.      18743542, 20347562, 16619249, 18354830, 19687159, 19174942, 20424899
  59.      19989009, 20688221, 20441797, 19157754, 19032777, 19058490, 19399918
  60.      18885870, 19434529, 19018447, 18417036, 20919320, 19022470, 19284031
  61.      20474192, 20173897, 22062026, 19385656, 19501299, 17274537, 20899461
  62.      19440586, 16887946, 19606174, 18436647, 17655240, 19023822, 19178851
  63.      19124589, 19805359, 19597583, 19155797, 19393542, 19050649

  64. Patch 21948344 : applied on Wed Feb 24 07:10:23 CST 2016
  65. Unique Patch ID: 19577088
  66. Patch description: "OCW Patch Set Update : 12.1.0.2.160119 (21948344)"
  67.    Created on 13 Jan 2016, 10:24:27 hrs PST8PDT
  68.    Bugs fixed:
  69.      19701617, 21339083, 18589889, 20768643, 19139608, 19280860, 19061429
  70.      19133945, 19341538, 19521169, 20011424, 18946768, 19135521, 18604143
  71.      19361757, 19187207, 19627476, 19302350, 19130141, 19530755, 20317221
  72.      20177779, 19699720, 19168690, 19266658, 18899171, 19244316, 19653795
  73.      18330979, 19471722, 18634372, 19027351, 21227730, 19536337, 18707416
  74.      19184188, 19131709, 21113068, 19925992, 20235486, 20160490, 20006646
  75.      20995001, 18439295, 18991776, 19380733, 21245437, 20552947, 18943696
  76.      19591984, 19163425, 18135723, 19550195, 20014326, 18849021, 19524857
  77.      18890943, 18861196, 19154753, 17940721, 19522313, 18748932, 18835283
  78.      19184765, 19499021, 20923930, 19046190, 14851828, 19051385, 19050688
  79.      19682695, 19831611, 20598625, 19226141, 19053891, 18871287, 18998228
  80.      18980002, 18922918, 18956780, 19683886, 19325604, 19026993, 18777835
  81.      17338864, 18261648, 18945906, 19513650, 20185476, 18952577, 19702758
  82.      18882642, 19414274, 17447588, 19262534, 20752167, 19147513, 21242118
  83.      19473088, 20758997, 19178517, 18729269, 19529729, 19659885, 19455563
  84.      20877072, 19319904, 18703978, 20340620, 18536826, 19700256, 19703246
  85.      19292605, 20467806, 19192901, 21527118, 20660273, 20011635, 17592037
  86.      19147751, 19479503, 19029647, 19179158, 18901356, 19140712, 20012766
  87.      21232394, 18964974, 18835366, 19184276, 19013789, 19207286, 20510208
  88.      20001507, 18950232, 20079414, 19680763, 19259765, 19148791, 19556820
  89.      19449737, 18962892, 21646169, 19187515, 19513888, 14661880, 19230771
  90.      21519340, 20795241, 20218012, 21222147, 19453778, 19853036, 19551830
  91.      21616278, 19068333, 18843572, 18520351, 18945435, 19185148, 19232454
  92.      20775015, 18541110, 19319192, 18834955, 19204743, 20839581, 19178629
  93.      19304104, 19140891, 18747335, 20676340, 19457575, 19270660, 21297657
  94.      19069755, 19021575, 18715884, 18798573, 19584688, 19018001, 19812592
  95.      19325701, 19270956, 19292272, 20877003, 18700893, 19222693, 19662663
  96.      21276514, 18406774, 19684131, 19010177, 21082737, 19272663, 18907170
  97.      18910576, 19426384, 9372680, 20883009, 19700294, 19164099, 20289828
  98.      19331454, 19155350, 20119857, 19703199, 18955644, 18508710, 19908346
  99.      18798432, 19146822, 21123424, 19589221, 19471836, 19537762, 16286734
  100.      20669114, 18762843, 19045143, 18945249, 19146980, 19184799, 19601003
  101.      19205086, 20099624, 19351363, 21378016, 20091753, 18862203, 19537547
  102.      19281106, 19031737, 19079087, 18968981, 19148367, 19150517, 20231741
  103.      19954372, 19217019, 18730096, 18235274, 18975620, 19205617, 19513351
  104.      20219458, 18843054, 19150313, 18708349, 19332386, 18953639, 21423055
  105.      21259359, 19067804, 19371270, 19203996, 18747382, 20038431, 19054979
  106.      19209951, 19318983, 19154673, 18752378, 19370846, 19150088, 19013444
  107.      21053036, 19234177, 18998379, 20157569, 18999857, 19273577, 19075747
  108.      19367276, 19632437, 19612597, 19874047, 19288396, 18990354, 19557558
  109.      19427050, 19127078, 18910443, 20053557, 19315567, 20033787, 19444471
  110.      19148982, 18290252, 18813323, 19915945, 19500293, 19777496, 18643483
  111.      19134098, 18523468, 19277814, 20562133, 21420753, 19071526, 18965694
  112.      19226858, 18850051, 19591356, 19602208, 20061168, 18417590, 19370739
  113.      18920408, 18636884, 19609388, 20136892, 18776786, 18989446, 19148793
  114.      19043795, 19585454, 20746507, 18260170, 18317489, 19955755, 18919682
  115.      19059053, 19807548, 19124972, 18678829, 19617592, 18910748, 18849896
  116.      19147509, 19076165, 18953878, 19273758, 19319357, 19498411, 18999195
  117.      19704993, 18759724, 19459023, 20634511, 21474380, 19066844, 20276459
  118.      17208793, 19234907, 13843841, 20290467, 19538714, 19649640, 19383028
  119.      19062675, 19513969, 18859710, 20862812, 19504641, 19341481, 19343245
  120.      18304090, 19986391, 20293730, 19314048, 19473851, 18834934, 19241655
  121.      19470791, 19458082, 18242738, 18894342, 18372060, 20649573, 19522067
  122.      18953889, 18827679, 19023430, 19140711, 19259290, 19045388, 20186278
  123.      19241857, 19522571, 19076778, 18875012, 19709663, 19066699, 18861564
  124.      19273760, 19225265, 20853464, 21696068, 18819158, 19068003, 18937186
  125.      21394146, 19049721, 19916737, 19368917, 19635215, 20408163, 18868829
  126.      22024217, 20783416, 19315522, 19141785, 19163887, 19885321, 19820247
  127.      18852058, 18715868, 20363708, 19538241, 19804032



  128. Rac system comprising of multiple nodes
  129.   Local node = node2
  130.   Remote node = node1

  131. --------------------------------------------------------------------------------

  132. OPatch succeeded.


点击(此处)折叠或打开

  1. [root@node2 soft]# su - grid
  2. [grid@node2 ~]$ opatch lsinventory
  3. Oracle Interim Patch Installer version 12.1.0.1.10
  4. Copyright (c) 2016, Oracle Corporation. All rights reserved.


  5. Oracle Home : /u01/app/12.1.0/grid
  6. Central Inventory : /u01/app/oraInventory
  7.    from : /u01/app/12.1.0/grid/oraInst.loc
  8. OPatch version : 12.1.0.1.10
  9. OUI version : 12.1.0.2.0
  10. Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2016-02-24_07-48-30AM_1.log

  11. Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2016-02-24_07-48-30AM.txt

  12. --------------------------------------------------------------------------------
  13. Local Machine Information::
  14. Hostname: node2
  15. ARU platform id: 226
  16. ARU platform description:: Linux x86-64

  17. Installed Top-level Products (1):

  18. Oracle Grid Infrastructure 12c 12.1.0.2.0
  19. There are 1 products installed in this Oracle Home.


  20. Interim patches (4) :

  21. Patch 21948354 : applied on Wed Feb 24 07:25:54 CST 2016
  22. Unique Patch ID: 19553095
  23. Patch description: "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
  24.    Created on 20 Dec 2015, 23:39:33 hrs PST8PDT
  25. Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
  26. Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
  27. Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
  28. Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
  29.    Bugs fixed:
  30.      19189525, 19075256, 19141838, 19865345, 19791273, 19280225, 18845653
  31.      20951038, 19243521, 19248799, 21756699, 18988834, 19238590, 21281532
  32.      20245930, 18921743, 18799063, 19134173, 19571367, 20476175, 20925795
  33.      19018206, 20509482, 20387265, 20588502, 19149990, 18849537, 18886413
  34.      17551063, 19183343, 19703301, 19001390, 18202441, 19189317, 19644859
  35.      19358317, 19390567, 19279273, 19706965, 19068970, 19619732, 20348653
  36.      18607546, 18940497, 19670108, 19649152, 18948177, 19315691, 19676905
  37.      18964978, 19035573, 20165574, 19176326, 20413820, 20558005, 19176223
  38.      19532017, 20134339, 19074147, 18411216, 20361671, 20425790, 18966843
  39.      20294666, 19307662, 19371175, 19195895, 19154375, 19468991, 19174521
  40.      19520602, 19382851, 21875360, 19326908, 19658708, 20093776, 20618595
  41.      21787056, 17835294, 19791377, 19068610, 20048359, 20746251, 19143550
  42.      19185876, 19627012, 20281121, 19577410, 22092979, 19001359, 19518079
  43.      18610915, 19490948, 18674024, 18306996, 19309466, 19081128, 19915271
  44.      20122715, 21188532, 20284155, 18791688, 20890311, 21442094, 18973548
  45.      19303936, 19597439, 20235511, 18964939, 19430401, 19044962, 19409212
  46.      19879746, 20657441, 19684504, 19024808, 18799993, 20877664, 19028800
  47.      19065556, 19723336, 19077215, 19604659, 21421886, 19524384, 19048007
  48.      18288842, 19689979, 20446883, 18952989, 16870214, 19928926, 21526048
  49.      19180770, 19197175, 19902195, 20318889, 19730508, 19012119, 19067244
  50.      20074391, 19512341, 19841800, 14643995, 20331945, 19587324, 19547370
  51.      19065677, 19637186, 21225209, 20397490, 18967382, 19174430, 18674047
  52.      19054077, 19536415, 19708632, 19289642, 20869721, 19335438, 17365043
  53.      18856999, 19869255, 20471920, 19468347, 21620471, 16359751, 18990693
  54.      17890099, 19439759, 19769480, 19272708, 19978542, 20101006, 21300341
  55.      20402832, 19329654, 19873610, 21668627, 21517440, 19304354, 19052488
  56.      20794034, 19291380, 18681056, 19896336, 19076343, 19561643, 18618122
  57.      20440930, 18456643, 19699191, 18909599, 19487147, 18250893, 19016730
  58.      18743542, 20347562, 16619249, 18354830, 19687159, 19174942, 20424899
  59.      19989009, 20688221, 20441797, 19157754, 19032777, 19058490, 19399918
  60.      18885870, 19434529, 19018447, 18417036, 20919320, 19022470, 19284031
  61.      20474192, 20173897, 22062026, 19385656, 19501299, 17274537, 20899461
  62.      19440586, 16887946, 19606174, 18436647, 17655240, 19023822, 19178851
  63.      19124589, 19805359, 19597583, 19155797, 19393542, 19050649

  64. Patch 21948344 : applied on Wed Feb 24 07:24:16 CST 2016
  65. Unique Patch ID: 19577088
  66. Patch description: "OCW Patch Set Update : 12.1.0.2.160119 (21948344)"
  67.    Created on 13 Jan 2016, 10:24:27 hrs PST8PDT
  68.    Bugs fixed:
  69.      19701617, 21339083, 18589889, 20768643, 19139608, 19280860, 19061429
  70.      19133945, 19341538, 19521169, 20011424, 18946768, 19135521, 18604143
  71.      19361757, 19187207, 19627476, 19302350, 19130141, 19530755, 20317221
  72.      20177779, 19699720, 19168690, 19266658, 18899171, 19244316, 19653795
  73.      18330979, 19471722, 18634372, 19027351, 21227730, 19536337, 18707416
  74.      19184188, 19131709, 21113068, 19925992, 20235486, 20160490, 20006646
  75.      20995001, 18439295, 18991776, 19380733, 21245437, 20552947, 18943696
  76.      19591984, 19163425, 18135723, 19550195, 20014326, 18849021, 19524857
  77.      18890943, 18861196, 19154753, 17940721, 19522313, 18748932, 18835283
  78.      19184765, 19499021, 20923930, 19046190, 14851828, 19051385, 19050688
  79.      19682695, 19831611, 20598625, 19226141, 19053891, 18871287, 18998228
  80.      18980002, 18922918, 18956780, 19683886, 19325604, 19026993, 18777835
  81.      17338864, 18261648, 18945906, 19513650, 20185476, 18952577, 19702758
  82.      18882642, 19414274, 17447588, 19262534, 20752167, 19147513, 21242118
  83.      19473088, 20758997, 19178517, 18729269, 19529729, 19659885, 19455563
  84.      20877072, 19319904, 18703978, 20340620, 18536826, 19700256, 19703246
  85.      19292605, 20467806, 19192901, 21527118, 20660273, 20011635, 17592037
  86.      19147751, 19479503, 19029647, 19179158, 18901356, 19140712, 20012766
  87.      21232394, 18964974, 18835366, 19184276, 19013789, 19207286, 20510208
  88.      20001507, 18950232, 20079414, 19680763, 19259765, 19148791, 19556820
  89.      19449737, 18962892, 21646169, 19187515, 19513888, 14661880, 19230771
  90.      21519340, 20795241, 20218012, 21222147, 19453778, 19853036, 19551830
  91.      21616278, 19068333, 18843572, 18520351, 18945435, 19185148, 19232454
  92.      20775015, 18541110, 19319192, 18834955, 19204743, 20839581, 19178629
  93.      19304104, 19140891, 18747335, 20676340, 19457575, 19270660, 21297657
  94.      19069755, 19021575, 18715884, 18798573, 19584688, 19018001, 19812592
  95.      19325701, 19270956, 19292272, 20877003, 18700893, 19222693, 19662663
  96.      21276514, 18406774, 19684131, 19010177, 21082737, 19272663, 18907170
  97.      18910576, 19426384, 9372680, 20883009, 19700294, 19164099, 20289828
  98.      19331454, 19155350, 20119857, 19703199, 18955644, 18508710, 19908346
  99.      18798432, 19146822, 21123424, 19589221, 19471836, 19537762, 16286734
  100.      20669114, 18762843, 19045143, 18945249, 19146980, 19184799, 19601003
  101.      19205086, 20099624, 19351363, 21378016, 20091753, 18862203, 19537547
  102.      19281106, 19031737, 19079087, 18968981, 19148367, 19150517, 20231741
  103.      19954372, 19217019, 18730096, 18235274, 18975620, 19205617, 19513351
  104.      20219458, 18843054, 19150313, 18708349, 19332386, 18953639, 21423055
  105.      21259359, 19067804, 19371270, 19203996, 18747382, 20038431, 19054979
  106.      19209951, 19318983, 19154673, 18752378, 19370846, 19150088, 19013444
  107.      21053036, 19234177, 18998379, 20157569, 18999857, 19273577, 19075747
  108.      19367276, 19632437, 19612597, 19874047, 19288396, 18990354, 19557558
  109.      19427050, 19127078, 18910443, 20053557, 19315567, 20033787, 19444471
  110.      19148982, 18290252, 18813323, 19915945, 19500293, 19777496, 18643483
  111.      19134098, 18523468, 19277814, 20562133, 21420753, 19071526, 18965694
  112.      19226858, 18850051, 19591356, 19602208, 20061168, 18417590, 19370739
  113.      18920408, 18636884, 19609388, 20136892, 18776786, 18989446, 19148793
  114.      19043795, 19585454, 20746507, 18260170, 18317489, 19955755, 18919682
  115.      19059053, 19807548, 19124972, 18678829, 19617592, 18910748, 18849896
  116.      19147509, 19076165, 18953878, 19273758, 19319357, 19498411, 18999195
  117.      19704993, 18759724, 19459023, 20634511, 21474380, 19066844, 20276459
  118.      17208793, 19234907, 13843841, 20290467, 19538714, 19649640, 19383028
  119.      19062675, 19513969, 18859710, 20862812, 19504641, 19341481, 19343245
  120.      18304090, 19986391, 20293730, 19314048, 19473851, 18834934, 19241655
  121.      19470791, 19458082, 18242738, 18894342, 18372060, 20649573, 19522067
  122.      18953889, 18827679, 19023430, 19140711, 19259290, 19045388, 20186278
  123.      19241857, 19522571, 19076778, 18875012, 19709663, 19066699, 18861564
  124.      19273760, 19225265, 20853464, 21696068, 18819158, 19068003, 18937186
  125.      21394146, 19049721, 19916737, 19368917, 19635215, 20408163, 18868829
  126.      22024217, 20783416, 19315522, 19141785, 19163887, 19885321, 19820247
  127.      18852058, 18715868, 20363708, 19538241, 19804032

  128. Patch 21948341 : applied on Wed Feb 24 07:21:39 CST 2016
  129. Unique Patch ID: 19577084
  130. Patch description: "ACFS Patch Set Update : 12.1.0.2.160119 (21948341)"
  131.    Created on 2 Dec 2015, 05:52:43 hrs PST8PDT
  132.    Bugs fixed:
  133.      19452723, 18900953, 21208140, 19844362, 19526234, 18951113, 18899600
  134.      20923224, 19517835, 18185024, 19013966, 19195735, 19001684, 19509898
  135.      19053182, 20438706, 19593769, 19610001, 19475588, 19811784, 18957085
  136.      19279106, 20098064, 19184398, 20140148, 21519796, 19450090, 19859183
  137.      19502657, 18877486, 18915417, 18955907, 19060056, 19078259, 19919907
  138.      19127216, 20010980, 18934139, 19335268, 21555038, 20681968, 18851012
  139.      19149476, 19526283, 19428756, 19183802, 19051391, 19690653, 19355146
  140.      20314907, 20402287, 19644505, 19353057, 19201087, 19270227, 21233961
  141.      21124596, 19901825, 19610022, 19446719, 19649858, 18321597, 19557156
  142.      19469788, 18510745, 19528981, 21369858, 19134464

  143. Patch 21436941 : applied on Wed Feb 24 07:16:53 CST 2016
  144. Unique Patch ID: 19245012
  145. Patch description: "WLM Patch Set Update: 12.1.0.2.5 (21436941)"
  146.    Created on 13 Aug 2015, 04:00:40 hrs PST8PDT
  147.    Bugs fixed:
  148.      20075154, 20641027, 20548410, 19016964, 19582630



  149. Patch level status of Cluster nodes :

  150.  Patching Level          Nodes
  151.  --------------          -----
  152.  2278979115          node1,node2

  153. --------------------------------------------------------------------------------

  154. OPatch succeeded.


十二、将打好的PSU信息导入到数据库中


点击(此处)折叠或打开

  1. [root@node2 soft]# su - oracle
  2. [oracle@node2 ~]$ sqlplus / as sysdba

  3. SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 07:51:44 2016

  4. Copyright (c) 1982, 2014, Oracle. All rights reserved.


  5. Connected to:
  6. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  7. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
  8. Advanced Analytics and Real Application Testing options

  9. SQL> show pdbs

  10.     CON_ID CON_NAME             OPEN MODE RESTRICTED
  11. ---------- ------------------------------ ---------- ----------
  12.      2 PDB$SEED             READ ONLY NO
  13.      3 PDB                 MOUNTED
  14. SQL> alter pluggable database all open;

  15. Warning: PDB altered with errors.

  16. SQL> show pdbs

  17.     CON_ID CON_NAME             OPEN MODE RESTRICTED
  18. ---------- ------------------------------ ---------- ----------
  19.      2 PDB$SEED             READ ONLY NO
  20.      3 PDB                 READ WRITE YES
  21. SQL> exit
  22. Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  23. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
  24. Advanced Analytics and Real Application Testing options
  25. [oracle@node2 ~]$ cd /u01/app/oracle/product/12.1.0/db_1/OPatch
  26. [oracle@node2 OPatch]$ ./datapatch -verbose
  27. SQL Patching tool version 12.1.0.2.0 on Wed Feb 24 07:54:27 2016
  28. Copyright (c) 2015, Oracle. All rights reserved.

  29. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_5516_2016_02_24_07_54_27/sqlpatch_invocation.log

  30. Connecting to database...OK
  31. Note: Datapatch will only apply or rollback SQL fixes for PDBs
  32.        that are in an open state, no patches will be applied to closed PDBs.
  33.        Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
  34.        (Doc ID 1585822.1)
  35. Bootstrapping registry and package to current versions...done
  36. Determining current state...done

  37. Current state of SQL patches:
  38. Bundle series PSU:
  39.   ID 160119 in the binary registry and ID 160119 in PDB CDB$ROOT, ID 160119 in PDB PDB$SEED

  40. Adding patches to installation queue and performing prereq checks...
  41. Installation queue:
  42.   For the following PDBs: CDB$ROOT PDB$SEED
  43.     Nothing to roll back
  44.     Nothing to apply
  45.   For the following PDBs: PDB
  46.     Nothing to roll back
  47.     The following patches will be applied:
  48.       21948354 (Database Patch Set Update : 12.1.0.2.160119 (21948354))

  49. Installing patches...
  50. Patch installation complete. Total patches installed: 1

  51. Validating logfiles...
  52. Patch 21948354 apply (pdb PDB): SUCCESS
  53.   logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/21948354/19553095/21948354_apply_CDB_PDB_2016Feb24_07_58_11.log (no errors)
  54. SQL Patching tool complete on Wed Feb 24 07:58:50 2016


十三、验证


点击(此处)折叠或打开

  1. [oracle@node2 OPatch]$ sqlplus / as sysdba

  2. SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 08:34:10 2016

  3. Copyright (c) 1982, 2014, Oracle. All rights reserved.


  4. Connected to:
  5. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  6. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
  7. Advanced Analytics and Real Application Testing options

  8. SQL> desc dba_registry_sqlpatch
  9.  Name                     Null? Type
  10.  ----------------------------------------- -------- ----------------------------
  11.  PATCH_ID                 NOT NULL NUMBER
  12.  PATCH_UID                 NOT NULL NUMBER
  13.  VERSION                 NOT NULL VARCHAR2(20)
  14.  FLAGS                         VARCHAR2(10)
  15.  ACTION                  NOT NULL VARCHAR2(15)
  16.  STATUS                      VARCHAR2(15)
  17.  ACTION_TIME                 NOT NULL TIMESTAMP(6)
  18.  DESCRIPTION                     VARCHAR2(100)
  19.  BUNDLE_SERIES                     VARCHAR2(30)
  20.  BUNDLE_ID                     NUMBER
  21.  BUNDLE_DATA                     CLOB
  22.  LOGFILE                     VARCHAR2(500)

  23. SQL> set linesize 300
  24. SQL> col DESCRIPTION for a30
  25. SQL> select PATCH_ID, PATCH_UID,VERSION,ACTION, STATUS,ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch;

  26.   PATCH_ID PATCH_UID VERSION         ACTION     STATUS     ACTION_TIME             DESCRIPTION
  27. ---------- ---------- -------------------- --------------- --------------- --------------------------------------------------------------------------- ------------------------------
  28.   21948354 19553095 12.1.0.2         APPLY     SUCCESS     23-FEB-16 02.19.02.241087 PM Database Patch Set Update : 12
  29.                                                      .1.0.2.160119 (21948354)








阅读(1512) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~