oracle 19cRAC 19.6基础上安装19.9 GI +DB+JAVAVM

检查RAC所有节点下的OPatch版本
su - oracle
[oracle@oadb1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.21

OPatch succeeded.

su - grid
[grid@oadb1:/u01/app/19.0.0/grid/OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.21

OPatch succeeded.
RAC所有节点检查补丁冲突
For Grid Infrastructure Home, as home user:

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraru/31720429/31750108/31771877
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraru/31720429/31750108/31772784
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraru/31720429/31750108/31773437
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraru/31720429/31750108/
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraru/31720429/31750108/31780966
For Database home, as home user:
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraru/31720429/31750108/31771877
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraru/31720429/31750108/31772784

RAC所有节点检查文件系统上是否有足够的可用空间来应用补丁

vi /tmp/patch_list_gihome.txt

/oraru/31720429/31750108/31771877
/oraru/31720429/31750108/31772784
/oraru/31720429/31750108/31773437
/oraru/31720429/31750108/
/oraru/31720429/31750108/31780966

$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt

vi /tmp/patch_list_dbhome.txt
/oraru/31720429/31750108/31771877
/oraru/31720429/31750108/31772784

$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

RAC各节点滚动应用GI+DB RU
此操作需要停集群服务，允许滚动应用补丁，先操作一个节点，其他节点提供服务，这个节点操作完成启动成功可对外服务后，再依次操作其他节点。

export ORACLE_HOME=/u01/app/19.0.0/grid
export PATH=$PATH:$ORACLE_HOME/OPatch
opatchauto apply /oraru/31720429/31750108
第一个节点大约20分钟，执行完成无报错且集群服务和数据库启动正常，在第二个节点执行opatchauto，第二个节点大约30分钟，执行完成无报错且集群服务和数据库启动正常。

RAC在其中一个节点执行datapatch -verbose

[oracle@oadb1 ~]$ cd $ORACL{E}_{H}OME/OPatch[oracle@oadb1OPatch]$ ./datapatch -verbose

RAC在其中一个节点执行utlrp.sql

[oracle@oadb1 ~]$ cd $ORACL{E}_{H}OME/rdbms/admin[oracle@oadb1]$sqlplus / as sysdba
SQL> @utlrp.sql

GI+DB RU安装后检查

[grid@oadb1:/u01/app/19.0.0/grid/OPatch]$opatch lspatches
31780966;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31780966)
31773437;ACFS RELEASE UPDATE 19.9.0.0.0 (31773437)
31772784;OCW RELEASE UPDATE 19.9.0.0.0 (31772784)
31771877;Database Release Update : 19.9.0.0.201020 (31771877)

[oracle@oadb1 OPatch]$ ./opatch lspatches
31772784;OCW RELEASE UPDATE 19.9.0.0.0 (31772784)
31771877;Database Release Update : 19.9.0.0.201020 (31771877)

OPatch succeeded.
SQL> select status,description from dba_registry_sqlpatch;

STATUS DESCRIPTION

SUCCESS Database Release Update : 19.3.0.0.190416 (29517242)
SUCCESS Database Release Update : 19.6.0.0.200114 (30557433)
SUCCESS Database Release Update : 19.9.0.0.201020 (31771877)

打JAVAVM RU

cd /oraru/31720429/31668882
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
依次关闭RAC的各个实例并应用补丁

[oracle@oadb1 OPatch]$ sqlplus / as sysdba
SQL> shutdown immediate
cd /oraru/31720429/31668882
$ORACLE_HOME/OPatch/opatch apply

关闭最后一个实例前修改cluster_database=false

[oracle@oadb1 OPatch]$ sqlplus / as sysdba
SQL> alter system set cluster_database=false scope=spfile;
SQL> shutdown immediate
cd /oraru/31720429/31668882
$ORACLE_HOME/OPatch/opatch apply
RAC所有节点opatch apply完成无报错后，在其中一个节点以UPGRADE模式启动数据库

[oracle@oadb1 OPatch]$ sqlplus / as sysdba
SQL> STARTUP UPGRADE
SQL> alter pluggable database all open upgrade;

RAC其中一个节点执行datapatch -verbose

./datapatch -verbose
datapatch -verbose执行成功无报错后，修改参数cluster_database=true并关闭此节点，启动数据库

sqlplus / as sysdba
SQL> alter system set cluster_database=true scope=spfile;
SQL> shutdown immediate
srvctl start database -d jcoadb
补丁安装后检查
SQL> select status,description from dba_registry_sqlpatch;

STATUS DESCRIPTION

SUCCESS Database Release Update : 19.3.0.0.190416 (29517242)
SUCCESS Database Release Update : 19.6.0.0.200114 (30557433)
SUCCESS Database Release Update : 19.9.0.0.201020 (31771877)
SUCCESS OJVM RELEASE UPDATE: 19.9.0.0.201020 (31668882)