11g单实例数据库打最新11.2.0.4.160119 PSU补丁记录

11g单实例数据库打最新11.2.0.4.160119 PSU补丁记录
[oracle@rh64 ~]$ opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.




Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_15-33-46PM_1.log


Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-02-01_15-33-46PM.txt


--------------------------------------------------------------------------------
Installed Top-level Products (2): 


Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g Examples                                         11.2.0.1.0
There are 2 product(s) installed in this Oracle Home.




Interim patches (1) :


Patch  21352635     : applied on Fri Oct 30 10:14:55 CST 2015
Unique Patch ID:  19227862
Patch description:  "Database Patch Set Update : 11.2.0.4.8 (21352635)"
   Created on 1 Sep 2015, 07:49:44 hrs 
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:
     17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699
     17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817
     16992075, 17446237, 14015842, 19972569, 21538558, 20925795, 17449815
     17375354, 19463897, 17982555, 17235750, 13866822, 18317531, 17478514
     18235390, 14338435, 20803583, 13944971, 20142975, 17811789, 16929165
     18704244, 20506706, 17546973, 20334344, 14054676, 17088068, 18264060
     17346091, 17343514, 21538567, 19680952, 18471685, 19211724, 13951456
     16315398, 18744139, 16850630, 19049453, 18673304, 17883081, 19915271
     18641419, 18262334, 17006183, 16065166, 18277454, 16833527, 10136473
     18051556, 17865671, 17852463, 18554871, 17853498, 18334586, 17588480
     17551709, 19827973, 17842825, 17344412, 18828868, 17025461, 11883252
     13609098, 17239687, 17602269, 19197175, 18316692, 17313525, 12611721
     19544839, 18964939, 17600719, 18191164, 19393542, 17571306, 18482502
     20777150, 19466309, 17040527, 17165204, 18098207, 16785708, 17174582
     16180763, 17465741, 16777840, 12982566, 19463893, 12816846, 16875449
     17237521, 19358317, 17811438, 17811447, 17945983, 18762750, 17184721
     16912439, 18061914, 17282229, 18331850, 18202441, 17082359, 18723434
     19554106, 14034426, 18339044, 19458377, 17752995, 20448824, 17891943
     17258090, 17767676, 16668584, 18384391, 17040764, 17381384, 15913355
     18356166, 14084247, 20506715, 13853126, 18203837, 14245531, 16043574
     17848897, 17877323, 17468141, 17786518, 17912217, 17037130, 18155762
     16956380, 17478145, 17394950, 18189036, 18641461, 18619917, 17027426
     21352646, 16268425, 19584068, 18436307, 17265217, 17634921, 13498382
     20004087, 17443671, 18000422, 20004021, 17571039, 21067387, 16344544
     18009564, 14354737, 18135678, 18614015, 20441797, 18362222, 17835048
     16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775
     16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359
     18203835, 17297939, 17811456, 16731148, 17215560, 13829543, 14133975
     17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634
     18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
     17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317
     19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671
     18996843, 17783588, 16618694, 17672719, 18856999, 18783224, 17851160
     17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606
     13645875, 18199537, 16542886, 17889549, 14565184, 17071721, 20299015
     17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058
     18641451, 12747740, 18430495, 17042658, 17016369, 14602788, 19972568
     18508861, 19788842, 14657740, 17332800, 13837378, 19972564, 17186905
     18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024
     17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551
     19854503, 19309466, 18681862, 18554763, 20558005, 17390160, 18456514
     16306373, 13955826, 18139690, 17501491, 17299889, 17752121, 17889583
     18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 19615136
     17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222
     16595641, 16524926, 18228645, 18282562, 17596908, 17156148, 18031668
     16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305
     16392068, 19271443, 18092127, 18440047, 17614227, 14106803, 16903536
     18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717
     17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 19972570
     17267114, 18244962, 21538485, 18765602, 18203838, 16198143, 17246576
     14829250, 17835627, 18247991, 14458214, 21051862, 16692232, 17786278
     17227277, 16042673, 16314254, 16228604, 16837842, 17393683, 17787259
     20331945, 20074391, 15861775, 16399083, 18018515, 18260550, 21051858
     17036973, 16613964, 17080436, 16579084, 18384537, 18280813, 20296213
     16901385, 15979965, 18441944, 16450169, 9756271, 17892268, 11733603
     16285691, 17587063, 16538760, 18180390, 18193833, 21051833, 17238511
     17824637, 16571443, 18306996, 14852021, 18674047, 17853456, 12364061






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


