19c 自动打RU补丁

$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.zip1.2 Grid用户双节点执行：$ unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME1.3 root用户修改属组# chown oracle:oinstall p6880880_122010_Linux-x86-64.zip1.4 Oracle用户双节点执行：$ unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME查看opatch当前版本[oracle@s1-11g OPatch]$ opatch versionOPatch Version: 12.2.0.1.25OPatch succeeded.二、解压补丁包在双节点执行（grid或oracle用户都可以）$ cd /soft$ unzip p31750108_190000_Linux-x86-64.zip三、安装过程检查readme文件：31750108Patch Number Description Applicable Homes31771877 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 Home31773437 ACFS Release Update 19.9.0.0.201020     Only Grid Home31780966 Tomcat Release Update 19.0.0.0.0 Only Grid HomeORACLE_HOME=/oracle/app/product/12.2.0/db_1GRID_HOME=/oracle/grid/crs_1status file location=/soft/status.lstnode name=rac1,rac2打补丁前准备：1.备份安装文件tar cvf /ora_backup/oracle.tar oracletar cvf /ora_backup/grid.tar grid2.备份数据文件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 -analyze1. 关闭2节点集群/oracle/grid/crs_1/bin/crsctl stop has2. 1节点执行打grid补丁/oracle/grid/crs_1/OPatch/opatchauto apply /soft/31750108 -oh /oracle/grid/crs_1 -nonrolling3. 1节点关集群 2节点开集群/oracle/grid/crs_1/bin/crsctl stop has/oracle/grid/crs_1/bin/crsctl start has4. 2节点打grid补丁chmod 660 /oracle/oraInventory/ContentsXML/oui-patch.xml/oracle/grid/crs_1/OPatch/opatchauto apply /soft/31750108 -oh /oracle/grid/crs_1 -nonrolling5. 1节点打db补丁/oracle/app/product/12.2.0/db_1/OPatch/opatchauto apply /soft/31750108 -oh /oracle/app/product/12.2.0/db_16. 2节点打db补丁/oracle/app/product/12.2.0/db_1/OPatch/opatchauto apply /soft/31750108 -oh /oracle/app/product/12.2.0/db_17.加载sqlsrvctl start database -d orclcd $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_1db:/oracle/app/product/12.2.0/db_1/OPatch/opatchauto rollback -oh /oracle/app/product/12.2.0/db_1