检查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=
P
A
T
H
:
PATH:
PATH:ORACLE_HOME/OPatch
opatchauto apply /oraru/31720429/31750108
第一个节点大约20分钟,执行完成无报错且集群服务和数据库启动正常,在第二个节点执行opatchauto,第二个节点大约30分钟,执行完成无报错且集群服务和数据库启动正常。
RAC在其中一个节点执行datapatch -verbose
[oracle@oadb1 ~]$ cd O R A C L E H O M E / O P a t c h [ o r a c l e @ o a d b 1 O P a t c h ] ORACLE_HOME/OPatch [oracle@oadb1 OPatch] ORACLEHOME/OPatch[oracle@oadb1OPatch] ./datapatch -verbose
RAC在其中一个节点执行utlrp.sql
[oracle@oadb1 ~]$ cd
O
R
A
C
L
E
H
O
M
E
/
r
d
b
m
s
/
a
d
m
i
n
[
o
r
a
c
l
e
@
o
a
d
b
1
]
ORACLE_HOME/rdbms/admin [oracle@oadb1 ~]
ORACLEHOME/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)