Oracle RU23 发布了，花个把小时来玩玩

最新推荐文章于 2024-05-03 11:02:00 发布
最新推荐文章于 2024-05-03 11:02:00 发布
阅读量525 收藏 10
点赞数 10
文章标签： oracle 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jiekexu/article/details/138184414
版权

a78924bf9b5d65ba97879d19e2493176.gif

作者 | JiekeXu

来源 |公众号 JiekeXu DBA之路（ID: JiekeXu_IT）

如需转载请联系授权 | (个人微信 ID：JiekeXu_DBA)

大家好，我是 JiekeXu,江湖人称“强哥”，很高兴又和大家见面了,今天和大家一起来看看 Oracle RU23 发布了，花个把小时来玩玩，欢迎点击上方蓝字“JiekeXu DBA之路”关注我的微信公众号，标星或置顶，更多干货才能第一时间到达，谢谢！

前  言

2024 年 4 月 16 日，Oracle 2024 年第二季度 RU 补丁发布。每个季度 Oracle 发布补丁程序后都会更新 Doc ID 888.1 文档，Primary Note for Database Proactive Patch Program (Doc ID 888.1)，从 2022 年 10 月的补丁周期开始，将不再为 19.17.0 及以上版本提供 19c RUR。在 2023 年 1 月交付 Oracle Database 19c RUR 19.16.2 之后，将不再在任何平台上交付其他 RUR。有关详细信息，请参阅 19c RUR 的日落和常见问题解答（Note 2898381.1）。为了让客户更频繁地访问推荐的、经过充分测试的补丁集，Oracle 很高兴从 2022 年 11 月起推出每月推荐补丁（MRP）。MRP 仅支持 Linux x86-64 平台。MRP 可能包括与安全相关的修复。此类安全相关修复将按季度记录在下表中。有关详细信息，请参阅介绍每月推荐补丁 (MRP) 和常见问题解答（Note 2898740.1）。

另外，我的微信群社区本次限时开放，截止目前 ① 群 500 人满员，② 群三百五十多人，本次开放后后面不打算开发本群自由入群了，这两个群异常活跃，算是我见过的最活跃的微信群了，他们都太卷了，里面讨论技术闲聊人生等等，总之每天都有看不完的群消息，当然群里有行业内的一些大佬前辈，包括十几位 Oracle ACE，几位 Oracle 原厂工程师、前 Oracle 工程师，几十位 OCM、OCP 等大多数 Oracle 行业大佬，同时也邀请了几位 MySQL 大佬及 PG 大佬、PG ACE 等，感兴趣的可添加我个人微信【JiekeXu_DBA】私聊加入，注意：喷子、营销人员慎入，不然全网拉黑！

目  录
240416 补丁更新信息
    21c 21.14 RU 发布
    19c 19.23 RU 发布
RU12 升级至 RU23
    1）Oracle 上传补丁包到 /u01/soft 并解压
    2）替换 OPatch
    3) 停止应用访问、OGG、监听、数据库等
    4) 检查磁盘空间
    5) 安装 DB 补丁
    6) 安装 OCW 补丁
    7）启动数据库，执行 datapatch 脚本
    8) 查看补丁更新视图

240416 补丁更新信息

21c 21.14 RU 发布

894f964f4ea4bff2c638b0ed06c4be9f.png

19c 19.23 RU 发布

80468230f945f29cc5554451cc677c03.png

18c 自 2021 年 7 月起发布的季度补丁包受密码保护，仅适用于获得季度更新例外批准的客户。普通用户只能下载到 18.14.0.0.210420 补丁。

4643f62b7e9e02ab42005315cc60bedc.png

Oracle 12.2.0.1 自 2022 年 4 月 1 日起进入持续模式，自 2022 年 4 月起发布的季度补丁包受密码保护，仅适用于获得季度更新例外批准的客户。

3a5b27bc84ece2b298bdf8759fdba718.png

Oracle 12.1.0.2 自 2022 年 8 月 1 日起进入持续模式。2022 年 7 月之后发布的季度补丁包仅适用于获得季度更新批准的客户。

71600b258615e2fe0bb5abdd5608d188.png

数据库 11.2.0.4 自 2021 年 1 月 1 日起进入市场驱动支持 (MDS) 模式。自 2021 年 1 月起发布的季度修补程序包是受限制的 MDS 计划修补程序，详见说明 2728619.1。有关最新数据库 11.2.0.4 补丁信息的列表，请参阅 Oracle 支持说明 2285559.1。

0bfb0bf5e68c2f3ba57d245f81a0e0ea.png

11g\12c\18c 均已经 EOL。

6e0b0eaebf2bb14cdf9c086cd0f5d2da.png

RU12 升级至 RU23

打补丁的文章已经写了很多了，Oracle 19c RAC RU15 补丁更新详细步骤，想着不会在写了，但是昨天还是没忍住，下载补丁后就打了起来，还记录了文档，也可参考Oracle 19c 19.10DBRU 补丁升级看这一篇就够了，那么索性就记录一下吧,因为后期需要对生产环境打补丁 RU23，RU23 ：https://www.128，打补丁也就花费不到一个小时，但写文档得花费两个小时以上。

1）Oracle 上传补丁包到 /u01/soft 并解压

我个人更喜欢下载 “COMBO OF OJVM RU COMPONENT” 类型的补丁，“COMBO OF OJVM RU COMPONENT 19.23.0.0.240416 + GI RU 19.23.0.0.240416”补丁 36209493 包含 OJVM 36199232 和 GI 补丁包 36233126，而 GI 补丁包中又包含了 DB 补丁包 36233263。

Oracle Database Patch 36209493   - Combo of OJVM Component Release Update 19.23.0.0.240116 + Grid Infrastrusture Apr 2024 Release Update 19.23.0.0.240116

Patch 36233126 - GI Release Update 19.23.0.0.240416

In this document, Oracle Database home refers to Oracle Database Enterprise Edition and Oracle Database Standard Edition.

The GI Release Update 19.23.0.0.240416 includes updates for both the Oracle Grid Infrastructure home and Oracle Database home that can be applied in a rolling fashion.

63d03cbdaec706d4321a535b5b516813.png

3994a7a931eb4d65c2c1a279ca885aa2.png

jiekexu-t1:/u01/soft(jiekexu)$ pwd
/u01/soft


