安装 ORACLE OJVM 19.20 ru

郑全

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   
。。。