4.安装补丁
[oracle@dbserver ru]$ $ORACLE_HOME/OPatch/opatch apply /u01/app/oracle/product/19.19.0/db_1/35354406
Oracle Interim Patch Installer version 12.2.0.1.39
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.19.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.19.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.39
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.19.0/db_1/cfgtoollogs/opatch/opatch2023-07-19_11-52-36AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 35354406
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.19.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '35354406' to OH '/u01/app/oracle/product/19.19.0/db_1'
Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 35354406 successfully applied.
Sub-set patch [35050341] has become inactive due to the application of a super-set patch [35354406].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.19.0/db_1/cfgtoollogs/opatch/opatch2023-07-19_11-52-36AM_1.log
6.更新数据字典
启动数据库
@ >conn / as sysdba
SYS@orclcdb >startup
$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose
Current state of interim SQL patches:
Interim patch 35050341 (OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)):
Binary registry: Not installed
PDB CDB$ROOT: Applied successfully on 23-JUN-23 07.13.04.967920 PM
PDB PDB$SEED: Applied successfully on 23-JUN-23 07.48.51.298990 PM
Interim patch 35354406 (OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406)):
Binary registry: Installed
PDB CDB$ROOT: Not installed
PDB PDB$SEED: Not installed
Current state of release update SQL patches:
Binary registry:
19.20.0.0.0 Release_Update 230715022800: Installed
PDB CDB$ROOT:
Applied 19.20.0.0.0 Release_Update 230715022800 successfully on 19-JUL-23 11.29.39.390732 AM
PDB PDB$SEED:
Applied 19.20.0.0.0 Release_Update 230715022800 successfully on 19-JUL-23 11.29.39.921303 AM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
The following interim patches will be rolled back:
35050341 (OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341))
No release update patches need to be installed
The following interim patches will be applied:
35354406 (OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406))
Installing patches...
Patch installation complete. Total patches installed: 4