Docker下Oracle12C安装PSU补丁-应用PSU

在 Docker下Oracle12C安装PSU补丁-OPatch 后，将OPatch工具安装到12.1.0.1.10版本

应用PSU补丁

在xe路径下新建一个Oracleupdate文件夹，将应用补丁放入，并解压

#cd进入补丁内
cd 28259833
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

进行冲突检查 ：opatch prereq CheckConflictAgainstOHWithDetail -ph ./ （这里是相对路径，所以要在28259833下）

确定当前安装的任何临时补丁是否与正在安装的补丁冲突，结果如下：

[Dec 13, 2018 2:55:20 AM]    OPatch invoked as follows: 'apply -invPtrLoc /u01/app/oracle/product/12.1.0/xe/oraInst.loc '
[Dec 13, 2018 2:55:20 AM]    Could not get central inventory using NGOUI; oracle.sysman.nextgen.utils.NextGenInventoryUtil
[Dec 13, 2018 2:55:20 AM]    OUI-67077:
                             Oracle Home       : /u01/app/oracle/product/12.1.0/xe
                             Central Inventory : /u01/app/oraInventory
                                from           : /u01/app/oracle/product/12.1.0/xe/oraInst.loc
                             OPatch version    : 12.1.0.1.10
                             OUI version       : 12.1.0.2.0
                             OUI location      : /u01/app/oracle/product/12.1.0/xe/oui
                             Log file location : /u01/app/oracle/product/12.1.0/xe/cfgtoollogs/opatch/opatch2018-12-13_02-55-20AM_1.log
[Dec 13, 2018 2:55:20 AM]    Patch history file: /u01/app/oracle/product/12.1.0/xe/cfgtoollogs/opatch/opatch_history.txt
[Dec 13, 2018 2:55:24 AM]    [OPSR-MEMORY-1] : after installInventory.getAllCompsVect() call : 38 (MB)
[Dec 13, 2018 2:55:24 AM]    [OPSR-MEMORY-2] : before loading cooked one off : 6 (MB)
[Dec 13, 2018 2:55:24 AM]    [OPSR-MEMORY-3] : after loading rawOneOffList and before loading minipatch list in cooked one off : 6 (MB)
[Dec 13, 2018 2:55:24 AM]    [OPSR-MEMORY-4] : after filling cookedOneOffs and when inventory is loaded.. : 6 (MB)
[Dec 13, 2018 2:55:24 AM]    Verifying environment and performing prerequisite checks...
[Dec 13, 2018 2:55:24 AM]    Ignoring file "/u01/app/oracle-product/12.1.0/xe/Oracleupdate/28259833/README.html" in the patch directory.
[Dec 13, 2018 2:55:24 AM]    Ignoring file "/u01/app/oracle-product/12.1.0/xe/Oracleupdate/28259833/README.txt" in the patch directory.
[Dec 13, 2018 2:55:26 AM]    OUI-67100:NApply could not load patch from location '/u01/app/oracle-product/12.1.0/xe/Oracleupdate/28259833/27547329'
[Dec 13, 2018 2:55:26 AM]    OUI-67073:UtilSession failed: /u01/app/oracle-product/12.1.0/xe/Oracleupdate/28259833/27547329/etc/config/actions.xml with Version field of the component "delete" in actions file cannot be <null> or empty. Please check patch metadata.
[Dec 13, 2018 2:55:26 AM]    Finishing UtilSession at Thu Dec 13 02:55:26 UTC 2018
[Dec 13, 2018 2:55:26 AM]    Log file location: /u01/app/oracle/product/12.1.0/xe/cfgtoollogs/opatch/opatch2018-12-13_02-55-20AM_1.log
[Dec 13, 2018 2:55:26 AM]    Stack Description: java.lang.RuntimeException: /u01/app/oracle-product/12.1.0/xe/Oracleupdate/28259833/27547329/etc/config/actions.xml with Version field of the component "delete" in actions file cannot be <null> or empty. Please check patch metadata.

根据Oracle社区所说，是因为OPatch工具太低

