本次的主要的任务是在rac数据库在线的情况下，将原有rac 19.3的库升级到19.18，主要升级组件包括grid，db，jvm三个组件。
1、组件升级顺序
gi-->db-->ojvm
2、rac节点升级顺序
rac1-->rac2
3、升级完成后，加载变化的sql到数据库（一个节点执行）
下面我们对现有的19.3 rac环境进行升级。
一、环境介绍
1、数据库版本 oracle 19c 19.3
2、操作系统版本 Orhel 7.9 x64
3、地址信息：
|
序号 |
节点名称 |
地址 |
实例 |
scan-ip |
|
1 |
rac1 |
10.10.10.11 |
orcl1 |
10.10.10.15- |
|
2 |
rac2 |
10.10.10.12 |
orcl2 |
10.10.10.19 |
4、实例名称：orcl 包含pdb 2个（pdb01,pdb02）
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
4 PDB01 READ WRITE NO
5 PDB02 READ WRITE NO
5、现有环境
[grid@rac1 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@rac1 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@rac1 ~]$ cd $ORACLE_HOME/OPatch/
[grid@rac1 OPatch]$ ./opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)
OPatch succeeded.
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL> select * from product_component_version;
PRODUCT VERSION VERSION_FU STATUS
Oracle Database 19c Enterprise 19.0.0.0.0 19.3.0.0.0 Production Edition
[oracle@rac1 OPatch]$ ./opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
6、下载19.18补丁包和升级工具
7、升级包介绍
- p6880880_190000_Linux-x86-64.zip ：本安装包用户升级Opatch工具（高版本库无法使用低版本opatch）
- p34762026_190000_Linux-x86-64.zip：本安装包用于升级gi基础设施，用于rac环境
Oracle® Database Patch 34762026 - GI Release Update 19.18.0.0.230117 (REL-JAN230131)
- p34765931_190000_Linux-x86-64.zip：本安装包用于db升级RU
Patch 34765931 - Database Release Update 19.18.0.0.230117 (REL-JAN230131)
- p34786990_190000_Linux-x86-64.zip：本安装包用于JavaJVM升级
Patch 34786990 - Oracle JavaVM Component Release Update 19.18.0.0.230117
二、升级OPatch（grid/oracle）
1、grid
[root@rac1 ~]# su - grid
Last login: Mon Jan 26 06:20:04 CST 2026 on pts/0
[grid@rac1 ~]$ cd /u01/app/19.3.0/grid/
[grid@rac1 grid]$ ls OPatch/
auto docs jre opatch opatch_env.sh operr oracle_common scripts
config emdpatch.pl modules opatchauto opatch.pl operr_readme.txt plugins version.txt
datapatch jlib ocm opatchauto.cmd opatchprereqs oplan README.txt
[grid@rac1 grid]$ cd OPatch/
[grid@rac1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17
[root@rac1 grid]# cd /u01/app/19.3.0/grid/
[root@rac1 grid]# mv OPatch/ OPatch.bak
[root@rac1 grid]# chown grid:oinstall OPatch -R
[grid@rac1 grid]$ cd OPatch
[grid@rac1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.36
OPatch succeeded.
#节点2 rac2采用相同的方式升级
2、oracle
[oracle@rac1 OPatch]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch
[oracle@rac1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[root@rac1 oracle]# chown oracle:oinstall soft/ -R
[root@rac1 oracle]# chmod 775 soft/ -R
[oracle@rac1 OPatch]$ ll /home/oracle/soft/
total 2044768
-rwxrwxr-x. 1 oracle oinstall 1843577895 Jan 26 08:45 p34765931_190000_Linux-x86-64.zip
-rwxrwxr-x. 1 oracle oinstall 125907700 Jan 26 08:45 p34786990_190000_Linux-x86-64.zip
-rwxrwxr-x. 1 oracle oinstall 124347218 Jan 26 08:56 p6880880_190000_Linux-x86-64.zip
[oracle@rac1 dbhome_1]$ mv OPatch OPatch.bak
[oracle@rac1 OPatch]$ unzip /home/oracle/soft/p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/dbhome_1/
[oracle@rac1 dbhome_1]$ cd OPatch
[oracle@rac1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.36
OPatch succeeded.
#节点2 rac2采用相同的方式升级
三、验证OPatch Inventory的有效性
1、grid
[grid@rac1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2026, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2026-01-26_09-38-32AM_1.log
Lsinventory Output file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2026-01-26_09-38-32AM.txt
...............................................................................................................................................................
OPatch succeeded.
2、oracle
[oracle@rac1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2026, Oracle Corporation. All rights reserved.
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.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-26_09-42-18AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2026-01-26_09-42-18AM.txt
..........................................................................................................................................................
OPatch succeeded.
备注：所有节点都返回SUCCESS，节点2采用同样的方法进行操作。
四、检查补丁冲突
1、grid
解压补丁文件
[grid@rac1 soft_grid]$ unzip p34762026_190000_Linux-x86-64.zip
[grid@rac1 soft_grid]$ ll
total 2928796
drwxr-x---. 8 grid oinstall 4096 Feb 1 2023 34762026
-rwxrwxr-x. 1 grid oinstall 2872741741 Jan 26 05:48 p34762026_190000_Linux-x86-64.zip
-rwxrwxr-x. 1 grid oinstall 124347218 Jan 26 05:47 p6880880_190000_Linux-x86-64.zip
-rw-rw-r--. 1 grid oinstall 1989290 Feb 1 2023 PatchSearch.xml
[grid@rac1 34762026]$ ls
33575402 34765931 34768559 34768569 34863894 automation bundle.xml README.html README.txt
[grid@rac1 34762026]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/soft_grid/34762026/33575402
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2026, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2026-01-26_09-53-16AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@rac1 34762026]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/soft_grid/34762026/34765931
[grid@rac1 34762026]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/soft_grid/34762026/34768559
[grid@rac1 34762026]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/soft_grid/34762026/34768569
[grid@rac1 34762026]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/soft_grid/34762026/34863894
2、oracle
解压DB RU补丁文件
[oracle@rac1 soft]$ unzip p34765931_190000_Linux-x86-64.zip
解压OJVM
[oracle@rac1 soft]$ unzip p34786990_190000_Linux-x86-64.zip
[oracle@rac1 soft]$ ll
total 2044780
drwxr-xr-x. 5 oracle oinstall 81 Jan 27 2023 34765931
drwxr-xr-x. 4 oracle oinstall 67 Dec 7 2022 34786990
-rwxrwxr-x. 1 oracle oinstall 1843577895 Jan 26 08:45 p34765931_190000_Linux-x86-64.zip
-rwxrwxr-x. 1 oracle oinstall 125907700 Jan 26 08:45 p34786990_190000_Linux-x86-64.zip
-rwxrwxr-x. 1 oracle oinstall 124347218 Jan 26 08:56 p6880880_190000_Linux-x86-64.zip
-rw-rw-r--. 1 oracle oinstall 10219 Jan 17 2023 PatchSearch.xml
[oracle@rac1 soft]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/soft/34765931
[oracle@rac1 soft]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/soft/34786990
备注：节点2 rac2采用同样的方式进行检查
五、运行OPatch System Space检查
1、grid
[grid@rac1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2026, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2026-01-26_10-13-55AM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
2、oracle
[oracle@rac1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile patch_list_home.txt
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2026, 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.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-26_10-16-40AM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
备注：节点2 rac2采用相同的方式检查
六、补丁冲突检测与解决
[root@rac1 soft_grid]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /home/grid/soft_grid/34762026 -analyze
OPatchauto session is initiated at Mon Jan 26 10:26:18 2026
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2026-01-26_10-26-25AM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2026-01-26_10-26-53AM.log
The id for this session is UZI4
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1
Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1
Patch applicability verified successfully on home /u01/app/19.3.0/grid
Executing patch validation checks on home /u01/app/19.3.0/grid
Patch validation checks successfully completed on home /u01/app/19.3.0/grid
Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1
OPatchAuto successful.
[root@rac1 ~]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /tmp/34765931 -analyze
OPatchauto session is initiated at Mon Jan 26 11:28:47 2026
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2026-01-26_11-28-54AM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2026-01-26_11-29-26AM.log
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /tmp/34765931
Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2026-01-26_11-30-09AM_1.log
备注：节点2 rac2采用相同方式检测
七、安装gi补丁
1、节点1 rac1
使用root账户安装
[root@rac1 tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /tmp/34762026 -oh /u01/app/19.3.0/grid
OPatchauto session is initiated at Mon Jan 26 11:35:47 2026
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2026-01-26_11-35-55AM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2026-01-26_11-36-11AM.log
The id for this session is AWGG
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Patch applicability verified successfully on home /u01/app/19.3.0/grid
Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/rac1/crsconfig/crs_postpatch_apply_inplace_rac1_2026-01-26_11-52-35AM.log
CRS service started successfully on home /u01/app/19.3.0/grid
OPatchAuto successful.
[grid@rac1 OPatch]$ ./opatch lspatches
34863894;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34863894)
34768569;ACFS RELEASE UPDATE 19.18.0.0.0 (34768569)
34768559;OCW RELEASE UPDATE 19.18.0.0.0 (34768559)
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
节点1 rac1升级过程中节点1自动进行重启，节点2正常，不受影响，升级完成后，开启节点1库，确保业务正常使用。
2、升级节点2 rac2
[root@rac2 soft_grid]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /home/grid/soft_grid/34762026 -oh /u01/app/19.3.0/grid
==Following patches were SUCCESSFULLY applied:
OPatchauto session completed at Mon Jan 26 13:45:39 2026
Time taken to complete the session 28 minutes, 40 seconds
[grid@rac2 OPatch]$ ./opatch lspatches
34863894;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34863894)
34768569;ACFS RELEASE UPDATE 19.18.0.0.0 (34768569)
34768559;OCW RELEASE UPDATE 19.18.0.0.0 (34768559)
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
八、升级db补丁
升级gi完成后，开始升级db，是从rac1-->rac2
1、节点1 rac1
停止rac1节点数据库实例，DB RU 和 OJVM都需要先停掉对应的db 实例，否则会报错
[oracle@rac1 ~]$ srvctl status instance -node rac1 -db orcl
Instance orcl1 is running on node rac1
[oracle@rac1 ~]$ srvctl stop instance -node rac1 -db orcl
[oracle@rac1 ~]$ srvctl status instance -node rac1 -db orcl
Instance orcl1 is not running on node rac1
使用root用户升级oracle RU
[root@rac1 tmp]# /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatchauto apply /tmp/34765931 -oh /u01/app/oracle/product/19.3.0/dbhome_1
升级OJVM补丁，使用oracle用户
[oracle@rac1 soft]$ cd 34786990
[oracle@rac1 34786990]$ ls
etc files README.html README.txt
[oracle@rac1 34786990]$ id
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54327(asmdba),54330(racdba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rac1 34786990]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch apply
Patch 34786990 successfully applied.
Log file location: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-26_14-52-31PM_1.log
OPatch succeeded.
[oracle@rac1 34786990]$ cd /u01/app/oracle/product/19.3.0/dbhome_1/OPatch
[oracle@rac1 OPatch]$ ./opatch lspatches
34786990;OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990)
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
备注：升级DB RU和OJVM升级完成，需要启动数据库实例，保证业务不中断，在去打rac2节点补丁
[oracle@rac1 34786990]$ srvctl start instance -d orcl -i orcl1
[oracle@rac1 34786990]$ srvctl status instance -d orcl -i orcl1
Instance orcl1 is running on node rac1
2、升级节点2 rac DB RU和OJVM
使用root用户执行
[root@rac2 ~]# /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatchauto apply /tmp/34765931 -oh /u01/app/oracle/product/19.3.0/dbhome_1
==Following patches were SUCCESSFULLY applied:
Patch: /tmp/34765931
Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2026-01-26_16-52-34PM_1.log
Patching session reported following warning(s):
[WARNING] The database instance 'orcl2' from '/u01/app/oracle/product/19.3.0/dbhome_1', in host'rac2' is not running. SQL changes, if any, will not be applied.
To apply. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle).
Refer to the readme to get the correct steps for applying the sql changes
OPatchauto session completed at Mon Jan 26 17:05:04 2026
Time taken to complete the session 15 minutes, 19 seconds
使用oracle用户升级OJVM补丁
[oracle@rac2 soft]$ ls
p34765931_190000_Linux-x86-64.zip p34786990_190000_Linux-x86-64.zip p6880880_190000_Linux-x86-64.zip
[oracle@rac2 soft]$ unzip p34786990_190000_Linux-x86-64.zip
[oracle@rac2 34786990]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch apply
Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 34786990 successfully applied.
Log file location: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-26_17-07-25PM_1.log
OPatch succeeded.
[oracle@rac2 34786990]$ cd /u01/app/oracle/product/19.3.0/dbhome_1/OPatch
[oracle@rac2 OPatch]$ ./opatch lspatches
34786990;OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990)
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
[oracle@rac2 OPatch]$ srvctl status instance -d orcl -i orcl2
Instance orcl2 is running on node rac2
九、加载SQL到数据库
注意：在rac一个节点执行即可。
[oracle@rac2 OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 26 17:17:07 2026
Version 19.18.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.18.0.0.0
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
4 PDB01 MOUNTED
5 PDB02 MOUNTED
SQL> alter pluggable database all open;
Pluggable database altered.
[oracle@rac2 OPatch]$ $ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 19.18.0.0.0 Production on Mon Jan 26 17:19:23 2026
Copyright (c) 2012, 2023, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_92089_2026_01_26_17_19_23/sqlpatch_invocation.log
如果有未打开的，需要open pdb后手工指定pdb 来加载：
$ORACLE_HOME/OPatch/datapatch -verbose -apply 34765931 -force -pdbs <pdbname>
$ORACLE_HOME/OPatch/datapatch -verbose -apply 34786990 -force -pdbs <pdbname>
十、编译无效对象
datapatch命令会加载SQL，这个过程可能会产生无效对象。
如下两种方法都可以修复无效对象，任选一个。
方法一：
[oracle@ oneoffs]$ cd $ORACLE_HOME/rdbms/admin
[oracle@ admin]$ sqlplus / as sysdba
@$ORACLE_HOME/rdbms/admin/utlrp.sql
方法二：
$ORACLE_HOME/perl/bin/perl ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d $ORACLE_HOME/rdbms/admin $ORACLE_HOME/rdbms/admin/utlrp.sql
十一、验证版本
1、GI
[grid@rac2 ~]$ /u01/app/19.3.0/grid/
Display all 100 possibilities? (y or n)
[grid@rac2 ~]$ /u01/app/19.3.0/grid/OPatch/opatch lspatches
34863894;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34863894)
34768569;ACFS RELEASE UPDATE 19.18.0.0.0 (34768569)
34768559;OCW RELEASE UPDATE 19.18.0.0.0 (34768559)
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
2、DB
[grid@rac2 ~]$ /u01/app/19.3.0/grid/
Display all 100 possibilities? (y or n)
[grid@rac2 ~]$ /u01/app/19.3.0/grid/OPatch/opatch lspatches
34863894;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34863894)
34768569;ACFS RELEASE UPDATE 19.18.0.0.0 (34768569)
34768559;OCW RELEASE UPDATE 19.18.0.0.0 (34768559)
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
[grid@rac2 ~]$ EXIT
bash: EXIT: command not found...
[grid@rac2 ~]$ exit
logout
[root@rac2 ~]# su - oracle
Last login: Mon Jan 26 18:29:10 CST 2026
[oracle@rac2 ~]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lspatches
34786990;OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990)
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
OPatch succeeded.
参考：https:///dave/article/131696
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69963467/viewspace-3109043/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
19c 单库19.3升级到19.18
下一篇：
Oracle 19c dg主备切换
请登录后发表评论
登录
全部评论
