Oracle 11g RAC自动打GI PSU补丁(11.2.0.4.8)

一、准备工作

1，数据库环境

操作系统版本  : RedHat 6.5 x64  
数据库版本    : Oracle 11.2.0.4 x64 RAC    
Grid          : 11.2.0.4    
Oracle database: 11.2.0.4

2，准备内容

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

2. grid目录OPatch替换

(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.

3. oracle目录OPatch替换

(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.

三、分别在节点1和节点2分别生成ocm.rsp文件。

# 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>    

小节：自动打还是比较顺利的，没有出现手动打出现的问题，在此记录。