同时，在该应用补丁目录下的readme.html中也提到：

所以需要重新更新OPatch到12.2.*版本，在网上找到一个补丁包，已分享到百度云，没有积分的朋友可以直接下载。

此时和上篇一样，只需将原OPatch文件改名为OPatch_bak2，并将该OPatch复制到xe目录下，都可参考上篇

但有一点需要注意，该12.2.*版本的补丁包中没有opatch文件，所以我从复制了一个patch文件过去

如果遇到这个问题：

root@62a5a35737c1:/# $ORACLE_HOME/OPatch/opatch version
bash: /u01/app/oracle/product/12.1.0/xe/OPatch/opatch: No such file or directory

然后再按照以前的顺序，给path添加$ORACLE_HOME/OPatch路径，给opatch文件改权限，查看OPatch版本

root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/OPatch# export PATH=$PATH:$ORACLE_HOME/OPatch
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/OPatch# $PATH
bash: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/u01/app/oracle/product/12.1.0/xe/bin:/u01/app/oracle/product/12.1.0/xe/OPatch
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/OPatch# opatch version
bash: /u01/app/oracle/product/12.1.0/xe/OPatch/opatch: Permission denied
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/OPatch# chmod +x opatch
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/OPatch# opatch version
OPatch Version: 12.2.0.1.14

OPatch succeeded.

再进入应用补丁进行冲突检查

[root@localhost ~]# docker exec -it 62a5a35737c1 /bin/bash
root@62a5a35737c1:/# cd $ORACLE_HOME
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe# cd Oracleupdate
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/Oracleupdate# cd 28259833    
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/Oracleupdate/28259833# opatch prereq CheckConflictAgainstOHWithDetail -ph ./
bash: opatch: command not found
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/Oracleupdate/28259833# export PATH=$ORACLE_HOME/OPatch:$PATH
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/Oracleupdate/28259833# opatch prereq CheckConflictAgainstOHWithDetail -ph ./
The user is root. OPatch cannot continue if the user is root.

OPatch failed with error code 255
root@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/Oracleupdate/28259833# su oracle
oracle@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/Oracleupdate/28259833$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
bash: opatch: command not found
oracle@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/Oracleupdate/28259833$ export PATH=$ORACLE_HOME/OPatch:$PATH
oracle@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/Oracleupdate/28259833$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/xe
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/xe/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/xe/cfgtoollogs/opatch/opatch2018-12-13_09-29-46AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

此时冲突检查完成，根据文档

但是执行报错如下：

oracle@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/Oracleupdate/28259833$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/xe
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/xe/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/xe/cfgtoollogs/opatch/opatch2018-12-13_09-32-09AM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuserMissing command :arMissing command :make
Prerequisite check "CheckSystemCommandAvailable" failed.
······················································
UtilSession failed: 
Prerequisite check "CheckSystemCommandAvailable" failed.
·····················································
Log file location: /u01/app/oracle/product/12.1.0/xe/cfgtoollogs/opatch/opatch2018-12-13_09-32-09AM_1.log

OPatch failed with error code 73

报错原因是：fuser命令、ar命令、make命令都无法使用，因为这是在Linux下Docker容器中，网上说可以使用yum安装，但是这时候yum也用不了啊！怎么想的！！

终于有了进展，突然尝试发现apt-get命令在该Oracle容器中可用！

安装fuser

apt-get install psmisc

安装ar

apt-get install gcc 

安装make命令

yum -y install gcc automake autoconf libtool make

因为没有指定编译对象，所以失败，但是已经完成安装make

安装完成，再执行opatch apply，完成应用补丁安装！

然后到OPatch目录下查看补丁安装

cd /u01/app/oracle/product/12.1.0/xe/OPatch
./opatch lsinventory

oracle@62a5a35737c1:/u01/app/oracle/product/12.1.0/xe/OPatch$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/xe
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/xe/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/xe/cfgtoollogs/opatch/opatch2018-12-14_09-48-37AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/xe/cfgtoollogs/opatch/lsinv/lsinventory2018-12-14_09-48-37AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: 62a5a35737c1
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1): 

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


