ORACLE 11G RAC打补丁

来源：这里教程网时间：2026-03-03 12:15:02 作者：

*******************不停也是可以的，但为了保险起见最好停服！！！！！********************* 1.1 打grid和db补丁注：先一节点、二节点打完GI补丁,然后一节点、二节点打数据库补丁. 节点一: 1、解压软件、更改权限以及替换OPatch [root@ivrdb01 ~]#cd /tools [root@ivrdb01 tools]#unzip p6880880_112000_Linux-x86-64.zip [root@ivrdb01 tools]#unzip p22378167_112040_Linux-x86-64.zip [root@ivrdb01 ~]# cd /u01/app/11.2.0/grid [root@ ivrdb01 grid]# mv OPatch OPatch_old [root@ ivrdb01 grid]# cp -rp /tools/OPatch ./ [root@ ivrdb01 grid]# chmod -R 775 OPatch [root@ ivrdb01 grid]# chown -R grid:oinstall OPatch [root@ ivrdb01 grid]# su - oracle [oracle@ ivrdb01 ~]$ echo $ORACLE_HOME /u01/app/oracle/product/11.2.0/dbhome_1 [root@ ivrdb01 grid]# cd /u01/app/oracle/product/11.2.0/dbhome_1 [root@ ivrdb01 dbhome_1]# mv OPatch OPatch_old [root@ ivrdb01 dbhome_1]# cp -rp /tools/OPatch ./OPatch [root@ ivrdb01 dbhome_1]# chown -R oracle:oinstall OPatch [root@ ivrdb01 dbhome_1]# chmod -R 775 OPatch 2、验证Opacth版本 [grid@ivrdb01 tmp]$ /u01/app/11.2.0/grid/OPatch/opatch version OPatch Version: 11.2.0.3.6 OPatch succeeded. [root@ivrdb01 dbhome_1]# su - oracle [oracle@ivrdb02 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch version OPatch Version: 11.2.0.3.6 3、生成ocm文件( grid 和 oracle ) [grid@ivrdb01 /]$cd /tmp [grid@ivrdb01 tmp]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp OCM Installation Response Generator 10.3.4.0.0 - Production Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y The OCM configuration response file (ocm.rsp) was successfully created. [grid@ivrdb01 tmp]$ chmod 777 ocm.rsp [oracle@ivrdb01 /]$cd /tmp [oracle@ivrdb01 tmp]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp OCM Installation Response Generator 10.3.4.0.0 - Production Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y The OCM configuration response file (ocm.rsp) was successfully created. [oracle@ivrdb01 tmp]$chmod 777 ocm.rsp 4、开始分别grid和db软件补丁(22191577权限为grid) [root@ ivrdb01 22191577]# /u01/app/11.2.0/grid/OPatch/opatch auto /tools/22378167/22191577 -ocmrf /tmp/ocm.rsp -oh /u01/app/11.2.0/grid Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /tools/22378167 -patchn 22191577 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-05-13_14-30-24.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/opatchauto2016-05-13_14-30-24.report.log 2016-05-13 14:30:24: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params Stopping CRS... Stopped CRS successfully patch /tools/22378167/22191577/21948347 apply successful for home /u01/app/11.2.0/grid patch /tools/22378167/22191577/21948348 apply successful for home /u01/app/11.2.0/grid patch /tools/22378167/22191577/21948355 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. opatch auto succeeded. [root@node1 22646198]# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /home/22646198/ -ocmrf /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/ocm.rsp -oh /u01/app/oracle/product/11.2.0/db_1 This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-05-13_14-24-02.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/opatchauto2016-05-13_14-24-02.report.log 2016-05-13 14:24:02: 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 /tools/22378167/22191577/21948347 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1 patch /tools/22378167/22191577/21948348/custom/server/21948348 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1 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. [root@ ivrdb01 22191577]# su - grid [grid@ ivrdb01 ~]$ /u01/app/11.2.0/grid/OPatch/opatch lspatches 21948355;ACFS Patch Set Update : 11.2.0.4.160119 (21948355) 21948348;OCW Patch Set Update : 11.2.0.4.160119 (21948348) 21948347;Database Patch Set Update : 11.2.0.4.160119 (21948347) 节点二: 1、解压软件、更改权限以及替换OPatch [root@ivrdb02 ~]#cd /tools [root@ivrdb02 tools]#unzip p6880880_112000_Linux-x86-64.zip [root@ivrdb02 tools]#unzip p22378167_112040_Linux-x86-64.zip [root@ivrdb02 ~]# cd /u01/app/11.2.0/grid [root@ivrdb02 grid]# mv OPatch OPatch_old [root@ivrdb02 grid]# cp -rp /tools/OPatch ./ [root@ivrdb02 grid]# chmod -R 775 OPatch [root@ivrdb02 grid]# chown -R grid:oinstall OPatch [root@ivrdb02 grid]# su - oracle [oracle@ivrdb02 ~]$ echo $ORACLE_HOME /u01/app/oracle/product/11.2.0/dbhome_1 [root@ivrdb02 grid]# cd /u01/app/oracle/product/11.2.0/dbhome_1 [root@ivrdb02 dbhome_1]# mv OPatch OPatch_old [root@ivrdb02 dbhome_1]# cp -rp /tools/OPatch ./OPatch [root@ivrdb02 dbhome_1]# chown -R oracle:oinstall OPatch [root@ivrdb02 dbhome_1]# chmod -R 775 OPatch 2、验证Opacth版本 [grid@ivrdb02 tmp]$ /u01/app/11.2.0/grid/OPatch/opatch version OPatch Version: 11.2.0.3.6 OPatch succeeded. [root@ivrdb02 dbhome_1]# su - oracle [oracle@ivrdb02 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch version OPatch Version: 11.2.0.3.6 OPatch succeeded. 3、生成ocm文件（ grid和oracle ） [grid@ivrdb02 /]$cd /tmp [grid@ ivrdb02 tmp]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp OCM Installation Response Generator 10.3.4.0.0 - Production Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y The OCM configuration response file (ocm.rsp) was successfully created. [grid@ ivrdb02 tmp]$ chmod 777 ocm.rsp 3、开始分别grid和db软件补丁 [root@ ivrdb02 22191577]# /u01/app/11.2.0/grid/OPatch/opatch auto /tools/22378167/22191577 -ocmrf /tmp/ocm.rsp -oh /u01/11.2.0/grid Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /tools/22378167 -patchn 22191577 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-05-13_14-32-25.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/opatchauto2016-05-13_14-32-25.report.log 2016-05-13 14:30:24: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params Stopping CRS... Stopped CRS successfully patch /tools/22378167/22191577/21948347 apply successful for home /u01/app/11.2.0/grid patch /tools/22378167/22191577/21948348 apply successful for home /u01/app/11.2.0/grid patch /tools/22378167/22191577/21948355 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. opatch auto succeeded. [root@node1 22646198]# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /home/22646198/ -ocmrf /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/ocm.rsp -oh /u01/app/oracle/product/11.2.0/db_1 This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-05-13_14-44-02.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/opatchauto2016-05-13_14-44-02.report.log 2016-05-13 14:24:02: 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 /tools/22378167/22191577/21948347 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1 patch /tools/22378167/22191577/21948348/custom/server/21948348 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1 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. [root@ ivrdb02 22191577]# su - grid [grid@ ivrdb02 ~]$ /u01/app/11.2.0/grid/OPatch/opatch lspatches 21948355;ACFS Patch Set Update : 11.2.0.4.160119 (21948355) 21948348;OCW Patch Set Update : 11.2.0.4.160119 (21948348) 21948347;Database Patch Set Update : 11.2.0.4.160119 (21948347) 检查：针对ORACLE 11 G su - oracle $ cd $ORACLE_HOME/OPatch/ $ ./opatch lsinventory -oh $ORACLE_HOME su – grid $ cd $ORACLE_HOME $ cd OPatch/ $ ./opatch lsinventory -oh $ORACLE_HOME 5.3 启动集群和确认PSU信息节点1： [root@ ivrdb01 22191577]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been started. 节点2： [root@ ivrdb012 22191577]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been started. 核对psu信息: 已经升级到16版本 [grid@ivrdb01 ~]$ /u01/app/11.2.0/grid/OPatch/opatch lspatches 1852360; 21948355;ACFS Patch Set Update : 11.2.0.4.160119 (21948355) 21948348;OCW Patch Set Update : 11.2.0.4.160119 (21948348) 21948347;Database Patch Set Update : 11.2.0.4.160119 (21948347) [grid@ivrdb02 ~]$ /u01/app/11.2.0/grid/OPatch/opatch lspatches 1852360; 21948355;ACFS Patch Set Update : 11.2.0.4.160119 (21948355) 21948348;OCW Patch Set Update : 11.2.0.4.160119 (21948348) 21948347;Database Patch Set Update : 11.2.0.4.160119 (21948347) [oracle@ ivrdb01 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lspatches 22139245;ORACLE JAVAVM COMPONENT 11.2.0.4.160119 DATABASE PSU (JAN2016) 21948348;OCW Patch Set Update : 11.2.0.4.160119 (21948348) 21948347;Database Patch Set Update : 11.2.0.4.160119 (21948347) [oracle@ ivrdb02 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lspatches 22139245;ORACLE JAVAVM COMPONENT 11.2.0.4.160119 DATABASE PSU (JAN2016) 21948348;OCW Patch Set Update : 11.2.0.4.160119 (21948348) 21948347;Database Patch Set Update : 11.2.0.4.160119 (21948347)