jiekexu-t1:/u01/soft(jiekexu)$ ls -lrt *.zip
total 10413296
-rw-r--r--  1 oracle oinstall 1319414278 Jan  6  2023 p31718723_112040_Linux-x86-64.zip
-rw-r--r--  1 oracle oinstall 3558403835 Apr 17 17:37 p36209493_190000_Linux-x86-64.zip
-rw-r--r--  1 oracle oinstall  133535622 Apr 17 17:37 p6880880_190000_Linux-x86-64.zip


jiekexu-t1:/u01/soft(jiekexu)$ unzip p6880880_190000_Linux-x86-64.zip 
Archive:  p6880880_190000_Linux-x86-64.zip
   creating: OPatch/
  inflating: OPatch/opatchauto       
   creating: OPatch/ocm/
   creating: OPatch/ocm/doc/
   creating: OPatch/ocm/bin/
   creating: OPatch/ocm/lib/
 extracting: OPatch/ocm/generic.zip  
  inflating: OPatch/datapatch.bat    
  inflating: OPatch/emdpatch.pl      
 extracting: OPatch/version.txt      
   creating: OPatch/private/
  inflating: OPatch/private/commons-compress-1.26.0.jar  
  inflating: OPatch/private/jaxb-api-2.2.3.jar  
  inflating: OPatch/private/commons-io-2.15.1.jar  
  inflating: OPatch/opatchauto.cmd   
   creating: OPatch/oplan/ 
-----省略中间部分------
  inflating: OPatch/modules/features/com.oracle.glcm.patch.opatch-common-api-classpath.jar  
  inflating: OPatch/modules/com.sun.org.apache.xml.internal.resolver.jar  
  inflating: OPatch/modules/com.oracle.glcm.patch.opatchauto-wallet_12.2.1.42.0.jar  
  inflating: OPatch/modules/com.sun.xml.bind.jaxb-jxc.jar  
  inflating: OPatch/modules/javax.activation.javax.activation.jar  
jiekexu-t1:/u01/soft(jiekexu)$ ls -lrt
total 10413300
-rw-r--r--  1 oracle oinstall 1319414278 Jan  6  2023 p31718723_112040_Linux-x86-64.zip
drwxr-x--- 15 oracle oinstall       4096 Apr 15 18:41 OPatch
-rw-r--r--  1 oracle oinstall 3558403835 Apr 17 17:37 p36209493_190000_Linux-x86-64.zip
-rw-r--r--  1 oracle oinstall  133535622 Apr 17 17:37 p6880880_190000_Linux-x86-64.zip
jiekexu-t1:/u01/soft(jiekexu)$ unzip p36209493_190000_Linux-x86-64.zip 
Archive:  p36209493_190000_Linux-x86-64.zip
   creating: 36209493/
   creating: 36209493/36233126/
   creating: 36209493/36233126/36240578/
   creating: 36209493/36233126/36240578/files/
   creating: 36209493/36233126/36240578/files/bin/
-----省略中间部分------
  inflating: 36209493/36233126/36233263/files/lib/xmlparserv2_sans_jaxp_services.jar/oracle/xml/parser/schema/XSDValidator$1.class  


