1.下载opatch 12.2.0.1.37 及以上的版本
su - oracle
unzip -d $ORACLE_HOME p6880880_122010_Linux-x86-64.zip
2.下载ojvm 19.20.ru,并解压
unzip -d $ORACLE_HOME p35354406_190000_Linux-x86-64.zip
3.关闭所有数据库
sql>shutdown immediate;
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.server, 19.0.0.0.0...
Patching component oracle.javavm.server.core, 19.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
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
OPatch succeeded.
5.验证
[oracle@dbserver ru]$ $ORACLE_HOME/OPatch/opatch lspatches
。。。
35354406;OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406)
。。。
OPatch succeeded.
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
Validating logfiles...done
Patch 35050341 rollback (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35050341/25148755/35050341_rollback_ORCLCDB_CDBROOT_2023Jul19_12_01_44.log (no errors)
Patch 35354406 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35354406/25255010/35354406_apply_ORCLCDB_CDBROOT_2023Jul19_12_02_34.log (no errors)
Patch 35050341 rollback (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35050341/25148755/35050341_rollback_ORCLCDB_PDBSEED_2023Jul19_12_02_35.log (no errors)
Patch 35354406 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35354406/25255010/35354406_apply_ORCLCDB_PDBSEED_2023Jul19_12_02_44.log (no errors)
SQL Patching tool complete on Wed Jul 19 12:02:46 2023
7.验证字典更新
1* select PATCH_ID,PATCH_TYPE,DESCRIPTION,ACTION,ACTION_TIME,STATUS,TARGET_VERSION from dba_registry_sqlpatch
PATCH_ID PATCH_TYPE DESCRIPTION ACTION ACTION_TIME STATUS TARGET_VERSION
---------- ---------- ------------------------------------------------------- --------------- ------------------------------ -------------------- ---------------
。。。
35050341 INTERIM OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341) ROLLBACK 19-JUL-23 12.02.44.566027 PM SUCCESS 19.20.0.0.0
35354406 INTERIM OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406) APPLY 19-JUL-23 12.02.44.579184 PM SUCCESS 19.20.0.0.0
。。。
|