$ORACLE_HOME为oracle软件安装目录(/oracle/app/product/12.2.0/db_1)

$GRID_HOME为grid安装目录(/oracle/grid/crs_1)

<UNZIPPED_PATCH_LOCATION>为psu安装包解压路径，本次实验改目录为/soft

一、解压opatch工具

1.1 root用户修改属组

# chown grid:oinstall p6880880_122010_Linux-x86-64.zip

1.2 Grid用户双节点执行：

$ unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME

1.3 root用户修改属组

# chown oracle:oinstall p6880880_122010_Linux-x86-64.zip

1.4 Oracle用户双节点执行：

$ unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME

查看opatch当前版本

[oracle@s1-11g OPatch]$ opatch version

OPatch Version: 12.2.0.1.25

OPatch succeeded.

二、解压补丁包

在双节点执行（grid或oracle用户都可以）

$ cd /soft

$ unzip p31750108_190000_Linux-x86-64.zip

三、安装过程

检查readme文件：

31750108

Patch Number Description Applicable Homes

31771877 Database Release Update 19.9.0.0.201020 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.

31772784 OCW Release Update 19.9.0.0.201020   Both DB Homes and Grid Home

31773437 ACFS Release Update 19.9.0.0.201020     Only Grid Home

31780966 Tomcat Release Update 19.0.0.0.0 Only Grid Home

ORACLE_HOME=/oracle/app/product/12.2.0/db_1

GRID_HOME=/oracle/grid/crs_1

status file location=/soft/status.lst

node name=rac1,rac2

打补丁前准备：

1.备份安装文件

tar cvf /ora_backup/oracle.tar oracle

tar cvf /ora_backup/grid.tar grid

2.备份数据文件

rmant target /

backup database format '/ora_backup/full_%U.bak' plus archivelog;

3.关闭数据库

srvctl stop database -d orcl -o immediate

自动打补丁过程：

预检查

双节点执行

/oracle/grid/crs_1/OPatch/opatchauto apply /soft/31750108 -analyze

1. 关闭2节点集群

/oracle/grid/crs_1/bin/crsctl stop has

2. 1节点执行打grid补丁

/oracle/grid/crs_1/OPatch/opatchauto apply /soft/31750108 -oh /oracle/grid/crs_1 -nonrolling

3. 1节点关集群 2节点开集群

/oracle/grid/crs_1/bin/crsctl stop has

/oracle/grid/crs_1/bin/crsctl start has

4. 2节点打grid补丁

chmod 660 /oracle/oraInventory/ContentsXML/oui-patch.xml

/oracle/grid/crs_1/OPatch/opatchauto apply /soft/31750108 -oh /oracle/grid/crs_1 -nonrolling

5. 1节点打db补丁

/oracle/app/product/12.2.0/db_1/OPatch/opatchauto apply /soft/31750108 -oh /oracle/app/product/12.2.0/db_1

6. 2节点打db补丁

/oracle/app/product/12.2.0/db_1/OPatch/opatchauto apply /soft/31750108 -oh /oracle/app/product/12.2.0/db_1

7.加载sql

srvctl start database -d orcl

cd $ORACLE_HOME/OPatch

./datapatch -verbose

回滚：

同时回滚

/oracle/grid/crs_1/OPatch/opatchauto rollback /soft/31750108

单独回滚

grid:

/oracle/grid/crs_1/OPatch/opatchauto rollback /oracle/grid/crs_1

db:

/oracle/app/product/12.2.0/db_1/OPatch/opatchauto rollback -oh /oracle/app/product/12.2.0/db_1