Interim patches (1) :

Patch  28259833     : applied on Fri Dec 14 09:45:16 UTC 2018
Unique Patch ID:  22488632
Patch description:  "Database Patch Set Update : 12.1.0.2.181016 (28259833)"
   Created on 8 Oct 2018, 06:11:15 hrs PST8PDT
Sub-patch  27547329; "Database Patch Set Update : 12.1.0.2.180717 (27547329)"
Sub-patch  27338041; "Database Patch Set Update : 12.1.0.2.180417 (27338041)"
Sub-patch  26925311; "Database Patch Set Update : 12.1.0.2.180116 (26925311)"
Sub-patch  26713565; "Database Patch Set Update : 12.1.0.2.171017 (26713565)"
Sub-patch  26609783; "Database Patch Set Update : 12.1.0.2.170814 (26609783)"
Sub-patch  25755742; "Database Patch Set Update : 12.1.0.2.170718 (25755742)"
Sub-patch  25171037; "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
Sub-patch  24732082; "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Sub-patch  24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Sub-patch  23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch  22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch  21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
   Bugs fixed:
     22083366, 21913183, 19791273, 21542577, 23105538, 19243521, 21842740
     21281532, 19238590, 24577566, 25427662, 27314206, 19134173, 20717359
     20569094, 20031873, 20322560, 21575362, 17551063, 21063322, 22507210
     20736227, 19001390, 19358317, 22730454, 24739928, 26828994, 23521523
     18940497, 18866977, 18948177, 22826718, 19035573, 19176326, 20413820
     25417958, 22364044, 21106027, 20904530, 19074147, 23035249, 18411216
     21072646, 22507234, 18966843, 25861398, 24929210, 20562898, 20273319
     19468991, 22855193, 19402853, 27375542, 24796092, 20618595, 22238921
     21787056, 19068610, 22178855, 16777441, 22173980, 20048359, 20493163
     26153977, 19001359, 20603378, 23089357, 25353983, 21387964, 17532734
     22351572, 18849970, 20627866, 20844426, 24908321, 21188532, 18791688
     20890311, 21442094, 22760595, 26366517, 21296029, 20882568, 22536802
     22972770, 22077517, 20936905, 20235511, 21220620, 21153266, 19409212
     22228324, 22657942, 20657441, 26088426, 24693382, 20466322, 18740837
     19662635, 18440095, 21794615, 20382309, 19065556, 21868720, 22905130
     20938170, 25459958, 19524384, 24350831, 17722075, 22922076, 18952989
     19928926, 21629064, 21354456, 26039623, 23007241, 24386767, 19931709
     27060167, 26318627, 25643931, 19188927, 20074391, 21147908, 26430737
     14643995, 26024732, 18371441, 26575788, 20397490, 20172151, 22729345
     19174430, 22068305, 25654936, 19536415, 19171086, 21889720, 22168163
     19335438, 24397438, 18604692, 20076781, 23019710, 20447445, 18856999
     27351628, 19124336, 17890099, 18990023, 21300341, 20848335, 21744290
     21828126, 20897759, 20543011, 19052488, 22007324, 25606091, 19562381
     25539063, 20328248, 24365589, 22865673, 22816287, 21514877, 20798891
     18743542, 20347562, 18774543, 23315153, 27034890, 19687159, 25879984
     20424899, 21641760, 21899588, 22862134, 21476308, 24308635, 21297872
     20171986, 22815955, 25150925, 21273804, 23125826, 20424183, 18043064
     26898563, 23713236, 22062026, 20505778, 18308268, 20475845, 24350620
     17274537, 19440586, 24825843, 18974476, 22961508, 22374754, 17319928
     20708701, 24674955, 22809871, 16439813, 20859910, 19393542, 24326444
     22024071, 24737403, 21847223, 25079710, 25823754, 19075256, 19370504
     20315311, 20936731, 20437153, 25165496, 19280225, 20560611, 19248799
     21756699, 21532755, 20302006, 20373598, 20476175, 25264559, 24385983
     20711718, 25034396, 22842151, 27199245, 21142837, 23003979, 22528741
     22707244, 25546608, 26633558, 19315691, 27938623, 26262953, 17867700
     25919622, 23528412, 19532017, 19818513, 22353346, 16941434, 20361671
     25423453, 19718981, 20009833, 20294666, 23197103, 23514710, 22707866
     19195895, 18272672, 20043616, 18914624, 22256560, 25330273, 21291274
     19520602, 19174521, 21875360, 19326908, 23567857, 20093776, 21246723
     20803014, 24717859, 23026585, 19627012, 24415926, 22087683, 23548817
     25575628, 14283239, 21422580, 19213447, 18610915, 26243698, 18674024
     24831514, 21863727, 18306996, 19524158, 19915271, 20513399, 25091141
     20284155, 21080143, 22359063, 19383839, 21756677, 22458049, 25982666
     19475971, 22353199, 25634317, 21060755, 25780343, 22916353, 21756661
     25555252, 19028800, 21380789, 19077215, 21421886, 23533524, 22365117
     25392535, 19048007, 19689979, 17409174, 19503821, 24662775, 25429959
     24555417, 19902195, 25313154, 20318889, 20591183, 21260397, 19012119
     22645009, 21625179, 25670786, 25178179, 21632821, 19512341, 19841800
     22695831, 19211433, 25760195, 19587324, 24316947, 19578350, 19637186
     23115139, 27997875, 25123585, 18674047, 19054077, 20898997, 19708632
     19285025, 21091431, 27534509, 19289642, 26256131, 21133343, 20835241
     20869721, 22894949, 21419850, 21373473, 22721409, 24421668, 21164318
     25484507, 25489607, 27370965, 22520320, 22734547, 23088803, 19978542
     19329654, 20641666, 24600330, 25856821, 21517440, 23642282, 25897615
     21915719, 20879709, 20677396, 19076343, 19990037, 18909599, 25600421
     18250893, 22179537, 23240358, 24411921, 18254023, 25766822, 17414008
     20704450, 20441797, 25612095, 25957038, 24652769, 20725343, 19157754
     19207117, 23302839, 24437510, 18868646, 17533661, 20673810, 21450666
     18893947, 22223463, 16923858, 18417036, 23084507, 24563422, 20919320
     22503297, 20474192, 22046677, 21299490, 19385656, 22808310, 18542562
     20920911, 21315084, 18122373, 26111842, 19606174, 18436647, 25110233
     27169796, 19597583, 22232606, 18499088, 21099555, 21174504, 22175564
     19141838, 20842388, 20117253, 19865345, 20830459, 20671094, 20951038
     22165897, 21656630, 25789277, 17008068, 19908836, 26784509, 24401351
     21184223, 26029780, 20387265, 19149990, 21263635, 18886413, 24719736
     22160989, 21623164, 22519146, 23338911, 19366375, 19703301, 18007682
     24285405, 18202441, 25655390, 20267166, 19706965, 19068970, 18549238
     22148226, 18797519, 26544823, 20825533, 21196809, 19649152, 19670108
     22496904, 19404068, 18964978, 20717081, 24713381, 19176223, 20134339
     20868862, 25475853, 21322887, 20425790, 20862087, 24624166, 21329301
     19333670, 20124446, 19883092, 23543183, 20878790, 18510194, 19658708
     19591608, 23149541, 24848928, 24393981, 21795111, 25669791, 22380919
     19469538, 21266085, 17835294, 19721304, 23172924, 19791377, 25551676
     20746251, 21896069, 20898391, 19185876, 20907061, 20281121, 26658759
     22950945, 21281607, 6599380, 19577410, 22092979, 23572982, 25635149
     19490948, 22294260, 20832516, 19309466, 23008056, 19081128, 25775213
     20596234, 20368850, 18973548, 19303936, 19932634, 24321547, 21479753
     19461270, 18964939, 19430401, 22806698, 22296366, 20703000, 19879746
     20557786, 26198926, 23237313, 26758193, 21294938, 19684504, 20528052
     19024808, 20977794, 18799993, 24642295, 20228093, 20212067, 25547060
     20144308, 20446883, 25056052, 26089440, 27847259, 24523374, 27314390
     16870214, 26822620, 21773465, 19835133, 25437699, 20466628, 25490238
     24737064, 25492379, 25489342, 19730508, 18819908, 27052607, 20250147
     23124895, 23220453, 21641414, 24790914, 18307021, 23533807, 20856766
     20356733, 19891090, 18090142, 22901797, 19547370, 19065677, 21960504
     21225209, 23195445, 23315889, 18967382, 18419520, 21241829, 26546664
     21132297, 20470877, 25058080, 22465352, 28174827, 19869255, 20471920
     21620471, 23096938, 18990693, 24812585, 20101006, 21241052, 27229389
     28000269, 21668627, 19304354, 20794034, 23140259, 23025340, 23260854
     18681056, 24570598, 20952966, 19896336, 20828947, 22305887, 18618122
     20440930, 18456643, 19699191, 23065323, 19201867, 22022760, 25161298
     23294548, 25653109, 24560906, 22551446, 19777862, 21373076, 19174942
     24461826, 18899974, 16354467, 26245237, 20598042, 19032777, 19058490
     19399918, 24718260, 19434529, 18051556, 22492533, 19018447, 27337759
     22757364, 18851894, 21842017, 19022470, 19284031, 20173897, 16887946
     23725036, 20401975, 22062517, 17655240, 25307368, 19805359, 19155797
     26513709, 17210525, 19189525, 21649497, 22762046, 22075064, 18604493
     18845653, 18988834, 22256431, 20245930, 18921743, 22454326, 18799063
     19571367, 20925795, 19018206, 20509482, 20181030, 24509056, 20588502
     27441326, 21911701, 18849537, 23501901, 19183343, 27620950, 21917884
     20603431, 25639019, 22654475, 19189317, 19644859, 19390567, 26546754
     19279273, 27213224, 20669434, 16863642, 25914276, 19619732, 18607546
     20348653, 19676905, 20165574, 20558005, 20734332, 20922010, 19450314
     22366558, 26714910, 18191823, 20860659, 19307662, 19371175, 19154375
     21977392, 20324049, 22529728, 19708342, 20139391, 19593445, 19382851
     27726780, 19676012, 20217801, 27548131, 18840932, 21097043, 21665897
     20118035, 19143550, 20428621, 24801152, 26637824, 19518079, 26446098
     23492665, 24413809, 21522582, 21626377, 20122715, 18110491, 22366322
     25790353, 20017509, 25357142, 19363645, 19597439, 21239530, 23108128
     20880215, 19888853, 19534363, 19354335, 19044962, 19639483, 24683149
     22243719, 20378086, 24808595, 21260431, 22923409, 20877664, 22518784
     21059919, 20879889, 19723336, 19604659, 21285458, 23170620, 26569225
     18288842, 19308965, 23068169, 21526048, 19197175, 19180770, 24573817
     26444887, 27012701, 24835538, 23324000, 21492036, 19013183, 20464614
     19067244, 24737581, 23053606, 20331945, 26187943, 24589081, 25947799
     21172913, 25602488, 19258504, 17365043, 23709062, 21644640, 19468347
     25093739, 16359751, 25495682, 19769480, 19439759, 19272708, 20402832
     6418158, 19873610, 23229229, 23151677, 25029423, 13542050, 19291380
     25600342, 25633101, 25192729, 19561643, 22897344, 19487147, 20831538
     19016730, 26263721, 16619249, 18354830, 25764020, 16756406, 21188584
     22977256, 19989009, 20688221, 21780146, 25483815, 18885870, 21785691
     23061453, 24341675, 18705806, 23314180, 27207110, 20432873, 19501299
     20899461, 21429602, 21387128, 20581111, 22624709, 27086138, 24690216
     19023822, 19178851, 19124589, 19578247, 20480209, 19050649



--------------------------------------------------------------------------------

OPatch succeeded.

ye