oracle 11g 文件系统单机PSU补丁升级安装(二)

概述: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

完成

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值