19c RAC+ADG在线打Opatch19.3到19.10

        Oracle 19c rac集群最新19.3Opatch到19.10整体升级步骤流程与相关要求，请仔细阅读并参照README文档。

一、查看当前数据库patch版本

col ACTION for a8
col status for a15
set line 999
col ACTION_TIME for a30
col DESCRIPTION for a50

SQL> select patch_id, action,status,action_time,description  from dba_registry_sqlpatch;
  PATCH_ID ACTION   STATUS     ACTION_TIME          DESCRIPTION
---------- -------- ---------- ------------------------------ ------------------------------------------------------------
  29517242 APPLY    SUCCESS    24-JUN-21 05.57.37.337431 PM   Database Release Update : 19.3.0.0.190416 (29517242)

SQL> !$ORACLE_HOME/OPatch/opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
OPatch succeeded.

[[email protected]:/u01/app/oracle/product/19.0.0/db_1/OPatch]$opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.

        所需Opatch安装包和补丁包：

p32126842_190000_Linux-x86-64.zip   p6880880_122010_Linux-x86-64.zip

二、备份数据库家目录，防止升级失败的回退

三、RAC两节点GI_home和DB_home都替换新的Opatch（备库相同步骤修改）

注意grid用户的OPatch权限不足，需要root用户替换，注意赋权
[root@saast01 ~]# mv /u01/app/19.0.0/grid/OPatch /tmp/OPatch_bak19017
[root@saast01 ~]# unzip p6880880_122010_Linux-x86-64.zip -d /u01/app/19.0.0/grid/
[root@saast01 ~]# cd /u01/app/19.0.0/grid/
[root@rac02 grid]# chown -R grid.oinstall OPatch
[root@rac02 grid]# chmod -R 775 OPatch
oracle用户替换新版OPatch
[[email protected]:/u01/app/oracle/product/19.0.0/db_1]$mv OPatch OPatch_bak19017
[[email protected]:/home/oracle]$unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME/
验证查看grid与oracle用户opatch版本为最新
[[email protected]:/u01/app/19.0.0/grid/OPatch]$opatch version
OPatch Version: 12.2.0.1.24
[[email protected]:/u01/app/oracle/product/19.0.0/db_1/OPatch]$opatch version
OPatch Version: 12.2.0.1.24

四、检查 Grid主页和Oracle主页的清单信息一致性（注意rac主库oracle和grid用户都需要检查，备库oracle用户检查）

[[email protected]:/u01/app/19.0.0/grid/OPatch]$./opatch lsinventory -detail -oh $ORACLE_HOME
[[email protected]:/u01/app/19.0.0/grid/OPatch]$./opatch lsinventory -detail -oh $ORACL