jiekexu-t1:/u01/soft(jiekexu)$ ls -lrt 
total 10414452
-rw-r--r--  1 oracle oinstall 1319414278 Jan  6  2023 p31718723_112040_Linux-x86-64.zip
drwxr-x--- 15 oracle oinstall       4096 Apr 15 18:41 OPatch
drwxrwxrwx  4 oracle oinstall         80 Apr 16 18:29 36209493
-rw-rw-r--  1 oracle oinstall    2410549 Apr 16 22:23 PatchSearch.xml
-rw-r--r--  1 oracle oinstall 3558403835 Apr 17 17:37 p36209493_190000_Linux-x86-64.zip
-rw-r--r--  1 oracle oinstall  133535622 Apr 17 17:37 p6880880_190000_Linux-x86-64.zip
jiekexu-t1:/u01/soft(jiekexu)$ tree -L 2 36209493
36209493
|-- 36199232
|   |-- etc
|   |-- files
|   |-- README.html
|   `-- README.txt
|-- 36233126
|   |-- 36233263
|   |-- 36233343
|   |-- 36240578
|   |-- 36383196
|   |-- 36460248
|   |-- automation
|   |-- bundle.xml
|   |-- README.html
|   `-- README.txt
|-- PatchSearch.xml
`-- README.html


10 directories, 7 files

2） 替换 OPatch

OPatch 工具必须在 12.2.0.1.41 及以上版本才可用，这里下载最新的 12.2.0.1.42 版本，必须要有 MOS 账号才可以哦。
https://updates.oracle.com/download/6880880.html

c2567c2c5668fe437be22a940081e41c.png

jiekexu-t1:/u01/soft(jiekexu)$ cd $ORACLE_HOME
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1(jiekexu)$ ls
??[0m       bin          crs  data       demo         env.ora  instantclient  jdk   log      nls     OPatch_12.17  ord   owm      QOpatch  relnotes       root.sh.old.2  sdk           sqlpatch  ucp  xdk
addnode     cfgtoollogs  css  dbjava     diagnostics  has      inventory      jlib  md       odbc    opmn          ords  perl     R        root.sh        root.sh.old.3  slax          sqlplus   usm
apex        client       ctx  dbs        drdaas       hs       javavm         ldap  mgw      olap    oracore       oss   plsql    racg     root.sh.old    runInstaller   sqldeveloper  srvm      utl
assistants  clone        cv   deinstall  dv           install  jdbc           lib   network  OPatch  oraInst.loc   oui   precomp  rdbms    root.sh.old.1  schagent.conf  sqlj          suptools  wwg
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1(jiekexu)$ 
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1(jiekexu)$ 
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1(jiekexu)$ ll OPatch
total 156
drwxr-x--- 7 oracle oinstall    83 Apr  1  2022 auto
drwxr-x--- 2 oracle oinstall    31 Apr  1  2022 config
-rwxr-x--- 1 oracle oinstall   589 Apr  1  2022 datapatch
-rwxr-x--- 1 oracle oinstall   627 Apr  1  2022 datapatch.bat
drwxr-x--- 2 oracle oinstall    90 Apr  1  2022 docs
-rwxr-x--- 1 oracle oinstall 23550 Apr  1  2022 emdpatch.pl
drwxr-x--- 2 oracle oinstall  4096 Apr  1  2022 jlib
drwxr-x--- 6 oracle oinstall   198 Apr  1  2022 jre
drwxr-x--- 9 oracle oinstall  4096 Apr  1  2022 modules
drwxr-x--- 5 oracle oinstall    58 Apr  1  2022 ocm
-rwxr-x--- 1 oracle oinstall 50108 Apr  1  2022 opatch
-rwxr-x--- 1 oracle oinstall  1763 Apr  1  2022 opatchauto
-rwxr-x--- 1 oracle oinstall   393 Apr  1  2022 opatchauto.cmd
-rwxr-x--- 1 oracle oinstall 16554 Apr  1  2022 opatch.bat
-rwxr-x--- 1 oracle oinstall  4290 Apr  1  2022 opatch_env.sh
-rw-r----- 1 oracle oinstall  2551 Apr  1  2022 opatch.pl
drwxr-x--- 4 oracle oinstall    62 Apr  1  2022 opatchprereqs
-rwxr-x--- 1 oracle oinstall  3159 Apr  1  2022 operr
-rwxr-x--- 1 oracle oinstall  4218 Apr  1  2022 operr.bat
-rw-r----- 1 oracle oinstall  3177 Apr  1  2022 operr_readme.txt
drwxr-x--- 2 oracle oinstall    19 Apr  1  2022 oplan
drwxr-x--- 3 oracle oinstall    21 Apr  1  2022 oracle_common
drwxr-x--- 3 oracle oinstall    24 Apr  1  2022 plugins
drwxr-xr-x 2 oracle oinstall    39 Apr  1  2022 private
-rw-r----- 1 oracle oinstall  2980 Apr  1  2022 README.txt
drwxr-x--- 2 oracle oinstall   170 Apr  1  2022 scripts
-rw-r----- 1 oracle oinstall    27 Apr  1  2022 version.txt
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1(jiekexu)$ cat OPatch/version.txt 
OPATCH_VERSION:12.2.0.1.25
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1(jiekexu)$ mv OPatch OPatch_12.25
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1(jiekexu)$ cp -r /u01/soft/OPatch ./
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1(jiekexu)$ opatch version
OPatch Version: 12.2.0.1.42


OPatch succeeded.
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1(jiekexu)$ cd
3) 停止应用访问、OGG、监听、数据库等
jiekexu-t1:/home/oracle(jiekexu)$ lsnrctl stop


LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-APR-2024 17:44:39


Copyright (c) 1991, 2021, Oracle.  All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jiekexu-t1)(PORT=1521)))
The command completed successfully
jiekexu-t1:/home/oracle(jiekexu)$ sys


SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 17 17:44:43 2024
Version 19.12.0.0.0


Copyright (c) 1982, 2021, Oracle.  All rights reserved.




Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0


17:44:44 SYS@jiekexu> shu immediate 
Database closed.
Database dismounted.
ORACLE instance shut down.
17:45:22 SYS@jiekexu> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
jiekexu-t1:/home/oracle(jiekexu)$ cd /u01/soft/
jiekexu-t1:/u01/soft(jiekexu)$ ll
jiekexu-t1:/u01/soft(jiekexu)$ ps -ef | grep ogg
oracle   23109 19874  0 17:46 pts/0    00:00:00 grep --color=auto ogg
jiekexu-t1:/u01/soft(jiekexu)$ ps -ef | grep ext
oracle   23117 19874  0 17:46 pts/0    00:00:00 grep --color=auto ext
jiekexu-t1:/u01/soft(jiekexu)$ ls -lrt 
-rw-r--r--  1 oracle oinstall 1319414278 Jan  6  2023 p31718723_112040_Linux-x86-64.zip
drwxr-x--- 15 oracle oinstall       4096 Apr 15 18:41 OPatch
drwxrwxrwx  4 oracle oinstall         80 Apr 16 18:29 36209493
-rw-rw-r--  1 oracle oinstall    2410549 Apr 16 22:23 PatchSearch.xml
-rw-r--r--  1 oracle oinstall 3558403835 Apr 17 17:37 p36209493_190000_Linux-x86-64.zip
-rw-r--r--  1 oracle oinstall  133535622 Apr 17 17:37 p6880880_190000_Linux-x86-64.zip
jiekexu-t1:/u01/soft(jiekexu)$ cd 36209493
jiekexu-t1:/u01/soft/36209493(jiekexu)$ ll
total 40
drwxr-xr-x 4 oracle oinstall    67 Mar 13 08:07 36199232
drwxr-x--- 8 oracle oinstall   159 Apr 12 18:03 36233126
-rw-rw-r-- 1 oracle oinstall 13912 Apr 16 17:01 PatchSearch.xml
-rw-rw-r-- 1 oracle oinstall 22575 Apr 16 21:39 README.html
jiekexu-t1:/u01/soft/36209493(jiekexu)$ cd /u01/soft/36209493/36233126/36233263
jiekexu-t1:/u01/soft/36209493/36233126/36233263(jiekexu)$ 
jiekexu-t1:/u01/soft/36209493/36233126/36233263(jiekexu)$ ll
total 100
drwxr-x---  3 oracle oinstall    21 Apr 12 18:04 custom
drwxr-x---  3 oracle oinstall    20 Apr 12 18:04 etc
drwxr-x--- 45 oracle oinstall  4096 Apr 12 18:04 files
-rw-rw-r--  1 oracle oinstall 90295 Apr 16 21:39 README.html
-rw-r--r--  1 oracle oinstall    21 Apr 12 18:08 README.txt
jiekexu-t1:/u01/soft/36209493/36233126/36233263(jiekexu)$ cd /u01/soft/36209493/36233126/        
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$ ll
total 152
drwxr-x--- 5 oracle oinstall     81 Apr 12 18:04 36233263
drwxr-x--- 5 oracle oinstall     62 Apr 12 18:03 36233343
drwxr-x--- 5 oracle oinstall     62 Apr 12 18:03 36240578
drwxr-x--- 4 oracle oinstall     48 Apr 12 18:04 36383196
drwxr-x--- 4 oracle oinstall     48 Apr 12 18:04 36460248
drwxr-x--- 2 oracle oinstall   4096 Apr 12 18:08 automation
-rw-rw-r-- 1 oracle oinstall   5824 Apr 12 18:44 bundle.xml
-rw-rw-r-- 1 oracle oinstall 139790 Apr 16 21:39 README.html
-rw-r--r-- 1 oracle oinstall      0 Apr 12 18:08 README.txt
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$ ll 36233263
total 100
drwxr-x---  3 oracle oinstall    21 Apr 12 18:04 custom
drwxr-x---  3 oracle oinstall    20 Apr 12 18:04 etc
drwxr-x--- 45 oracle oinstall  4096 Apr 12 18:04 files
-rw-rw-r--  1 oracle oinstall 90295 Apr 16 21:39 README.html
-rw-r--r--  1 oracle oinstall    21 Apr 12 18:08 README.txt
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$ 
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$ ll 36240578
total 192
drwxr-x---  3 oracle oinstall     21 Apr 12 18:03 custom
drwxr-x---  3 oracle oinstall     20 Apr 12 18:03 etc
drwxr-x--- 21 oracle oinstall    234 Apr 12 18:03 files
-rw-r--r--  1 oracle oinstall 192698 Apr 12 18:03 README.txt
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$ cd /u01/soft/36209493/36233126/36233263
jiekexu-t1:/u01/soft/36209493/36233126/36233263(jiekexu)$ 
jiekexu-t1:/u01/soft/36209493/36233126/36233263(jiekexu)$ 
jiekexu-t1:/u01/soft/36209493/36233126/36233263(jiekexu)$ ll
total 100
drwxr-x---  3 oracle oinstall    21 Apr 12 18:04 custom
drwxr-x---  3 oracle oinstall    20 Apr 12 18:04 etc
drwxr-x--- 45 oracle oinstall  4096 Apr 12 18:04 files
-rw-rw-r--  1 oracle oinstall 90295 Apr 16 21:39 README.html
-rw-r--r--  1 oracle oinstall    21 Apr 12 18:08 README.txt
4) 检查磁盘空间

安装 Oracle 补丁，直接读 /u01/soft/36209493/36233126 文件夹下的 README.html 就行，补丁冲突检测，磁盘空间检测呀详细信息可以查看。

For Oracle home, as home user:


    Create file /tmp/patch_list_dbhome.txt with the following content:


    % cat /tmp/patch_list_dbhome.txt
    <UNZIPPED_PATCH_LOCATION>/36233126/36233263
    <UNZIPPED_PATCH_LOCATION>/36233126/36240578


    Run OPatch command to check if enough free space is available in the Oracle home:


    % $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt




--补丁冲突检测，我这里没有安装其他小补丁，只有一个 RU12 的补丁集，不存在补丁冲突的问题。
For Oracle home, as home user:


% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/36233126/36233263
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/36233126/36240578
我这里是单机环境，安装在根目录，还有 45G 的磁盘空间足够了。
jiekexu-t1:/u01/soft/36209493/36233126/36233263(jiekexu)$ df -h
Filesystem                 Size  Used Avail Use% Mounted on
/dev/mapper/rootvg-lvroot  392G  347G   45G  89% /
devtmpfs                   7.8G     0  7.8G   0% /dev
tmpfs                      7.8G   52K  7.8G   1% /dev/shm
tmpfs                      7.8G   17M  7.8G   1% /run
tmpfs                      7.8G     0  7.8G   0% /sys/fs/cgroup
/dev/sda1                 1014M  190M  825M  19% /boot
tmpfs                      1.6G     0  1.6G   0% /run/user/0
5) 安装 DB 补丁
jiekexu-t1:/u01/soft/36209493/36233126/36233263(jiekexu)$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation.  All rights reserved.




Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-04-17_17-49-33PM_1.log


Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   36233263  


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.0.0/dbhome_1')




Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '36233263' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms.rsf, 19.0.0.0.0...


Patching component oracle.rdbms.util, 19.0.0.0.0...


Patching component oracle.rdbms, 19.0.0.0.0...


Patching component oracle.assistants.acf, 19.0.0.0.0...


Patching component oracle.assistants.deconfig, 19.0.0.0.0...


Patching component oracle.assistants.server, 19.0.0.0.0...


Patching component oracle.blaslapack, 19.0.0.0.0...


Patching component oracle.buildtools.rsf, 19.0.0.0.0...


Patching component oracle.ctx, 19.0.0.0.0...


Patching component oracle.dbdev, 19.0.0.0.0...


Patching component oracle.dbjava.ic, 19.0.0.0.0...


Patching component oracle.dbjava.jdbc, 19.0.0.0.0...


Patching component oracle.dbjava.ucp, 19.0.0.0.0...


Patching component oracle.duma, 19.0.0.0.0...


Patching component oracle.javavm.client, 19.0.0.0.0...


Patching component oracle.ldap.owm, 19.0.0.0.0...


Patching component oracle.ldap.rsf, 19.0.0.0.0...


Patching component oracle.ldap.security.osdt, 19.0.0.0.0...


Patching component oracle.marvel, 19.0.0.0.0...


Patching component oracle.network.rsf, 19.0.0.0.0...


Patching component oracle.odbc.ic, 19.0.0.0.0...


Patching component oracle.ons, 19.0.0.0.0...


Patching component oracle.ons.ic, 19.0.0.0.0...


Patching component oracle.oracore.rsf, 19.0.0.0.0...


Patching component oracle.perlint, 5.28.1.0.0...


Patching component oracle.precomp.common.core, 19.0.0.0.0...


Patching component oracle.precomp.rsf, 19.0.0.0.0...


Patching component oracle.rdbms.crs, 19.0.0.0.0...


Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...


Patching component oracle.rdbms.deconfig, 19.0.0.0.0...


Patching component oracle.rdbms.oci, 19.0.0.0.0...


Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...


Patching component oracle.rdbms.scheduler, 19.0.0.0.0...


Patching component oracle.rhp.db, 19.0.0.0.0...


Patching component oracle.rsf, 19.0.0.0.0...


Patching component oracle.sdo, 19.0.0.0.0...


Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...


Patching component oracle.sqlplus, 19.0.0.0.0...


Patching component oracle.sqlplus.ic, 19.0.0.0.0...


Patching component oracle.wwg.plsql, 19.0.0.0.0...


Patching component oracle.xdk.rsf, 19.0.0.0.0...


Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...


Patching component oracle.ldap.client, 19.0.0.0.0...


Patching component oracle.rdbms.rman, 19.0.0.0.0...


Patching component oracle.rdbms.dv, 19.0.0.0.0...


Patching component oracle.xdk.parser.java, 19.0.0.0.0...


Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...


Patching component oracle.oraolap.api, 19.0.0.0.0...


Patching component oracle.javavm.server, 19.0.0.0.0...


Patching component oracle.mgw.common, 19.0.0.0.0...


Patching component oracle.xdk, 19.0.0.0.0...


Patching component oracle.odbc, 19.0.0.0.0...


Patching component oracle.xdk.xquery, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...


Patching component oracle.rdbms.lbac, 19.0.0.0.0...


Patching component oracle.network.client, 19.0.0.0.0...


Patching component oracle.network.listener, 19.0.0.0.0...


Patching component oracle.install.deinstalltool, 19.0.0.0.0...


Patching component oracle.ctx.atg, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...


Patching component oracle.rdbms.install.common, 19.0.0.0.0...


Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...


Patching component oracle.sdo.locator, 19.0.0.0.0...


Patching component oracle.rdbms.drdaas, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...


Patching component oracle.oraolap, 19.0.0.0.0...


Patching component oracle.ovm, 19.0.0.0.0...


Patching component oracle.rdbms.hs_common, 19.0.0.0.0...


Patching component oracle.ctx.rsf, 19.0.0.0.0...


Patching component oracle.dbtoolslistener, 19.0.0.0.0...


Patching component oracle.ldap.ssl, 19.0.0.0.0...


Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...


Patching component oracle.precomp.common, 19.0.0.0.0...


Patching component oracle.precomp.lang, 19.0.0.0.0...


Patching component oracle.jdk, 1.8.0.201.0...
Patch 36233263 successfully applied.
Sub-set patch [32904851] has become inactive due to the application of a super-set patch [36233263].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-04-17_17-49-33PM_1.log


OPatch succeeded.


jiekexu-t1:/u01/soft/36209493/36233126/36233263(jiekexu)$ cd ..
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$ ll
total 152
drwxr-x--- 5 oracle oinstall     81 Apr 12 18:04 36233263
drwxr-x--- 5 oracle oinstall     62 Apr 12 18:03 36233343
drwxr-x--- 5 oracle oinstall     62 Apr 12 18:03 36240578
drwxr-x--- 4 oracle oinstall     48 Apr 12 18:04 36383196
drwxr-x--- 4 oracle oinstall     48 Apr 12 18:04 36460248
drwxr-x--- 2 oracle oinstall   4096 Apr 12 18:08 automation
-rw-rw-r-- 1 oracle oinstall   5824 Apr 12 18:44 bundle.xml
-rw-rw-r-- 1 oracle oinstall 139790 Apr 16 21:39 README.html
-rw-r--r-- 1 oracle oinstall      0 Apr 12 18:08 README.txt
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$ ls -lrt 
total 152
drwxr-x--- 5 oracle oinstall     62 Apr 12 18:03 36240578
drwxr-x--- 5 oracle oinstall     62 Apr 12 18:03 36233343
drwxr-x--- 4 oracle oinstall     48 Apr 12 18:04 36460248
drwxr-x--- 4 oracle oinstall     48 Apr 12 18:04 36383196
drwxr-x--- 5 oracle oinstall     81 Apr 12 18:04 36233263
-rw-r--r-- 1 oracle oinstall      0 Apr 12 18:08 README.txt
drwxr-x--- 2 oracle oinstall   4096 Apr 12 18:08 automation
-rw-rw-r-- 1 oracle oinstall   5824 Apr 12 18:44 bundle.xml
-rw-rw-r-- 1 oracle oinstall 139790 Apr 16 21:39 README.html
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$
6) 安装 OCW 补丁
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$ ll
total 152
drwxr-x--- 5 oracle oinstall     81 Apr 12 18:04 36233263
drwxr-x--- 5 oracle oinstall     62 Apr 12 18:03 36233343
drwxr-x--- 5 oracle oinstall     62 Apr 12 18:03 36240578
drwxr-x--- 4 oracle oinstall     48 Apr 12 18:04 36383196
drwxr-x--- 4 oracle oinstall     48 Apr 12 18:04 36460248
drwxr-x--- 2 oracle oinstall   4096 Apr 12 18:08 automation
-rw-rw-r-- 1 oracle oinstall   5824 Apr 12 18:44 bundle.xml
-rw-rw-r-- 1 oracle oinstall 139790 Apr 16 21:39 README.html
-rw-r--r-- 1 oracle oinstall      0 Apr 12 18:08 README.txt
jiekexu-t1:/u01/soft/36209493/36233126(jiekexu)$ cd 36240578
jiekexu-t1:/u01/soft/36209493/36233126/36240578(jiekexu)$ ll
total 192
drwxr-x---  3 oracle oinstall     21 Apr 12 18:03 custom
drwxr-x---  3 oracle oinstall     20 Apr 12 18:03 etc
drwxr-x--- 21 oracle oinstall    234 Apr 12 18:03 files
-rw-r--r--  1 oracle oinstall 192698 Apr 12 18:03 README.txt
jiekexu-t1:/u01/soft/36209493/36233126/36240578(jiekexu)$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation.  All rights reserved.




Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-04-17_18-06-00PM_1.log


Verifying environment and performing prerequisite checks...


--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...


Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation.  All rights reserved.




Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-04-17_18-11-46PM_1.log


Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   36240578  


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.0.0/dbhome_1')




Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '36240578' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.xag, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] , [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms, 19.0.0.0.0...


Patching component oracle.has.rsf, 19.0.0.0.0...


Patching component oracle.has.db, 19.0.0.0.0...


Patching component oracle.rhp.db, 19.0.0.0.0...


Patching component oracle.has.db.cvu, 19.0.0.0.0...


Patching component oracle.has.common, 19.0.0.0.0...


Patching component oracle.has.common.cvu, 19.0.0.0.0...


Patching component oracle.rhp.common, 19.0.0.0.0...
Patch 36240578 successfully applied.
Sub-set patch [32916816] has become inactive due to the application of a super-set patch [36240578].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-04-17_18-11-46PM_1.log


OPatch succeeded.

7）启动数据库，执行 datapatch 脚本

建议使用：datapatch -sanity_checks 可选步骤会运行一系列环境和数据库检查，以验证修补条件是否最佳。结果会显示在屏幕上，并说明严重程度和可能采取的措施。有关更多信息和操作，请参阅 Oracle 支持文档 2680521.1 Datapatch 用户指南。Oracle 强烈建议您执行此步骤。

然后，datapatch 实用程序将运行必要的应用脚本，将修改后的 SQL 文件加载到数据库中。dba_registry_sqlpatch 视图中将添加一个条目，以反映补丁应用程序。在 dba_registry_sqlpatch 视图中，验证 APPLY 的状态是否为 SUCCESS。对于任何其他状态，请参阅 Oracle 支持文档 2335899.2 Troubleshooting Assistant: 12c Datapatch Issues，了解更多信息和操作。

检查 $ORACLE_BASE/cfgtoollogs/sqlpatch/36233263/ 中的下列日志文件是否有错误：

36233263_apply_.log

其中，数据库 SID 是数据库 SID，CDB 名称是多租户容器数据库的名称，时间戳的形式是 YYYYMMMDD_HH_MM_SS。

如果任何（可插拔）数据库在执行 datapatch 后出现无效对象，则应运行 catcon.pl 重新验证这些对象。例如

export PATH=$PATH:$ORACLE_HOME/bin
cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql
jiekexu-t1:/u01/soft/36209493/36233126/36240578(jiekexu)$ sys


SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 17 18:24:42 2024
Version 19.23.0.0.0


Copyright (c) 1982, 2023, Oracle.  All rights reserved.


Connected to an idle instance.


18:24:43 SYS@jiekexu> 
18:24:44 SYS@jiekexu> 
18:24:44 SYS@jiekexu> startup
ORACLE instance started.


Total System Global Area 6878655856 bytes
Fixed Size                  8955248 bytes
Variable Size            4143972352 bytes
Database Buffers         2717908992 bytes
Redo Buffers                7819264 bytes
Database mounted.
Database opened.
18:25:24 SYS@jiekexu> 
18:25:26 SYS@jiekexu> 
18:25:26 SYS@jiekexu> !opatch lspatches
36240578;OCW RELEASE UPDATE 19.23.0.0.0 (36240578)
36233263;Database Release Update : 19.23.0.0.240416 (36233263)
32876380;OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)


OPatch succeeded.


18:26:30 SYS@jiekexu> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
jiekexu-t1:/u01/soft/36209493/36233126/36240578(jiekexu)$ cd $ORACLE_HOME/OPatch
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1/OPatch(jiekexu)$ ll datapatch*
total 15
-rwxr-x--- 1 oracle oinstall   589 Apr 17 17:44 datapatch
-rwxr-x--- 1 oracle oinstall   627 Apr 17 17:44 datapatch.bat
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1/OPatch(jiekexu)$ ./datapatch -sanity_checks           
SQL Patching sanity checks version 19.23.0.0.0 on Wed 17 Apr 2024 06:27:18 PM CST
Copyright (c) 2021, 2024, Oracle.  All rights reserved.


Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20240417_182718_31257/sanity_checks_20240417_182718_31257.log


Running checks
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 942.
Use of uninitialized value $pdb in hash element at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 946.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 942.
Use of uninitialized value $pdb in hash element at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 946.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 942.
Use of uninitialized value $pdb in hash element at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 946.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.0.0/dbhome_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
JSON report generated in /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20240417_182718_31257/sqlpatch_sanity_checks_summary.json file
Checks completed. Printing report:


Check: Database component status - INFO
  There should be no INVALID components prior patching due to risk of potential errors.
  Listed components have a non-valid status.
  Run '?/rdbms/admin/utlrp.sql' (per container) to try recompiling invalid objects and restore component status.
  :
    | COMPONENT | STATUS  |
    |-----------+---------|
    |    SDO    | LOADING |
    |-----------+---------|
Check: PDB Violations - OK
Check: Invalid System Objects - WARNING
  There should be no INVALID objects in Oracle-maintained schemas before patching.
  The following number of objects are INVALID (per container).
  Run '?/rdbms/admin/utlrp.sql' (per container) to try recompiling invalid objects.
  :
    | OBJECT_COUNT |
    |--------------|
    |      9       |
    |--------------|
Check: Tablespace Status - OK
Check: Backup jobs - OK
Check: Temp file exists - OK
Check: Temp file online - OK
Check: Data Pump running - OK
Check: Container status - OK
Check: Oracle Database Keystore - OK
Check: Dictionary statistics gathering - OK
Check: Scheduled Jobs - OK
Check: GoldenGate triggers - WARNING
  Datapatch execution may fail with ORA- errors when Oracle GoldenGate triggers are enabled in the database.
  At least one GoldenGate trigger is enabled in the database.
  Refer to MOS Note 2301658.1 on how to disable listed trigger(s) before patching.
  :
    | STATUS  |      TRIGGER_NAME      |
    |---------+------------------------|
    | ENABLED | GGS_DDL_TRIGGER_BEFORE |
    |---------+------------------------|
Check: Logminer DDL triggers - OK
Check: Check sys public grants - OK
Check: Statistics gathering running - OK
Check: Optim dictionary upgrade parameter - OK
Check: Symlinks on oracle home path - OK
Check: Central Inventory - OK
Check: Queryable Inventory dba directories - OK
Check: Queryable Inventory locks - OK
Check: Queryable Inventory package - OK
Check: Queryable Inventory external table - OK
Check: Imperva processes - OK
Check: Guardium processes - OK
Check: Locale - OK


Refer to MOS Note 2680521.1 and debug log
/u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20240417_182718_31257/sanity_checks_debug_20240417_182718_31257.log


SQL Patching sanity checks completed on Wed 17 Apr 2024 06:28:41 PM CST
jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1/OPatch(jiekexu)$


jiekexu-t1:/u01/app/oracle/product/19.0.0/dbhome_1/OPatch(jiekexu)$ ./datapatch -verbose
SQL Patching tool version 19.23.0.0.0 Production on Wed Apr 17 18:34:57 2024
Copyright (c) 2012, 2024, Oracle.  All rights reserved.


Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_535_2024_04_17_18_34_57/sqlpatch_invocation.log


Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done


Current state of interim SQL patches:
Interim patch 32876380 (OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)):
  Binary registry: Installed
  SQL registry: Applied successfully on 01-APR-22 02.40.11.251757 PM


Current state of release update SQL patches:
  Binary registry:
    19.23.0.0.0 Release_Update 240406004238: Installed
  SQL registry:
    Applied 19.12.0.0.0 Release_Update 210716141810 successfully on 01-APR-22 02.40.11.224643 PM


Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 36233263 (Database Release Update : 19.23.0.0.240416 (36233263)):
    Apply from 19.12.0.0.0 Release_Update 210716141810 to 19.23.0.0.0 Release_Update 240406004238
  No interim patches need to be applied


Installing patches...
Patch installation complete.  Total patches installed: 1


Validating logfiles...done
Patch 36233263 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36233263/25638263/36233263_apply_TESTOGG_2024Apr17_18_37_29.log (no errors)
SQL Patching tool complete on Wed Apr 17 19:01:28 2024
8) 查看补丁更新视图
col ACTION_TIME for a30
col DESCRIPTION for a55
select patch_id, action,status,action_time,description  from dba_registry_sqlpatch;
  PATCH_ID ACTION          STATUS                    ACTION_TIME                    DESCRIPTION
---------- --------------- ------------------------- ------------------------------ -------------------------------------------------------
  29517242 APPLY           SUCCESS                   13-JUL-21 08.09.15.437183 PM   Database Release Update : 19.3.0.0.190416 (29517242)
  32876380 APPLY           SUCCESS                   01-APR-22 02.40.11.251757 PM   OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)
  32904851 APPLY           SUCCESS                   01-APR-22 02.40.11.224643 PM   Database Release Update : 19.12.0.0.210720 (32904851)
  36233263 APPLY           SUCCESS                   17-APR-24 06.59.37.027240 PM   Database Release Update : 19.23.0.0.240416 (36233263)
19:20:24 SYS@jiekexu> !opatch lspatches 
36240578;OCW RELEASE UPDATE 19.23.0.0.0 (36240578)
36233263;Database Release Update : 19.23.0.0.240416 (36233263)
32876380;OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)    --OJVM 我这里没有更新


OPatch succeeded.

41ce0311b735ccbf2eeaa6d7aa932bbc.png

其他补丁相关文章链接：

https://mp.weixin.qq.com/s/2DoBV-8PsoYENgwM3BAIaQ
https://mp.weixin.qq.com/s/zS4aE3TfhbMwDk37nIEGfg
https://mp.weixin.qq.com/s/C0YbdGs2SVxqDuTm1g83fw
https://mp.weixin.qq.com/s/0jPYvtfFezGLhq-S-9RqGQ
https://mp.weixin.qq.com/s/Q45cfsRz1Oa4dSzi8_2Ktg
https://mp.weixin.qq.com/s/VGyb-UjbI1IFo1llEfVduQ
https://www.modb.pro/db/27255
https://www.modb.pro/doc/1602
https://www.modb.pro/doc/4638
https://www.modb.pro/download/39727

全文完，希望可以帮到正在阅读的你，如果觉得有帮助，可以分享给你身边的朋友，同事，你关心谁就分享给谁，一起学习共同进步~~~

❤️ 欢迎关注我的公众号【JiekeXu DBA之路】，一起学习新知识！

————————————————————————————
公众号：JiekeXu DBA之路
墨天轮：https://www.modb.pro/u/4347
CSDN ：https://blog.csdn.net/JiekeXu
ITPUB：https://blog.itpub.net/69968215
腾讯云：https://cloud.tencent.com/developer/user/5645107
————————————————————————————

ab2d4024cd7dec48de3faa7d13ac8d2c.gif

分享几个数据库备份脚本

一文搞懂 Oracle 统计信息
 
 
我的 Oracle ACE 心路历程
 
 
Oracle 主流版本不同架构下的静默安装指南
 
 
 
 
关机重启导致 ASM 磁盘丢失数据库无法启动
 
 
Oracle SQL 性能分析(SPA)原理与实战演练
 
 
 
 
Oracle 11g 升级到 19c 需要关注的几个问题
 
 
Windows 10 环境下 MySQL 8.0.33 安装指南
 
 
SQL 大全（四）|数据库迁移升级时常用 SQL 语句
 
 
OGG|使用 OGG19c 迁移 Oracle11g 到 19C(第二版)
 
 
Oracle 大数据量导出工具——sqluldr2 的安装与使用
 
 
从国产数据库调研报告中你都能了解哪些信息及我的总结建议
 
 
使用数据泵利用 rowid 分片导出导入 lob 大表及最佳实践
 
 
在归档模式下直接 rm dbf 数据文件并重启数据库还有救吗？
 
 
c7a0efb219cdb3a3d3c2ef6ca82ae9ed.png
 


                

        

        

    




    

      

        

            

              
                
                  JiekeXu
                
              
            

            

                关注
              
            

        

        

          
    
            
  • 
              
                
                
                
                
                    10
                
              
              
    点赞
    
            
    • 
            
  • 
              
                
                
                
              
              
    踩
    
            
    • 
            
  • 
              
                
                
                
                
                    10
                
              
              
    
                
    
                  
                    收藏
                  
                
    
              
    
              
    
                
    
                  觉得还不错?
                  
                    一键收藏
                  
                 
                
    
              
    
            
    • 
          
  • 
            
    
              
              
            
    
              
              
              
                    0
              
            
            
    评论
    
          
    • 
          
  • 
          
    • 
          
  • 
            
              
            
              
    
            
              
                
            
    
          
    • 
        

      

      










                



	

		

			

				
					
100天精通Oracle-实战系列 - 总目录

				
			

			

				

					LuciferLiu_DBA
				

				

					12-19
					
					8829
					
				

			

		

		

			
				
100天精通Oracle-实战系列 - 总目录

			
		

	



                

              
                



	

		

			

				
					
服务器遭遇挖矿脚本入侵，歪果仁玩的真花

				
			

			

				

					王声声的博客
				

				

					03-21
					
					1660
					
				

			

		

		

			
				
【代码】服务器遭遇挖矿脚本入侵，歪果仁玩的真花。

			
		

	



                


  
              

                


	

		

			

				
					
oracle+schemaname,ORACLE中修改表的Schema的小结

				
			

			

				

					weixin_39936134的博客
				

				

					04-04
					
					395
					
				

			

		

		

			
				
ORACLE中修改表的Schema的总结前阵子遇到一个案例，需要将数据库中的几个表从USER A 移动到USER B下面，在ORACLE中，这个叫做更改表的所有者或者修改表的Schema。其实遇到这种案例，有好几种解决方法。下面我们通过实验来测试、验证一下。首先准备简单测试数据,如下所示:SQL> CREATETABLE TEST.KKK( ID INT ,NAME VARCHAR...

			
		

	





	

		

			

				
					
oracle 触发器对同一张表,oracle 触发器 对同一表的操作

				
			

			

				

					weixin_32870457的博客
				

				

					04-04
					
					543
					
				

			

		

		

			
				
昨天,头给布置了一任务,主要是写一个触发器 ,用来在某表中的一个字段更新后,将同表中的另一个字段也进行修改.我昨天那个纠结啊!!好半天,主要是之前没有玩过触发器,找了些资料后,大概能看懂了网上的那些资料.不过,我真觉得有太多的资料都是在那里胡扯,都是ctrl+c 和ctrl+v来的,有意思吗?!废话不多说了,首先,我要实现的这个操作是对同一个表的操作,当然了,当一个字段改变时需要改变另一个字段的这...

			
		

	



		

			
		



	

		

			

				
					
韩顺平经典玩转Oracle视频课程

				
			

			

				

					07-23
				

			

		

		

			
				
教程名称： 韩顺平 经典玩转Oracle视频课程该教程用循序渐进的手法和项目驱动的案例，由浅入深的讲解oracle的基础部分和高级部分。包括以下内容:(1)oracle基础介绍　(2)oralce安装(3)oracle的基本使用　(4)oracle...

			
		

	





	

		

			

				
					
韩顺平玩转Oracle数据库的PPT

				
			

			

				

					06-05
				

			

		

		

			
				
韩顺平玩转Oracle数据库的PPT

			
		

	





	

		

			

				
					
韩顺平玩转oracle视频教程笔记

				
			

			

				

					12-26
				

			

		

		

			
				
韩顺平玩转oracle视频教程笔记

			
		

	





	

		

			

				
					
xinxi.rar_jsp oracle_oracle_信息发布

				
			

			

				

					09-24
				

			

		

		

			
				
一个利用JSP与ORACLE实现的信息发布系统

			
		

	





	

		

			

				
					
Oracle统计一天内每小时的数据量

				
			

			

				

					11-17
				

			

		

		

			
				
Oracle统计一天内每小时的数据量。在某小时内有数据，该时间段会被统计出来；该时间段内没有交易，该时间段不会被统计出来，默认为0即可

			
		

	





	

		

			

				
					
Oracle 11g 生产库因密码过期修改密码产生library cache lock等待事件导致用户hang问题分析及处理

				
			

			

				

					shlei5580的专栏
				

				

					04-28
					
					641
					
				

			

		

		

			
				
该生产库是Oracle 11g库，数据库版本为11.2.0.4，Oracle在11g有个新特性，即有一个用户使用错误的密码连接数据库，随着登陆失败次数的增加，每次登陆验证前延迟等待的时间也会增加，这个新特性的主要目的是用于防止一些应用程序使用错误的密码尝试登陆数据库，由于密码延迟策略，大量会话等待登陆验证，导致数据库后续连接产生大量library cache lock等待事件导致hang住。此问题可以在MOS上查询(ID 1309738.1)这篇文章，有详细描述。

			
		

	





	

		

			

				
					
HarmonyOS实战开发-如何在鸿蒙开发中使用数据库

				
			

			

				

					m0_70749039的博客
				

				

					04-26
					
					937
					
				

			

		

		

			
				
鸿蒙中的数据库基于SQLite组件，用来处理关系比较复杂的数据，本文将以WORKER表为例，为大家演示在鸿蒙开发中对数据库的增删改查操作。

			
		

	





	

		

			

				
					
Oracle数据常驻程序内存优化【数据库实例优化系列三】

				
			

			

				

					奋斗的阿杰的博客
				

				

					04-30
					
					160
					
				

			

		

		

			
				
在生产中，为提高用户的访问速度。可以将经常使用的表常驻与内存中。避免频繁的访问磁盘，降低IO。
虽然会占用一定的内存，但是效果还是很明显的。
如果不是用了，DBA可以将其删除。

			
		

	





	

		

			

				
					
数据库学习之用户管理和权限问题

				
			

			

				

					banliyaoguai的博客
				

				

					04-30
					
					291
					
				

			

		

		

			
				
grant命令用来管理权限，grant是集授权、创建用户、修改密码到等一系列权限于一身的一个命令。

			
		

	





	

		

			

				
					
indexedDB---浏览器内建的数据库（学习记录）

				
			

			

				

					I_am_shy的博客
				

				

					04-29
					
					404
					
				

			

		

		

			
				
IndexedDB 是一个浏览器内建的数据库，它比强大得多。要注意的点是，网页只能访问自身域名下的indexedDB数据库，而不能访问跨域的数据库。

			
		

	





	

		

			

				
					
数据库的嵌套查询（子查询），分组查询和统计查询—学生选课

				
			

			

				

					2301_77713282的博客
				

				

					04-28
					
					526
					
				

			

		

		

			
				
数据库的嵌套查询（子查询）,分组查询和统计查询案例;查询选修了"数据库原理与应用"课程的学生学号和姓名;查询比"王华"同学年龄大的学生的学号和姓名;查询选修"数据库原理与应用"的成绩低于"张三"的学生的学号和成绩;查询其他学员中比"数计学院"学生"年龄"都小的学生;查询选修"数据库原理与应用"课程的学生姓名;查询选修了"全部"课程的学生姓名;查询至少选修了指定学号学生所选修课中一门课程的学生的学号和姓名;查询至少选修了指定学号学生所选修课的全部课程的学生的学号和姓名;查询既选修了"数据结构"又选修了"数据库

			
		

	





	

		

			

				
					
分布式事务—＞ seata

					
最新发布

				
			

			

				

					2302_77971734的博客
				

				

					05-03
					
					875
					
				

			

		

		

			
				
分布式事务是一种特殊类型的事务，它涉及多个分布式系统中的节点，包括事务的参与者、支持事务的服务器、资源服务器以及事务管理器。在分布式事务中，一次大型操作通常由多个小操作组成，这些小操作分布在不同的服务器上，并且属于不同的应用。分布式事务的关键在于确保这些小操作要么全部成功，要么全部失败，以保持数据的一致性。这种事务模型主要用于确保不同数据库或系统之间的数据一致性。分布式事务管理通常面临一些独特的挑战，例如确保所有参与系统的事务日志之间的一致性，以及处理网络延迟或断连的情况。

			
		

	





	

		

			

				
					
Oracle对空值(NULL)的 聚合函数 排序

				
			

			

				

					jnrjian的博客
				

				

					04-28
					
					955
					
				

			

		

		

			
				
目录。

			
		

	





	

		

			

				
					
drop、delete与truncate的区别

				
			

			

				

					weixin_47493863的博客
				

				

					05-02
					
					334
					
				

			

		

		

			
				
drop、delete与truncate的区别

			
		

	





	

		

			

				
					
oracle取某天每个小时

				
			

			

				

					09-01
				

			

		

		

			
				
使用Oracle数据库，可以使用以下语句来获取某天每个小时的数据：  ```sql SELECT TO_CHAR(your_date_column, 'YYYY-MM-DD HH24:MI:SS') AS hour FROM your_table WHERE TO_CHAR(your_date_column, 'YYYY-MM-DD') = '...

			
		

	



              



  
“相关推荐”对你有帮助么？

  

      
    
          
  • 
              
    
                  
                  
              
    
              
    非常没帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    没帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    一般
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    有帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    非常有帮助
    
          
    • 
      

      

      

          
          提交
      

      

  




          




        



    





    



      

      

        
      

      





	

		评论	
	

	
	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

                
 1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
 2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

              

            

          

      

      余额充值