一、   安装前准备

1.   准备所有相关补丁

其中p6880880为11.2.0版本数据库升级所使用opatch工具

P20760997为database升级到11.2.0.3.15升级包

P20996944为GI升级到11.2.0.3.15升级包

2.   检查操作系统剩余空间,需要大概12G左右.

二、   补丁安装

1.  上传所有相关patch到服务器

2.  解压升级opatch组件(grid和oracle都要执行)
$unzip –d $ORACLE_HOME p6880880*

3.  升级grid软件,使用root用户执行,执行前需要确保两节点rac资源正常

l  生成响应文件(grid用户执行)
cd $ORACLE_HOME/OPatch/ocm/bin

$ ./emocmrsp -no_banner -output /u01/soft/psu.rsp

Provide your email address to be informed of security issues,

install and

initiate Oracle Configuration Manager. Easier for you if you use

your MyOracle 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

The OCM configuration response file (/u01/soft/psu.rsp) was successfully created.

l  进入到patch解压目录,使用auto opatch安装升级(root 用户)
*期间会停掉当前节点所有资源,安装完成后自动重启(50分钟左右)
cd /u01/soft
# opatch auto /u01/soft/20996944 -oh /u01/oracle/grid -ocmrf /u01/soft/psu.rsp

Executing /u01/oracle/grid/perl/bin/perl /u01/oracle/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 20996944 -oh /u01/oracle/grid -ocmrf /u01/soft/psu.rsp -paramfile /u01/oracle/grid/crs/install/crsconfig_params

 

This is the main log file: /u01/oracle/grid/cfgtoollogs/opatchauto2016-08-05_03-27-54.log

 

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/oracle/grid/cfgtoollogs/opatchauto2016-08-05_03-27-54.report.log

 

2016-08-05 03:27:54: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/oracle/grid/crs/install/crsconfig_params

 

Stopping CRS...

Stopped CRS successfully

 

patch /u01/soft/20996944/17592127  apply successful for home  /u01/oracle/grid

patch /u01/soft/20996944/20760997  apply successful for home  /u01/oracle/grid

 

Starting CRS...

CRS-4123: Oracle High Availability Services has been started.

 

opatch auto succeeded.

 

 

4.  升级oracle软件,使用root用户执行,执行前需确保两节点rac资源正常

l  生成相应文件(oracle用户执行)
cd $ORACLE_HOME/OPatch/ocm/bin
$ ./emocmrsp -no_banner -output /u01/soft/opsu.rsp

l  进入到patch解压目录,使用auto opatch安装升级(root 用户)
*期间会停掉当前节点所有资源,安装完成后自动重启(30分钟左右)

# opatch auto /u01/soft/20760997 –oh

/u01/oracle/app/product/11.2.0/db_1 –ocmrf

/u01/soft/opsu.rsp

Executing /u01/oracle/grid/perl/bin/perl

/u01/oracle/app/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 20760997 -oh /u01/oracle/app/product/11.2.0/db_1 -ocmrf /u01/soft/opsu.rsp -paramfile /u01/oracle/grid/crs/install/crsconfig_params

 

This is the main log file: /u01/oracle/app/product/11.2.0/db_1/cfgtoollogs/opatchauto2016-08-05_08-02-04.log

 

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/oracle/app/product/11.2.0/db_1/cfgtoollogs/opatchauto2016-08-05_08-02-04.report.log

 

2016-08-05 08:02:04: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/oracle/grid/crs/install/crsconfig_params

Enter 'yes' if you have unzipped this patch to an empty directory to proceed  (yes/no):yes

Enter 'yes' if you have unzipped this patch to an empty directory to proceed  (yes/no):yes

 

Stopping RAC /u01/oracle/app/product/11.2.0/db_1 ...

Stopped RAC /u01/oracle/app/product/11.2.0/db_1 successfully

 

patch /u01/soft/20760997/20760997  apply successful for home  /u01/oracle/app/product/11.2.0/db_1

 

Starting RAC /u01/oracle/app/product/11.2.0/db_1 ...

Started RAC /u01/oracle/app/product/11.2.0/db_1 successfully

 

opatch auto succeeded.

 

 

在另一节点执行相同操作

5.  登录数据库执行脚本,编译无效对象(oracle用户执行)

Cd $ORACLE_HOME/rdbms/admin

@catbundle.sql psu apply
SQL> @utlrp.sql

 

6.  检查数据库当前补丁安装情况

l  数据库中查看

SQL> select * from dba_registry_history;

 

ACTION_TIME

---------------------------------------------------------------------------

ACTION                         NAMESPACE

------------------------------ ------------------------------

VERSION                                ID BUNDLE_SERIES

------------------------------ ---------- ------------------------------

COMMENTS

--------------------------------------------------------------------------------

17-SEP-11 10.21.11.595816 AM

APPLY                          SERVER

11.2.0.3                                0 PSU

Patchset 11.2.0.2.0

 

23-MAY-14 04.05.26.349017 AM

APPLY                          SERVER

11.2.0.3                                0 PSU

