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
