11g grid 2节点数据安装PSU丨【绽放吧！数据库】
【摘要】 1,下载OPatch版本要求 OPatch utility version 11.2.0.3.6 or later to apply this patch下载地址：6880880grid Opatch 替换：rm -rf /u01/app/11.2.0/grid/OPatch/unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0/...
集群和数据库版本：11.2.0.4.0
补丁版本：p28429134_112040_Linux-x86-64.zip 11.2.0.4.181016
OPatch版本：p6880880_112000_Linux-x86-64.zip OPatch Version: 11.2.0.3.29
1,下载OPatch
版本要求 OPatch utility version 11.2.0.3.6 or later to apply this patch
下载地址：6880880
grid Opatch 替换：
rm -rf /u01/app/11.2.0/grid/OPatch/
unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0/grid/
chown grid:oinstall -R /u01/app/11.2.0/grid/OPatch/
/u01/app/11.2.0/grid/OPatch/opatch version
[root@db01 soft]# /u01/app/11.2.0/grid/OPatch/opatch version
OPatch Version: 11.2.0.3.29
OPatch succeeded.
oracle Opatch 替换：
rm -rf /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/
unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0/dbhome_1/
chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/
/u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch version
[root@db01 soft]# /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch version
OPatch Version: 11.2.0.3.29
2，节点01补丁安装
unzip p28429134_112040_Linux-x86-64.zip
chown -R grid:oinstall 28429134/
[root@db01 soft]# /u01/app/11.2.0/grid/OPatch/opatch auto /soft/28429134
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 28429134 -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2021-08-09_20-10-36.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2021-08-09_20-10-36.report.log
2021-08-09 20:10:36: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully
patch /soft/28429134/27735020/custom/server/27735020 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1
patch /soft/28429134/28204707 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1
Stopping CRS...
Stopped CRS successfully
patch /soft/28429134/27735020 apply successful for home /u01/app/11.2.0/grid
patch /soft/28429134/28204707 apply successful for home /u01/app/11.2.0/grid
patch /soft/28429134/28204939 apply successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
Started RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully
opatch auto succeeded.
3，节点02补丁安装
root解压并修改权限
unzip p28429134_112040_Linux-x86-64.zip
chown -R grid:oinstall 28429134/补丁安装：
[root@db02 soft]# /u01/app/11.2.0/grid/OPatch/opatch auto /soft/28429134
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 28429134 -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2021-08-09_20-31-17.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2021-08-09_20-31-17.report.log
2021-08-09 20:31:17: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully
patch /soft/28429134/27735020/custom/server/27735020 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1
patch /soft/28429134/28204707 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1
Stopping CRS...
Stopped CRS successfully
patch /soft/28429134/27735020 apply successful for home /u01/app/11.2.0/grid
patch /soft/28429134/28204707 apply successful for home /u01/app/11.2.0/grid
patch /soft/28429134/28204939 apply successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
Started RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully
opatch auto succeeded.
4，检查补丁安装情况：
[grid@db01 ~]$ /u01/app/11.2.0/grid/OPatch/opatch lspatches
28204939;ACFS Patch Set Update : 11.2.0.4.181016 (28204939)
28204707;Database Patch Set Update : 11.2.0.4.181016 (28204707)
27735020;OCW Patch Set Update : 11.2.0.4.181016 (27735020)[oracle@db01 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lspatches
28204707;Database Patch Set Update : 11.2.0.4.181016 (28204707)
27735020;OCW Patch Set Update : 11.2.0.4.181016 (27735020)
5,检查数据库状态
[grid@db01 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE db01
ONLINE ONLINE db02
ora.LISTENER.lsnr
ONLINE ONLINE db01
ONLINE ONLINE db02
ora.asm
ONLINE ONLINE db01 Started
ONLINE ONLINE db02 Started
ora.gsd
OFFLINE OFFLINE db01
OFFLINE OFFLINE db02
ora.net1.network
ONLINE ONLINE db01
ONLINE ONLINE db02
ora.ons
ONLINE ONLINE db01
ONLINE ONLINE db02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE db01
ora.cvu
1 ONLINE ONLINE db01
ora.db01.vip
1 ONLINE ONLINE db01
ora.db02.vip
1 ONLINE ONLINE db02
ora.oc4j
1 ONLINE ONLINE db01
ora.ora.db
1 ONLINE ONLINE db01 Open
2 ONLINE ONLINE db02 Open
ora.scan1.vip
1 ONLINE ONLINE db01
[grid@db01 ~]$
附录：
新版本OPatch 已经不需要指定ocm response file.
Supplemental Readme - Patch Installation and Deinstallation for 12.1.0.x.x GI PSU and Database Proactive Bundle Patch (文档 ID 1591616.1)
The OPatch utility will prompt for your OCM (Oracle Configuration Manager) response file when it is run. You should enter a complete path of OCM response file if you already have created this in your environment.
If you do not have the OCM response file (ocm.rsp), then you should run the following command to create it.
As the GI home owner execute:
$ <ORACLE_HOME>/OPatch/ocm/bin/emocmrsp
Note: as latest opatch doesn't contain OCM anymore, the option "-ocmrf" is unnecessary if latest opatch is being used, refer to the following for details:【绽放吧！数据库】有奖征文火热进行中：https://bbs.huaweicloud.com/blogs/285617
【版权声明】本文为华为云社区用户原创内容，转载时必须标注文章的来源（华为云社区）、文章链接、文章作者等基本信息， 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）