正德厚生,臻于至善

EBS DB 19.16 RU patch

https://www.oracle.com/security-alerts/cpujul2022.html

替换OPatch
备份两个节点oracle_home下的OPatch文件,替换为高版本opatch:  p6880880_190000_Linux-x86-64.zip
备份OPatch 
su - grid
cd /u01/122media/19c
unzip -oq p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch version

su - oracle
cd /u01/122media/19c
unzip -oq p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch version


安装RU16
安装RU前,检查补丁包的详细说明,readme.html
Oracle Database Patch 34160854 - Combo of OJVM Component Release Update 19.16.0.0.220719 + Grid Infrastrusture Jul 2022 Release Update 19.16.0.0.220719
34086870 OJVM RELEASE UPDATE 19.16.0.0.0
34130714 GI RELEASE UPDATE 19.16.0.0.0

su - root
cd /u01/122media/19c
unzip -oq p34160854_190000_Linux-x86-64.zip
chmod -fR 777 /u01/122media/19c

cd /u01/UAT/oraInventory
chmod -R g+rw *

两节点root用户执行
export GI_HOME=/u01/UAT/19.0.0.0/grid
$GI_HOME/OPatch/opatchauto apply /u01/122media/19c/34160854/34130714 -oh $GI_HOME

Time taken to complete the session 13 minutes, 55 seconds
Time taken to complete the session 12 minutes, 10 seconds

export GI_HOME=/u01/UAT/19.0.0.0/grid
$GI_HOME/OPatch/opatchauto apply /u01/122media/19c/34160854/34086870 -oh $GI_HOME

Time taken to complete the session 7 minutes, 40 seconds
Time taken to complete the session 8 minutes, 1 second

日志路径cd $GI_HOME/cfgtoollogs/opatchautodb/

两节点oracle用户执行
su - oracle
sqlplus / as sysdba
shutdown immediate
exit;

两节点root用户执行
export DB_HOME=/u01/UAT/db/19.0.0.0
$DB_HOME/OPatch/opatchauto apply /u01/122media/19c/34160854/34130714 -oh $DB_HOME

export DB_HOME=/u01/UAT/db/19.0.0.0
$DB_HOME/OPatch/opatchauto apply /u01/122media/19c/34160854/34086870 -oh $DB_HOME

查看PATCH安装结果
$ORACLE_HOME/OPatch/opatch lsinventory|grep applied

GRID:
Patch  34086870     : applied on Tue Sep 06 19:23:45 CST 2022
Patch  34318175     : applied on Tue Sep 06 19:00:30 CST 2022
Patch  34160635     : applied on Tue Sep 06 19:00:14 CST 2022
Patch  34139601     : applied on Tue Sep 06 18:59:52 CST 2022
Patch  34133642     : applied on Tue Sep 06 18:58:34 CST 2022
Patch  33575402     : applied on Thu Jun 09 21:45:45 CST 2022

RDBMS:
Patch  34086870     : applied on Tue Sep 06 20:16:50 CST 2022
Patch  34160635     : applied on Tue Sep 06 20:11:49 CST 2022
Patch  34133642     : applied on Tue Sep 06 20:09:56 CST 2022


安装19c 推荐补丁
安装19c RDBMS one-off patches
19C RDBMS层安装如下one-off 补丁:
详细补丁列表参见《ZTE项目_EBS+ASCP补丁分析_v20220805.xlsx》

34223583;MERGE ON DATABASE RU 19.16.0.0.0 OF 28907129 29213893
34294184;MERGE ON DATABASE RU 19.16.0.0.0 OF 29780459 32043701

批量安装:
export PATH=$ORACLE_HOME/OPatch:$PATH
cd /u01/122media/19c/
mkdir -p one-off
for i in `ls *.zip|egrep -v '34160854|28907129|29780459|29213893|32043701|6880880'`; do unzip -oq $i -d one-off; done

cd /u01/122media/19c/one-off 
for patchnum in `ls -ld [1-9]*|awk '{print $NF}'` 
do cd $patchnum ; opatch apply -silent ; sleep 5; 
cd .. ; done

安装19c RDBMS bundle patches

cd /u01/122media/19c/one-off/etcc-bundle/LINUX_X86-64/database/19.16.0.0.220719DBRU
for i in `ls *.zip`; do unzip -oq $i; done
for patchnum in `ls -ld [1-9]*|awk '{print $NF}'` 
do cd $patchnum ; opatch apply -silent ; sleep 5; 
cd .. ; done

