重庆思庄Oracle、Redhat认证学习论坛

标题: 19c GI 应用19.20RU [打印本页]

作者: 郑全 时间: 2023-7-19 11:20
标题: 19c GI 应用19.20RU
本帖最后由郑全于 2023-7-19 11:30 编辑

1.下载OPATCH最新的版本
  su - grid
  unzip -d $GRID_HOME/  p6880880_122010_Linux-x86-64.zip

  su - oracle
  unzip -d $ORACLE_HOME p6880880_122010_Linux-x86-64.zip

2.解压19.20ru
cd /u01/setup/ru
unzip p35319490_190000_Linux-x86-64.zip

3.打补丁
  /u01/app/19.19.0/grid/OPatch/opatchauto apply /u01/setup/ru/35319490

4.补丁验证  [grid@dbserver ~]$ cd $ORACLE_HOME/OPatch[grid@dbserver OPatch]$ ./opatch lspatches
35553096;TOMCAT RELEASE UPDATE 19.0.0.0.0 (35553096)
35332537;ACFS RELEASE UPDATE 19.20.0.0.0 (35332537)
35320149;OCW RELEASE UPDATE 19.20.0.0.0 (35320149)
35320081;Database Release Update : 19.20.0.0.230718 (35320081)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)

OPatch succeeded.

  [root@dbserver ru]# su - oracle
pw[oracle@dbserver ~]$ pwd
/home/oracle
[oracle@dbserver ~]$ cd $ORACLE_HOME/OPatch
[oracle@dbserver OPatch]$ ./opatch lspatches
35320149;OCW RELEASE UPDATE 19.20.0.0.0 (35320149)
35320081;Database Release Update : 19.20.0.0.230718 (35320081)
35050341;OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)

OPatch succeeded.

4.修改数据字典
  su - oracle
  sqlplus /as sysdba
  sql>startup
  sql>exit
  cd $ORACLE_HOME/OPatch
  ./datapatch -verbose

5.验证
1 select PATCH_ID,PATCH_TYPE,DESCRIPTION,ACTION,ACTION_TIME,STATUS,TARGET_VERSION  from dba_registry_sqlpatch
  2*

  PATCH_ID PATCH_TYPE DESCRIPTION                                           ACTION       ACTION_TIME                   STATUS             TARGET_VERSION
---------- ---------- ------------------------------------------------------- --------------- ------------------------------ -------------------- ---------------
  35050341 INTERIM OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)       APPLY          15-JUL-23 03.20.52.778803 PM SUCCESS             19.1.0.0.0
  35042068 RU       Database Release Update : 19.19.0.0.230418 (35042068) APPLY          15-JUL-23 03.20.52.765067 PM SUCCESS             19.19.0.0.0
  35320081 RU       Database Release Update : 19.20.0.0.230718 (35320081) APPLY          19-JUL-23 11.11.53.712858 AM SUCCESS             19.20.0.0.0

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)