【PSU】Oracle11g_psu_include_grid

xysoul_雲龍發表於2017-10-27
Oracle

環境介紹： Oracle11.2.0.4+GRID（ASM) redhat6.7 單機版   


為資料庫環境打補丁  命令很簡單，首先下載相關補丁包，請閱讀補丁包中readme.html

首先升級OPatch目錄，GRID oracle 使用者都需要

點選(此處)摺疊或開啟

  1. cp -rf /oracle/u01/soft/OPatch $ORACLE_HOME

再個就是檢查

點選(此處)摺疊或開啟

  1. cd 25476126/
  2. $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

生成一個配置檔案

點選(此處)摺疊或開啟

  1. su - grid
  2. $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /u01/soft/config.rsp

下面就可是執行自動安裝了

點選(此處)摺疊或開啟

  1. [root@myasm ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/soft/26635745 -ocmrf /u01/soft/config.rsp
  2. Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 26635745 -ocmrf /u01/soft/config.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

  4. This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-10-26_23-11-19.log

  6. This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
  7. /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-10-26_23-11-19.report.log

  9. 2017-10-26 23:11:19: Starting Oracle Restart Patch Setup
  10. Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
  11. The opatch minimum version check for patch /u01/soft/26635745/26392168 failed for /u01/app/11.2.0/grid
  12. The opatch minimum version check for patch /u01/soft/26635745/26609929 failed for /u01/app/11.2.0/grid
  13. The opatch minimum version check for patch /u01/soft/26635745/22502505 failed for /u01/app/11.2.0/grid
  14. Opatch version check failed for oracle home /u01/app/11.2.0/grid
  15. Opatch version check failed
  16. ERROR: update the opatch version for the failed homes and retry

  18. opatch auto failed.
  19. [root@myasm ~]# vi /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-10-26_23-11-19.report.log
  20. *********** Configuration Data ***********
  21. * It shows only those targets that will be patched in this session *


  24. crs_home=/u01/app/11.2.0/grid owner=grid opatch_ver=11.2.0.3.15
  25. rac_home=/u02/app/oracle/product/11.2.0/db_home owner=oracle opatch_ver=11.2.0.3.15

  27. *********** Steps to be executed as owner unless specified as root ***********
我去報錯了，版本？ 升級了啊，看看日誌


點選(此處)摺疊或開啟

  1. ……………………

  3. 2017-10-26 23:18:54: The opatch minimum version check for patch /u01/soft/26635745/26392168 failed for /u01/app/11.2.0/grid
  4. 2017-10-26 23:18:54: The opatch version check failed with following error
  5. 2017-10-26 23:18:54: Oracle Interim Patch Installer version 11.2.0.3.15
  6.  Copyright (c) 2017, Oracle Corporation. All rights reserved.
  7.  
  8.  
  9.  Oracle Home : /u01/app/11.2.0/grid
  10.  Central Inventory : /u01/app/oraInventory
  11.     from : /u01/app/11.2.0/grid/oraInst.loc
  12.  OPatch version : 11.2.0.3.15
  13.  OUI version : 11.2.0.4.0
  14.  Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2017-10-26_23-18-54PM_1.log
  15.  
  16.  OPatch failed to lock and get an Inventory Session for the given Oracle Home /u01/app/11.2.0/grid
  17.  Possible causes are:
  18.     No read or write permission to $ORACLE_HOME, cannot create $ORACLE_HOME/.patch_storage   
  19.     No read or write permission to $ORACLE_HOME/.patch_storage
  20.     OPatch cannot proceed further because system will not be able to backup files, or read the backup area for rollback/restore.
  21.  OPatchSession cannot load inventory for the given Oracle Home /u01/app/11.2.0/grid. Possible causes are:
  22.     No read or write permission to ORACLE_HOME/.patch_storage
  23.     Central Inventory is locked by another OUI instance
  24.     No read permission to Central Inventory
  25.     The lock file exists in ORACLE_HOME/.patch_storage
  26.     The Oracle Home does not exist in Central Inventory
  27.  

  29. ……………………
不能建立？什麼情況， 算了，自己建立唄


點選(此處)摺疊或開啟

  1. mkdir -p /u01/app/11.2.0/grid/.patch_storage
  2. mkdir -p /u02/app/oracle/product/11.2.0/db_home/.patch_storage
  3. chown grid:oinstall /u01/app/11.2.0/grid/.patch_storage
  4. chown oracle:oinstall /u02/app/oracle/product/11.2.0/db_home/.patch_storage
再次執行，通過啦

指令碼輸出內容比較簡單，具體資訊可以檢視日誌

點選(此處)摺疊或開啟

  1. [root@myasm ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/soft/26635745 -ocmrf /u01/soft/config.rsp
  2. Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 26635745 -ocmrf /u01/soft/config.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

  4. This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-10-26_23-23-32.log

  6. This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
  7. /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-10-26_23-23-32.report.log

  9. 2017-10-26 23:23:32: Starting Oracle Restart Patch Setup
  10. Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

  12. Stopping RAC /u02/app/oracle/product/11.2.0/db_home ...
  13. Stopped RAC /u02/app/oracle/product/11.2.0/db_home successfully

  15. patch /u01/soft/26635745/26392168 apply successful for home /u02/app/oracle/product/11.2.0/db_home
  16. patch /u01/soft/26635745/26609929/custom/server/26609929 apply successful for home /u02/app/oracle/product/11.2.0/db_home

  18. Stopping CRS...
  19. Stopped CRS successfully

  21. patch /u01/soft/26635745/26392168 apply successful for home /u01/app/11.2.0/grid
  22. patch /u01/soft/26635745/26609929 apply successful for home /u01/app/11.2.0/grid
  23. patch /u01/soft/26635745/22502505 apply successful for home /u01/app/11.2.0/grid

  25. Starting CRS...
  26. CRS-4123: Oracle High Availability Services has been started.

  28. Starting RAC /u02/app/oracle/product/11.2.0/db_home ...
  29. Started RAC /u02/app/oracle/product/11.2.0/db_home successfully

  31. opatch auto succeeded.


檢查檢查唄

點選(此處)摺疊或開啟

  1. [root@myasm ~]# su - grid
  2. [grid@myasm ~]$ cd /u01/app/11.2.0/grid/OPatch/
  3. [grid@myasm OPatch]$ ./opatch lsinventory
  4. Oracle Interim Patch Installer version 11.2.0.3.15
  5. Copyright (c) 2017, Oracle Corporation. All rights reserved.


  8. Oracle Home : /u01/app/11.2.0/grid
  9. Central Inventory : /u01/app/oraInventory
  10.    from : /u01/app/11.2.0/grid/oraInst.loc
  11. OPatch version : 11.2.0.3.15
  12. OUI version : 11.2.0.4.0
  13. Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2017-10-27_00-37-15AM_1.log

  15. Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-10-27_00-37-15AM.txt

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

  23. Installed Top-level Products (1):

  25. Oracle Grid Infrastructure 11g 11.2.0.4.0
  26. There are 1 products installed in this Oracle Home.


  29. Interim patches (3) :

  31. Patch 22502505 : applied on Thu Oct 26 23:34:26 CST 2017
  32. Unique Patch ID: 19880366
  33. Patch description: "ACFS Patch Set Update : 11.2.0.4.160419 (22502505)"
  34.    Created on 17 Feb 2016, 00:12:23 hrs PST8PDT
  35.    Bugs fixed:
  36.      21369858, 16318126, 19690653, 17503605, 17203009, 17359415, 20140148
  37.      17611362, 17164243, 19053182, 17696547, 17488768, 18168684, 21519796
  38.      18143006, 21208140, 17428148, 17070158, 20438706, 17510275, 17172303
  39.      18610307, 17376318, 17721778, 22198405, 17699423, 18915417, 18155334
  40.      18321597, 19919907, 18185024, 17636008, 17363999, 20681968, 17475946

  42. Patch 26609929 : applied on Thu Oct 26 23:33:43 CST 2017
  43. Unique Patch ID: 21512432
  44. Patch description: "OCW Patch Set Update : 11.2.0.4.170814 (26609929)"
  45.    Created on 10 Aug 2017, 22:16:53 hrs PST8PDT
  46.    Bugs fixed:
  47.      19270660, 18328800, 18508710, 18691572, 20038451, 21251192, 22162062
  48.      21232394, 20365005, 17750548, 17387214, 17617807, 14497275, 20219458
  49.      17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171
  50.      20110156, 17843489, 17065496, 21694632, 13991403, 17273020, 22762046
  51.      17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634
  52.      17886392, 20995001, 17039197, 17947785, 16317771, 10052729, 22353346
  53.      20340620, 16237657, 20317221, 15917869, 18199185, 18399991, 20186278
  54.      18024089, 17374271, 16849642, 20246071, 20746251, 14270845, 23621494
  55.      20552947, 18414137, 18882642, 17001914, 17927970, 14378120, 16346413
  56.      15986647, 18068871, 21222147, 18143836, 16206997, 21982225, 25490238
  57.      19168690, 20235511, 18343490, 21875360, 16613232, 19276791, 17722664
  58.      20440643, 12928658, 18952577, 16249829, 18520351, 18226143, 18265482
  59.      16076412, 18229842, 17172091, 20676340, 17818075, 20091753, 18231837
  60.      14373486, 20136892, 17483479, 20551654, 18120545, 18729166, 13843841
  61.      21225209, 17405302, 18709496, 18330979, 18744838, 14525998, 18187697
  62.      17087371, 20531190, 20598625, 14385860, 18348155, 19479503, 12928592
  63.      17516024, 18370031, 17764053, 19272663, 17551223, 14671408, 18272135
  64.      14207615, 21255373, 17500165, 18875012, 14769643, 25656952, 19558324
  65.      18464784, 18848125, 19241857, 17955615, 14851828, 20315294, 14693336
  66.      20014326, 17352230, 16284825, 17238586, 17089344, 17405605, 21327402
  67.      17531342, 26546632, 19398098, 17640316, 17159489, 13823394, 16543190
  68.      22024217, 17983675, 20795241, 16281493, 17598201, 18346135, 17481314
  69.      15986311, 19601468, 17208793, 18700935, 18999857, 14076173, 18428146
  70.      18352845, 17435488, 17592037, 20408163, 18352846, 19616601, 17391726
  71.      17387779, 15851860, 14777968, 20141091, 16206882, 19885321, 21113068
  72.      20175174, 17305100, 15832129, 16901346, 25591658, 17985714, 18536826
  73.      17780903, 18752378, 18946768, 16875342, 16876500, 17769597, 19955755
  74.      16429265, 18336452, 17273003, 17209968, 25484507, 17059927, 17046460
  75.      20094984, 19319357, 16988311, 18053631, 16867761, 18774591, 20235486
  76.      21442094, 19359787, 15869775, 19642566, 17447588, 21152052, 16798862
  77.      15920201

  79. Patch 26392168 : applied on Thu Oct 26 23:32:36 CST 2017
  80. Unique Patch ID: 21615794
  81. Patch description: "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
  82.    Created on 5 Oct 2017, 23:50:44 hrs PST8PDT
  83. Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
  84. Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
  85. Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
  86. Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
  87. Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
  88. Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
  89. Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
  90. Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
  91. Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
  92. Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
  93. Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
  94. Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
  95. Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
  96. Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
  97. Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
  98.    Bugs fixed:
  99.      17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 16731148
  100.      16314254, 13837378, 18441944, 17835048, 13558557, 17008068, 17201159
  101.      25427662, 17853498, 17246576, 18356166, 18681862, 18440047, 20569094
  102.      16875449, 20387265, 19788842, 17296856, 21330264, 14010183, 17648596
  103.      17551063, 17025461, 24719736, 17267114, 22507210, 17912217, 17889583
  104.      18202441, 17040764, 17478145, 25655390, 16524926, 19358317, 22148226
  105.      18747196, 26544823, 18641419, 17036973, 17811789, 14285317, 16542886
  106.      18009564, 16618694, 8322815, 16832076, 18247991, 16692232, 22507234
  107.      17570240, 13871092, 24624166, 17848897, 17441661, 14034426, 17465741
  108.      16596890, 17437634, 21343897, 20506706, 21453153, 18339044, 22321741
  109.      17951233, 18430495, 21787056, 22380919, 20506715, 19469538, 17811429
  110.      17903598, 19721304, 18230522, 19554106, 19458377, 21281607, 17612828
  111.      6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740
  112.      13364795, 19490948, 21387964, 17346671, 17588480, 18235390, 18849970
  113.      26474853, 17889549, 19309466, 16472716, 20596234, 18331850, 18641451
  114.      17344412, 21179898, 19461270, 17546761, 24842886, 14521849, 18203835
  115.      18203838, 18964939, 18203837, 17313525, 22195457, 18139690, 16837842
  116.      22296366, 14106803, 17842825, 21352646, 22657942, 20657441, 16360112
  117.      22195441, 17389192, 26198926, 14565184, 17205719, 18440095, 22195448
  118.      14354737, 14764829, 13944971, 16571443, 21868720, 17186905, 17080436
  119.      18673342, 22905130, 17027426, 19972569, 19972568, 20144308, 19972566
  120.      17282229, 19972564, 16870214, 19615136, 17390431, 18762750, 16613964
  121.      17957017, 18098207, 18471685, 19730508, 21538485, 18264060, 17323222
  122.      17754782, 17600719, 18317531, 17852463, 17596908, 17655634, 16228604
  123.      20074391, 19972570, 18996843, 19854503, 16042673, 17835627, 20334344
  124.      17393683, 18000422, 20861693, 17551709, 26575788, 23315889, 20506699
  125.      19006849, 18277454, 18456514, 17258090, 17174582, 25654936, 17242746
  126.      16399083, 21132297, 17824637, 17762296, 22168163, 17397545, 16450169
  127.      12364061, 20067212, 18856999, 19211724, 19463893, 21343775, 19463897
  128.      17853456, 18673304, 20004021, 26030218, 21668627, 16194160, 17477958
  129.      16538760, 12982566, 20828947, 20296213, 18259031, 18293054, 17610798
  130.      19699191, 23065323, 17311728, 18135678, 23294548, 16785708, 10136473
  131.      22551446, 24560906, 19777862, 17786518, 18315328, 18334586, 12747740
  132.      19032867, 18096714, 18899974, 17390160, 17232014, 16422541, 18673325
  133.      18155762, 14015842, 19827973, 22683225, 17726838, 18554871, 23177648
  134.      18051556, 20803583, 21972320, 15990359, 17922254, 18282562, 16855292
  135.      16668584, 21343838, 20299015, 17446237, 18043064, 18093615, 23713236
  136.      17694209, 17288409, 20475845, 17274537, 13955826, 16934803, 17634921
  137.      17501491, 16315398, 22683212, 17006183, 13829543, 18191164, 26746894
  138.      17655240, 19393542, 18384391, 21538567, 16198143, 21847223, 25823754
  139.      17892268, 20142975, 19584068, 17165204, 21756699, 18508861, 16901385
  140.      18554763, 21532755, 18189036, 17443671, 17385178, 17936109, 14829250
  141.      20925795, 20509482, 17478514, 16850630, 13951456, 16595641, 14054676
  142.      15861775, 16912439, 17299889, 17297939, 18619917, 16833527, 17798953
  143.      17816865, 18607546, 17571306, 21286665, 17341326, 17851160, 20558005
  144.      17586955, 19049453, 21051840, 17587063, 16956380, 18328509, 25423453
  145.      14133975, 18061914, 21051833, 18522509, 18765602, 18199537, 17332800
  146.      13609098, 18384537, 22502493, 14338435, 17945983, 21067387, 16392068
  147.      17752995, 21051862, 16863422, 25505382, 17237521, 18244962, 19544839
  148.      24433711, 17156148, 18973907, 23026585, 17877323, 17449815, 18180390
  149.      17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
  150.      21051858, 18674024, 21051852, 18091059, 16306373, 25369547, 18306996
  151.      18193833, 19915271, 17787259, 20631274, 25879656, 16344544, 14692762
  152.      18614015, 17346091, 18228645, 17721717, 18436307, 19888853, 21756677
  153.      11883252, 17891943, 22353199, 16384983, 19121551, 12816846, 17982555
  154.      17761775, 22243719, 17265217, 25505394, 17071721, 16721594, 21756661
  155.      18262334, 15913355, 17891946, 17672719, 17602269, 17239687, 17042658
  156.      17238511, 17811456, 17284817, 17752121, 20879889, 17394950, 16579084
  157.      17011832, 22195465, 14602788, 18325460, 24476265, 24476274, 12611721
  158.      16903536, 19689979, 17006570, 16043574, 18783224, 24662775, 16494615
  159.      21526048, 19197175, 16069901, 17811447, 17308789, 22195477, 17865671
  160.      19013183, 17343514, 17325413, 18316692, 16180763, 17348614, 14368995
  161.      21983325, 17393915, 16285691, 19211433, 20331945, 17883081, 24316947
  162.      17705023, 17614227, 19578350, 22195485, 14084247, 13645875, 16777840
  163.      19727057, 14852021, 18744139, 18674047, 19285025, 17716305, 18482502
  164.      17622427, 19289642, 25947799, 22195492, 20869721, 14458214, 18723434
  165.      17767676, 25505407, 17786278, 19258504, 17082983, 21351877, 17365043
  166.      13498382, 18331812, 16065166, 25489607, 16685417, 18031668, 22893153
  167.      16943711, 19272701, 21517440, 17649265, 13866822, 18094246, 24528741
  168.      17783588, 14245531, 17082359, 20448824, 18280813, 23330119, 16268425
  169.      25600421, 17302277, 18018515, 17215560, 24411921, 19271443, 17016369
  170.      20777150, 23330124, 20441797, 19769489, 17545847, 25093656, 18260550
  171.      13853126, 23536835, 17227277, 25957038, 24652769, 19207117, 9756271
  172.      18868646, 17614134, 26667023, 17546973, 18704244, 19680952, 26667015
  173.      17050888, 18828868, 18273830, 17360606, 16992075, 17375354, 12905058
  174.      18362222, 21429602, 17571039, 17468141, 18436647, 17235750, 21168487
  175.      16220077, 16929165



  179. --------------------------------------------------------------------------------

  181. OPatch succeeded.
  182. [grid@myasm OPatch]$ exit
  183. logout
  184. [root@myasm ~]# su - oracle
  185. [oracle@myasm ~]$ cd /u02/app/oracle/product/11.2.0/db_home/OPatch/
  186. [oracle@myasm OPatch]$ ./opatch lsinventory
  187. Oracle Interim Patch Installer version 11.2.0.3.15
  188. Copyright (c) 2017, Oracle Corporation. All rights reserved.


  191. Oracle Home : /u02/app/oracle/product/11.2.0/db_home
  192. Central Inventory : /u01/app/oraInventory
  193.    from : /u02/app/oracle/product/11.2.0/db_home/oraInst.loc
  194. OPatch version : 11.2.0.3.15
  195. OUI version : 11.2.0.4.0
  196. Log file location : /u02/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatch/opatch2017-10-27_00-38-03AM_1.log

  198. Lsinventory Output file location : /u02/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatch/lsinv/lsinventory2017-10-27_00-38-03AM.txt

  200. --------------------------------------------------------------------------------
  201. Local Machine Information::
  202. Hostname: myasm
  203. ARU platform id: 226
  204. ARU platform description:: Linux x86-64

  206. Installed Top-level Products (1):

  208. Oracle Database 11g 11.2.0.4.0
  209. There are 1 products installed in this Oracle Home.


  212. Interim patches (2) :

  214. Patch 26609929 : applied on Thu Oct 26 23:27:49 CST 2017
  215. Unique Patch ID: 21512432
  216. Patch description: "OCW Patch Set Update : 11.2.0.4.170814 (26609929)"
  217.    Created on 10 Aug 2017, 22:16:45 hrs PST8PDT
  218.    Bugs fixed:
  219.      19270660, 18328800, 18508710, 18691572, 20038451, 21251192, 22162062
  220.      21232394, 20365005, 17750548, 17387214, 17617807, 14497275, 20219458
  221.      17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171
  222.      20110156, 17843489, 17065496, 21694632, 13991403, 17273020, 22762046
  223.      17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634
  224.      17886392, 20995001, 17039197, 17947785, 16317771, 10052729, 22353346
  225.      20340620, 16237657, 20317221, 15917869, 18199185, 18399991, 20186278
  226.      18024089, 17374271, 16849642, 20246071, 20746251, 14270845, 23621494
  227.      20552947, 18414137, 18882642, 17001914, 17927970, 14378120, 16346413
  228.      15986647, 18068871, 21222147, 18143836, 16206997, 21982225, 25490238
  229.      19168690, 20235511, 18343490, 21875360, 16613232, 19276791, 17722664
  230.      20440643, 12928658, 18952577, 16249829, 18520351, 18226143, 18265482
  231.      16076412, 18229842, 17172091, 20676340, 17818075, 20091753, 18231837
  232.      14373486, 20136892, 17483479, 20551654, 18120545, 18729166, 13843841
  233.      21225209, 17405302, 18709496, 18330979, 18744838, 14525998, 18187697
  234.      17087371, 20531190, 20598625, 14385860, 18348155, 19479503, 12928592
  235.      17516024, 18370031, 17764053, 19272663, 17551223, 14671408, 18272135
  236.      14207615, 21255373, 17500165, 18875012, 14769643, 25656952, 19558324
  237.      18464784, 18848125, 19241857, 17955615, 14851828, 20315294, 14693336
  238.      20014326, 17352230, 16284825, 17238586, 17089344, 17405605, 21327402
  239.      17531342, 26546632, 19398098, 17640316, 17159489, 13823394, 16543190
  240.      22024217, 17983675, 20795241, 16281493, 17598201, 18346135, 17481314
  241.      15986311, 19601468, 17208793, 18700935, 18999857, 14076173, 18428146
  242.      18352845, 17435488, 17592037, 20408163, 18352846, 19616601, 17391726
  243.      17387779, 15851860, 14777968, 20141091, 16206882, 19885321, 21113068
  244.      20175174, 17305100, 15832129, 16901346, 25591658, 17985714, 18536826
  245.      17780903, 18752378, 18946768, 16875342, 16876500, 17769597, 19955755
  246.      16429265, 18336452, 17273003, 17209968, 25484507, 17059927, 17046460
  247.      20094984, 19319357, 16988311, 18053631, 16867761, 18774591, 20235486
  248.      21442094, 19359787, 15869775, 19642566, 17447588, 21152052, 16798862
  249.      15920201

  251. Patch 26392168 : applied on Thu Oct 26 23:26:40 CST 2017
  252. Unique Patch ID: 21615794
  253. Patch description: "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
  254.    Created on 5 Oct 2017, 23:50:44 hrs PST8PDT
  255. Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
  256. Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
  257. Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
  258. Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
  259. Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
  260. Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
  261. Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
  262. Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
  263. Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
  264. Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
  265. Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
  266. Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
  267. Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
  268. Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
  269. Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
  270.    Bugs fixed:
  271.      17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 16731148
  272.      16314254, 13837378, 18441944, 17835048, 13558557, 17008068, 17201159
  273.      25427662, 17853498, 17246576, 18356166, 18681862, 18440047, 20569094
  274.      16875449, 20387265, 19788842, 17296856, 21330264, 14010183, 17648596
  275.      17551063, 17025461, 24719736, 17267114, 22507210, 17912217, 17889583
  276.      18202441, 17040764, 17478145, 25655390, 16524926, 19358317, 22148226
  277.      18747196, 26544823, 18641419, 17036973, 17811789, 14285317, 16542886
  278.      18009564, 16618694, 8322815, 16832076, 18247991, 16692232, 22507234
  279.      17570240, 13871092, 24624166, 17848897, 17441661, 14034426, 17465741
  280.      16596890, 17437634, 21343897, 20506706, 21453153, 18339044, 22321741
  281.      17951233, 18430495, 21787056, 22380919, 20506715, 19469538, 17811429
  282.      17903598, 19721304, 18230522, 19554106, 19458377, 21281607, 17612828
  283.      6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740
  284.      13364795, 19490948, 21387964, 17346671, 17588480, 18235390, 18849970
  285.      26474853, 17889549, 19309466, 16472716, 20596234, 18331850, 18641451
  286.      17344412, 21179898, 19461270, 17546761, 24842886, 14521849, 18203835
  287.      18203838, 18964939, 18203837, 17313525, 22195457, 18139690, 16837842
  288.      22296366, 14106803, 17842825, 21352646, 22657942, 20657441, 16360112
  289.      22195441, 17389192, 26198926, 14565184, 17205719, 18440095, 22195448
  290.      14354737, 14764829, 13944971, 16571443, 21868720, 17186905, 17080436
  291.      18673342, 22905130, 17027426, 19972569, 19972568, 20144308, 19972566
  292.      17282229, 19972564, 16870214, 19615136, 17390431, 18762750, 16613964
  293.      17957017, 18098207, 18471685, 19730508, 21538485, 18264060, 17323222
  294.      17754782, 17600719, 18317531, 17852463, 17596908, 17655634, 16228604
  295.      20074391, 19972570, 18996843, 19854503, 16042673, 17835627, 20334344
  296.      17393683, 18000422, 20861693, 17551709, 26575788, 23315889, 20506699
  297.      19006849, 18277454, 18456514, 17258090, 17174582, 25654936, 17242746
  298.      16399083, 21132297, 17824637, 17762296, 22168163, 17397545, 16450169
  299.      12364061, 20067212, 18856999, 19211724, 19463893, 21343775, 19463897
  300.      17853456, 18673304, 20004021, 26030218, 21668627, 16194160, 17477958
  301.      16538760, 12982566, 20828947, 20296213, 18259031, 18293054, 17610798
  302.      19699191, 23065323, 17311728, 18135678, 23294548, 16785708, 10136473
  303.      22551446, 24560906, 19777862, 17786518, 18315328, 18334586, 12747740
  304.      19032867, 18096714, 18899974, 17390160, 17232014, 16422541, 18673325
  305.      18155762, 14015842, 19827973, 22683225, 17726838, 18554871, 23177648
  306.      18051556, 20803583, 21972320, 15990359, 17922254, 18282562, 16855292
  307.      16668584, 21343838, 20299015, 17446237, 18043064, 18093615, 23713236
  308.      17694209, 17288409, 20475845, 17274537, 13955826, 16934803, 17634921
  309.      17501491, 16315398, 22683212, 17006183, 13829543, 18191164, 26746894
  310.      17655240, 19393542, 18384391, 21538567, 16198143, 21847223, 25823754
  311.      17892268, 20142975, 19584068, 17165204, 21756699, 18508861, 16901385
  312.      18554763, 21532755, 18189036, 17443671, 17385178, 17936109, 14829250
  313.      20925795, 20509482, 17478514, 16850630, 13951456, 16595641, 14054676
  314.      15861775, 16912439, 17299889, 17297939, 18619917, 16833527, 17798953
  315.      17816865, 18607546, 17571306, 21286665, 17341326, 17851160, 20558005
  316.      17586955, 19049453, 21051840, 17587063, 16956380, 18328509, 25423453
  317.      14133975, 18061914, 21051833, 18522509, 18765602, 18199537, 17332800
  318.      13609098, 18384537, 22502493, 14338435, 17945983, 21067387, 16392068
  319.      17752995, 21051862, 16863422, 25505382, 17237521, 18244962, 19544839
  320.      24433711, 17156148, 18973907, 23026585, 17877323, 17449815, 18180390
  321.      17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
  322.      21051858, 18674024, 21051852, 18091059, 16306373, 25369547, 18306996
  323.      18193833, 19915271, 17787259, 20631274, 25879656, 16344544, 14692762
  324.      18614015, 17346091, 18228645, 17721717, 18436307, 19888853, 21756677
  325.      11883252, 17891943, 22353199, 16384983, 19121551, 12816846, 17982555
  326.      17761775, 22243719, 17265217, 25505394, 17071721, 16721594, 21756661
  327.      18262334, 15913355, 17891946, 17672719, 17602269, 17239687, 17042658
  328.      17238511, 17811456, 17284817, 17752121, 20879889, 17394950, 16579084
  329.      17011832, 22195465, 14602788, 18325460, 24476265, 24476274, 12611721
  330.      16903536, 19689979, 17006570, 16043574, 18783224, 24662775, 16494615
  331.      21526048, 19197175, 16069901, 17811447, 17308789, 22195477, 17865671
  332.      19013183, 17343514, 17325413, 18316692, 16180763, 17348614, 14368995
  333.      21983325, 17393915, 16285691, 19211433, 20331945, 17883081, 24316947
  334.      17705023, 17614227, 19578350, 22195485, 14084247, 13645875, 16777840
  335.      19727057, 14852021, 18744139, 18674047, 19285025, 17716305, 18482502
  336.      17622427, 19289642, 25947799, 22195492, 20869721, 14458214, 18723434
  337.      17767676, 25505407, 17786278, 19258504, 17082983, 21351877, 17365043
  338.      13498382, 18331812, 16065166, 25489607, 16685417, 18031668, 22893153
  339.      16943711, 19272701, 21517440, 17649265, 13866822, 18094246, 24528741
  340.      17783588, 14245531, 17082359, 20448824, 18280813, 23330119, 16268425
  341.      25600421, 17302277, 18018515, 17215560, 24411921, 19271443, 17016369
  342.      20777150, 23330124, 20441797, 19769489, 17545847, 25093656, 18260550
  343.      13853126, 23536835, 17227277, 25957038, 24652769, 19207117, 9756271
  344.      18868646, 17614134, 26667023, 17546973, 18704244, 19680952, 26667015
  345.      17050888, 18828868, 18273830, 17360606, 16992075, 17375354, 12905058
  346.      18362222, 21429602, 17571039, 17468141, 18436647, 17235750, 21168487
  347.      16220077, 16929165



  351. --------------------------------------------------------------------------------

  353. OPatch succeeded.


別忘了更新資料字典

點選(此處)摺疊或開啟

  1. cd $ORACLE_HOME/rdbms/admin
  2. sqlplus / AS SYSDBA
  3. SQL> STARTUP
  4. SQL> @?/rdbms/admin/catbundle.sql psu apply

  6. SQL> @?/rdbms/admin/utlrp.sql

OK ，就這樣吧

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29487349/viewspace-2146523/，如需轉載，請註明出處，否則將追究法律責任。

相關文章