$ORACLE_HOME/OPatch/opatch lsinventory|grep applied
补丁最终结果
DB 19c: 23个补丁
Patch  34256518     : applied on Tue Sep 06 21:20:25 CST 2022
Patch  33720650     : applied on Tue Sep 06 21:19:43 CST 2022
Patch  31424070     : applied on Tue Sep 06 21:19:02 CST 2022
Patch  28739606     : applied on Tue Sep 06 21:18:21 CST 2022
Patch  28318139     : applied on Tue Sep 06 21:17:38 CST 2022
Patch  34294184     : applied on Tue Sep 06 21:15:46 CST 2022
Patch  34223583     : applied on Tue Sep 06 21:15:02 CST 2022
Patch  34333986     : applied on Tue Sep 06 20:43:45 CST 2022
Patch  34113634     : applied on Tue Sep 06 20:43:03 CST 2022
Patch  33510062     : applied on Tue Sep 06 20:41:35 CST 2022
Patch  33195096     : applied on Tue Sep 06 20:40:33 CST 2022
Patch  32642994     : applied on Tue Sep 06 20:39:31 CST 2022
Patch  31599215     : applied on Tue Sep 06 20:37:27 CST 2022
Patch  31489731     : applied on Tue Sep 06 20:36:24 CST 2022
Patch  31211220     : applied on Tue Sep 06 20:35:22 CST 2022
Patch  30787757     : applied on Tue Sep 06 20:34:23 CST 2022
Patch  30691454     : applied on Tue Sep 06 20:33:22 CST 2022
Patch  30662963     : applied on Tue Sep 06 20:32:18 CST 2022
Patch  30458233     : applied on Tue Sep 06 20:31:15 CST 2022
Patch  29151989     : applied on Tue Sep 06 20:28:58 CST 2022
Patch  34086870     : applied on Tue Sep 06 20:23:43 CST 2022
Patch  34160635     : applied on Tue Sep 06 20:11:00 CST 2022
Patch  34133642     : applied on Tue Sep 06 20:09:38 CST 2022

GRID 19c: 6个补丁
Patch  34086870     : applied on Tue Sep 06 19:23:45 CST 2022
Patch  34318175     : applied on Tue Sep 06 19:00:30 CST 2022
Patch  34160635     : applied on Tue Sep 06 19:00:14 CST 2022
Patch  34139601     : applied on Tue Sep 06 18:59:52 CST 2022
Patch  34133642     : applied on Tue Sep 06 18:58:34 CST 2022
Patch  33575402     : applied on Thu Jun 09 21:45:45 CST 2022

[root@r122uatdb1 ~]# su - grid
Last login: Thu Nov 24 22:37:38 CST 2022
[grid@r122uatdb1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory|grep applied
Patch  34086870     : applied on Mon Nov 14 10:36:02 CST 2022
Patch  34318175     : applied on Mon Nov 14 10:01:31 CST 2022
Patch  34160635     : applied on Mon Nov 14 10:01:19 CST 2022
Patch  34139601     : applied on Mon Nov 14 10:01:03 CST 2022
Patch  34133642     : applied on Mon Nov 14 09:59:58 CST 2022
Patch  33575402     : applied on Mon Nov 14 09:59:21 CST 2022
[grid@r122uatdb1 ~]$ exit
logout
[root@r122uatdb1 ~]# su - oracle
Last login: Thu Nov 24 22:37:40 CST 2022
[oracle@r122uatdb1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory|grep applied
Patch  34256518     : applied on Mon Nov 14 11:43:40 CST 2022
Patch  33720650     : applied on Mon Nov 14 11:43:08 CST 2022
Patch  31424070     : applied on Mon Nov 14 11:42:36 CST 2022
Patch  28739606     : applied on Mon Nov 14 11:42:04 CST 2022
Patch  28318139     : applied on Mon Nov 14 11:41:31 CST 2022
Patch  34333986     : applied on Mon Nov 14 11:32:34 CST 2022
Patch  34294184     : applied on Mon Nov 14 11:31:46 CST 2022
Patch  34223583     : applied on Mon Nov 14 11:31:13 CST 2022
Patch  34113634     : applied on Mon Nov 14 11:30:40 CST 2022
Patch  33510062     : applied on Mon Nov 14 11:29:38 CST 2022
Patch  33195096     : applied on Mon Nov 14 11:28:50 CST 2022
Patch  32642994     : applied on Mon Nov 14 11:28:02 CST 2022
Patch  31599215     : applied on Mon Nov 14 11:26:26 CST 2022
Patch  31489731     : applied on Mon Nov 14 11:25:37 CST 2022
Patch  31211220     : applied on Mon Nov 14 11:24:51 CST 2022
Patch  30787757     : applied on Mon Nov 14 11:24:03 CST 2022
Patch  30691454     : applied on Mon Nov 14 11:23:15 CST 2022
Patch  30662963     : applied on Mon Nov 14 11:22:27 CST 2022
Patch  30458233     : applied on Mon Nov 14 11:21:37 CST 2022
Patch  29151989     : applied on Mon Nov 14 11:20:17 CST 2022
Patch  34086870     : applied on Mon Nov 14 11:11:52 CST 2022
Patch  34160635     : applied on Mon Nov 14 11:02:46 CST 2022
Patch  34133642     : applied on Mon Nov 14 11:01:31 CST 2022
[oracle@r122uatdb1 ~]$

如果有库需要:
sqlplus / as sysdba
startup
exit

$ORACLE_HOME/OPatch/datapatch

SQL> @?/rdbms/admin/utlrp.sql
赞(0) 打赏
未经允许不得转载:徐万新之路 » EBS DB 19.16 RU patch

评论 抢沙发

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏

登录

找回密码

注册