前提说明:通过opatchauto的方式发现1节点和其他3个节点GI补丁版本不一致,导致ASM无法操作ORA-15137: The ASM cluster is in rolling patch state,所以改用手动方式;
官方参考文档:
Supplemental Readme - Grid Infrastructure Release Update 12.2.0.1.x / 18c /19c (Doc ID 2246888.1)
环境说明:
4节点RAC
mcxdb1
mcxdb2
mcxdb3
mcxdb4
前置准备:
1)升级GI DB OPatch Version: 12.2.0.1.19
2)下载并解压Patch
存放路径/u01/soft/30899722
chmod -R 775 /u01/soft/30899722
1.执行补丁冲突检查
#grid
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30869156
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30894985
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30869304
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/
/u01/app/19c/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30898856
#oracle
/u01/app/19c/oracle/product/19.3.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30869156
/u01/app/19c/oracle/product/19.3.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/30899722/30894985
2.手动打GI PATCH
#以下步骤4个节点依次执行,全部执行成功之后,再执行DB PATCH
#oracle:
srvctl stop home -o /u01/app/19c/oracle/product/19.3.0/db_1 -s /home/oracle/stat.f -n mcxdb1
#root
[root@mcxdb1 ~]# /u01/app/19c/19.3.0/grid/crs/install/rootcrs.sh -prepatch
#grid:
/u01/app/19c/19.3.0/grid/OPatch/opatch apply -oh /u01/app/19c/19.3.0/grid -local /u01/soft/30899722/30894985
/u01/app/19c/19.3.0/grid/OPatch/opatch apply -oh /u01/app/19c/19.3.0/grid -local /u01/soft/30899722/30869304
/u01/app/19c/19.3.0/grid/OPatch/opatch apply -oh /u01/app/19c/19.3.0/grid -local /u01/soft/30899722/30869156
/u01/app/19c/19.3.0/grid/OPatch/opatch apply -oh /u01/app/19c/19.3.0/grid -local /u01/soft/30899722/30898856
#execute as root
/oracle/app/19.7.0/grid/rdbms/install/rootadd_rdbms.sh
/oracle/app/19.7.0/grid/crs/install/rootcrs.sh -postpatch
#grid:crsctl query crs softwarepatch
[grid@mcxdb1 ~]$ crsctl query crs softwarepatch
Oracle Clusterware patch level on node mcxdb1 is [3633918477].
3.手动打DB PATCH
#以下步骤待GI补丁所有节点均打成功后再执行
#节点2/3/4执行,1节点不需要执行
chmod 775 /u01/app/19c/grid/oraInventory/ContentsXML/oui-patch.xml
#oracle
/u01/soft/30899722/30894985/custom/scripts/prepatch.sh -dbhome /u01/app/19c/oracle/product/19.3.0/db_1
/u01/app/19c/oracle/product/19.3.0/db_1/OPatch/opatch apply -oh /u01/app/19c/oracle/product/19.3.0/db_1 -local /u01/soft/30899722/30894985
/u01/app/19c/oracle/product/19.3.0/db_1/OPatch/opatch apply -oh /u01/app/19c/oracle/product/19.3.0/db_1 -local /u01/soft/30899722/30869156
/u01/soft/30899722/30894985/custom/scripts/postpatch.sh -dbhome /u01/app/19c/oracle/product/19.3.0/db_1
#oracle
srvctl start home -o /u01/app/19c/oracle/product/19.3.0/db_1 -s /home/oracle/stat.f -n mcxdb1
#以上DB PATCH步骤,4个节点DB均打patch成功后,任一节点运行
cd $ORACLE_HOME/OPatch
./datapatch -verbose
编辑失效对象
SQL> @?/rdbms/admin/utlrp.sql
4.验证补丁信息
#登录数据库查看补丁注册信息
SQL> select INSTALL_ID,PATCH_ID,ACTION,STATUS,ACTION_TIME,DESCRIPTION,SOURCE_VERSION,TARGET_VERSION from dba_registry_sqlpatch;
INSTALL_ID PATCH_ID ACTION STATUS ACTION_TIME DESCRIPTION SOURCE_VERSION TARGET_VERSION
---------- ---------- --------------- ------------------------- --------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- --------------- ---------------
1 30869156 APPLY SUCCESS 29-APR-20 06.06.17.095013 PM Database Release Update : 19.7.0.0.200414 (30869156) 19.1.0.0.0 19.7.0.0.0
#验证补丁信息GI DB,4节点均验证
[oracle@mcxdb1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19c/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/19c/grid/oraInventory
from : /u01/app/19c/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.7.0
Log file location : /u01/app/19c/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-05-10_20-46-48PM_1.log
Lsinventory Output file location : /u01/app/19c/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-05-10_20-46-48PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: mcxdb1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 19c 19.0.0.0.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 30869156 : applied on Mon May 04 23:00:53 CST 2020
Unique Patch ID: 23493838
Patch description: "Database Release Update : 19.7.0.0.200414 (30869156)"
Created on 6 Apr 2020, 23:20:53 hrs PST8PDT
Bugs fixed:
30533132, 30312546, 29924181, 29549154, 30937410, 29970081, 8476681
14735102, 17428816, 19080742, 19697993, 20313356, 21374587, 21965541
23296836, 23606241, 24687075, 24971456, 25756945, 25806201, 25883179
... ...
Patch 30894985 : applied on Mon May 04 22:50:04 CST 2020
Unique Patch ID: 23451591
Patch description: "OCW RELEASE UPDATE 19.7.0.0.0 (30894985)"
Created on 10 Apr 2020, 05:35:01 hrs PST8PDT
Bugs fixed:
17787434, 25736599, 26675491, 27148384, 27222128, 27262781, 27505699
27526265, 27572040, 27604329, 27760043, 27877830, 28302439, 28302580
28319989, 28406406, 28441307, 28470673, 28554809, 28567875, 28621543
... ...
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@mcxdb1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19c/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/19c/grid/oraInventory
from : /u01/app/19c/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.7.0
Log file location : /u01/app/19c/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-05-10_20-46-48PM_1.log
Lsinventory Output file location : /u01/app/19c/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-05-10_20-46-48PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: mcxdb1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 19c 19.0.0.0.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 30869156 : applied on Mon May 04 23:00:53 CST 2020
Unique Patch ID: 23493838
Patch description: "Database Release Update : 19.7.0.0.200414 (30869156)"
Created on 6 Apr 2020, 23:20:53 hrs PST8PDT
Bugs fixed:
30533132, 30312546, 29924181, 29549154, 30937410, 29970081, 8476681
14735102, 17428816, 19080742, 19697993, 20313356, 21374587, 21965541
23296836, 23606241, 24687075, 24971456, 25756945, 25806201, 25883179
... ...
Patch 30894985 : applied on Mon May 04 22:50:04 CST 2020
Unique Patch ID: 23451591
Patch description: "OCW RELEASE UPDATE 19.7.0.0.0 (30894985)"
Created on 10 Apr 2020, 05:35:01 hrs PST8PDT
Bugs fixed:
17787434, 25736599, 26675491, 27148384, 27222128, 27262781, 27505699
27526265, 27572040, 27604329, 27760043, 27877830, 28302439, 28302580
28319989, 28406406, 28441307, 28470673, 28554809, 28567875, 28621543
... ...
--------------------------------------------------------------------------------
OPatch succeeded.