#Oracle 11.2.0.4單實例打PSU補丁的過程
#1.OPatch替換為最新版本
[oracle@XAG140 OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@XAG140 OPatch]$ id
uid=1001(oracle) gid=1001(oinstall) groups=1001(oinstall),1002(dba),1003(oper)
[oracle@DB OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@XAG140 OPatch]$ cd ..
[oracle@XAG140 db_1]$ mv OPatch/ OPatch_bak
[oracle@XAG140 db_1]$ unzip /home/oracle/setup/p6880880_112000_Linux-x86-64.zip
[oracle@XAG140 db_1]$ ls
apex? ? ? ? config? dc_ocm? ? ? has? ? ? ? ? ? javavm? log? ? ? odbc? ? ? ? ord? ? ? racg? ? ? ? ? sqlj? ? ? ? ? ? uix
assistants? crs? ? deinstall? ? hs? ? ? ? ? ? jdbc? ? md? ? ? olap? ? ? ? oui? ? ? rdbms? ? ? ? sqlplus? ? ? ? ? usm
bin? ? ? ? ? csmig? demo? ? ? ? ide? ? ? ? ? ? jdev? ? mesg? ? OPatch? ? ? owb? ? ? relnotes? ? ? srvm? ? ? ? ? ? utl
ccr? ? ? ? ? css? ? diagnostics? install? ? ? ? jdk? ? mgw? ? ? OPatch_bak? owm? ? ? root.sh? ? ? suptools? ? ? ? wwg
cdata? ? ? ? ctx? ? dv? ? ? ? ? instantclient? jlib? ? network? opmn? ? ? ? perl? ? scheduler? ? sysman? ? ? ? ? xdk
cfgtoollogs? cv? ? ? emcli? ? ? ? inventory? ? ? ldap? ? nls? ? ? oracore? ? ? plsql? ? slax? ? ? ? ? timingframework
clone? ? ? ? dbs? ? EMStage? ? ? j2ee? ? ? ? ? lib? ? oc4j? ? oraInst.loc? precomp? sqldeveloper? ucp
[oracle@XAG140 db_1]$ cd OPatch
[oracle@XAG140 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.19
OPatch succeeded.
----------------------------------------------------------------------------------------------------------------------------------------------
2.數(shù)據(jù)庫軟件應用p27734982_112040_Linux-x86-64補丁程序 24732075 (11.2.0.4.170418)
[oracle@XAG140 patch]$ pwd
/u01/app/patch
[oracle@XAG140 patch]$ unzip p27734982_112040_Linux-x86-64.zip
[oracle@XAG140 patch]$ ls
27734982? p27734982_112040_Linux-x86-64.zip? PatchSearch.xml
[oracle@XAG140 patch]$
[oracle@XAG140 patch]$ ls -lh
total 135M
drwxr-xr-x 21 oracle oinstall 4.0K May 31 17:49 27734982
-rw-r--r--? 1 oracle oinstall 135M Aug 23 15:10 p27734982_112040_Linux-x86-64.zip
-rw-rw-r--? 1 oracle oinstall? 91K Jul 17 18:15 PatchSearch.xml
[oracle@XAG140 patch]$ cd 27734982/
[oracle@XAG140 27734982]$ ls
17478514? 18522509? 19769489? 20760982? 21948347? 23054359? 24732075? 26392168? 26925576? 27734982? ? README.html
18031668? 19121551? 20299013? 21352635? 22502456? 24006111? 25869727? 26609445? 27338049? patchmd.xml? README.txt
[oracle@XAG140 27734982]$ pwd
/u01/app/patch/27734982
[oracle@XAG140 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation.? All rights reserved.
PREREQ session
Oracle Home? ? ? : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
? from? ? ? ? ? : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version? ? : 11.2.0.3.19
OUI version? ? ? : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-23_15-38-45PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@XAG140 27734982]$
[oracle@XAG140 27734982]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 23 15:41:21 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> !lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-AUG-2018 15:41:36
Copyright (c) 1991, 2013, Oracle.? All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XAG140)(PORT=1521)))
The command completed successfully
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@XAG140 27734982]$ ls
17478514? 18522509? 19769489? 20760982? 21948347? 23054359? 24732075? 26392168? 26925576? 27734982? ? README.html
18031668? 19121551? 20299013? 21352635? 22502456? 24006111? 25869727? 26609445? 27338049? patchmd.xml? README.txt
[oracle@XAG140 27734982]$
[oracle@XAG140 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation.? All rights reserved.
Oracle Home? ? ? : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
? from? ? ? ? ? : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version? ? : 11.2.0.3.19
OUI version? ? ? : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-23_15-51-07PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
UtilSession failed:
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Prerequisite check "CheckSystemCommandAvailable" failed.
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-23_15-51-07PM_1.log
OPatch failed with error code 73
[oracle@XAG140 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/u01/app/oracle/product/11.2.0/db_1".
OPatch succeeded.
[root@XAG140 ~]# yum search fuser
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.centos.org
* extras: mirror.centos.org
* updates: mirror.centos.org
============================================================== Matched: fuser ===============================================================
psmisc.x86_64 : Utilities for managing processes on your system
[root@XAG140 ~]# yum install -y psmisc
Loaded plugins: fastestmirror
base? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? | 3.6 kB? 00:00:00? ?
extras? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? | 3.4 kB? 00:00:00? ?
updates? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? | 3.4 kB? 00:00:00? ?
Loading mirror speeds from cached hostfile
* base: mirror.centos.org
* extras: mirror.centos.org
* updates: mirror.centos.org
Resolving Dependencies
--> Running transaction check
---> Package psmisc.x86_64 0:22.20-15.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================
Package? ? ? ? ? ? ? ? ? ? ? ? Arch? ? ? ? ? ? ? ? ? ? ? ? ? ? Version? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Repository? ? ? ? ? ? ? ? ? ? Size
=============================================================================================================================================
Installing:
psmisc? ? ? ? ? ? ? ? ? ? ? ? ? x86_64? ? ? ? ? ? ? ? ? ? ? ? ? 22.20-15.el7? ? ? ? ? ? ? ? ? ? ? ? ? ? base? ? ? ? ? ? ? ? ? ? ? ? ? 141 k
Transaction Summary
=============================================================================================================================================
Install? 1 Package
Total download size: 141 k
Installed size: 475 k
Downloading packages:
psmisc-22.20-15.el7.x86_64.rpm? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? | 141 kB? 00:00:00? ?
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
? Installing : psmisc-22.20-15.el7.x86_64? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 1/1
? Verifying? : psmisc-22.20-15.el7.x86_64? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 1/1
Installed:
? psmisc.x86_64 0:22.20-15.el7? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
Complete!
[root@XAG140 ~]#
[oracle@XAG140 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply
#3.數(shù)據(jù)庫打補丁
[oracle@DB 19121551]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/
[oracle@XAG140 admin]$ sqlplus / as sysdba
SQL> @catbundle.sql psu apply
#4.驗證PSU補丁是否應用成功
[oracle@XAG140 OPatch]$ pwd
/u01/app/oracle/product/11.2.0/db_1/OPatch
[oracle@XAG140 OPatch]$
[oracle@XAG140 OPatch]$ ./opatch lspatches
27734982;Database Patch Set Update : 11.2.0.4.180717 (27734982)
OPatch succeeded.
[oracle@XAG140 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation.? All rights reserved.
Oracle Home? ? ? : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
? from? ? ? ? ? : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version? ? : 11.2.0.3.19
OUI version? ? ? : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-23_17-55-36PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-08-23_17-55-36PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: XAG140
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 Thu Aug 23 16:15:47 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.
SQL> select * from dba_registry_history;
? ACTION_TIME ? ? ? ? ? ? ? ? ? ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
1 24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
2 23-AUG-18 03.24.44.382287 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
3 23-AUG-18 04.48.52.034209 PM APPLY SERVER 11.2.0.4 180717 PSU PSU 11.2.0.4.180717
================================================================================================
#安裝OJVM補丁集預檢查
SQL> shutdown immediate
SQL> exit
[oracle@XAG140 patch]$ pwd
/u01/app/patch
[oracle@XAG140 patch]$ unzip p27923163_112040_Linux-x86-64.zip
[oracle@XAG140 patch]$ cd 27923163/
[oracle@XAG140 27923163]$? /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation.? All rights reserved.
PREREQ session
Oracle Home? ? ? : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
? from? ? ? ? ? : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version? ? : 11.2.0.3.19
OUI version? ? ? : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-09-14_10-38-43AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
#安裝OJVM補丁集
[oracle@XAG140 27923163]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation.? All rights reserved.
Oracle Home? ? ? : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
? from? ? ? ? ? : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version? ? : 11.2.0.3.19
OUI version? ? ? : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-09-14_11-14-10AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:? 27923163?
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/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '27923163' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ]? not present in the Oracle Home or a higher version is found.
Patching component oracle.javavm.server, 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.dbjava.jdbc, 11.2.0.4.0...
Patching component oracle.dbjava.ic, 11.2.0.4.0...
Patching component oracle.javavm.client, 11.2.0.4.0...
Patch 27923163 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-09-14_11-14-10AM_1.log
OPatch succeeded.
[oracle@XAG140 27923163]$
#安裝OJVM補丁集的后續(xù)工作
[oracle@XAG140 27923163]$ cd $ORACLE_HOME/sqlpatch/27923163
[oracle@XAG140 27923163]$ pwd
/u01/app/oracle/product/11.2.0/db_1/sqlpatch/27923163
[oracle@XAG140 27923163]$ sqlplus / as sysdba
SQL> startup upgrade
SQL> @postinstall.sql
SQL> shutdown immediate
SQL> startup
SQL> @/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlrp.sql
SQL> exit
[oracle@XAG140 27923163]$ lsnrctl start
[oracle@XAG140 27923163]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation.? All rights reserved.
Oracle Home? ? ? : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
? from? ? ? ? ? : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version? ? : 11.2.0.3.19
OUI version? ? ? : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-09-14_11-25-57AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-09-14_11-25-57AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: XAG140
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 (2) :
Patch? 27923163? ? : applied on Fri Sep 14 11:15:56 CST 2018
Unique Patch ID:? 22212880
Patch description:? "OJVM PATCH SET UPDATE 11.2.0.4.180717"
? Created on 24 May 2018, 08:57:43 hrs PST8PDT
? Bugs fixed:
? ? 26637592, 26023002, 19007266, 21566944, 27642235, 21811517, 19058059
? ? 19852360, 20408829, 18933818, 25076732, 22675136, 27461842, 25649873
? ? 22670385, 19231857, 21047766, 17804361, 18458318, 17285560, 17056813
? ? 18166577, 23265914, 23727132, 19374518, 24448240, 25494379, 19554117
? ? 19153980, 19909862, 17201047, 17528315, 24534298, 25067795, 19187988
? ? 19699946, 22118835, 19006757, 21911849, 27952577, 27000663, 19895326
? ? 19176885, 22253904, 14774730, 19223010
Patch? 27734982? ? : applied on Thu Aug 23 16:15:47 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.
[oracle@XAG140 27923163]$
SQL> select * from dba_registry_history;
ACTION_TIME ? ? ? ? ? ? ? ? ? ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
1 22-AUG-18 04.37.01.355121 PM VIEW RECOMPILE 8289601 view recompilation
2 22-AUG-18 04.37.01.464407 PM UPGRADE SERVER 10.2.0.5.0 Upgraded from 10.2.0.1.0
3 24-AUG-18 06.20.16.789759 PM VIEW INVALIDATE 8289601 view invalidation
4 24-AUG-18 06.20.48.426719 PM UPGRADE SERVER 11.2.0.4.0 Upgraded from 10.2.0.5.0
5 24-AUG-18 06.28.34.974329 PM APPLY SERVER 11.2.0.4 180717 PSU PSU 11.2.0.4.180717
6 14-SEP-18 11.21.30.172469 AM jvmpsu.sql SERVER 11.2.0.4.180717OJVMPSU 0 RAN jvmpsu.sql
7 14-SEP-18 11.21.30.632304 AM APPLY SERVER 11.2.0.4.180717OJVMPSU 0 OJVM PSU post-install
8 14-SEP-18 11.21.30.636062 AM APPLY 27923163 Patch 27923163 applied
