11g R2 RAC打最新11.2.0.4.8 PSU补丁记录

采用手工打补丁,步骤如下:

1.
su - 
# $GRID_HOME/crs/install/rootcrs.pl -unlock


2.
su - grid
$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./21523375/21352649


$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./21523375/21352642


$ $GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./21523375/21352635


3.
su - oracle
$ ./21523375/21352649/custom/server/21352649/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME


$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local ./21523375/21352649/custom/server/21352649
$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./21523375/21352635


$ ./21523375/21352649/custom/server/21352649/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME


4.
su - 
# $GRID_HOME/rdbms/install/rootadd_rdbms.sh


# $GRID_HOME/crs/install/rootcrs.pl -patch


在节点二重复执行上面步骤


然后启动数据库执行如下脚本
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

注意要使用最新OPatch版本

未打补丁之前:

[grid@elvis111 ~]$ opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.




Oracle Home       : /g01/grid/app/11.2.0/grid
Central Inventory : /g01/grid/app/oraInventory
   from           : /g01/grid/app/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /g01/grid/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-10-30_05-35-49AM_1.log


Lsinventory Output file location : /g01/grid/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2015-10-30_05-35-49AM.txt


--------------------------------------------------------------------------------
Installed Top-level Products (1): 


Oracle Grid Infrastructure 11g                                       11.2.0.4.0
There are 1 product(s) installed in this Oracle Home.




Interim patches (3) :


Patch  20299019     : applied on Tue Jul 21 04:13:26 CST 2015
Unique Patch ID:  18573450
Patch description:  "ACFS Patch set update : 11.2.0.4.6 (20299019)"
   Created on 27 Mar 2015, 15:26:30 hrs 
   Bugs fixed:
     17510275, 17172303, 16318126, 19690653, 17203009, 17376318, 17503605
     20140148, 17611362, 17721778, 17164243, 19053182, 17696547, 17699423
     17488768, 18915417, 18155334, 18321597, 19919907, 18168684, 17363999
     17636008, 18143006, 17428148, 17070158, 17475946


Patch  20760982     : applied on Tue Jul 21 03:49:47 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
  &nb