Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

3

积分

0

好友

0

主题
1#
发表于 2012-8-20 16:47:19 | 查看: 4179| 回复: 2
首先是我的环境:
OS: OEL 5.5 x86_64 on Vmware Workstation 8
Oracle Version: 11.2.0.1 Running RAC

实现目标:RAC 在线滚动升级,从11.2.0.1到11.2.0.3
Apply Patch : 9413827 and 10404530
升级方式:out-of-place

遇到的问题:升级GI时,第一个节点执行rootupgrade.sh成功,第二个节点执行rootupgrade.sh,输出Oracle Clusterware operating version was successfully set to 11.2.0.3.0后两个节点都重启,滚动升级失败。

具体情况:
    1) opatch升级到最新版
           $ /u01/app/11.2.0/grid/OPatch/opatch
           Oracle Interim Patch Installer version 11.2.0.3.0

    2) 两个节点滚动方式打上了Patch - 9413827,采用手动napply方式

    3) 进行CVU工具检查,结果成功,如下:
          $ ./runcluvfy.sh stage -pre crsinst -upgrade -n rac1,rac2 -rolling -src_crshome /u01/app/11.2.0/grid -dest_crshome /u01/app/11.2.0.3/grid -dest_version 11.2.0.3.0 -verbose
          输出最后一行:Pre-check for cluster services setup was successful.

    4) 开始升级GI,顺利到达以root用户执行rootupgrade.sh脚本提示。
        
    5) 第一个节点执行脚本成功
         
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in inittab
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Preparing packages for installation...
cvuqdisk-1.0.9-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded


    6) 第二节点,脚本没执行完两个节点都重启,节点重启之前的脚本输出如下
         
CRS-2673: Attempting to stop 'ora.diskmon' on 'rac2'
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac2'
CRS-2677: Stop of 'ora.gipcd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'rac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in inittab
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Started to upgrade the Oracle Clusterware. This operation may take a few minutes.
Started to upgrade the CSS.
Started to upgrade the CRS.
The CRS was successfully upgraded.
Oracle Clusterware operating version was successfully set to 11.2.0.3.0
         

    7) 两节点重启后GI升级检查:
          [grid@rac1 ~]$ crsctl query crs activeversion
          Oracle Clusterware active version on the cluster is [11.2.0.3.0]

          [grid@rac1 ~]$ crsctl query crs releaseversion
          Oracle High Availability Services release version on the local node is [11.2.0.1.0]

          [grid@rac1 ~]$ crsctl query crs softwareversion
          Oracle Clusterware version on node [rac1] is [11.2.0.3.0]

     我从网上查找相关资料,成功的案例在最后一个节点执行rootupgrade.sh脚本的时候应该输出如下几行:
     Oracle Clusterware operating version was successfully set to 11.2.0.3.0
     ASM upgrade has finished on last node.
     Preparing packages for installation...
     cvuqdisk-1.0.9-1
     Configure Oracle Grid Infrastructure for a Cluster ... succeeded

      但我是没有输出ASM升级提示两节点都重启了,希望各位帮忙分析原因并提供解决方法,或者是提供思路也可以。
      如果我打的patch有问题,那么我应该打哪一个?

      另外,我昨天又尝试升级到11.2.0.2,Apply 9655006先升级到11.2.0.1.2,再通过Apply 10098816升级到11.2.0.2,
      但到了执行rootupgrade.sh的时候,居然还是把两台节点给重启了。

      希望能够得到帮助,谢谢

[ 本帖最后由 luocs 于 2012-8-21 00:32 编辑 ]
2#
发表于 2012-8-20 22:36:44
如果

crsctl query crs activeversion

显示11.2.0.3 那么说明升级是成功的, 检查 所有相关资源是否正常即可

"此外 的另一点忠告是,如果希望学好oracle,那么不要老是去截图, 发现很多poster 对着 command line或其他文字界面都喜欢去截一个图, maclean难以理解其中诡异的逻辑。 图片介质是难以SEO的,或者说难以被索引化和整理的,由图片承载的知识很难被传播下去, 当然示意图、图表这类例外 。 oracle是一个庞大的体系, 其知识需要组织和细分,对知识的记忆和存储很重要。 "


http://t.askmaclean.com/thread-714-1-1.html

回复 只看该作者 道具 举报

3#
发表于 2012-8-21 00:23:53
原帖由 maclean 于 2012-8-20 22:36 发表
如果

crsctl query crs activeversion

显示11.2.0.3 那么说明升级是成功的, 检查 所有相关资源是否正常即可

"此外 的另一点忠告是,如果希望学好oracle,那么不要老是去截图, 发现很多poster 对着 command line或其他 ...


     OK,记住了,以后尽可能少截图。
     另外,crsctl query crs activeversion尽管显示11.2.0.3,但两个节点都重启掉了,这又怎能是在线滚动升级呢?

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 02:33 , Processed in 0.051494 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569