概述:PSU补丁系列(二)
1、OPatch版本升级
[oracle@11g ~]$ cd $ORACLE_HOME
[oracle@11g 11.2.0]$ cd OPatch/
[oracle@11g OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@11g OPatch]$ cd ..
[oracle@11g 11.2.0]$ mv OPatch/ OPatchold
[oracle@11g 11.2.0]$ OPatch/opatch version
OPatch Version: 11.2.0.3.16
OPatch succeeded.
2、补丁升级前环境监测
[oracle@11g 27734982]$ /u01/ora/app/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/ora/app/product/11.2.0
Central Inventory : /u01/ora/oraInventory
from : /u01/ora/app/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/opatch2018-09-12_09-55-57AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
3、关闭数据库及监听
[oracle@11g 11.2.0]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 12 09:58:01 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g 11.2.0]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 12-SEP-2018 09:58:18
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=11g)(PORT=1521)))
The command completed successfully
4、psu补丁应用
[oracle@11g 27734982]$ /u01/ora/app/product/11.2.0/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /u01/ora/app/product/11.2.0
Central Inventory : /u01/ora/oraInventory
from : /u01/ora/app/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/opatch2018-09-12_09-58-23AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075 25869727 26609445 26392168 26925576 27338049 27734982
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/ora/app/product/11.2.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sdo, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.sdo.locator, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18031668' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.crs, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18522509' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '19121551' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.ordim.client, 11.2.0.4.0...
Patching component oracle.ordim.jai, 11.2.0.4.0...
Applying sub-patch '19769489' to OH '/u01/ora/app/product/11.2.0'
ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.ovm, 11.2.0.4.0...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms.util, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.oraolap, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20299013' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.rdbms.dv, 11.2.0.4.0...
Patching component oracle.rdbms.oci, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.sysman.common, 10.2.0.4.5...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sysman.common.core, 10.2.0.4.5...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20760982' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '21352635' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '21948347' to OH '/u01/ora/app/product/11.2.0'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.ovm, 11.2.0.4.0...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sysman.oms.core, 10.2.0.4.5...
Applying sub-patch '22502456' to OH '/u01/ora/app/product/11.2.0'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.olap, 11.2.0.4.0...
Patching component oracle.oraolap, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '23054359' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.rdbms.dv, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '24006111' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.sqlplus.ic, 11.2.0.4.0...
Patching component oracle.sqlplus, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '24732075' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...
Patching component oracle.sqlplus.ic, 11.2.0.4.0...
Patching component oracle.sqlplus, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.util, 11.2.0.4.0...
Patching component oracle.ordim.client, 11.2.0.4.0...
Patching component oracle.ordim.jai, 11.2.0.4.0...
Patching component oracle.ordim.server, 11.2.0.4.0...
Applying sub-patch '25869727' to OH '/u01/ora/app/product/11.2.0'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '26609445' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '26392168' to OH '/u01/ora/app/product/11.2.0'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 11.2.0.4.0...
Patching component oracle.ldap.client, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.network.listener, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '26925576' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '27338049' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.assistants.server, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '27734982' to OH '/u01/ora/app/product/11.2.0'
Patching component oracle.ctx, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.ctx.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of `/u01/ora/app/product/11.2.0/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)
Composite patch 27734982 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/opatch2018-09-12_09-58-23AM_1.log
OPatch completed with warnings.
5、补丁应用情况:
[oracle@11g OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /u01/ora/app/product/11.2.0
Central Inventory : /u01/ora/oraInventory
from : /u01/ora/app/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/opatch2018-09-12_10-17-48AM_1.log
Lsinventory Output file location : /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2018-09-12_10-17-48AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: 11g
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 27734982 : applied on Wed Sep 12 10:02:22 CST 2018
Unique Patch ID: 22229176
Patch description: "Database Patch Set Update : 11.2.0.4.180717 (27734982)"
Created on 31 May 2018, 01:37:49 hrs PST8PDT
Sub-patch 27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"
Sub-patch 26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"
Sub-patch 26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965
20671094, 16731148, 16314254, 13837378, 18441944, 17835048, 13558557
17008068, 17201159, 25427662, 17853498, 20717359, 17246576, 18356166
18681862, 18440047, 20569094, 20031873, 16875449, 20387265, 19788842
17296856, 21330264, 14010183, 17648596, 17551063, 17025461, 24719736
17267114, 22507210, 17912217, 17889583, 18202441, 17040764, 17478145
16524926, 25655390, 19358317, 22148226, 18747196, 26544823, 18641419
17036973, 18948177, 17811789, 16542886, 14285317, 18009564, 16618694
8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092
24624166, 24348685, 17848897, 17441661, 14034426, 17465741, 16596890
17437634, 21343897, 20506706, 21453153, 18339044, 17951233, 22321741
21795111, 18430495, 21787056, 22380919, 19469538, 20506715, 17811429
19721304, 17903598, 18230522, 19554106, 19458377, 21281607, 17612828
6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740
13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390
26474853, 18849970, 17889549, 19309466, 16472716, 20596234, 18331850
18641451, 17344412, 21179898, 19461270, 17546761, 24842886, 14521849
18203835, 18203838, 18964939, 18203837, 17313525, 22195457, 18139690
16837842, 22296366, 14106803, 17842825, 21352646, 22657942, 16360112
20657441, 22195441, 17389192, 26198926, 14565184, 17205719, 18440095
14764829, 22195448, 14354737, 13944971, 16571443, 21868720, 17186905
17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568
20144308, 19972566, 17282229, 19972564, 16870214, 21629064, 19615136
21354456, 17390431, 18762750, 23007241, 16613964, 17957017, 18098207
18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719
18317531, 17852463, 17596908, 17655634, 16228604, 27053456, 20074391
19972570, 18090142, 18996843, 19854503, 16042673, 17835627, 20334344
17393683, 20861693, 18000422, 17551709, 26575788, 23315889, 20506699
19006849, 18277454, 18456514, 19174430, 17258090, 17174582, 25654936
17242746, 16399083, 17824637, 21132297, 22465352, 17762296, 22168163
17397545, 16450169, 12364061, 20067212, 18856999, 19211724, 19463893
19463897, 21343775, 17853456, 18673304, 20004021, 26030218, 21668627
16194160, 17477958, 16538760, 12982566, 24570598, 20828947, 18259031
20296213, 18293054, 17610798, 19699191, 23065323, 17311728, 18135678
18774543, 23294548, 16785708, 10136473, 24560906, 22551446, 19777862
17786518, 18315328, 18334586, 12747740, 18096714, 19032867, 21641760
17390160, 18899974, 17232014, 20598042, 18673325, 16422541, 18155762
14015842, 19827973, 22683225, 17726838, 18554871, 23177648, 18051556
20803583, 21972320, 15990359, 17922254, 18282562, 16855292, 16668584
21343838, 20299015, 17446237, 18093615, 18043064, 23713236, 17694209
17288409, 18308268, 20475845, 17274537, 13955826, 16934803, 17634921
17501491, 16315398, 23725036, 22683212, 17006183, 13829543, 18191164
17655240, 26746894, 22809871, 18384391, 19393542, 21538567, 16198143
21847223, 25823754, 17892268, 20142975, 19584068, 17165204, 25165496
18604493, 21756699, 18508861, 16901385, 18554763, 21532755, 18189036
17443671, 17385178, 14829250, 17936109, 20925795, 20509482, 17478514
27441326, 16850630, 13951456, 16595641, 14054676, 15861775, 21142837
16912439, 17299889, 17297939, 23003979, 18619917, 16833527, 17798953
17816865, 18607546, 17571306, 21286665, 17341326, 26910644, 17851160
20558005, 17586955, 19049453, 21051840, 17587063, 16956380, 18328509
25423453, 14133975, 18061914, 18522509, 21051833, 20294666, 18765602
20860659, 20324049, 18199537, 17332800, 13609098, 22502493, 18384537
14338435, 17945983, 16392068, 21067387, 17752995, 21051862, 16863422
25505382, 17237521, 18244962, 19544839, 24433711, 24717859, 17156148
18973907, 23026585, 17877323, 17449815, 18180390, 17088068, 17037130
20004087, 21422580, 19466309, 11733603, 25505371, 21051858, 18084625
18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259
18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762
18614015, 17346091, 18228645, 17721717, 18436307, 21756677, 19888853
11883252, 17891943, 19475971, 22353199, 16384983, 19121551, 27825893
12816846, 17982555, 17761775, 22243719, 17265217, 25505394, 17071721
16721594, 18262334, 21756661, 17891946, 15913355, 17672719, 17602269
17239687, 17042658, 17238511, 17811456, 17284817, 17752121, 20879889
21380789, 17394950, 17011832, 16579084, 22195465, 14602788, 18325460
24476265, 26569225, 24476274, 12611721, 16903536, 17006570, 19689979
16043574, 18783224, 24662775, 16494615, 21526048, 17392698, 19197175
16069901, 17811447, 27870645, 17308789, 22195477, 24835538, 17865671
17343514, 19013183, 17325413, 18316692, 16180763, 17348614, 14368995
21983325, 17393915, 16285691, 19211433, 20331945, 17883081, 17705023
24316947, 17614227, 19578350, 22195485, 14084247, 13645875, 16777840
19727057, 14852021, 18744139, 18674047, 17716305, 19285025, 18482502
27534509, 17622427, 19289642, 22195492, 25947799, 14458214, 20869721
21172913, 17767676, 18723434, 25505407, 17786278, 19258504, 17082983
21351877, 17365043, 13498382, 18331812, 16065166, 25489607, 16685417
18031668, 22893153, 16943711, 19272701, 21517440, 25897615, 17649265
13866822, 18094246, 24528741, 17783588, 14245531, 17082359, 18280813
20448824, 23330119, 16268425, 19487147, 25600421, 18018515, 17302277
17215560, 24411921, 19271443, 25764020, 17016369, 20777150, 23330124
16756406, 20441797, 19769489, 28100487, 17545847, 25093656, 18260550
13853126, 17227277, 23536835, 25957038, 24652769, 19207117, 9756271
18868646, 17614134, 26667023, 17546973, 18704244, 19680952, 26667015
17050888, 18828868, 18273830, 17360606, 16992075, 24563422, 17375354
12905058, 18362222, 21429602, 27086138, 17571039, 17468141, 18436647
17235750, 21168487, 16220077, 16929165
--------------------------------------------------------------------------------
OPatch succeeded.
6、数据库补丁应用:
1* select * from DBA_REGISTRY_HISTORY
SQL> /
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
------------------------------ ---------- ---------- ---------- ---------- ------------------------------ ------------------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
12-SEP-18 09.44.40.810385 AM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
SQL> @/u01/ora/app/product/11.2.0/rdbms/admin/catbundle.sql psu apply
select * from DBA_REGISTRY_HISTORY;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
------------------------------ ---------- ---------- ---------- ---------- ------------------------------ ------------------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
12-SEP-18 09.44.40.810385 AM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
12-SEP-18 10.12.57.995695 AM APPLY SERVER 11.2.0.4 180717 PSU PSU 11.2.0.4.180717
SQL> @/u01/ora/app/product/11.2.0/rdbms/admin/utlrp.sql
完成