Oracle 19C 单机环境升级RU(19.3升级至19.12)

2.1 当前DB版本

SYS@orcl()> set linesize 300

SYS@orcl()> select comp_id,status,version from dba_registry;

[oracle@OEL7 ~]$ sqlplus -v

SQL*Plus: Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@OEL7 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 9 06:47:53 2023

Version 19.3.0.0.0

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

2.2 升级检查

[oracle@OEL7 ~]$ cd $ORACLE_HOME

[oracle@OEL7 db_1]$ cd OPatch/

[oracle@OEL7 OPatch]$ ./opatch lspatches

29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

29517242;Database Release Update : 19.3.0.0.190416 (29517242)

 3.升级Opatch

3.1 OPatch升级

复制

[oracle@OEL7 ~]$ $ORACLE_HOME/OPatch/