Patchset 11.2.0.2.0

 

05-AUG-16 06.16.03.515415 AM

APPLY                          SERVER

11.2.0.3                                0 PSU

Patchset 11.2.0.2.0

 

05-AUG-16 08.14.53.201883 AM

APPLY                          SERVER

11.2.0.3                               15 PSU

PSU 11.2.0.3.15

 

 

4 rows selected.

 

l  使用opatch工具查看

$ opatch lsinv

Oracle Interim Patch Installer version 11.2.0.3.14

Copyright (c) 2016, Oracle Corporation.  All rights reserved.

 

 

Oracle Home       : /u01/oracle/app/product/11.2.0/db_1

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/app/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.14

OUI version       : 11.2.0.3.0

Log file location : /u01/oracle/app/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-08-05_08-20-09AM_1.log

 

Lsinventory Output file location : /u01/oracle/app/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-08-05_08-20-09AM.txt

 

--------------------------------------------------------------------------------

Local Machine Information::

Hostname: db01

ARU platform id: 226

ARU platform description:: Linux x86-64

 

Installed Top-level Products (1):

 

Oracle Database 11g                                                  11.2.0.3.0

There are 1 products installed in this Oracle Home.

 

 

Interim patches (1) :

 

Patch  20760997     : applied on Fri Aug 05 08:08:18 GMT+00:00 2016

Unique Patch ID:  18966522

Patch description:  "Database Patch Set Update : 11.2.0.3.15 (20760997)"

   Created on 8 Jun 2015, 23:57:50 hrs PST8PDT

Sub-patch  20299017; "Database Patch Set Update : 11.2.0.3.14 (20299017)"

Sub-patch  19769496; "Database Patch Set Update : 11.2.0.3.13 (19769496)"

Sub-patch  19121548; "Database Patch Set Update : 11.2.0.3.12 (19121548)"

Sub-patch  18522512; "Database Patch Set Update : 11.2.0.3.11 (18522512)"

Sub-patch  18031683; "Database Patch Set Update : 11.2.0.3.10 (18031683)"

Sub-patch  17540582; "Database Patch Set Update : 11.2.0.3.9 (17540582)"

Sub-patch  16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"

Sub-patch  16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"

Sub-patch  16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"

