Chinaunix首页 | 论坛 | 博客

东北胖子dyspangzi.blog.chinaunix.net

首页　| 　博文目录　| 　关于我

东北胖子

  • 博客访问： 378910
  • 博文数量： 50
  • 博客积分： 309
  • 博客等级： 二等列兵
  • 技术积分： 503
  • 用 户 组： 普通用户
  • 注册时间： 2010-05-09 20:16
文章分类

全部博文（50）

文章存档

2018年（2）

2015年（1）

2014年（21）

2013年（24）

2012年（1）

2010年（1）

我的朋友
最近访客
推荐博文
相关博文
Applying PSU Patch 11.2.0.1.2 To A Two Node RAC – Part2

分类： Oracle

2014-09-06 00:10:14

This article is continuation to the previous article 

In this article i want to show you the session output for PSU patch application and the session output for  roll backing a PSU patch.

This is the best example to show the hot patching in RAC 11gR2. The patch is applied in a rolling fashion on each node of the cluster. The clusterware automatically relocates the services to other node while patching is running on some node. The end user does not feel any service interruption.

PSU Patch On GRID_HOME(Node1 and Node2)
On b600e6tr01:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
[root@b600e6tr01 ~]# cd /u01/home/oracle/product/11.2.0/db_1/patches/psupatch
[root@b600e6tr01 psupatch]# opatch auto . -oh /u01/home/11.2.0/grid
Executing /usr/bin/perl /u01/home/11.2.0/grid/OPatch/crs/patch112.pl -patchdir . -patchn . -oh /u01/home/11.2.0/grid -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-04-19_11-28-59.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/11.2.0/grid/ocm.rsp
 
Unable to determine if /u01/home/11.2.0/grid is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
Successfully unlock /u01/home/11.2.0/grid
patch ././9655006  apply successful for home  /u01/home/11.2.0/grid
patch ././9654983  apply successful for home  /u01/home/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@b600e6tr01 psupatch]#

On b600e6tr02:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
[root@b600e6tr02 psupatch]# opatch auto . -oh /u01/home/11.2.0/grid
Executing /usr/bin/perl /u01/home/11.2.0/grid/OPatch/crs/patch112.pl -patchdir . -patchn . -oh /u01/home/11.2.0/grid -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-04-19_12-26-36.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/11.2.0/grid/ocm.rsp
 
Unable to determine if /u01/home/11.2.0/grid is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
Successfully unlock /u01/home/11.2.0/grid
patch ././9655006  apply successful for home  /u01/home/11.2.0/grid
patch ././9654983  apply successful for home  /u01/home/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@b600e6tr02 psupatch]#

PSU Patch On RDBMS_HOME(Node1 and Node2)
On b600e6tr01 :

1
2
3
4
5
6
7
8
9
10
11
12
13
[root@b600e6tr01 psupatch]# /u01/home/oracle/product/11.2.0/db_1/OPatch/opatch auto . -oh  /u01/home/oracle/product/11.2.0/db_1
Executing /usr/bin/perl /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/patch112.pl -patchdir . -patchn . -oh /u01/home/oracle/product/11.2.0/db_1 -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2011-04-19_13-52-07.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/oracle/product/11.2.0/db_1/ocm.rsp
 
Unable to determine if /u01/home/oracle/product/11.2.0/db_1 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
patch ././9655006/custom/server/9655006  apply successful for home  /u01/home/oracle/product/11.2.0/db_1
patch ././9654983  apply successful for home  /u01/home/oracle/product/11.2.0/db_1
[root@b600e6tr01 psupatch]#

On b600e6tr02:

1
2
3
4
5
6
7
8
9
10
11
12
13
[root@b600e6tr02 psupatch]# /u01/home/oracle/product/11.2.0/db_1/OPatch/opatch auto . -oh  /u01/home/oracle/product/11.2.0/db_1
Executing /usr/bin/perl /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/patch112.pl -patchdir . -patchn . -oh /u01/home/oracle/product/11.2.0/db_1 -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2011-04-19_13-28-55.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/oracle/product/11.2.0/db_1/ocm.rsp
 
