Oracle 11g 补丁升级

1.检查版本

操作系统版本   : 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    

2.更新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

grid目录OPatch替换

(1) root用户上传Opatch

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.

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.

3.分别在各节点生成ocm.rsp文件

su - oracle

$ cd  /u01/software   
$ /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp    
$ ls

ocm.rsp
打grid时候：更改为grid:oinstall
打oracle时候：更改为oracle：oinstall

4.升级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 注意停DB 不停CRS

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    

​

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.

5.打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> @?/rdbms/admin/catbundle.sql psu apply
 
执行完后我们可以查到PSU更新信息：    
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>