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, 1747851