Sub-patch  14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"

Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"

Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"

Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"

Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"

   Bugs fixed:

     18681866, 13931044, 14318397, 19517437, 20134036, 20134035, 16279211

     20134034, 20134033, 12879027, 13499412, 12748240, 16101465, 13566938

     12845115, 10625145, 16462834, 13429702, 13399435, 18440047, 13503204

     13419660, 14191508, 14781609, 13092220, 13035804, 13812031, 14609690

     14383007, 13369579, 11732473, 7509451, 16524926, 19358317, 12925089

     12595606, 13804294, 14138130, 14226599, 18641419, 10256843, 16694777

     14668670, 12620823, 13072654, 13612575, 13528551, 15853081, 13914613

     13911821, 14459552, 14275605, 9095696, 13427062, 13918644, 16231699

     13370330, 13063120, 13923374, 13903046, 13544396, 14258925, 13454210

     13483354, 19854461, 12919564, 14098509, 17437634, 14035825, 13424216

     16382448, 14237793, 14695377, 13724193, 14230270, 14262913, 13840704

     12658411, 13596521, 14003090, 12755231, 14762511, 13705338, 9812682

     19554106, 19458377, 13699124, 11708510, 14127231, 12387467, 13786142

     12938841, 12983611, 13857111, 18641461, 12917230, 12813641, 14657740

     13736413, 14222403, 14406648, 16382353, 13807411, 13911711, 19309466

     12312133, 21146680, 9163477, 13686047, 16014985, 14398795, 14472647

     12971775, 18641451, 12974860, 12535346, 12796518, 12898558, 16710363

     13936424, 13042639, 16314470, 14052871, 9761357, 14637368, 13848402

     20657441, 16710753, 13916709, 13397104, 16294378, 13593999, 12571991

     15869211, 11071989, 13502183, 16314466, 16314467, 16314468, 16048375

     16314469, 14176879, 18139695, 12784406, 13060271, 12345082, 13944971

     16347904, 13579992, 18673342, 14207163, 13354082, 13945708, 13912931

     13923995, 12940620, 9703627, 13958038, 13719292, 14220725, 13496884

     13642044, 8547978, 13719081, 16038929, 16019955, 13732226, 14063280

     14063281, 12899768, 12940637, 18740215, 9397635, 13466801, 16794240

     20803576, 16794242, 20074391, 16794241, 13596581, 16794244, 16794243

     13326736, 13011409, 12411746, 13366202, 14841409, 20334344, 19972198

     19972199, 13257247, 13787482, 16794239, 12320556, 19006849, 16794238

     20477068, 12594032, 20477069, 12588744, 13467683, 10242202, 12998795

     13584130, 19710542, 14512189, 16944698, 13972394, 14121009, 12821418

     11868640, 17762296, 13340388, 12857027, 16088176, 13420224, 16450169

     17019974, 19211724, 13035360, 14343501, 20477071, 13814739, 14023636

     12614359, 15994107, 13038684, 12797620, 18673304, 14755945, 14613900

     20004021, 12797765, 13791364, 12847466, 13794550, 15905421, 15996344

     13250244, 14369664, 19433747, 19433745, 12964067, 19433746, 11877623

     20296213, 13553883, 19699191, 13489024, 12755116, 13477790, 13338048

     13146182, 13855490, 13907462, 12693626, 14548763, 17333202, 17333200

     12747740, 13099577, 18096714, 14128555, 12873183, 17333203, 13457582

     12747437, 16530565, 18673325, 19827973, 13026410, 14188650, 17540582

     14508968, 16864562, 13066936, 16362358, 13913630, 12861463, 13098318

     13632717, 12582664, 16344871, 17478415, 16272008, 14841558, 12945879

     12829021, 13773133, 16563678, 15856660, 14841812, 12894807, 12815057

     10182005, 16872333, 13561750, 16844086, 10133521, 14263036, 14390252

     13772618, 16850197, 12764337, 12834027, 14038787, 12960925, 14088346

     13554409, 15910002, 13484963, 13476583, 13872868, 10263668, 12744759

     14588746, 17165204, 12865902, 16212405, 13430938, 15987992, 13737888

     13723052, 11840910, 20299010, 13070939, 12976376, 19121548, 14546638

     14193240, 13448206, 13559697, 19259446, 14644185, 14273397, 11715084

     13616375, 6690853, 13718279, 13332439, 14488943, 13843646, 12395918

     13015379, 14489591, 15826962, 13492735, 15901852, 20477440, 13527323

     10400244, 13040943, 16279401, 14263073, 13649031, 18522512, 14182835

     13632809, 13358781, 14076523, 20558005, 12977562, 13464002, 9797851

     13901201, 12772404, 12731940, 13572659, 13810393, 13878246, 16372203

     12950644, 17332800, 12912137, 12780983, 17748831, 17748830, 17748833

     12959852, 17748832, 13790109, 17748835, 13647945, 17748834, 12718090

     13366199, 10110625, 16368108, 13361350, 9547706, 13259364, 12662040

     16338983, 14546575, 14207902, 13440516, 16299830, 14198511, 14040433

     13871316, 17088068, 13499128, 14546673, 20004087, 14207317, 13685544

     13065099, 10359307, 13591624, 14408859, 16902043, 13493847, 19915271

     18173595, 18173592, 18173593, 13696216, 13043012, 16747736, 14692762

     13605839, 14558880, 14727310, 9873405, 17721717, 12591399, 11883252

     15931756, 14799269, 14110275, 13657605, 15981698, 12621588, 13866372

     13524899, 17761775, 12588237, 9706792, 16721594, 12612118, 13059165

     18262334, 13551402, 12880299, 5144934, 14007968, 13550185, 17752121

     17230530, 14062792, 16056266, 14062793, 14062794, 13534412, 14062795

     14062796, 14052474, 13840711, 14062797, 13780035, 18325460, 16024441

     12780098, 14138823, 13890080, 16761566, 16923127, 9858539, 14053457

     15862024, 15862022, 15862023, 15862021, 19197175, 15862020, 13384182

     13362079, 16844448, 14571027, 13725395, 12791981, 17865671, 7276499

     16619892, 17343514, 15883525, 15841373, 15862019, 14205448, 14163397

     15862016, 15862017, 15862018, 13981051, 14664355, 13385346, 20331945

     13041324, 14751895, 12797420, 14189694, 14351566, 13001379, 13645875

     14095982, 14480676, 13680405, 14480675, 14480674, 19727057, 10350832

     17716305, 12794305, 19289642, 14589750, 12583611, 14409183, 12646784

     17767676, 16505333, 16175381, 14791477, 21151526, 21031414, 21031410

     21031411, 21031412, 21031413, 12923168, 12617123, 13853654, 14123213

     13582702, 12391034, 14393728, 13839336, 19638161, 13866822, 16306019

     11063191, 14497307, 13839641, 13860201, 14774091, 12913474, 13910420

     19769496, 13377816, 17082364, 16742095, 12401111, 12678920, 13624984

     12656535, 20777150, 13036331, 13645917, 14158012, 13834436, 13742464

     19537916, 13737746, 13853126, 13103913, 14467061, 12849688, 13080778

     14523004, 19271438, 17050888, 13343438, 13783957, 12596444, 13849733

     13503598, 12905053, 16992075, 18031683, 12985237, 12905058, 13742436

     13742437, 13561951, 13742438, 17333198, 17333197, 13742433, 12585543

     13916549, 17333199, 13742434, 9659614, 13742435, 12748538, 16344758

     13588248, 17468141, 18436647, 16703112, 13834065, 16710324, 14301592

     14469008, 16929165

 

 

 

Rac system comprising of multiple nodes

  Local node = db01

  Remote node = db02

 

------------------------------------------------------------------------

 

OPatch succeeded.