OPatch succeeded.
[oracle@rh64 ~]$ 
[oracle@rh64 ~]$ 


解压补丁
[oracle@rh64 soft]$ unzip 11.2.0.4.160119DB_p21948347_112040_Linux-x86-64.zip 


检查依赖性
[oracle@rh64 soft]$ cd 21948347/
[oracle@rh64 21948347]$ ls -ltr
total 96
drwxrwxr-x 4 oracle oinstall  4096 Dec 14 19:32 19769489
drwxrwxr-x 4 oracle oinstall  4096 Dec 14 19:32 21948347
drwxrwxr-x 4 oracle oinstall  4096 Dec 14 19:32 21352635
drwxr-xr-x 4 oracle oinstall  4096 Dec 14 19:32 18031668
drwxr-xr-x 4 oracle oinstall  4096 Dec 14 19:32 19121551
drwxrwxr-x 4 oracle oinstall  4096 Dec 14 19:32 20760982
drwxrwxr-x 4 oracle oinstall  4096 Dec 14 19:32 20299013
drwxr-xr-x 4 oracle oinstall  4096 Dec 14 19:32 18522509
drwxr-xr-x 4 oracle oinstall  4096 Dec 14 19:32 17478514
-rw-r--r-- 1 oracle oinstall    21 Dec 14 19:33 README.txt
-rw-r--r-- 1 oracle oinstall  3073 Dec 14 19:33 patchmd.xml
-rw-rw-r-- 1 oracle oinstall 51588 Jan 16 08:36 README.html
[oracle@rh64 21948347]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


PREREQ session


Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_15-37-53PM_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.


OPatch succeeded.


应用补丁
[oracle@rh64 21948347]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.




Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_15-38-12PM_1.log


Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   21948347  


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/app/oracle/product/11.2.0/dbhome_1')




Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
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...


Verifying the update...
Composite patch 21948347 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_15-38-12PM_1.log


OPatch succeeded.


检查升级完补丁版本
[oracle@rh64 21948347]$ opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.




Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_15-41-23PM_1.log


Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-02-01_15-41-23PM.txt


--------------------------------------------------------------------------------
Installed Top-level Products (2): 


Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g Examples                                         11.2.0.1.0
There are 2 product(s) installed in this Oracle Home.




Interim patches (1) :


