【PSU】Oracle11g_psu_include_grid

环境介绍： 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
   
3. 
   
4. This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-10-26_23-11-19.log
   
5. 
   
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
   
8. 
   
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
    
17. 
    
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 *
    
22. 
    
23. 
    
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
    
26. 
    
27. *********** Steps to be executed as owner unless specified as root ***********

我去报错了，版本？ 升级了啊，看看日志

点击(此处)折叠或打开

1. ……………………
   
2. 
   
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.  
    
28. 
    
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
   
3. 
   
4. This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-10-26_23-23-32.log
   
5. 
   
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
   
8. 
   
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
    
11. 
    
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
    
14. 
    
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
    
17. 
    
18. Stopping CRS...
    
19. Stopped CRS successfully
    
20. 
    
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
    
24. 
    
25. Starting CRS...
    
26. CRS-4123: Oracle High Availability Services has been started.
    
27. 
    
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
    
30. 
    
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.
   
6. 
   
7. 
   
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
    
14. 
    
15. Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-10-27_00-37-15AM.txt
    
16. 
    
17. --------------------------------------------------------------------------------
    
18. Local Machine Information::
    
19. Hostname: myasm
    
20. ARU platform id: 226
    
21. ARU platform description:: Linux x86-64
    
22. 
    
23. Installed Top-level Products (1):
    
24. 
    
25. Oracle Grid Infrastructure 11g 11.2.0.4.0
    
26. There are 1 products installed in this Oracle Home.
    
27. 
    
28. 
    
29. Interim patches (3) :
    
30. 
    
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
    
41. 
    
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
    
78. 
    
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
     
176. 
     
177. 
     
178. 
     
179. --------------------------------------------------------------------------------
     
180. 
     
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.
     
189. 
     
190. 
     
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
     
197. 
     
198. Lsinventory Output file location : /u02/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatch/lsinv/lsinventory2017-10-27_00-38-03AM.txt
     
199. 
     
200. --------------------------------------------------------------------------------
     
201. Local Machine Information::
     
202. Hostname: myasm
     
203. ARU platform id: 226
     
204. ARU platform description:: Linux x86-64
     
205. 
     
206. Installed Top-level Products (1):
     
207. 
     
208. Oracle Database 11g 11.2.0.4.0
     
209. There are 1 products installed in this Oracle Home.
     
210. 
     
211. 
     
212. Interim patches (2) :
     
213. 
     
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
     
250. 
     
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
     
348. 
     
349. 
     
350. 
     
351. --------------------------------------------------------------------------------
     
352. 
     
353. OPatch succeeded.

别忘了更新数据字典

点击(此处)折叠或打开

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

OK ，就这样吧

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29487349/viewspace-2146523/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29487349/viewspace-2146523/