Oracle 19c 单实例 19.3.0 升级到19.11.0

1.查看当前DB环境

[oracle@db01 ~]$ cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 7.9 (Maipo)
[oracle@db01 ~]$ uname -r
3.10.0-1160.el7.x86_64
[oracle@db01 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-SEP-2021 22:16:01

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db01)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                12-SEP-2021 22:15:39
Uptime                    0 days 0 hr. 0 min. 22 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/db01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "cbcaa727be4e34eee0536438a8c036f0" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "hbhe" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
s[oracle@db01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Sep 12 22:05:25 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 HBHE                           MOUNTED
SQL> alter pluggable database hbhe open;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 HBHE                           READ WRITE NO

2从MOS下载19.6 的RU 补丁

19.11 的DB补丁是：p32545013_190000_Linux-x86-64.zip， 可以直接从MOS上下载。
解压之后查阅readme文档。

3开始安装RU补丁

3.1 检查OPatch工具版本

要安装19c的RU，OPatch 工具的版本必须大于 12.2.0.1.23。 在Oracle 19.3的版本中，OPatch版本是12.2.0.1.17的。 所以需要单独的更新OPatch。

[oracle@db01 ~]$ cd /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/
[oracle@db01 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.27
OPatch succeeded.

3.2查看OPatch是否冲突

[oracle@db01 tmp]$ unzip p32545013_190000_Linux-x86-64.zip
[oracle@db01 tmp]$ cd 32545013/
[oracle@db01 32545013]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.3.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2021-09-12_22-23-55PM_1.log