Chinaunix首页 | 论坛 | 博客

情系天下的ChinaUnix博客

首页　| 　博文目录　| 　关于我

qxtx2012

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

全部博文（18）

文章存档

2016年（4）

2015年（14）

我的朋友
最近访客
推荐博文
相关博文
12C RAC安装PSU补丁

分类： 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

  5. 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

  5. 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:

  8. You have not provided an email address for notification of security issues.
  9. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
  10. 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

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

  12. OPatchauto Version : 12.1.0.1.10
  13. OUI Version : 12.1.0.2.0
  14. Running from : /u01/app/12.1.0/grid

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

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


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

  23. Parameter Validation: Successful

  25. Configuration Validation: Successful

  27. Patch Location: /soft/22191349
  28. Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
  29. DB Patch(es): 21948344 21948354

  31. Patch Validation: Successful
  32. Grid Infrastructure home:
  33. /u01/app/12.1.0/grid
  34. DB home(s):
  35. /u01/app/oracle/product/12.1.0/db_1


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

  42. Analyzing patch(es) on "/u01/app/12.1.0/grid" ...
  43. Patch "/soft/22191349/21436941" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
  44. Patch "/soft/22191349/21948341" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
  45. Patch "/soft/22191349/21948344" successfully analyzed on "/u01/app/12.1.0/grid" for apply.
  46. Patch "/soft/22191349/21948354" successfully analyzed on "/u01/app/12.1.0/grid" for apply.

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

  50. Apply Summary:
  51. Following patch(es) are successfully analyzed:
  52. GI Home: /u01/app/12.1.0/grid: 21436941,21948341,21948344,21948354
  53. DB Home: /u01/app/oracle/product/12.1.0/db_1: 21948344,21948354

  55. 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.

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

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

  11. Parameter Validation: Successful

  13. Configuration Validation: Successful

  15. Patch Location: /soft/22191349
  16. Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
  17. DB Patch(es): 21948344 21948354

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


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

  28. Applying patch(es) to "/u01/app/oracle/product/12.1.0/db_1" ...
  29. Patch "/soft/22191349/21948344" successfully applied to "/u01/app/oracle/product/12.1.0/db_1".
  30. Patch "/soft/22191349/21948354" successfully applied to "/u01/app/oracle/product/12.1.0/db_1".

  32. Applying patch(es) to "/u01/app/12.1.0/grid" ...
  33. Patch "/soft/22191349/21436941" successfully applied to "/u01/app/12.1.0/grid".
  34. Patch "/soft/22191349/21948341" successfully applied to "/u01/app/12.1.0/grid".
  35. Patch "/soft/22191349/21948344" successfully applied to "/u01/app/12.1.0/grid".
  36. Patch "/soft/22191349/21948354" successfully applied to "/u01/app/12.1.0/grid".

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

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

  42. Apply Summary:
  43. Following patch(es) are successfully installed:
  44. GI Home: /u01/app/12.1.0/grid: 21436941,21948341,21948344,21948354
  45. DB Home: /u01/app/oracle/product/12.1.0/db_1: 21948344,21948354

  47. 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.


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

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

  16. --------------------------------------------------------------------------------
  17. Local Machine Information::
  18. Hostname: node2
  19. ARU platform id: 226
  20. ARU platform description:: Linux x86-64

  22. Installed Top-level Products (1):

  24. Oracle Database 12c 12.1.0.2.0
  25. There are 1 products installed in this Oracle Home.


  28. Interim patches (2) :

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

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



  141. Rac system comprising of multiple nodes
  142.   Local node = node2
  143.   Remote node = node1

  145. --------------------------------------------------------------------------------

  147. 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.


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

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

  16. --------------------------------------------------------------------------------
  17. Local Machine Information::
  18. Hostname: node2
  19. ARU platform id: 226
  20. ARU platform description:: Linux x86-64

  22. Installed Top-level Products (1):

  24. Oracle Grid Infrastructure 12c 12.1.0.2.0
  25. There are 1 products installed in this Oracle Home.


  28. Interim patches (4) :

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

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

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

  155. Patch 21436941 : applied on Wed Feb 24 07:16:53 CST 2016
  156. Unique Patch ID: 19245012
  157. Patch description: "WLM Patch Set Update: 12.1.0.2.5 (21436941)"
  158.    Created on 13 Aug 2015, 04:00:40 hrs PST8PDT
  159.    Bugs fixed:
  160.      20075154, 20641027, 20548410, 19016964, 19582630



  164. Patch level status of Cluster nodes :

  166.  Patching Level          Nodes
  167.  --------------          -----
  168.  2278979115          node1,node2

  170. --------------------------------------------------------------------------------

  172. OPatch succeeded.


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


点击(此处)折叠或打开

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

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

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


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

  14. SQL> show pdbs

  16.     CON_ID CON_NAME             OPEN MODE RESTRICTED
  17. ---------- ------------------------------ ---------- ----------
  18.      2 PDB$SEED             READ ONLY NO
  19.      3 PDB                 MOUNTED
  20. SQL> alter pluggable database all open;

  22. Warning: PDB altered with errors.

  24. SQL> show pdbs

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

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

  41. Connecting to database...OK
  42. Note: Datapatch will only apply or rollback SQL fixes for PDBs
  43.        that are in an open state, no patches will be applied to closed PDBs.
  44.        Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
  45.        (Doc ID 1585822.1)
  46. Bootstrapping registry and package to current versions...done
  47. Determining current state...done

  49. Current state of SQL patches:
  50. Bundle series PSU:
  51.   ID 160119 in the binary registry and ID 160119 in PDB CDB$ROOT, ID 160119 in PDB PDB$SEED

  53. Adding patches to installation queue and performing prereq checks...
  54. Installation queue:
  55.   For the following PDBs: CDB$ROOT PDB$SEED
  56.     Nothing to roll back
  57.     Nothing to apply
  58.   For the following PDBs: PDB
  59.     Nothing to roll back
  60.     The following patches will be applied:
  61.       21948354 (Database Patch Set Update : 12.1.0.2.160119 (21948354))

  63. Installing patches...
  64. Patch installation complete. Total patches installed: 1

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


十三、验证


点击(此处)折叠或打开

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

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

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


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

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

  29. SQL> set linesize 300
  30. SQL> col DESCRIPTION for a30
  31. SQL> select PATCH_ID, PATCH_UID,VERSION,ACTION, STATUS,ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch;

  33.   PATCH_ID PATCH_UID VERSION         ACTION     STATUS     ACTION_TIME             DESCRIPTION
  34. ---------- ---------- -------------------- --------------- --------------- --------------------------------------------------------------------------- ------------------------------
  35.   21948354 19553095 12.1.0.2         APPLY     SUCCESS     23-FEB-16 02.19.02.241087 PM Database Patch Set Update : 12
  36.                                                      .1.0.2.160119 (21948354)








阅读(1514) | 评论(0) | 转发(0) |
0

上一篇：oracle安装介质及补丁集下载地址补全版

下一篇：sqlplus 登录时快时慢问题诊断

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6