rac数据库下oracle打小补丁,ORACLE 11G RAC打补丁

*******************不停也是可以的，但为了保险 起见最好停服！！！！！*********************

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 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 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 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)