为解决oracle 19c xstream的一个bug，决定将oracle 19c库从19.14升级至19.18，为整理升级过程，本次在一套19c 两节点rac上进行了一次。
为尽可能模拟生产环境，本次升级选择采用滚动升级方式进行。
以下是整个升级过程记录
根据oraclem6米乐安卓版下载官网介绍，对于oracle 19c，其通常会在每年1月、4月、7月、10月每个季度发布一个ru，为使客户能够在其环境稳定之后即刻获得最新的安全相关修复，其在每年1月，4月，7月，10月还为最近的两个ru提供rur。
oracle 在2023年1月份发布了19.18的ru，对应gi和db其ru信息分别如下：
oracle 19.18 gi的ru编号: 35037840, db的ru 编号：34765931。
35037840 gi 补丁详细信息如下：
升级19.18，要求opatch版本不低于 12.2.0.1.34，本次从mos上下载的opatch版本为12.2.0.1.37
# 升级前opatch版本检查 [grid@xxxx ~]$ opatch version opatch version: 12.2.0.1.28 opatch succeeded.
2.1 升级opatch
备份之前建议分别对grid用户及oracle用户opatch进行备份
# grid用户 [root@xxx]# cd /u01/app/19.3.0/grid [root@xxx]# mv opatch opatch_bak # oracle用户 [root@xxx]# cd /u01/app/oracle/product/19.3.0/db_1 [root@xxx]# mv opatch opatch_bak
# 升级grid用户opatch 【每个节点都需执行】 [root@xxx]# unzip /home/soft/p6880880_190000_linux-x86-64.zip -d /u01/app/19.3.0/grid [root@xxx]# cd /u01/app/19.3.0/grid [root@xxx]# chown -r grid:oinstall ./opatch # 升级oracle用户opatch 【每个节点都需执行】 [root@xxx]# unzip /home/soft/p6880880_190000_linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/db_1 [root@xxx]# cd /u01/app/oracle/product/19.3.0/db_1 [root@xxx]# chown -r oracle:oinstall ./opatch
2.2 查看opatch版本
# grid用户 [grid@xxx ~]$ $oracle_home/opatch/opatch version opatch version: 12.2.0.1.37 opatch succeeded. # oracle用户 [oracle@xxx ~]$ $oracle_home/opatch/opatch version opatch version: 12.2.0.1.37 opatch succeeded.
3.1 grid用户检查
1）$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34765931
[grid@xxx ~]$ $oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34765931 oracle interim patch installer version 12.2.0.1.28 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-20-00am_1.log invoking prereq "checkconflictagainstohwithdetail" prereq "checkconflictagainstohwithdetail" passed. opatch succeeded. ===========日志内容如下 [may 15, 2023 10:20:01 am] [info] prereq session [may 15, 2023 10:20:01 am] [info] cas dynaorcl loading : casclasspathloader: opatch path to be searched for cas jars :/u01/app/19.3.0/grid/opatch/jlib casclasspathloader : non cas based home [may 15, 2023 10:20:01 am] [info] cup_log: trying to load homeoperations object [may 15, 2023 10:20:01 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 15, 2023 10:20:01 am] [info] opatch invoked as follows: 'prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34765931 -invptrloc /u01/app/19.3.0/grid/orainst.loc ' [may 15, 2023 10:20:01 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/19.3.0/grid/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatch.oracle_home=/ u01/app/19.3.0/grid, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/19.3.0/grid/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopatch.oui_location=/u01/app/19.3.0/grid/oui, -do patch.fmw_component_home=, -dopatch.opatch_classpath=, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 15, 2023 10:20:01 am] [info] heap in use : 55 mb total memory: 962 mb free memory : 906 mb max memory : 2731 mb [may 15, 2023 10:20:01 am] [info] oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 oui location : /u01/app/19.3.0/grid/oui log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-20-00am_1.log [may 15, 2023 10:20:01 am] [info] patch history file: /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch_history.txt [may 15, 2023 10:20:01 am] [info] invoking prereq "checkconflictagainstohwithdetail" [may 15, 2023 10:20:01 am] [info] [opsr-time] loading raw inventory [may 15, 2023 10:20:01 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 90 (mb) [may 15, 2023 10:20:01 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 100 (mb) [may 15, 2023 10:20:01 am] [info] [opsr-time] raw inventory loaded successfully [may 15, 2023 10:20:09 am] [info] [opsr-time] loading cooked inventory [may 15, 2023 10:20:09 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 139 (mb) [may 15, 2023 10:20:12 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 352 (mb) [may 15, 2023 10:20:12 am] [info] [opsr-time] cooked inventory loaded successfully [may 15, 2023 10:20:13 am] [info] running prereq checkconflictagainstohwithdetail [may 15, 2023 10:20:13 am] [info] cup_log: found pi cup 34765931 is a superset of poh cup: 33515361 [may 15, 2023 10:20:15 am] [info] following patches can be applied: 34765931 [may 15, 2023 10:20:15 am] [info] following patches are not required: [may 15, 2023 10:20:15 am] [info] following patches are auto rollbackable: [may 15, 2023 10:20:15 am] [info] finished checking prereq checkconflictagainstohwithdetail [may 15, 2023 10:20:15 am] [info] prereq "checkconflictagainstohwithdetail" passed. [may 15, 2023 10:20:15 am] [info] finishing prereqsession at mon may 15 10:20:15 cst 2023
2）$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34768559
[grid@xxx ~]$ oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34768559 oracle interim patch installer version 12.2.0.1.28 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-25-19am_1.log invoking prereq "checkconflictagainstohwithdetail" prereq "checkconflictagainstohwithdetail" passed. opatch succeeded. ===========日志内容如下 [may 15, 2023 10:25:19 am] [info] prereq session [may 15, 2023 10:25:19 am] [info] cas dynaorcl loading : casclasspathloader: opatch path to be searched for cas jars :/u01/app/19.3.0/grid/opatch/jlib casclasspathloader : non cas based home [may 15, 2023 10:25:19 am] [info] cup_log: trying to load homeoperations object [may 15, 2023 10:25:19 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 15, 2023 10:25:19 am] [info] opatch invoked as follows: 'prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34768559 -invptrloc /u01/app/19.3.0/grid/orainst.loc ' [may 15, 2023 10:25:19 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/19.3.0/grid/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatch.oracle_home=/ u01/app/19.3.0/grid, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/19.3.0/grid/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopatch.oui_location=/u01/app/19.3.0/grid/oui, -do patch.fmw_component_home=, -dopatch.opatch_classpath=, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 15, 2023 10:25:19 am] [info] heap in use : 55 mb total memory: 962 mb free memory : 906 mb max memory : 2731 mb [may 15, 2023 10:25:19 am] [info] oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 oui location : /u01/app/19.3.0/grid/oui log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-25-19am_1.log [may 15, 2023 10:25:19 am] [info] patch history file: /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch_history.txt [may 15, 2023 10:25:19 am] [info] invoking prereq "checkconflictagainstohwithdetail" [may 15, 2023 10:25:19 am] [info] [opsr-time] loading raw inventory [may 15, 2023 10:25:19 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 85 (mb) [may 15, 2023 10:25:20 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 95 (mb) [may 15, 2023 10:25:20 am] [info] [opsr-time] raw inventory loaded successfully [may 15, 2023 10:25:23 am] [info] [opsr-time] loading cooked inventory [may 15, 2023 10:25:23 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 128 (mb) [may 15, 2023 10:25:25 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 94 (mb) [may 15, 2023 10:25:25 am] [info] [opsr-time] cooked inventory loaded successfully [may 15, 2023 10:25:26 am] [info] running prereq checkconflictagainstohwithdetail [may 15, 2023 10:25:27 am] [info] following patches can be applied: 34768559 [may 15, 2023 10:25:27 am] [info] following patches are not required: [may 15, 2023 10:25:27 am] [info] following patches are auto rollbackable: [may 15, 2023 10:25:27 am] [info] finished checking prereq checkconflictagainstohwithdetail [may 15, 2023 10:25:27 am] [info] prereq "checkconflictagainstohwithdetail" passed. [may 15, 2023 10:25:27 am] [info] finishing prereqsession at mon may 15 10:25:27 cst 2023
3）$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34768569
[grid@xxx ~]$ $oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34768569 oracle interim patch installer version 12.2.0.1.28 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-26-59am_1.log invoking prereq "checkconflictagainstohwithdetail" prereq "checkconflictagainstohwithdetail" passed. opatch succeeded. ===========日志内容如下 [may 15, 2023 10:26:59 am] [info] prereq session [may 15, 2023 10:27:00 am] [info] cas dynaorcl loading : casclasspathloader: opatch path to be searched for cas jars :/u01/app/19.3.0/grid/opatch/jlib casclasspathloader : non cas based home [may 15, 2023 10:27:00 am] [info] cup_log: trying to load homeoperations object [may 15, 2023 10:27:00 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 15, 2023 10:27:00 am] [info] opatch invoked as follows: 'prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34768569 -invptrloc /u01/app/19.3.0/grid/orainst.loc ' [may 15, 2023 10:27:00 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/19.3.0/grid/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatch.oracle_home=/ u01/app/19.3.0/grid, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/19.3.0/grid/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopatch.oui_location=/u01/app/19.3.0/grid/oui, -do patch.fmw_component_home=, -dopatch.opatch_classpath=, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 15, 2023 10:27:00 am] [info] heap in use : 55 mb total memory: 962 mb free memory : 906 mb max memory : 2731 mb [may 15, 2023 10:27:00 am] [info] oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 oui location : /u01/app/19.3.0/grid/oui log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-26-59am_1.log [may 15, 2023 10:27:00 am] [info] patch history file: /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch_history.txt [may 15, 2023 10:27:00 am] [info] invoking prereq "checkconflictagainstohwithdetail" [may 15, 2023 10:27:00 am] [info] [opsr-time] loading raw inventory [may 15, 2023 10:27:00 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 85 (mb) [may 15, 2023 10:27:00 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 90 (mb) [may 15, 2023 10:27:00 am] [info] [opsr-time] raw inventory loaded successfully [may 15, 2023 10:27:03 am] [info] [opsr-time] loading cooked inventory [may 15, 2023 10:27:03 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 96 (mb) [may 15, 2023 10:27:05 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 547 (mb) [may 15, 2023 10:27:05 am] [info] [opsr-time] cooked inventory loaded successfully [may 15, 2023 10:27:06 am] [info] running prereq checkconflictagainstohwithdetail [may 15, 2023 10:27:06 am] [info] following patches can be applied: 34768569 [may 15, 2023 10:27:06 am] [info] following patches are not required: [may 15, 2023 10:27:06 am] [info] following patches are auto rollbackable: [may 15, 2023 10:27:06 am] [info] finished checking prereq checkconflictagainstohwithdetail [may 15, 2023 10:27:06 am] [info] prereq "checkconflictagainstohwithdetail" passed. [may 15, 2023 10:27:06 am] [info] finishing prereqsession at mon may 15 10:27:06 cst 2023
4） $oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34863894
[grid@xxx ~]$ $oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34863894 oracle interim patch installer version 12.2.0.1.28 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-28-07am_1.log invoking prereq "checkconflictagainstohwithdetail" prereq "checkconflictagainstohwithdetail" passed. opatch succeeded. ===========日志内容如下 [may 15, 2023 10:28:07 am] [info] prereq session [may 15, 2023 10:28:07 am] [info] cas dynaorcl loading : casclasspathloader: opatch path to be searched for cas jars :/u01/app/19.3.0/grid/opatch/jlib casclasspathloader : non cas based home [may 15, 2023 10:28:07 am] [info] cup_log: trying to load homeoperations object [may 15, 2023 10:28:07 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 15, 2023 10:28:08 am] [info] opatch invoked as follows: 'prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34863894 -invptrloc /u01/app/19.3.0/grid/orainst.loc ' [may 15, 2023 10:28:08 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/19.3.0/grid/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatch.oracle_home=/ u01/app/19.3.0/grid, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/19.3.0/grid/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopatch.oui_location=/u01/app/19.3.0/grid/oui, -do patch.fmw_component_home=, -dopatch.opatch_classpath=, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 15, 2023 10:28:08 am] [info] heap in use : 55 mb total memory: 962 mb free memory : 906 mb max memory : 2731 mb [may 15, 2023 10:28:08 am] [info] oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 oui location : /u01/app/19.3.0/grid/oui log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-28-07am_1.log [may 15, 2023 10:28:08 am] [info] patch history file: /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch_history.txt [may 15, 2023 10:28:08 am] [info] invoking prereq "checkconflictagainstohwithdetail" [may 15, 2023 10:28:08 am] [info] [opsr-time] loading raw inventory [may 15, 2023 10:28:08 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 85 (mb) [may 15, 2023 10:28:08 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 90 (mb) [may 15, 2023 10:28:08 am] [info] [opsr-time] raw inventory loaded successfully [may 15, 2023 10:28:11 am] [info] [opsr-time] loading cooked inventory [may 15, 2023 10:28:11 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 89 (mb) [may 15, 2023 10:28:13 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 546 (mb) [may 15, 2023 10:28:13 am] [info] [opsr-time] cooked inventory loaded successfully [may 15, 2023 10:28:14 am] [info] running prereq checkconflictagainstohwithdetail [may 15, 2023 10:28:14 am] [info] following patches can be applied: 34863894 [may 15, 2023 10:28:14 am] [info] following patches are not required: [may 15, 2023 10:28:14 am] [info] following patches are auto rollbackable: [may 15, 2023 10:28:14 am] [info] finished checking prereq checkconflictagainstohwithdetail [may 15, 2023 10:28:14 am] [info] prereq "checkconflictagainstohwithdetail" passed. [may 15, 2023 10:28:14 am] [info] finishing prereqsession at mon may 15 10:28:14 cst 2023
5）$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/33575402
[grid@xxx ~]$ $oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/33575402 oracle interim patch installer version 12.2.0.1.28 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-29-25am_1.log invoking prereq "checkconflictagainstohwithdetail" prereq "checkconflictagainstohwithdetail" passed. opatch succeeded. ===========日志内容如下 [may 15, 2023 10:29:25 am] [info] prereq session [may 15, 2023 10:29:25 am] [info] cas dynaorcl loading : casclasspathloader: opatch path to be searched for cas jars :/u01/app/19.3.0/grid/opatch/jlib casclasspathloader : non cas based home [may 15, 2023 10:29:25 am] [info] cup_log: trying to load homeoperations object [may 15, 2023 10:29:25 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 15, 2023 10:29:25 am] [info] opatch invoked as follows: 'prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/33575402 -invptrloc /u01/app/19.3.0/grid/orainst.loc ' [may 15, 2023 10:29:25 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/19.3.0/grid/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatch.oracle_home=/ u01/app/19.3.0/grid, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/19.3.0/grid/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopatch.oui_location=/u01/app/19.3.0/grid/oui, -do patch.fmw_component_home=, -dopatch.opatch_classpath=, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 15, 2023 10:29:25 am] [info] heap in use : 55 mb total memory: 962 mb free memory : 906 mb max memory : 2731 mb [may 15, 2023 10:29:25 am] [info] oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 oui location : /u01/app/19.3.0/grid/oui log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-29-25am_1.log [may 15, 2023 10:29:25 am] [info] patch history file: /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch_history.txt [may 15, 2023 10:29:25 am] [info] invoking prereq "checkconflictagainstohwithdetail" [may 15, 2023 10:29:25 am] [info] [opsr-time] loading raw inventory [may 15, 2023 10:29:26 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 85 (mb) [may 15, 2023 10:29:26 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 95 (mb) [may 15, 2023 10:29:26 am] [info] [opsr-time] raw inventory loaded successfully [may 15, 2023 10:29:29 am] [info] [opsr-time] loading cooked inventory [may 15, 2023 10:29:29 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 91 (mb) [may 15, 2023 10:29:31 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 546 (mb) [may 15, 2023 10:29:31 am] [info] [opsr-time] cooked inventory loaded successfully [may 15, 2023 10:29:32 am] [info] running prereq checkconflictagainstohwithdetail [may 15, 2023 10:29:32 am] [info] following patches can be applied: [may 15, 2023 10:29:32 am] [info] following patches are not required: 33575402 [may 15, 2023 10:29:32 am] [info] following patches are auto rollbackable: [may 15, 2023 10:29:32 am] [info] finished checking prereq checkconflictagainstohwithdetail [may 15, 2023 10:29:32 am] [info] prereq "checkconflictagainstohwithdetail" passed. [may 15, 2023 10:29:32 am] [info] finishing prereqsession at mon may 15 10:29:32 cst 2023
3.2 oracle用户检查
>1) [oracle@xxx ~]$ $oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34765931 oracle interim patch installer version 12.2.0.1.28 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-15_10-31-45am_1.log invoking prereq "checkconflictagainstohwithdetail" prereq "checkconflictagainstohwithdetail" passed. opatch succeeded. ===========日志内容如下 [may 15, 2023 10:31:46 am] [info] prereq session [may 15, 2023 10:31:46 am] [info] cas dynaorcl loading : casclasspathloader: opatch path to be searched for cas jars :/u01/app/oracle/product/19.3.0/db_1/opatch/jlib casclasspathloader : non cas based home [may 15, 2023 10:31:46 am] [info] cup_log: trying to load homeoperations object [may 15, 2023 10:31:46 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 15, 2023 10:31:46 am] [info] opatch invoked as follows: 'prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34765931 -invptrloc /u01/app/oracle/product/19.3.0/db_1/orainst.loc ' [may 15, 2023 10:31:46 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatc h.oracle_home=/u01/app/oracle/product/19.3.0/db_1, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/oracle/product/19.3.0/db_1/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopat ch.oui_location=/u01/app/oracle/product/19.3.0/db_1/oui, -dopatch.fmw_component_home=, -dopatch.opatch_classpath=/u01/app/oracle/product/19.3.0/db_1/jre:/u01/app/oracle/product/19.3.0/db_1/jlib:/u01/app/oracle/product/19.3.0/db_1/rdbms/j lib:/u01/app/oracle/product/19.3.0/db_1/network/jlib, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 15, 2023 10:31:46 am] [info] heap in use : 60 mb total memory: 962 mb free memory : 902 mb max memory : 2731 mb [may 15, 2023 10:31:46 am] [info] oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 oui location : /u01/app/oracle/product/19.3.0/db_1/oui log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-15_10-31-45am_1.log [may 15, 2023 10:31:46 am] [info] patch history file: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch_history.txt [may 15, 2023 10:31:46 am] [info] invoking prereq "checkconflictagainstohwithdetail" [may 15, 2023 10:31:46 am] [info] [opsr-time] loading raw inventory [may 15, 2023 10:31:47 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 95 (mb) [may 15, 2023 10:31:47 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 100 (mb) [may 15, 2023 10:31:47 am] [info] [opsr-time] raw inventory loaded successfully [may 15, 2023 10:31:55 am] [info] [opsr-time] loading cooked inventory [may 15, 2023 10:31:55 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 131 (mb) [may 15, 2023 10:31:57 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 335 (mb) [may 15, 2023 10:31:57 am] [info] [opsr-time] cooked inventory loaded successfully [may 15, 2023 10:31:58 am] [info] cup_log: found poh cup 29517242 is a subset of other poh cup: 33515361 [may 15, 2023 10:31:58 am] [info] cup_log: found poh plo 33346851 implicitly overlays poh cup: 29517242 [may 15, 2023 10:31:58 am] [info] cup_log: found poh plo 33346851 implicitly overlays poh cup: 33515361 [may 15, 2023 10:32:03 am] [info] running prereq checkconflictagainstohwithdetail [may 15, 2023 10:32:03 am] [info] cup_log: found pi cup 34765931 is a superset of poh cup: 33515361 [may 15, 2023 10:32:05 am] [info] following patches can be applied: 34765931 [may 15, 2023 10:32:05 am] [info] following patches are not required: [may 15, 2023 10:32:05 am] [info] following patches are auto rollbackable: 33346851 [may 15, 2023 10:32:05 am] [info] finished checking prereq checkconflictagainstohwithdetail [may 15, 2023 10:32:05 am] [info] prereq "checkconflictagainstohwithdetail" passed. [may 15, 2023 10:32:05 am] [info] finishing prereqsession at mon may 15 10:32:05 cst 2023
2） $oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34768559
[oracle@xxx ~]$ $oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34768559 oracle interim patch installer version 12.2.0.1.28 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-15_10-33-55am_1.log invoking prereq "checkconflictagainstohwithdetail" prereq "checkconflictagainstohwithdetail" passed. opatch succeeded. ===========日志内容如下 [may 15, 2023 10:33:56 am] [info] prereq session [may 15, 2023 10:33:56 am] [info] cas dynaorcl loading : casclasspathloader: opatch path to be searched for cas jars :/u01/app/oracle/product/19.3.0/db_1/opatch/jlib casclasspathloader : non cas based home [may 15, 2023 10:33:56 am] [info] cup_log: trying to load homeoperations object [may 15, 2023 10:33:56 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 15, 2023 10:33:56 am] [info] opatch invoked as follows: 'prereq checkconflictagainstohwithdetail -phbasedir /home/soft/34762026/34768559 -invptrloc /u01/app/oracle/product/19.3.0/db_1/orainst.loc ' [may 15, 2023 10:33:56 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatc h.oracle_home=/u01/app/oracle/product/19.3.0/db_1, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/oracle/product/19.3.0/db_1/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopat ch.oui_location=/u01/app/oracle/product/19.3.0/db_1/oui, -dopatch.fmw_component_home=, -dopatch.opatch_classpath=/u01/app/oracle/product/19.3.0/db_1/jre:/u01/app/oracle/product/19.3.0/db_1/jlib:/u01/app/oracle/product/19.3.0/db_1/rdbms/j lib:/u01/app/oracle/product/19.3.0/db_1/network/jlib, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 15, 2023 10:33:56 am] [info] heap in use : 60 mb total memory: 962 mb free memory : 902 mb max memory : 2731 mb [may 15, 2023 10:33:56 am] [info] oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 oui location : /u01/app/oracle/product/19.3.0/db_1/oui log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-15_10-33-55am_1.log [may 15, 2023 10:33:56 am] [info] patch history file: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch_history.txt [may 15, 2023 10:33:56 am] [info] invoking prereq "checkconflictagainstohwithdetail" [may 15, 2023 10:33:56 am] [info] [opsr-time] loading raw inventory [may 15, 2023 10:33:56 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 90 (mb) [may 15, 2023 10:33:56 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 100 (mb) [may 15, 2023 10:33:56 am] [info] [opsr-time] raw inventory loaded successfully [may 15, 2023 10:33:59 am] [info] [opsr-time] loading cooked inventory [may 15, 2023 10:33:59 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 116 (mb) [may 15, 2023 10:34:02 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 550 (mb) [may 15, 2023 10:34:02 am] [info] [opsr-time] cooked inventory loaded successfully [may 15, 2023 10:34:02 am] [info] cup_log: found poh cup 29517242 is a subset of other poh cup: 33515361 [may 15, 2023 10:34:02 am] [info] cup_log: found poh plo 33346851 implicitly overlays poh cup: 29517242 [may 15, 2023 10:34:02 am] [info] cup_log: found poh plo 33346851 implicitly overlays poh cup: 33515361 [may 15, 2023 10:34:07 am] [info] running prereq checkconflictagainstohwithdetail [may 15, 2023 10:34:08 am] [info] following patches can be applied: 34768559 [may 15, 2023 10:34:08 am] [info] following patches are not required: [may 15, 2023 10:34:08 am] [info] following patches are auto rollbackable: [may 15, 2023 10:34:08 am] [info] finished checking prereq checkconflictagainstohwithdetail [may 15, 2023 10:34:08 am] [info] prereq "checkconflictagainstohwithdetail" passed. [may 15, 2023 10:34:08 am] [info] finishing prereqsession at mon may 15 10:34:08 cst 2023
4.1 grid用户
# 使用grid用户创建并编辑/tmp/patch_list_gihome.txt文件，内容如下，【每个节点都需执行】 [grid@xxx ~]$ cat /tmp/patch_list_gihome.txt /home/soft/34762026/34765931 /home/soft/34762026/34768559 /home/soft/34762026/34768569 /home/soft/34762026/34863894 /home/soft/34762026/33575402
执行 $oracle_home/opatch/opatch prereq checksystemspace -phbasefile /tmp/patch_list_gihome.txt
[grid@xxx ~]$ $oracle_home/opatch/opatch prereq checksystemspace -phbasefile /tmp/patch_list_gihome.txt oracle interim patch installer version 12.2.0.1.28 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-55-40am_1.log invoking prereq "checksystemspace" prereq "checksystemspace" passed. opatch succeeded. ===========日志内容如下 [may 15, 2023 10:55:40 am] [info] prereq session [may 15, 2023 10:55:40 am] [info] cas dynaorcl loading : casclasspathloader: opatch path to be searched for cas jars :/u01/app/19.3.0/grid/opatch/jlib casclasspathloader : non cas based home [may 15, 2023 10:55:40 am] [info] cup_log: trying to load homeoperations object [may 15, 2023 10:55:40 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 15, 2023 10:55:40 am] [info] opatch invoked as follows: 'prereq checksystemspace -phbasefile /tmp/patch_list_gihome.txt -invptrloc /u01/app/19.3.0/grid/orainst.loc ' [may 15, 2023 10:55:40 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/19.3.0/grid/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatch.oracle_home=/u01/app/19.3.0/grid, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/19.3.0/grid/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopatch.oui_location=/u01/app/19.3.0/grid/oui, -dopatch.fmw_component_home=, -dopatch.opatch_classpath=, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 15, 2023 10:55:40 am] [info] heap in use : 55 mb total memory: 962 mb free memory : 906 mb max memory : 2731 mb [may 15, 2023 10:55:40 am] [info] oracle home : /u01/app/19.3.0/grid central inventory : /u01/app/orainventory from : /u01/app/19.3.0/grid/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 oui location : /u01/app/19.3.0/grid/oui log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-15_10-55-40am_1.log [may 15, 2023 10:55:40 am] [info] patch history file: /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch_history.txt [may 15, 2023 10:55:40 am] [info] invoking prereq "checksystemspace" [may 15, 2023 10:55:41 am] [info] [opsr-time] loading raw inventory [may 15, 2023 10:55:41 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 90 (mb) [may 15, 2023 10:55:41 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 100 (mb) [may 15, 2023 10:55:41 am] [info] [opsr-time] raw inventory loaded successfully [may 15, 2023 10:55:47 am] [info] [opsr-time] loading cooked inventory [may 15, 2023 10:55:47 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 136 (mb) [may 15, 2023 10:55:49 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 355 (mb) [may 15, 2023 10:55:49 am] [info] [opsr-time] cooked inventory loaded successfully [may 15, 2023 10:55:50 am] [info] space needed : 10525.89mb [may 15, 2023 10:55:50 am] [info] prereq "checksystemspace" passed. [may 15, 2023 10:55:50 am] [info] finishing prereqsession at mon may 15 10:55:50 cst 2023
4.2 oracle用户
# 使用oracle用户创建并编辑/tmp/patch_list_dbhome.txt文件，内容如下 cat /tmp/patch_list_dbhome.txt /home/soft/34762026/34765931 /home/soft/34762026/34768559
$oracle_home/opatch/opatch prereq checksystemspace -phbasefile /tmp/patch_list_dbhome.txt
oracle interim patch installer version 12.2.0.1.28 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-15_10-59-23am_1.log invoking prereq "checksystemspace" prereq "checksystemspace" passed. opatch succeeded. ===========日志内容如下 [may 15, 2023 10:59:23 am] [info] prereq session [may 15, 2023 10:59:23 am] [info] cas dynaorcl loading : casclasspathloader: opatch path to be searched for cas jars :/u01/app/oracle/product/19.3.0/db_1/opatch/jlib casclasspathloader : non cas based home [may 15, 2023 10:59:23 am] [info] cup_log: trying to load homeoperations object [may 15, 2023 10:59:23 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 15, 2023 10:59:23 am] [info] opatch invoked as follows: 'prereq checksystemspace -phbasefile /tmp/patch_list_dbhome.txt -invptrloc /u01/app/oracle/product/19.3.0/db_1/orainst.loc ' [may 15, 2023 10:59:23 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatch.oracle_home=/u01/app/oracle/product/19.3.0/db_1, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/oracle/product/19.3.0/db_1/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopatch.oui_location=/u01/app/oracle/product/19.3.0/db_1/oui, -dopatch.fmw_component_home=, -dopatch.opatch_classpath=/u01/app/oracle/product/19.3.0/db_1/jre:/u01/app/oracle/product/19.3.0/db_1/jlib:/u01/app/oracle/product/19.3.0/db_1/rdbms/jlib:/u01/app/oracle/product/19.3.0/db_1/network/jlib, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 15, 2023 10:59:23 am] [info] heap in use : 60 mb total memory: 962 mb free memory : 902 mb max memory : 2731 mb [may 15, 2023 10:59:23 am] [info] oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.28 oui version : 12.2.0.7.0 oui location : /u01/app/oracle/product/19.3.0/db_1/oui log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-15_10-59-23am_1.log [may 15, 2023 10:59:23 am] [info] patch history file: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch_history.txt [may 15, 2023 10:59:24 am] [info] invoking prereq "checksystemspace" [may 15, 2023 10:59:24 am] [info] [opsr-time] loading raw inventory [may 15, 2023 10:59:24 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 95 (mb) [may 15, 2023 10:59:24 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 95 (mb) [may 15, 2023 10:59:24 am] [info] [opsr-time] raw inventory loaded successfully [may 15, 2023 10:59:30 am] [info] [opsr-time] loading cooked inventory [may 15, 2023 10:59:30 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 115 (mb) [may 15, 2023 10:59:32 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 311 (mb) [may 15, 2023 10:59:32 am] [info] [opsr-time] cooked inventory loaded successfully [may 15, 2023 10:59:33 am] [info] cup_log: found poh cup 29517242 is a subset of other poh cup: 33515361 [may 15, 2023 10:59:33 am] [info] cup_log: found poh plo 33346851 implicitly overlays poh cup: 29517242 [may 15, 2023 10:59:33 am] [info] cup_log: found poh plo 33346851 implicitly overlays poh cup: 33515361 [may 15, 2023 10:59:37 am] [info] space needed : 8867.22mb [may 15, 2023 10:59:37 am] [info] prereq "checksystemspace" passed. [may 15, 2023 10:59:37 am] [info] finishing prereqsession at mon may 15 10:59:37 cst 2023
5.1 grid用户
[root@xxx ~]# /u01/app/19.3.0/grid/opatch/opatchauto apply /home/soft/34762026 -oh /u01/app/19.3.0/grid -analyze
# root用户，每个节点都需执行 [root@xxx ~]# /u01/app/19.3.0/grid/opatch/opatchauto apply /home/soft/34762026 -oh /u01/app/19.3.0/grid -analyze opatchauto session is initiated at tue may 16 22:06:33 2023 system initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-05-16_10-06-42pm.log. session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2023-05-16_10-07-14pm.log the id for this session is 5hu9 executing opatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid patch applicability verified successfully on home /u01/app/19.3.0/grid executing patch validation checks on home /u01/app/19.3.0/grid patch validation checks successfully completed on home /u01/app/19.3.0/grid opatchauto successful. --------------------------------summary-------------------------------- analysis for applying patches has completed successfully: host:local-test-orcl1 crs home:/u01/app/19.3.0/grid version:19.0.0.0.0 ==following patches were skipped: patch: /home/soft/34762026/33575402 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-16_22-07-42pm_1.log reason: /home/soft/34762026/33575402 is not required to be applied to oracle home /u01/app/19.3.0/grid ==following patches were successfully analyzed to be applied: patch: /home/soft/34762026/34768559 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-16_22-07-42pm_1.log patch: /home/soft/34762026/34768569 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-16_22-07-42pm_1.log patch: /home/soft/34762026/34863894 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-16_22-07-42pm_1.log patch: /home/soft/34762026/34765931 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-16_22-07-42pm_1.log opatchauto session completed at tue may 16 22:09:03 2023 time taken to complete the session 2 minutes, 22 seconds
5.2 oracle用户
[root@xxx ~]# /u01/app/oracle/product/19.3.0/db_1/opatch/opatchauto apply /home/soft/34762026 -oh /u01/app/oracle/product/19.3.0/db_1 -analyze
# root用户，每个节点都需执行 [root@xxx ~]# /u01/app/oracle/product/19.3.0/db_1/opatch/opatchauto apply /home/soft/34762026 -oh /u01/app/oracle/product/19.3.0/db_1 -analyze opatchauto session is initiated at tue may 16 22:19:12 2023 system initialization log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2023-05-16_10-19-20pm.log. session log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2023-05-16_10-20-01pm.log the id for this session is rmpe executing opatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1 patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 executing patch validation checks on home /u01/app/oracle/product/19.3.0/db_1 patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/db_1 verifying sql patch applicability on home /u01/app/oracle/product/19.3.0/db_1 sql patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 opatchauto successful. --------------------------------summary-------------------------------- analysis for applying patches has completed successfully: host:local-test-orcl1 rac home:/u01/app/oracle/product/19.3.0/db_1 version:19.0.0.0.0 ==following patches were skipped: patch: /home/soft/34762026/34768569 reason: this patch is not applicable to this specified target type - "rac_database" patch: /home/soft/34762026/33575402 reason: this patch is not applicable to this specified target type - "rac_database" patch: /home/soft/34762026/34863894 reason: this patch is not applicable to this specified target type - "rac_database" ==following patches were successfully analyzed to be applied: patch: /home/soft/34762026/34768559 log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-16_22-20-23pm_1.log patch: /home/soft/34762026/34765931 log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-16_22-20-23pm_1.log opatchauto session completed at tue may 16 22:22:11 2023 time taken to complete the session 2 minutes, 52 seconds
5.3 补丁冲突检查
# oracle用户执行 su - oracle [oracle@xxxx]$ cd /home/soft/34762026/34765931 [oracle@xxxx 34765931]$ $oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -ph ./ oracle interim patch installer version 12.2.0.1.37 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. prereq session oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.37 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_10-26-34am_1.log invoking prereq "checkconflictagainstohwithdetail" prereq "checkconflictagainstohwithdetail" passed. opatch succeeded. ===== 冲突检查日志如下 [oracle@xxxx ~]$ cat /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_10-26-34am_1.log [may 17, 2023 10:26:35 am] [info] prereq session [may 17, 2023 10:26:35 am] [info] cas dynaorcl loading : [may 17, 2023 10:26:35 am] [info] cup_log: trying to load homeoperations object [may 17, 2023 10:26:35 am] [info] cup_log: homeoperations object created. cup1.0 is enabled [may 17, 2023 10:26:35 am] [info] opatch invoked as follows: 'prereq checkconflictagainstohwithdetail -ph ./ -invptrloc /u01/app/oracle/product/19.3.0/db_1/orainst.loc ' [may 17, 2023 10:26:35 am] [info] runtime args: [-xmx3072m, -xx: heapdumponoutofmemoryerror, -xx:heapdumppath=/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch, -dcommonlog.log_session_id=, -dcommonlog.command_name=prereq, -dopatch.oracle_home=/u01/app/oracle/product/19.3.0/db_1, -dopatch.debug=false, -dopatch.make=false, -dopatch.running_dir=/u01/app/oracle/product/19.3.0/db_1/opatch, -dopatch.mw_home=, -dopatch.wl_home=, -dopatch.common_components_home=, -dopatch.oui_location=/u01/app/oracle/product/19.3.0/db_1/oui, -dopatch.fmw_component_home=, -dopatch.opatch_classpath=/u01/app/oracle/product/19.3.0/db_1/jre:/u01/app/oracle/product/19.3.0/db_1/jlib:/u01/app/oracle/product/19.3.0/db_1/rdbms/jlib:/u01/app/oracle/product/19.3.0/db_1/network/jlib, -dopatch.weblogic_classpath=, -dopatch.skip_oui_version_check=, -dopatch.nextgen_home_check=false, -dopatch.parallel_on_fmw_oh=] [may 17, 2023 10:26:35 am] [info] heap in use : 55 mb total memory: 962 mb free memory : 907 mb max memory : 2731 mb [may 17, 2023 10:26:35 am] [info] oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.37 oui version : 12.2.0.7.0 oui location : /u01/app/oracle/product/19.3.0/db_1/oui log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_10-26-34am_1.log [may 17, 2023 10:26:35 am] [info] patch history file: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch_history.txt [may 17, 2023 10:26:35 am] [info] invoking prereq "checkconflictagainstohwithdetail" [may 17, 2023 10:26:35 am] [info] [opsr-time] loading raw inventory [may 17, 2023 10:26:35 am] [info] [opsr-memory] loaded all components from inventory. heap memory in use: 95 (mb) [may 17, 2023 10:26:35 am] [info] [opsr-memory] loaded all one offs from inventory. heap memory in use: 100 (mb) [may 17, 2023 10:26:35 am] [info] [opsr-time] raw inventory loaded successfully [may 17, 2023 10:26:42 am] [info] [opsr-time] loading cooked inventory [may 17, 2023 10:26:42 am] [info] [opsr-memory] : loading cooked one offs. heap memory used 77 (mb) [may 17, 2023 10:26:44 am] [info] [opsr-memory] : loaded cooked oneoffs. heap memory used : 275 (mb) [may 17, 2023 10:26:44 am] [info] [opsr-time] cooked inventory loaded successfully [may 17, 2023 10:26:44 am] [info] cup_log: found poh cup 29517242 is a subset of other poh cup: 33515361 [may 17, 2023 10:26:44 am] [info] cup_log: found poh plo 33346851 implicitly overlays poh cup: 29517242 [may 17, 2023 10:26:44 am] [info] cup_log: found poh plo 33346851 implicitly overlays poh cup: 33515361 [may 17, 2023 10:26:48 am] [info] running prereq checkconflictagainstohwithdetail [may 17, 2023 10:26:48 am] [info] cup_log: found pi cup 34765931 is a superset of poh cup: 33515361 [may 17, 2023 10:26:51 am] [info] following patches can be applied: 34765931 [may 17, 2023 10:26:51 am] [info] following patches are not required: [may 17, 2023 10:26:51 am] [info] following patches are auto rollbackable: 33346851 [may 17, 2023 10:26:51 am] [info] finished checking prereq checkconflictagainstohwithdetail [may 17, 2023 10:26:51 am] [info] prereq "checkconflictagainstohwithdetail" passed. [may 17, 2023 10:26:51 am] [info] finishing prereqsession at wed may 17 10:26:51 cst 2023
6.1 grid升级ru
# root用户执行 【节点一执行】 [root@xxx ~]# /u01/app/19.3.0/grid/opatch/opatchauto apply /home/soft/34762026 -oh /u01/app/19.3.0/grid [root@xxx ~]# export grid_home=/u01/app/19.3.0/grid [root@xxx ~]# export path=$path:/u01/app/19.3.0/grid/opatch [root@xxx ~]# /u01/app/19.3.0/grid/opatch/opatchauto apply /home/soft/34762026 -oh /u01/app/19.3.0/grid opatchauto session is initiated at wed may 17 20:36:32 2023 system initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-05-17_08-36-40pm.log. session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2023-05-17_08-36-51pm.log the id for this session is n2bh executing opatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid patch applicability verified successfully on home /u01/app/19.3.0/grid executing patch validation checks on home /u01/app/19.3.0/grid patch validation checks successfully completed on home /u01/app/19.3.0/grid performing prepatch operations on crs - bringing down crs service on home /u01/app/19.3.0/grid prepatch operation log file location: /u01/app/grid/crsdata/local-test-orcl1/crsconfig/crs_prepatch_apply_inplace_local-test-orcl1_2023-05-17_08-38-40pm.log crs service brought down successfully on home /u01/app/19.3.0/grid start applying binary patch on home /u01/app/19.3.0/grid binary patch applied successfully on home /u01/app/19.3.0/grid performing postpatch operations on crs - starting crs service on home /u01/app/19.3.0/grid postpatch operation log file location: /u01/app/grid/crsdata/local-test-orcl1/crsconfig/crs_postpatch_apply_inplace_local-test-orcl1_2023-05-17_08-50-04pm.log crs service started successfully on home /u01/app/19.3.0/grid opatchauto successful. --------------------------------summary-------------------------------- patching is completed successfully. please find the summary as follows: host:local-test-orcl1 crs home:/u01/app/19.3.0/grid version:19.0.0.0.0 summary: ==following patches were skipped: patch: /home/soft/34762026/33575402 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_20-37-19pm_1.log reason: /home/soft/34762026/33575402 is not required to be applied to oracle home /u01/app/19.3.0/grid ==following patches were successfully applied: patch: /home/soft/34762026/34765931 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_20-41-31pm_1.log patch: /home/soft/34762026/34768559 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_20-41-31pm_1.log patch: /home/soft/34762026/34768569 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_20-41-31pm_1.log patch: /home/soft/34762026/34863894 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_20-41-31pm_1.log opatchauto session completed at wed may 17 20:55:35 2023 time taken to complete the session 18 minutes, 56 seconds
6.2 oracle升级ru
# root用户执行 【节点一执行】 [root@xxx ~]#/u01/app/oracle/product/19.3.0/db_1/opatch/opatchauto apply /home/soft/34762026/34765931 -oh /u01/app/oracle/product/19.3.0/db_1 opatchauto session is initiated at wed may 17 21:01:35 2023 system initialization log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2023-05-17_09-01-43pm.log. session log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2023-05-17_09-02-05pm.log the id for this session is zb8r executing opatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1 patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 executing patch validation checks on home /u01/app/oracle/product/19.3.0/db_1 patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/db_1 verifying sql patch applicability on home /u01/app/oracle/product/19.3.0/db_1 sql patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 preparing to bring down database service on home /u01/app/oracle/product/19.3.0/db_1 successfully prepared home /u01/app/oracle/product/19.3.0/db_1 to bring down database service bringing down database service on home /u01/app/oracle/product/19.3.0/db_1 following database(s) and/or service(s) are stopped and will be restarted later during the session: orcl database service successfully brought down on home /u01/app/oracle/product/19.3.0/db_1 performing prepatch operation on home /u01/app/oracle/product/19.3.0/db_1 prepatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1 start applying binary patch on home /u01/app/oracle/product/19.3.0/db_1 binary patch applied successfully on home /u01/app/oracle/product/19.3.0/db_1 performing postpatch operation on home /u01/app/oracle/product/19.3.0/db_1 postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1 starting database service on home /u01/app/oracle/product/19.3.0/db_1 database service successfully started on home /u01/app/oracle/product/19.3.0/db_1 preparing home /u01/app/oracle/product/19.3.0/db_1 after database service restarted no step execution required......... trying to apply sql patch on home /u01/app/oracle/product/19.3.0/db_1 no sql patch operations are required on local node for this home opatchauto successful. --------------------------------summary-------------------------------- patching is completed successfully. please find the summary as follows: host:local-test-orcl1 rac home:/u01/app/oracle/product/19.3.0/db_1 version:19.0.0.0.0 summary: ==following patches were successfully applied: patch: /home/soft/34762026/34765931 log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_21-05-02pm_1.log patching session reported following warning(s): _________________________________________________ [warning] the database instance 'orcl1' from '/u01/app/oracle/product/19.3.0/db_1', in host'local-test-orcl1' is not running. sql changes, if any, will not be applied. to apply. the sql changes, bring up the database instance and run the command manually from any one node (run as oracle). refer to the readme to get the correct steps for applying the sql changes. opatchauto session completed at wed may 17 21:13:12 2023 time taken to complete the session 11 minutes, 29 seconds
6.3 升级ojvm
# oracle用户操作，滚动升级，先停节点一 [oracle@xxx~]$ srvctl stop instance -d dbname -i instance_name_id [oracle@xxx~]$ cd /home/soft/34786990 [oracle@xxx~]$ $oracle_home/opatch/opatch apply [oracle@xxx 34786990]$ $oracle_home/opatch/opatch apply oracle interim patch installer version 12.2.0.1.37 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.37 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_21-28-05pm_1.log verifying environment and performing prerequisite checks... opatch continues with these patches: 34786990 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.3.0/db_1') is the local system ready for patching? [y|n] y user responded with: y backing up files... applying interim patch '34786990' to oh '/u01/app/oracle/product/19.3.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 34786990 successfully applied. sub-set patch [33561310] has become inactive due to the application of a super-set patch [34786990]. please refer to doc id 2161861.1 for any possible further required actions. log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_21-28-05pm_1.log opatch succeeded.
6.4 升级ocw
[oracle@xxx 34786990]$ $oracle_home/opatch/opatch lspatches 34786990;ojvm release update: 19.18.0.0.230117 (34786990) 34765931;database release update : 19.18.0.0.230117 (rel-jan230131) (34765931) 33529556;ocw release update 19.14.0.0.0 (33529556) opatch succeeded. # 发现oracle用户ocw补丁未打上 [oracle@xxx 34768559]$ cd /home/soft/34762026/34768559 [oracle@xxx 34768559]$ $oracle_home/opatch/opatch apply oracle interim patch installer version 12.2.0.1.37 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.37 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_21-41-05pm_1.log verifying environment and performing prerequisite checks... -------------------------------------------------------------------------------- start oop by prereq process. launch oop... oracle interim patch installer version 12.2.0.1.37 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.37 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_21-42-10pm_1.log verifying environment and performing prerequisite checks... opatch continues with these patches: 34768559 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.3.0/db_1') is the local system ready for patching? [y|n] y user responded with: y backing up files... applying interim patch '34768559' to oh '/u01/app/oracle/product/19.3.0/db_1' applysession: optional component(s) [ oracle.xag, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] , [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.rhp.crs, 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.db, 19.0.0.0.0... patching component oracle.rhp.db, 19.0.0.0.0... patching component oracle.rhp.common, 19.0.0.0.0... patching component oracle.has.common, 19.0.0.0.0... patching component oracle.has.db.cvu, 19.0.0.0.0... patching component oracle.has.rsf, 19.0.0.0.0... patching component oracle.has.common.cvu, 19.0.0.0.0... patch 34768559 successfully applied. sub-set patch [33529556] has become inactive due to the application of a super-set patch [34768559]. please refer to doc id 2161861.1 for any possible further required actions. log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_21-42-10pm_1.log opatch succeeded.
6.5 检查节点一补丁升级结果
# grid用户 [grid@xxx ~]$ $oracle_home/opatch/opatch lspatches 34863894;tomcat release update 19.0.0.0.0 (34863894) 34768569;acfs release update 19.18.0.0.0 (34768569) 34768559;ocw release update 19.18.0.0.0 (34768559) 34765931;database release update : 19.18.0.0.230117 (rel-jan230131) (34765931) 33575402;dbwlm release update 19.0.0.0.0 (33575402) opatch succeeded. # oracle用户 [oracle@xxx]$ $oracle_home/opatch/opatch lspatches 34768559;ocw release update 19.18.0.0.0 (34768559) 34786990;ojvm release update: 19.18.0.0.230117 (34786990) 34765931;database release update : 19.18.0.0.230117 (rel-jan230131) (34765931) opatch succeeded.
以上操作完成后，在其它节点重复执行上述操作。
7.1 升级数字字典
# oracle用户,【只需在其中一节点执行】 [root@xxx ~]# su - oracle # 若是cdb/pdb模式，需执行 alter pluggable database all open instances=all [oracle@xxx]$ cd $oracle_home/opatch [oracle@xxx opatch]$ ./datapatch -verbose [oracle@xxx opatch]$ srvctl start instance -d xxx -i xxx2 [oracle@xxx opatch]$ ./datapatch -verbose sql patching tool version 19.18.0.0.0 production on wed may 17 23:16:11 2023 米乐app官网下载 copyright (c) 2012, 2023, oracle. all rights reserved. log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_43164_2023_05_17_23_16_11/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 33346851 (dba_capture view returns incorrect last_enqueued_scn value): binary registry: not installed sql registry: rolled back successfully on 17-may-23 10.57.42.832087 pm interim patch 33561310 (ojvm release update: 19.14.0.0.220118 (33561310)): binary registry: not installed sql registry: applied successfully on 08-jun-22 06.40.51.184713 pm interim patch 34786990 (ojvm release update: 19.18.0.0.230117 (34786990)): binary registry: installed sql registry: not installed current state of release update sql patches: binary registry: 19.18.0.0.0 release_update 230127005551: installed sql registry: applied 19.18.0.0.0 release_update 230127005551 successfully on 17-may-23 10.57.45.923948 pm adding patches to installation queue and performing prereq checks...done installation queue: the following interim patches will be rolled back: 33561310 (ojvm release update: 19.14.0.0.220118 (33561310)) no release update patches need to be installed the following interim patches will be applied: 34786990 (ojvm release update: 19.18.0.0.230117 (34786990)) installing patches... patch installation complete. total patches installed: 2 validating logfiles...done patch 33561310 rollback: success logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33561310/24538862/33561310_rollback_orcl_2023may17_23_16_54.log (no errors) patch 34786990 apply: success logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34786990/25032666/34786990_apply_orcl_2023may17_23_18_34.log (no errors) sql patching tool complete on wed may 17 23:18:35 2023
7.2 处理无效对象
# oracle用户，在其中一节点执行 [oracle@xxx]$ cd $oracle_home/rdbms/admin [oracle@xxx admin]$ sqlplus /nolog sql> connect / as sysdba sql> @utlrp.sql timestamp -------------------------------------------------------------------------------- comp_timestamp utlrp_bgn 2023-05-17 23:21:38 doc> the following pl/sql block invokes utl_recomp to recompile invalid doc> objects in the database. recompilation time is proportional to the doc> number of invalid objects in the database, so this command may take doc> a long time to execute on a database with a large number of invalid doc> objects. doc> doc> use the following queries to track recompilation progress: doc> doc> 1. query returning the number of invalid objects remaining. this doc> number should decrease with time. doc> select count(*) from obj$ where status in (4, 5, 6); doc> doc> 2. query returning the number of objects compiled so far. this number doc> should increase with time. doc> select count(*) from utl_recomp_compiled; doc> doc> this script automatically chooses serial or parallel recompilation doc> based on the number of cpus available (parameter cpu_count) multiplied doc> by the number of threads per cpu (parameter parallel_threads_per_cpu). doc> on rac, this number is added across all rac nodes. doc> doc> utl_recomp uses dbms_scheduler to create jobs for parallel doc> recompilation. jobs are created without instance affinity so that they doc> can migrate across rac nodes. use the following queries to verify doc> whether utl_recomp jobs are being created and run correctly: doc> doc> 1. query showing jobs created by utl_recomp doc> select job_name from dba_scheduler_jobs doc> where job_name like 'utl_recomp_slave_%'; doc> doc> 2. query showing utl_recomp jobs that are running doc> select job_name from dba_scheduler_running_jobs doc> where job_name like 'utl_recomp_slave_%'; doc># pl/sql procedure successfully completed. timestamp -------------------------------------------------------------------------------- comp_timestamp utlrp_end 2023-05-17 23:21:49 doc> the following query reports the number of invalid objects. doc> doc> if the number is higher than expected, please examine the error doc> messages reported with each object (using show errors) to see if they doc> point to system misconfiguration or resource constraints that must be doc> fixed before attempting to recompile these objects. doc># objects with errors ------------------- 237 doc> the following query reports the number of exceptions caught during doc> recompilation. if this number is non-zero, please query the error doc> messages in the table utl_recomp_errors to see if any of these errors doc> are due to misconfiguration or resource constraints that must be doc> fixed before objects can compile successfully. doc> note: typical compilation errors (due to coding errors) are not doc> logged into this table: they go into dba_errors instead. doc># errors during recompilation --------------------------- 0 function created. pl/sql procedure successfully completed. function dropped. pl/sql procedure successfully completed.
7.3 检查升级结果
col status for a10 col action for a10 col action_time for a30 col description for a60 select patch_id,patch_type,action,status,action_time,description from dba_registry_sqlpatch; col version for a25 col comments for a80 select action_time,version,comments from dba_registry_history;
可通过在grid和oracle用户下分别执行 opatch lsinventory -detail -oh $oracle_home查看补丁详细信息。
以下信息是在节点一外其它节点补丁升级过程记录。
[root@xxx ~]# export grid_home=/u01/app/19.3.0/grid [root@xxx ~]# export path=$path:/u01/app/19.3.0/grid/opatch [root@xxx ~]# /u01/app/19.3.0/grid/opatch/opatchauto apply /home/soft/34762026 -oh /u01/app/19.3.0/grid opatchauto session is initiated at wed may 17 21:51:04 2023 system initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-05-17_09-51-13pm.log. session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2023-05-17_09-51-27pm.log the id for this session is srav executing opatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid patch applicability verified successfully on home /u01/app/19.3.0/grid executing patch validation checks on home /u01/app/19.3.0/grid patch validation checks successfully completed on home /u01/app/19.3.0/grid performing prepatch operations on crs - bringing down crs service on home /u01/app/19.3.0/grid prepatch operation log file location: /u01/app/grid/crsdata/local-test-orcl2/crsconfig/crs_prepatch_apply_inplace_local-test-orcl2_2023-05-17_09-53-18pm.log crs service brought down successfully on home /u01/app/19.3.0/grid start applying binary patch on home /u01/app/19.3.0/grid binary patch applied successfully on home /u01/app/19.3.0/grid performing postpatch operations on crs - starting crs service on home /u01/app/19.3.0/grid postpatch operation log file location: /u01/app/grid/crsdata/local-test-orcl2/crsconfig/crs_postpatch_apply_inplace_local-test-orcl2_2023-05-17_10-14-20pm.log crs service started successfully on home /u01/app/19.3.0/grid opatchauto successful. --------------------------------summary-------------------------------- patching is completed successfully. please find the summary as follows: host:local-test-orcl2 crs home:/u01/app/19.3.0/grid version:19.0.0.0.0 summary: ==following patches were skipped: patch: /home/soft/34762026/33575402 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_21-51-56pm_1.log reason: /home/soft/34762026/33575402 is not required to be applied to oracle home /u01/app/19.3.0/grid ==following patches were successfully applied: patch: /home/soft/34762026/34765931 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_21-56-40pm_1.log patch: /home/soft/34762026/34768559 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_21-56-40pm_1.log patch: /home/soft/34762026/34768569 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_21-56-40pm_1.log patch: /home/soft/34762026/34863894 log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_21-56-40pm_1.log opatchauto session completed at wed may 17 22:22:44 2023 time taken to complete the session 31 minutes, 32 seconds
[root@xxx ~]# export oracle_home=/u01/app/oracle/product/19.3.0/db_1 [root@xxx ~]# $oracle_home/opatch/opatchauto apply /home/soft/34762026/34765931 -oh /u01/app/oracle/product/19.3.0/db_1 opatchauto session is initiated at wed may 17 22:28:48 2023 system initialization log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2023-05-17_10-28-56pm.log. session log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2023-05-17_10-29-25pm.log the id for this session is qipk executing opatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1 patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 executing patch validation checks on home /u01/app/oracle/product/19.3.0/db_1 patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/db_1 verifying sql patch applicability on home /u01/app/oracle/product/19.3.0/db_1 sql patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 preparing to bring down database service on home /u01/app/oracle/product/19.3.0/db_1 successfully prepared home /u01/app/oracle/product/19.3.0/db_1 to bring down database service bringing down database service on home /u01/app/oracle/product/19.3.0/db_1 following database(s) and/or service(s) are stopped and will be restarted later during the session: orcl database service successfully brought down on home /u01/app/oracle/product/19.3.0/db_1 performing prepatch operation on home /u01/app/oracle/product/19.3.0/db_1 prepatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1 start applying binary patch on home /u01/app/oracle/product/19.3.0/db_1 binary patch applied successfully on home /u01/app/oracle/product/19.3.0/db_1 performing postpatch operation on home /u01/app/oracle/product/19.3.0/db_1 postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1 starting database service on home /u01/app/oracle/product/19.3.0/db_1 database service successfully started on home /u01/app/oracle/product/19.3.0/db_1 preparing home /u01/app/oracle/product/19.3.0/db_1 after database service restarted no step execution required......... trying to apply sql patch on home /u01/app/oracle/product/19.3.0/db_1 sql patch applied successfully on home /u01/app/oracle/product/19.3.0/db_1 opatchauto successful. --------------------------------summary-------------------------------- patching is completed successfully. please find the summary as follows: host:local-test-orcl2 rac home:/u01/app/oracle/product/19.3.0/db_1 version:19.0.0.0.0 summary: ==following patches were successfully applied: patch: /home/soft/34762026/34765931 log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-17_22-32-47pm_1.log patching session reported following warning(s): _________________________________________________ [warning] the database instance 'orcl2' from '/u01/app/oracle/product/19.3.0/db_1', in host'local-test-orcl2' is not running. sql changes, if any, will not be applied. to apply. the sql changes, bring up the database instance and run the command manually from any one node (run as oracle). refer to the readme to get the correct steps for applying the sql changes. opatchauto session completed at wed may 17 22:57:47 2023 time taken to complete the session 28 minutes, 51 seconds [root@local-test-orcl2 ~]# su - oracle last login: wed may 17 22:48:14 cst 2023 [oracle@local-test-orcl2 ~]$ $oracle_home/opatch/opatch lspatches 34765931;database release update : 19.18.0.0.230117 (rel-jan230131) (34765931) 33561310;ojvm release update: 19.14.0.0.220118 (33561310) 33529556;ocw release update 19.14.0.0.0 (33529556) opatch succeeded.
[oracle@xxx 34786990]$ srvctl stop instance -d orcl -i orcl2 [oracle@xxx 34786990]$ $oracle_home/opatch/opatch apply oracle interim patch installer version 12.2.0.1.37 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.37 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_23-03-03pm_1.log verifying environment and performing prerequisite checks... opatch continues with these patches: 34786990 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.3.0/db_1') is the local system ready for patching? [y|n] y user responded with: y backing up files... applying interim patch '34786990' to oh '/u01/app/oracle/product/19.3.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 34786990 successfully applied. sub-set patch [33561310] has become inactive due to the application of a super-set patch [34786990]. please refer to doc id 2161861.1 for any possible further required actions. log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_23-03-03pm_1.log opatch succeeded.
[oracle@xxx soft]$ cd /home/soft/34762026/34768559 [oracle@xxx 34768559]$ $oracle_home/opatch/opatch apply oracle interim patch installer version 12.2.0.1.37 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.37 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_23-09-41pm_1.log verifying environment and performing prerequisite checks... -------------------------------------------------------------------------------- start oop by prereq process. launch oop... oracle interim patch installer version 12.2.0.1.37 米乐app官网下载 copyright (c) 2023, oracle corporation. all rights reserved. oracle home : /u01/app/oracle/product/19.3.0/db_1 central inventory : /u01/app/orainventory from : /u01/app/oracle/product/19.3.0/db_1/orainst.loc opatch version : 12.2.0.1.37 oui version : 12.2.0.7.0 log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_23-10-48pm_1.log verifying environment and performing prerequisite checks... opatch continues with these patches: 34768559 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.3.0/db_1') is the local system ready for patching? [y|n] y user responded with: y backing up files... applying interim patch '34768559' to oh '/u01/app/oracle/product/19.3.0/db_1' applysession: optional component(s) [ oracle.xag, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] , [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.rhp.crs, 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.db, 19.0.0.0.0... patching component oracle.rhp.db, 19.0.0.0.0... patching component oracle.rhp.common, 19.0.0.0.0... patching component oracle.has.common, 19.0.0.0.0... patching component oracle.has.db.cvu, 19.0.0.0.0... patching component oracle.has.rsf, 19.0.0.0.0... patching component oracle.has.common.cvu, 19.0.0.0.0... patch 34768559 successfully applied. sub-set patch [33529556] has become inactive due to the application of a super-set patch [34768559]. please refer to doc id 2161861.1 for any possible further required actions. log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-05-17_23-10-48pm_1.log opatch succeeded.
在升级过程中，发现执行datapatch -verbose 会升级ojvm的信息，会先将早期ojvm版本回退，然后升级19.18的ojvm补丁。
但我在本次升级过程中，是通过手工分别在所有节点升级了ojvm。
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【米乐app官网下载的版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。