测试环境信息:
[root@rac1 ~]# cat /etc/issue
Red Hat Enterprise Linux Server release 6.5 (Santiago)
Kernel \r on an \m
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
[grid@rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.FRA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2
ora.cvu
1 ONLINE ONLINE rac2
ora.orcl.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.oc4j
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac2
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
升级前检查确认各组件状态及补丁信息:
SQL> col comp_name format a35
SQL> col version format a15
SQL> col status format a15
SQL> select comp_name,version,status from DBA_REGISTRY;
COMP_NAME VERSION STATUS
----------------------------------- --------------- ---------------
OWB 11.2.0.4.0 VALID
Oracle Application Express 3.2.1.00.12 VALID
Oracle Enterprise Manager 11.2.0.4.0 VALID
OLAP Catalog 11.2.0.4.0 VALID
Spatial 11.2.0.4.0 VALID
Oracle Multimedia 11.2.0.4.0 VALID
Oracle XML Database 11.2.0.4.0 VALID
Oracle Text 11.2.0.4.0 VALID
Oracle Expression Filter 11.2.0.4.0 VALID
Oracle Rules Manager 11.2.0.4.0 VALID
Oracle Workspace Manager 11.2.0.4.0 VALID
COMP_NAME VERSION STATUS
----------------------------------- --------------- ---------------
Oracle Database Catalog Views 11.2.0.4.0 VALID
Oracle Database Packages and Types 11.2.0.4.0 VALID
JServer JAVA Virtual Machine 11.2.0.4.0 VALID
Oracle XDK 11.2.0.4.0 VALID
Oracle Database Java Packages 11.2.0.4.0 VALID
OLAP Analytic Workspace 11.2.0.4.0 VALID
Oracle OLAP API 11.2.0.4.0 VALID
Oracle Real Application Clusters 11.2.0.4.0 VALID
19 rows selected.
[oracle@rac1 ~]$ cd $ORACLE_HOME
[oracle@rac1 db_home]$ cd OPatch/
[oracle@rac1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u02/app/oracle/product/11.2.0/db_home
Central Inventory : /u01/app/oraInventory
from : /u02/app/oracle/product/11.2.0/db_home/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u02/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatch/opatch2016-05-10_06-20-57AM_1.log
Lsinventory Output file location : /u02/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatch/lsinv/lsinventory2016-05-10_06-20-57AM.txt
--------------------------------------------------------------------------------
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 19769489 : applied on Tue May 10 05:31:40 CST 2016
Unique Patch ID: 18236413
Patch description: "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Created on 28 Dec 2014, 21:22:44 hrs PST8PDT
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, 18273830, 17811429, 17205719, 19972566, 17922254, 17754782
17726838, 16934803, 13364795, 17311728, 17441661, 17284817, 13645875
16992075, 18199537, 16542886, 17446237, 14565184, 19972569, 17071721
17610798, 17449815, 17375354, 17397545, 19463897, 18230522, 13866822
16360112, 17982555, 17235750, 19769489, 17478514, 12905058, 18235390
14338435, 13944971, 18641451, 20142975, 16929165, 12747740, 17546973
14054676, 17088068, 18264060, 17042658, 17343514, 17016369, 14602788
19972568, 19680952, 18471685, 18508861, 14657740, 17332800, 19211724
13951456, 16315398, 19972564, 18744139, 17186905, 16850630, 18315328
17437634, 19049453, 18673304, 17883081, 19006849, 18641419, 17296856
18674024, 18262334, 17006183, 18277454, 16833527, 17232014, 16855292
10136473, 17705023, 17865671, 18554871, 19121551, 18334586, 19854503
19309466, 17551709, 17588480, 19827973, 17842825, 17344412, 18828868
18681862, 18554763, 17390160, 17025461, 13955826, 11883252, 13609098
18139690, 17501491, 17239687, 17299889, 17752121, 17602269, 19197175
18673325, 17313525, 18293054, 17242746, 19544839, 18964939, 17600719
18191164, 17571306, 18482502, 19466309, 17951233, 18094246, 19615136
17165204, 17011832, 17040527, 18098207, 16785708, 17477958, 17174582
16180763, 17465741, 16777840, 18522509, 17323222, 19463893, 16595641
12816846, 16875449, 16524926, 17237521, 18228645, 18282562, 17596908
17811438, 17811447, 18031668, 17184721, 16494615, 16912439, 18061914
17282229, 17545847, 18202441, 17082359, 19554106, 17614134, 13558557
17341326, 14034426, 17891946, 18339044, 19458377, 17716305, 17752995
16392068, 19271443, 17891943, 18092127, 17258090, 17767676, 17614227
17040764, 14106803, 17381384, 15913355, 18973907, 18356166, 18673342
14084247, 17389192, 17612828, 17006570, 13853126, 17721717, 17570240
18203837, 17390431, 14245531, 16043574, 16863422, 19727057, 17468141
17786518, 17912217, 16422541, 19972570, 17037130, 17267114, 18244962
18203838, 16198143, 16956380, 17478145, 14829250, 17394950, 18189036
18641461, 17835627, 17027426, 16268425, 18247991, 14458214, 19584068
18436307, 17265217, 13498382, 16692232, 17786278, 17227277, 16042673
16314254, 17443671, 16228604, 16837842, 17571039, 17393683, 16344544
17787259, 18009564, 20074391, 14354737, 15861775, 18135678, 18614015
16399083, 18018515, 17835048, 16472716, 17936109, 17050888, 17325413
14010183, 18747196, 17036973, 16613964, 17080436, 17761775, 16721594
18280813, 17302277, 16901385, 15979965, 15990359, 18203835, 17297939
17811456, 16731148, 17215560, 14133975, 17385178, 17586955, 18441944
16450169, 17655634, 9756271, 19730508, 17892268, 17648596, 16220077
16069901, 11733603, 16285691, 17587063, 16538760, 18180390, 17393915
17274537, 18096714, 17308789, 17238511, 18436647, 17824637, 14285317
19289642, 14764829, 18328509, 17622427, 16943711, 18306996, 17346671
18996843, 14852021, 17783588, 16618694, 18674047, 17672719, 12364061
17851160, 17546761
Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2
--------------------------------------------------------------------------------
OPatch succeeded.
普通人用不到啊。。。太占内存。。。自拍来一个raw没什么卵用