Oracle数据库补丁加载-19.13升级到19.15

1 数据库环境

主机 Rdehat linux 7.9

数据库环境19.13 RAC环境。

2 查看 GRU补丁对应的需要更新的软件

33806152

Database Release Update 19.15.0.0.220419

Only Oracle home for non-Oracle RAC setup. Both Oracle home and Grid home for Oracle RAC setup.

33815596

OCW Release Update 19.15.0.0.220419

Both Oracle home and Grid home.

33815607

ACFS Release Update 19.15.0.0.220419 Footnote2

Only Grid home.

33911149

Tomcat Release Update 19.0.0.0.0Footnote 2

Only Grid home.

33575402

DBWLM Release Update 19.0.0.0.0Footnote 2

Only Grid home.

此内容可以在数据库补丁加载的read me中可以查询到。

3 补丁记载步骤

3.1 安全关闭节点1数据库

oracle用户。
rm 123.txt
srvctl stop home -o $ORACLE_HOME -s /home/oracle/123.txt -n gzrac01

srvctl stop home -o $ORACLE_HOME -s /home/oracle/123.txt -n gzrac02

3.2 使用root进行prepatch，类似11.2 unlock

[root@gzrac01 install]# cd /u01/app/19.3/grid/crs/install

[root@gzrac02 install]# ./rootcrs.sh -prepatch

Using configuration parameter file: /u01/app/19.3/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/gzrac02/crsconfig/crs_prepatch_gzrac02_2022-07-07_11-41-51AM.log
2022/07/07 11:43:00 CLSRSC-4012: Shutting down Oracle Trace File Analyzer (TFA) Collector.
2022/07/07 11:43:13 CLSRSC-4013: Successfully shut down Oracle Trace File Analyzer (TFA) Collector.
2022/07/07 11:43:14 CLSRSC-347: Successfully unlock /u01/app/19.3/grid  ---crsctl stop crs -f
2022/07/07 11:43:18 CLSRSC-671: Pre-patch steps for patching GI home successfully completed.

3.3 GI HOME加载补丁

根据上述1中的补丁加载对应的软件进行补丁加载

opatch apply -oh $ORACLE_HOME -local /home/grid/1915/33803476/33806152  --RU
opatch apply -oh $ORACLE_HOME -local /home/grid/1915/33803476/33815596  --OCW
opatch apply -oh $ORACLE_HOME -local /home/grid/1915/33803476/33815607  --ACFS
opatch apply -oh $ORACLE_HOME -local /home/grid/1915/33803476/33911149  --Tomcat 
opatch apply -oh $ORACLE_HOME -local /home/grid/1915/33803476/33575402  --DBWLM

3.4 ORACLE_HOME加载补丁

根据上述1中的补丁加载对应的软件进行补丁加载

[oracle@gzrac01 scripts]$ ./prepatch.sh -dbhome $ORACLE_HOME
opatch apply -oh $ORACLE_HOME -local /home/oracle/1915/33803476/33806152  --RU
opatch apply -oh $ORACLE_HOME -local /home/oracle/1915/33803476/33815596 --OCW
[oracle@gzrac01 scripts]$ ./postpatch.sh -dbhome $ORACLE_HOME
 

3.5 解锁等工作

# cd /u01/app/19.3/grid/rdbms/install
./rootadd_rdbms.sh

# cd /u01/app/19.3/grid/crs/install

[root@gzrac01 install]# ./rootcrs.sh -postpatch
Using configuration parameter file: /u01/app/19.3/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/gzrac01/crsconfig/crs_postpatch_apply_inplace_gzrac01_2022-07-07_10-37-34AM.log
2022/07/07 10:37:46 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2022/07/07 10:39:49 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA)
Collector.
2022/07/07 10:39:50 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
You have new mail in /var/spool/mail/root
[root@gzrac01 install]# 

crsctl status res ora.mgmtdb -p

3.6 将补丁应用到数据库

[oracle@gzrac01 OPatch]$ ./datapatch -verbose

节点2按照如上操作即可。

4 JVM补丁加载 

将数据库全部关闭，并将JVM补丁加载到ORACLE_HOME

opatch apply 

srvctl start instance -d wyzxdb -n gzrac01

alter system set cluster_database=true sid='*' scope=spfile;

 % sqlplus /nolog
SQL> Connect / as sysdba
SQL> startup
    
SQL> alter pluggable database all open upgrade;
    
SQL> quit
% cd $ORACLE_HOME/OPatch
    
% ./datapatch -verbose

alter system set cluster_database=true sid='*' scope=spfile;

启动数据库系统。

srvctl start home -o $ORACLE_HOME -s /home/oracle/123.txt -n gzrac01
srvctl start home -o $ORACLE_HOME -s /home/oracle/123.txt -n gzrac02

5 查看补丁加载情况

[grid@gzrac01 ~]$ opatch lspatches