Unable to determine if /u01/home/oracle/product/11.2.0/db_1 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
patch ././9655006/custom/server/9655006  apply successful for home  /u01/home/oracle/product/11.2.0/db_1
patch ././9654983  apply successful for home  /u01/home/oracle/product/11.2.0/db_1
[root@b600e6tr02 psupatch]#

RollBack PSU Patch On GRID_HOME(Node1 and Node2)
On b600e6tr01:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
[oracle@b600e6tr01 ~]$ sudo su -
[root@b600e6tr01 ~]# /u01/home/11.2.0/grid/OPatch/opatch auto /u01/home/oracle/product/11.2.0/db_1/patches/psupatch -rollback -oh /u01/home/11.2.0/grid
Executing /usr/bin/perl /u01/home/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /u01/home/oracle/product/11.2.0/db_1/patches -patchn psupatch -rollback -oh /u01/home/11.2.0/grid -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-05-04_07-27-40.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/11.2.0/grid/ocm.rsp
 
Unable to determine if /u01/home/11.2.0/grid is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
Successfully unlock /u01/home/11.2.0/grid
patch 9655006  rollback successful for home /u01/home/11.2.0/grid
patch 9654983  rollback successful for home /u01/home/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@b600e6tr01 ~]#

On b600e6tr02:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
[oracle@b600e6tr02 ~]$ sudo su -
[root@b600e6tr02 ~]# /u01/home/11.2.0/grid/OPatch/opatch auto /u01/home/oracle/product/11.2.0/db_1/patches/psupatch -rollback -oh /u01/home/11.2.0/grid
Executing /usr/bin/perl /u01/home/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /u01/home/oracle/product/11.2.0/db_1/patches -patchn psupatch -rollback -oh /u01/home/11.2.0/grid -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-05-04_07-41-37.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/11.2.0/grid/ocm.rsp
 
Unable to determine if /u01/home/11.2.0/grid is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
Successfully unlock /u01/home/11.2.0/grid
patch 9655006  rollback successful for home /u01/home/11.2.0/grid
patch 9654983  rollback successful for home /u01/home/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@b600e6tr02 ~]#

RollBack PSU Patch ON RDBMS_HOME(Node1 and Node2)
On b600e6tr01 :

1
2
3
4
5
6
7
8
9
10
11
12
13
[root@b600e6tr01 ~]# /u01/home/oracle/product/11.2.0/db_1/OPatch/opatch auto /u01/home/oracle/product/11.2.0/db_1/patches/psupatch -rollback  -oh  /u01/home/oracle/product/11.2.0/db_1
Executing /usr/bin/perl /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/patch112.pl -patchdir /u01/home/oracle/product/11.2.0/db_1/patches -patchn psupatch -rollback -oh /u01/home/oracle/product/11.2.0/db_1 -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2011-05-04_07-54-30.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/oracle/product/11.2.0/db_1/ocm.rsp
 
Unable to determine if /u01/home/oracle/product/11.2.0/db_1 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
patch 9655006  rollback successful for home /u01/home/oracle/product/11.2.0/db_1
patch 9654983  rollback successful for home /u01/home/oracle/product/11.2.0/db_1
[root@b600e6tr01 ~]#

On b600e6tr02:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
[root@b600e6tr02 ~]#
[root@b600e6tr02 ~]# /u01/home/oracle/product/11.2.0/db_1/OPatch/opatch auto /u01/home/oracle/product/11.2.0/db_1/patches/psupatch -rollback  -oh  /u01/home/oracle/product/11.2.0/db_1
Executing /usr/bin/perl /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/patch112.pl -patchdir /u01/home/oracle/product/11.2.0/db_1/patches -patchn psupatch -rollback -oh /u01/home/oracle/product/11.2.0/db_1 -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2011-05-04_08-01-19.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/oracle/product/11.2.0/db_1/ocm.rsp
 
Unable to determine if /u01/home/oracle/product/11.2.0/db_1 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
patch 9655006  rollback successful for home /u01/home/oracle/product/11.2.0/db_1
patch 9654983  rollback successful for home /u01/home/oracle/product/11.2.0/db_1
[root@b600e6tr02 ~]#

Hope it helps

SRI

阅读(2870) | 评论(0) | 转发(0) |
0

上一篇：Applying PSU Patch 11.2.0.1.2 To A Two Node RAC

下一篇：How to RollBack a Database PSU

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6