Patch  21948347     : applied on Mon Feb 01 15:40:00 CST 2016
Unique Patch ID:  19564435
Patch description:  "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
   Created on 14 Dec 2015, 03:31:48 hrs PST8PDT
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:
     17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699
     17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817
     16992075, 17446237, 14015842, 19972569, 17449815, 21538558, 20925795
     17375354, 19463897, 17982555, 17235750, 13866822, 17478514, 18317531
     18235390, 14338435, 20803583, 13944971, 20142975, 17811789, 16929165
     18704244, 20506706, 17546973, 20334344, 14054676, 17088068, 18264060
     17346091, 17343514, 21538567, 19680952, 18471685, 19211724, 13951456
     21847223, 16315398, 18744139, 16850630, 19049453, 18673304, 17883081
     19915271, 18641419, 18262334, 17006183, 16065166, 18277454, 16833527
     10136473, 18051556, 17865671, 17852463, 18554871, 17853498, 18334586
     17588480, 17551709, 19827973, 17842825, 17344412, 18828868, 17025461
     11883252, 13609098, 17239687, 17602269, 19197175, 22195457, 18316692
     17313525, 12611721, 19544839, 18964939, 17600719, 18191164, 19393542
     17571306, 18482502, 20777150, 19466309, 17040527, 17165204, 18098207
     16785708, 17174582, 16180763, 17465741, 16777840, 12982566, 19463893
     22195465, 12816846, 16875449, 17237521, 19358317, 17811438, 17811447
     17945983, 18762750, 17184721, 16912439, 18061914, 17282229, 18331850
     18202441, 17082359, 18723434, 21972320, 19554106, 14034426, 18339044
     19458377, 17752995, 20448824, 17891943, 17258090, 17767676, 16668584
     18384391, 17040764, 17381384, 15913355, 18356166, 14084247, 20506715
     13853126, 18203837, 14245531, 21756699, 16043574, 22195441, 17848897
     17877323, 21453153, 17468141, 20861693, 17786518, 17912217, 17037130
     18155762, 16956380, 17478145, 17394950, 18189036, 18641461, 18619917
     17027426, 21352646, 16268425, 22195492, 19584068, 18436307, 17265217
     17634921, 13498382, 21526048, 20004087, 22195485, 17443671, 18000422
     22321756, 20004021, 17571039, 21067387, 16344544, 18009564, 14354737
     18135678, 18614015, 20441797, 18362222, 17835048, 16472716, 17936109
     17050888, 17325413, 14010183, 18747196, 17761775, 16721594, 17082983
     20067212, 21179898, 17302277, 18084625, 15990359, 18203835, 17297939
     17811456, 16731148, 21168487, 17215560, 13829543, 14133975, 17694209
     18091059, 17385178, 8322815, 17586955, 17201159, 17655634, 18331812
     19730508, 18868646, 17648596, 16220077, 16069901, 17348614, 17393915
     17274537, 17957017, 18096714, 17308789, 18436647, 14285317, 19289642
     14764829, 18328509, 17622427, 22195477, 16943711, 14368995, 17346671
     18996843, 17783588, 21343838, 16618694, 17672719, 18856999, 18783224
     17851160, 17546761, 17798953, 18273830, 22092979, 19972566, 16384983
     17726838, 17360606, 22321741, 13645875, 18199537, 16542886, 21787056
     17889549, 14565184, 17071721, 17610798, 20299015, 21343897, 20657441
     17397545, 18230522, 16360112, 19769489, 12905058, 18641451, 12747740
     18430495, 17042658, 17016369, 14602788, 17551063, 19972568, 21517440
     18508861, 19788842, 14657740, 17332800, 13837378, 19972564, 17186905
     18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024
     17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551
     21330264, 19854503, 19309466, 18681862, 18554763, 20558005, 17390160
     18456514, 16306373, 13955826, 18139690, 17501491, 21668627, 17299889
     17752121, 17889583, 18673325, 18293054, 17242746, 17951233, 17649265
     18094246, 19615136, 17011832, 16870214, 17477958, 18522509, 20631274
     16091637, 17323222, 16595641, 16524926, 18228645, 18282562, 17596908
     17156148, 18031668, 16494615, 17545847, 17655240, 17614134, 13558557
     17341326, 17891946, 17716305, 16392068, 19271443, 21351877, 18092127
     18440047, 17614227, 14106803, 16903536, 18973907, 18673342, 19032867
     17389192, 17612828, 16194160, 17006570, 17721717, 17570240, 17390431
     16863422, 18325460, 19727057, 16422541, 19972570, 17267114, 18244962
     21538485, 18765602, 18203838, 16198143, 17246576, 14829250, 17835627
     18247991, 14458214, 21051862, 16692232, 17786278, 17227277, 16042673
     16314254, 16228604, 16837842, 17393683, 17787259, 20331945, 20074391
     15861775, 16399083, 18018515, 21051858, 18260550, 17036973, 16613964
     17080436, 16579084, 18384537, 18280813, 20296213, 16901385, 15979965
     18441944, 16450169, 9756271, 17892268, 11733603, 16285691, 17587063
     21343775, 16538760, 18180390, 18193833, 21051833, 17238511, 17824637
     16571443, 18306996, 14852021, 18674047, 17853456, 12364061, 22195448






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


OPatch succeeded.




升级数据字典
[oracle@rh64 21948347]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 1 15:41:37 2016


Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to an idle instance.


SQL> quit
Disconnected
[oracle@rh64 21948347]$ cd $ORACLE_HOME/rdbms/admin
[oracle@rh64 admin]$ sqlplus /nolog


SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 1 15:41:59 2016


Copyright (c) 1982, 2013, Oracle.  All rights reserved.


SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> STARTUP
ORACLE instance started.


Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             356517912 bytes
Database Buffers          159383552 bytes
Redo Buffers                3780608 bytes
Database mounted.
Database opened.
SQL> @catbundle.sql psu apply


select * from SYS.DBA_REGISTRY_HISTORY
24-8月 -13 12.03.45.119862000 下午 APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
04-8月 -15 11.49.37.378075000 上午 APPLY SERVER 11.2.0.4 7 PSU PSU 11.2.0.4.7
01-2月 -16 03.43.03.459221000 下午 APPLY SERVER 11.2.0.4 160119 PSU PSU 11.2.0.4.160119