以下仅作参考，112.*其他具体看readme
环境
rhel6.4 oracle11204
gipsu 20996293
1、检查
ps -ef | grep smon
[root@rac1 oracle]# ps -ef | grep smon
root 2926 1 2 12:25 ? 00:01:03 /oracle/app/11.2.0/grid/bin/osysmond.bin
grid 3416 1 0 12:26 ? 00:00:00 asm_smon_+ASM1
oracle 3946 1 0 12:27 ? 00:00:00 ora_smon_orcl1
root 9838 5351 0 13:13 pts/0 00:00:00 grep smon
2、停库
[oracle@rac1 ~]$ srvctl stop database -d orcl
[oracle@rac1 ~]$ ps -ef | grep smon
root 2926 1 2 12:25 ? 00:01:04 /oracle/app/11.2.0/grid/bin/osysmond.bin
grid 3416 1 0 12:26 ? 00:00:00 asm_smon_+ASM1
oracle 10139 9990 0 13:15 pts/1 00:00:00 grep smon
[oracle@rac1 ~]$
停集群
[root@rac1 oracle]# cd /oracle/app/11.2.0/grid/bin
[root@rac1 bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.LOG.dg' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.LOG.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
CRS-2676: Start of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2'
CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 bin]#
3、备份、打包软件
[root@rac1 /oracle]#tar -cf app.tar app
4、起集群、起库
root 用户
[root@rac1 bin]# ./crsctl stop crs
oracle用户
[oracle@rac1 ~]$ srvctl start database -d orcl
5、打psu
grid用户解压psu
[grid@rac1 oracle]$ unzip -d psu/ p20996923_112040_Linux-x86-64.zip
升级opatch
For GI PSU 11.2.0.4.2 and above, you must use OPatch utility version 11.2.0.3.6 or later
可以这样
alias opatch=$ORACLE_HOME/OPatch/opatch
[oracle@rac1 ~]$ opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@rac1 OPatch]$
1、2节点oracle、grid用户都做
备份原来的opatch
[oracle@rac1 db_1]$ mv OPatch/ OPatch.bak
解压到$ORACLE_HOME
[oracle@rac1 db_1]$ unzip p6880880_112000_Linux-x86-64.zip
[oracle@rac1 db_1]$ cd OPatch
[oracle@rac1 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
[oracle@rac1 OPatch]$
----------------------开始---------------------------------------------------------------------------------
DB Version PSU Version
11.2.0.4.0 11.2.0.4.2GIPSU 18139609 18031740 18031731 18031668
11.2.0.4.3GIPSU 18706472 18522515 18522514 18522509
11.2.0.4.4GIPSU 19380115 19121549 19121552 19121551
11.2.0.4.5GIPSU 19955028 19769476 19769469 19769489
11.2.0.4.6GIPSU 20485808 20420937 20299019 20299013
11.2.0.4.7GIPSU 20996923 20831122 20299019 20760982
/oracle/app/oracle/product/11.2.0/db_1
/oracle/app/11.2.0/grid
/oracle/psu/
20996923
20760982
20831122
20299019
/home/oracle/status
rac1
rac2
以下操作1、2节点都做
1.oracle用户
$ORACLE_HOME/bin/srvctl stop home -o $ORACLE_HOME -s ~/status -n rac1
2.root用户
/oracle/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
3.grid用户
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /oracle/psu/20996923/20831122
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /oracle/psu/20996923/20299019
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /oracle/psu/20996923/20760982
4.oracle用户
/oracle/psu/20996923/20831122/custom/server/20831122/custom/scripts/prepatch.sh
5.oracle用户
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /oracle/psu/20996923/20831122/custom/server/20831122
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /oracle/psu/20996923/20760982
6.oracle用户
/oracle/psu/20996923/20831122/custom/server/20831122/custom/scripts/postpatch.sh
7.root用户
/oracle/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
/oracle/app/11.2.0/grid/crs/install/rootcrs.pl -patch
8.oracle用户
$ORACLE_HOME/bin/srvctl start home -o $ORACLE_HOME -s ~/status -n rac1
SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SER COMMENTS
------------------------------
-------------------- ------------------------------ ---------- ----------
---------- --------------------
24-AUG-13
12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
29-SEP-15
12.14.30.734626 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
SQL>
9、SQL>@?/rdbms/admin/catbundle.sql
psu apply
SQL> SPOOL off
SQL> SET echo off
Check the following
log file for errors:
/oracle/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_APPLY_2015Oct12_23_13_35.log
SQL>set lin
200
SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SER COMMENTS
------------------------------
-------------------- ------------------------------ ---------- ----------
---------- --------------------
24-AUG-13
12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
29-SEP-15
12.14.30.734626 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
12-OCT-15
11.15.01.672336 PM APPLY SERVER 11.2.0.4 7 PSU PSU 11.2.0.4.7
3 rows selected.
over！！！
[oracle@rac1 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/oracle/product/11.2.0/db_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.4.0
Log file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-09-29_16-58-16PM_1.log
Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-09-29_16-58-16PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1
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 20760982 : applied on Tue Sep 29 16:26:02 CST 2015
Unique Patch ID: 18908105
Patch description: "Database Patch Set Update : 11.2.0.4.7(20760982)"
Created on 4 Jun 2015, 00:23:20 hrs PST8PDT
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, 17375354, 19463897
17982555, 17235750, 13866822, 18317531, 17478514, 18235390, 14338435
20803583, 13944971, 20142975, 17811789, 16929165, 18704244, 20506706
17546973, 20334344, 14054676, 17088068, 18264060, 17346091, 17343514
19680952, 18471685, 19211724, 13951456, 16315398, 18744139, 16850630
19049453, 18673304, 17883081, 19915271, 18641419, 18262334, 17006183
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, 20777150, 18482502, 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, 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, 16268425, 19584068, 18436307, 17265217, 17634921
13498382, 20004087, 17443671, 18000422, 20004021, 17571039, 21067387
16344544, 18009564, 14354737, 18135678, 18614015, 18362222, 17835048
16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775
16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359
18203835, 17297939, 16731148, 17811456, 17215560, 13829543, 14133975
17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634
18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
17393915, 17957017, 17274537, 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
19788842, 18508861, 14657740, 17332800, 13837378, 19972564, 17186905
18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024
17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551
19854503, 19309466, 18681862, 20558005, 17390160, 18554763, 18456514
13955826, 16306373, 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, 17614227, 18440047, 14106803, 16903536
18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717
17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 17267114
19972570, 18244962, 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, 17587063
16285691, 16538760, 18180390, 18193833, 21051833, 17238511, 17824637
16571443, 18306996, 14852021, 18674047, 17853456, 12364061
Patch 20831122 : applied on Tue Sep 29 16:20:35 CST 2015
Unique Patch ID: 18923533
Patch description: "OCW Patch Set Update : 11.2.0.4.7 (20831122)"
Created on 1 Jul 2015, 06:26:39 hrs PST8PDT
Bugs fixed:
19270660, 18328800, 18691572, 20365005, 17750548, 17387214, 17617807
14497275, 17733927, 18180541, 18962892, 17292250, 17378618, 16759171
20110156, 17065496, 13991403, 17273020, 17155238, 18261183, 18053580
20218012, 17039197, 17947785, 16317771, 10052729, 20340620, 18199185
18399991, 20186278, 18024089, 20746251, 20246071, 14270845, 18414137
17001914, 17927970, 14378120, 16346413, 15986647, 18068871, 21222147
18143836, 16206997, 19168690, 20235511, 18343490, 16613232, 19276791
17722664, 12928658, 18520351, 16249829, 18226143, 18265482, 18229842
17172091, 17818075, 18231837, 14373486, 17483479, 18120545, 18729166
13843841, 21225209, 17405302, 18709496, 18330979, 18744838, 20531190
14525998, 18187697, 14385860, 18348155, 19479503, 12928592, 17516024
18370031, 17764053, 17551223, 14671408, 18272135, 14207615, 17500165
18875012, 18464784, 19558324, 18848125, 19241857, 14851828, 17955615
20315294, 14693336, 16284825, 17352230, 20014326, 17238586, 17089344
17405605, 17531342, 17159489, 17640316, 16543190, 17983675, 17481314
16281493, 18346135, 15986311, 17208793, 18700935, 18999857, 14076173
18428146, 18352845, 17435488, 18352846, 17391726, 17387779, 16206882
20141091, 17305100, 15832129, 19885321, 16901346, 17985714, 18536826
17780903, 18752378, 18946768, 16876500, 16875342, 19955755, 16429265
18336452, 17273003, 19319357, 17059927, 17046460, 18053631, 16867761
20235486, 15869775, 19642566, 17447588, 15920201
Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac1 ~]$
扫一扫
88
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
