操作系统版本 : RedHat 6.5 x64
数据库版本 : Oracle 11.2.0.4 x64 RAC
Grid : 11.2.0.4
Oracle database: 11.2.0.4
GI PSU : p21523375_112040_Linux-x86-64.zip
OPatch : p6880880_112000_Linux-x86-64.zip
DB PSU : p21352635_112040_Linux-x86-64.zip 仅单实例使用。
OPatch下载地址:
https://updates.oracle.com/download/6880880.html
说明:GI PSU包括DB PSU,CPU。
二、更新OPatch版本,必须要更新说明:分别在两个节点更新OPatch版本。
1. 更新OPatch版本,需要更新到11.2.0.3.11,OPatch直接压缩替换就可以了。(1) 上传p6880880_112000_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限,也可以采用/tmp目录。
(2) root用户下将原OPatch目录改名。
mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatchbk
mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatchBK
(1) root用户
cd /u01/software/;chown grid:oinstall p6880880_112000_Linux-x86-64.zip
(2) grid用户
su - grid
cd /u01/software/
unzip p6880880_112000_Linux-x86-64.zip
(3) root用户
cd /u01/software/
mv OPatch /u01/app/11.2.0/grid/
(4) grid用户测试
su - grid
/u01/app/11.2.0/grid/OPatch/opatch version
OPatch Version: 11.2.0.3.11
OPatch succeeded.
(1) root用户
cd /u01/software/;chown oracle:oinstall p6880880_112000_Linux-x86-64.zip
(2) oracle用户
su - oracle
cd /u01/software/
unzip p6880880_112000_Linux-x86-64.zip
(3) root用户
cd /u01/software/
mv OPatch /u01/app/oracle/product/11.2.0/db_1/
(4) oracle用户测试
su - oracle
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version
OPatch Version: 11.2.0.3.11
OPatch succeeded.
# su - oracle
$ cd /u01/software
$ /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp
$ ls
ocm.rsp
四、开始升级GI PSU软件包
说明:一定要按照顺序一个一个节点的打。
1. grid用户下解决GI PSU补丁包(1) root用户操作
cd /u01/software/;chown grid:oinstall p21523375_112040_Linux-x86-64.zip
(2) grid用户操作
su - grid
cd /u01/software/
unzip p21523375_112040_Linux-x86-64.zip
2. 测试兼容性
su - grid
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/21523375/21352649 -oh $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/21523375/21352642 -oh $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/21523375/21352635 -oh $ORACLE_HOME
过程略过…
3、开始升级GRID root用户依次节点1,节点2上执行。# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/software/21523375 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/software/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn 21523375 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-12-25_10-09-05.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-12-25_10-09-05.report.log
2015-12-25 10:09:05: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping CRS...
Stopped CRS successfully
patch /u01/software/21523375/21352635 apply successful for home /u01/app/11.2.0/grid
patch /u01/software/21523375/21352649 apply successful for home /u01/app/11.2.0/grid
patch /u01/software/21523375/21352642 apply successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
opatch auto succeeded.
4. 检查升级情况
# su - grid
$ /u01/app/11.2.0/grid/OPatch/opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-12-25_10-31-49AM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2015-12-25_10-31-49AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: db1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (3) :
Patch 21352642 : applied on Fri Dec 25 10:22:50 CST 2015
Unique Patch ID: 19203841
Patch description: "ACFS Patch Set Update : 11.2.0.4.8 (21352642)"
Created on 3 Sep 2015, 00:03:11 hrs PST8PDT
Bugs fixed:
17510275, 21369858, 17172303, 16318126, 19690653, 18610307, 17503605
17376318, 17203009, 20140148, 17721778, 17611362, 17164243, 19053182
17696547, 17699423, 17488768, 18915417, 18155334, 19919907, 18321597
18185024, 18168684, 17363999, 17636008, 18143006, 17428148, 20681968
17070158, 17475946
Patch 21352649 : applied on Fri Dec 25 10:19:11 CST 2015
Unique Patch ID: 19203841
Patch description: "OCW Patch Set Update : 11.2.0.4.8 (21352649)"
Created on 2 Sep 2015, 23:43:49 hrs PST8PDT
Bugs fixed:
19270660, 18328800, 18508710, 18691572, 21251192, 20365005, 17750548
17387214, 17617807, 14497275, 20219458, 17733927, 18180541, 18962892
17292250, 17378618, 16759171, 20110156, 17843489, 17065496, 13991403
17273020, 17155238, 21245437, 18261183, 18053580, 20218012, 20995001
17039197, 17947785, 16317771, 10052729, 20340620, 20317221, 15917869
18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251
20246071, 14270845, 18882642, 18414137, 17001914, 17927970, 14378120
16346413, 15986647, 18068871, 21222147, 18143836, 16206997, 19168690
20235511, 18343490, 16613232, 19276791, 17722664, 20440643, 12928658
18952577, 18520351, 16249829, 18226143, 18265482, 18229842, 17172091
20676340, 17818075, 20091753, 18231837, 14373486, 17483479, 18120545
18729166, 13843841, 21225209, 17405302, 18709496, 18330979, 18744838
17087371, 20531190, 14525998, 18187697, 20598625, 14385860, 18348155
19479503, 12928592, 17516024, 18370031, 17764053, 19272663, 17551223
14671408, 18272135, 14207615, 17500165, 18875012, 18464784, 19558324
18848125, 19241857, 14851828, 17955615, 20315294, 14693336, 16284825
17352230, 20014326, 17238586, 17089344, 17405605, 17531342, 17159489
17640316, 13823394, 16543190, 17983675, 17598201, 17481314, 16281493
18346135, 15986311, 19601468, 17208793, 18700935, 18999857, 14076173
18428146, 18352845, 17435488, 18352846, 17391726, 17387779, 14777968
15851860, 16206882, 20141091, 20175174, 17305100, 15832129, 19885321
16901346, 17985714, 18536826, 17780903, 18752378, 18946768, 16876500
16875342, 17769597, 19955755, 16429265, 18336452, 17273003, 17209968
16988311, 20094984, 19319357, 17059927, 17046460, 18053631, 16867761
18774591, 21442094, 20235486, 19359787, 15869775, 19642566, 17447588
16798862, 15920201
Patch 21352635 : applied on Fri Dec 25 10:16:29 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
Rac system comprising of multiple nodes
Local node = db1
Remote node = db2
--------------------------------------------------------------------------------
OPatch succeeded.
$ /u01/app/11.2.0/grid/OPatch/opatch lspatches
21352642;ACFS Patch Set Update : 11.2.0.4.8 (21352642)
21352649;OCW Patch Set Update : 11.2.0.4.8 (21352649)
21352635;Database Patch Set Update : 11.2.0.4.8 (21352635)
OPatch succeeded.
五、打database PSU补丁 1. 准备工作
(1) Root用户下,重新给PSU补丁包赋予权限
cd /u01/software/;chown oracle:oinstall p21523375_112040_Linux-x86-64.zip
(2) oracle用户
su - oracle
cd /u01/software/
unzip p21523375_112040_Linux-x86-64.zip
2. Oracle用户下检查兼容性
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/21523375/21352635 -oh $ORACLE_HOME
----------------------------------------------------
示例:
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2015, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-12-18_16-21-46PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
----------------------------------------------------
3. 开启自动打补丁 root用户依次节点1,节点2上人执行。
# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /u01/software/21523375 -oh /u01/app/oracle/product/11.2.0/db_1/ -ocmrf /u01/software/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn 21523375 -oh /u01/app/oracle/product/11.2.0/db_1/ -ocmrf /u01/software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-12-25_10-43-07.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-12-25_10-43-07.report.log
2015-12-25 10:43:07: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
patch /u01/software/21523375/21352635 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/software/21523375/21352649/custom/server/21352649 apply successful for home /u01/app/oracle/product/11.2.0/db_1
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
4. 检查升级情况
$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv
Patch 21352635 : applied on Fri Dec 18 17:38:24 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:
...
$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches
21352635;Database Patch Set Update : 11.2.0.4.8 (21352635)
21352642;ACFS Patch Set Update : 11.2.0.4.8 (21352642)
21352649;OCW Patch Set Update : 11.2.0.4.8 (21352649)
OPatch succeeded.
数据库启动,并加载修改SQL Files到数据库
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 25 11:26:02 2015
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL>
SQL>
SQL> @?/rdbms/admin/catbundle.sql psu apply
SQL>
执行完后我们可以查到PSU更新信息:
SQL>
set line 150
col ACTION_TIME for a30
col ACTION for a8
col NAMESPACE for a8
col VERSION for a10
col BUNDLE_SERIES for a5
col COMMENTS for a20
select * from dba_registry_history;
ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
------------------------------ -------- -------- ---------- ---------- ----- --------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
22-DEC-15 03.53.27.330912 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
25-DEC-15 11.54.19.486765 AM APPLY SERVER 11.2.0.4 8 PSU PSU 11.2.0.4.8
3 rows selected.
SQL>
小节:自动打还是比较顺利的,没有出现手动打出现的问题,在此记录。
Oracle 11g RAC手动打GI PSU补丁(11.2.0.4.8)
: