oracle19.3通过手动打RU30899722升级到oracle19.7 GI/DB linux-x64

前提说明：通过opatchauto的方式发现1节点和其他3个节点GI补丁版本不一致，导致ASM无法操作ORA-15137: The ASM cluster is in rolling patch state，所以改用手动方式；

官方参考文档：
Supplemental Readme - Grid Infrastructure Release Update 12.2.0.1.x / 18c /19c (Doc ID 2246888.1)

环境说明：
4节点RAC
mcxdb1
mcxdb2
mcxdb3
mcxdb4

前置准备：
1）升级GI DB OPatch Version: 12.2.0.1.19
2）下载并解压Patch 
    存放路径/u01/soft/30899722
    chmod -R 775 /u01/soft/30899722

1.执行补丁冲突检查
#grid
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30869156
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30894985
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30869304
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30898856

#oracle
/u01/app/19c/oracle/product/19.3.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30869156
/u01/app/19c/oracle/product/19.3.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30894985

2.手动打GI PATCH
#以下步骤4个节点依次执行，全部执行成功之后，再执行DB PATCH

#oracle:
srvctl stop home -o /u01/app/19c/oracle/product/19.3.0/db_1 -s /home/oracle/stat.f -n mcxdb1

#root
[root@mcxdb1 ~]# /u01/app/19c/19.3.0/grid/crs/install/rootcrs.sh -prepatch
#grid:
/u01/app/19c/19.3.0/grid/OPatch/opatch apply -oh /u01/app/19c/19.3.0/grid -local /u01/soft/30899722/30894985
/u01/app/19c/19.3.0/grid/OPatch/opatch apply -oh /u01/app/19c/19.3.0/grid -local /u01/soft/30899722/30869304
/u01/app/19c/19.3.0/grid/OPatch/opatch apply -oh /u01/app/19c/19.3.0/grid -local /u01/soft/30899722/30869156
/u01/app/19c/19.3.0/grid/OPatch/opatch apply -oh /u01/app/19c/19.3.0/grid -local /u01/soft/30899722/30898856

#execute as root
/oracle/app/19.7.0/grid/rdbms/install/rootadd_rdbms.sh
/oracle/app/19.7.0/grid/crs/install/rootcrs.sh -postpatch
 
#grid:crsctl query crs softwarepatch
[grid@mcxdb1 ~]$ crsctl query crs softwarepatch
Oracle Clusterware patch level on node mcxdb1 is [3633918477].

3.手动打DB PATCH
#以下步骤待GI补丁所有节点均打成功后再执行

#节点2/3/4执行,1节点不需要执行
chmod 775 /u01/app/19c/grid/oraInventory/ContentsXML/oui-patch.xml

#oracle
/u01/soft/30899722/30894985/custom/scripts/prepatch.sh -dbhome /u01/app/19c/oracle/product/19.3.0/db_1
/u01/app/19c/oracle/product/19.3.0/db_1/OPatch/opatch apply -oh /u01/app/19c/oracle/product/19.3.0/db_1 -local /u01/soft/30899722/30894985
/u01/app/19c/oracle/product/19.3.0/db_1/OPatch/opatch apply -oh /u01/app/19c/oracle/product/19.3.0/db_1 -local /u01/soft/30899722/30869156
/u01/soft/30899722/30894985/custom/scripts/postpatch.sh -dbhome /u01/app/19c/oracle/product/19.3.0/db_1 

#oracle
srvctl start home -o /u01/app/19c/oracle/product/19.3.0/db_1 -s /home/oracle/stat.f -n mcxdb1

#以上DB PATCH步骤，4个节点DB均打patch成功后，任一节点运行
cd $ORACLE_HOME/OPatch
./datapatch -verbose
编辑失效对象
SQL> @?/rdbms/admin/utlrp.sql

4.验证补丁信息
#登录数据库查看补丁注册信息
SQL> select INSTALL_ID,PATCH_ID,ACTION,STATUS,ACTION_TIME,DESCRIPTION,SOURCE_VERSION,TARGET_VERSION from dba_registry_sqlpatch;

INSTALL_ID   PATCH_ID ACTION          STATUS                    ACTION_TIME                                                                 DESCRIPTION                                                                                          SOURCE_VERSION  TARGET_VERSION
---------- ---------- --------------- ------------------------- --------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- --------------- ---------------
         1   30869156 APPLY           SUCCESS                   29-APR-20 06.06.17.095013 PM                                                Database Release Update : 19.7.0.0.200414 (30869156)                                                 19.1.0.0.0     19.7.0.0.0

#验证补丁信息GI DB,4节点均验证
[oracle@mcxdb1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/19c/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/19c/grid/oraInventory
   from           : /u01/app/19c/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19c/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-05-10_20-46-48PM_1.log

Lsinventory Output file location : /u01/app/19c/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-05-10_20-46-48PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: mcxdb1
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1): 

Oracle Database 19c                                                  19.0.0.0.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  30869156     : applied on Mon May 04 23:00:53 CST 2020
Unique Patch ID:  23493838
Patch description:  "Database Release Update : 19.7.0.0.200414 (30869156)"
   Created on 6 Apr 2020, 23:20:53 hrs PST8PDT
   Bugs fixed:
     30533132, 30312546, 29924181, 29549154, 30937410, 29970081, 8476681
     14735102, 17428816, 19080742, 19697993, 20313356, 21374587, 21965541
     23296836, 23606241, 24687075, 24971456, 25756945, 25806201, 25883179
         ... ...

Patch  30894985     : applied on Mon May 04 22:50:04 CST 2020
Unique Patch ID:  23451591
Patch description:  "OCW RELEASE UPDATE 19.7.0.0.0 (30894985)"
   Created on 10 Apr 2020, 05:35:01 hrs PST8PDT
   Bugs fixed:
     17787434, 25736599, 26675491, 27148384, 27222128, 27262781, 27505699
     27526265, 27572040, 27604329, 27760043, 27877830, 28302439, 28302580
     28319989, 28406406, 28441307, 28470673, 28554809, 28567875, 28621543
     ... ...

--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@mcxdb1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/19c/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/19c/grid/oraInventory
   from           : /u01/app/19c/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19c/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-05-10_20-46-48PM_1.log

Lsinventory Output file location : /u01/app/19c/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-05-10_20-46-48PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: mcxdb1
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1): 

Oracle Database 19c                                                  19.0.0.0.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  30869156     : applied on Mon May 04 23:00:53 CST 2020
Unique Patch ID:  23493838
Patch description:  "Database Release Update : 19.7.0.0.200414 (30869156)"
   Created on 6 Apr 2020, 23:20:53 hrs PST8PDT
   Bugs fixed:
     30533132, 30312546, 29924181, 29549154, 30937410, 29970081, 8476681
     14735102, 17428816, 19080742, 19697993, 20313356, 21374587, 21965541
     23296836, 23606241, 24687075, 24971456, 25756945, 25806201, 25883179
         ... ...

Patch  30894985     : applied on Mon May 04 22:50:04 CST 2020
Unique Patch ID:  23451591
Patch description:  "OCW RELEASE UPDATE 19.7.0.0.0 (30894985)"
   Created on 10 Apr 2020, 05:35:01 hrs PST8PDT
   Bugs fixed:
     17787434, 25736599, 26675491, 27148384, 27222128, 27262781, 27505699
     27526265, 27572040, 27604329, 27760043, 27877830, 28302439, 28302580
     28319989, 28406406, 28441307, 28470673, 28554809, 28567875, 28621543
     ... ...

--------------------------------------------------------------------------------

OPatch succeeded.