环境:
OS CentOS 6.6 64bit
Grid software 11.2.0.4.0
Oracle software 11.2.0.4.0
方式:完全手动方式patch
1.停监听:
[grid@rac02test ~]$ srvctl stop scan_listener
[grid@rac02test ~]$ srvctl stop listener
2.停实例:
关库(任一节点)
[grid@rac02test ~]$ srvctl stop database -d rac -o immediate
3. 如果有em也停掉
As the Oracle RAC database home owner execute:
$ <ORACLE_HOME>/bin/emctl stop dbconsole
4.准备补丁安装包如下:
p20760982_112040_Linux-x86-64.zip
p20996923_112040_Linux-x86-64.zip
5. 查看当前数据库的版本
[oracle@rac02test /]$cd /u01/app/oracle/product/11.2.0/db_1/OPatch
[oracle@rac02test OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@rac02test OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-10-21_11-54-35AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-10-21_11-54-35AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac02test
Remote node = rac01test
--------------------------------------------------------------------------------
OPatch succeeded.
6.备份节点1,2上 grid用户和oracle用户下的OPatch目录
Mv $ORACLE_HOME/OPatch /$ORACLE_HOME/OPatch.bak
[oracle@rac02test db_1]$ mv OPatch/ OPatch.bak
[oracle@rac01test db_1]$ mv OPatch/ OPatch.bak
grid
[root@rac02test grid]# mv OPatch/ OPatch.bak
[root@rac01test grid]# mv OPatch/ OPatch.bak
7.解压patch包
[grid@rac02test tools]$ unzip p20996923_112040_Linux-x86-64.zip
20760982—>>>DB PSU 11.2.0.4.7 (INCLUDES CPUJUL2015)—>>>Both DB Homes and Grid Home
20831122—>>>OCW PSU 11.2.0.4.7—>>>Both DB Homes and Grid Home
20299019—>>>ACFS PSU 11.2.0.4.7—>>>Only Grid Home
8.以root用户执行: