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

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

0

积分

0

好友

21

主题
1#
发表于 2014-3-24 17:22:52 | 查看: 4067| 回复: 3
今天给新搭建的Oracle RAC打PSU
系统:红帽6.4
数据库:11.2.0.3.0
GI:11.2.0.3.0
PSU:11.2.0.3.6
OPatch:11.2.0.3.4
按照readme执行,一步一步来,最后安装,刚开始很顺利,但是到最后,大家看看先
  1. [root@yxsd1 OPatch]# ./opatch auto /patch/p16083653_112030_Linux-x86-64 -ocmrf /patch/ocm.rsp
  2. Executing /ora/grid/11.2.0/grid/perl/bin/perl ./crs/patch11203.pl -patchdir /patch -patchn p16083653_112030_Linux-x86-64 -ocmrf /patch/ocm.rsp -paramfile /ora/grid/11.2.0/grid/crs/install/crsconfig_params
  3. /ora/grid/11.2.0/grid/crs/install/crsconfig_params
  4. /ora/grid/11.2.0/grid/crs/install/s_crsconfig_defs

  5. This is the main log file: /ora/grid/11.2.0/grid/cfgtoollogs/opatchauto2014-03-23_23-43-05.log
  6. This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /ora/grid/11.2.0/grid/cfgtoollogs/opatchauto2014-03-23_23-43-05.report.log

  7. 2014-03-23 23:43:05: Starting Clusterware Patch Setup
  8. Using configuration parameter file: /ora/grid/11.2.0/grid/crs/install/crsconfig_params
  9. patch /patch/p16083653_112030_Linux-x86-64/16315641/custom/server/16315641  apply successful for home  /ora/oracle/11.2.0/db
  10. patch /patch/p16083653_112030_Linux-x86-64/16056266  apply successful for home  /ora/oracle/11.2.0/db
  11. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'yxsd1'
  12. CRS-2673: Attempting to stop 'ora.crsd' on 'yxsd1'
  13. CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'yxsd1'
  14. CRS-2673: Attempting to stop 'ora.OCR_VOTE.dg' on 'yxsd1'
  15. CRS-2673: Attempting to stop 'ora.DATA.dg' on 'yxsd1'
  16. CRS-2673: Attempting to stop 'ora.LOG.dg' on 'yxsd1'
  17. CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'yxsd1'
  18. CRS-2673: Attempting to stop 'ora.cvu' on 'yxsd1'
  19. CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'yxsd1'
  20. CRS-2673: Attempting to stop 'ora.oc4j' on 'yxsd1'
  21. CRS-2677: Stop of 'ora.cvu' on 'yxsd1' succeeded
  22. CRS-2672: Attempting to start 'ora.cvu' on 'yxsd2'
  23. CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'yxsd1' succeeded
  24. CRS-2673: Attempting to stop 'ora.yxsd1.vip' on 'yxsd1'
  25. CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'yxsd1' succeeded
  26. CRS-2673: Attempting to stop 'ora.scan1.vip' on 'yxsd1'
  27. CRS-2677: Stop of 'ora.yxsd1.vip' on 'yxsd1' succeeded
  28. CRS-2672: Attempting to start 'ora.yxsd1.vip' on 'yxsd2'
  29. CRS-2677: Stop of 'ora.scan1.vip' on 'yxsd1' succeeded
  30. CRS-2672: Attempting to start 'ora.scan1.vip' on 'yxsd2'
  31. CRS-2677: Stop of 'ora.DATA.dg' on 'yxsd1' succeeded
  32. CRS-2676: Start of 'ora.cvu' on 'yxsd2' succeeded
  33. CRS-2677: Stop of 'ora.LOG.dg' on 'yxsd1' succeeded
  34. CRS-2676: Start of 'ora.yxsd1.vip' on 'yxsd2' succeeded
  35. CRS-2676: Start of 'ora.scan1.vip' on 'yxsd2' succeeded
  36. CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'yxsd2'
  37. CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'yxsd2' succeeded
  38. CRS-2677: Stop of 'ora.oc4j' on 'yxsd1' succeeded
  39. CRS-2672: Attempting to start 'ora.oc4j' on 'yxsd2'
  40. CRS-2676: Start of 'ora.oc4j' on 'yxsd2' succeeded
  41. CRS-2677: Stop of 'ora.OCR_VOTE.dg' on 'yxsd1' succeeded
  42. CRS-2673: Attempting to stop 'ora.asm' on 'yxsd1'
  43. CRS-2677: Stop of 'ora.asm' on 'yxsd1' succeeded
  44. CRS-2673: Attempting to stop 'ora.ons' on 'yxsd1'
  45. CRS-2677: Stop of 'ora.ons' on 'yxsd1' succeeded
  46. CRS-2673: Attempting to stop 'ora.net1.network' on 'yxsd1'
  47. CRS-2677: Stop of 'ora.net1.network' on 'yxsd1' succeeded
  48. CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'yxsd1' has completed
  49. CRS-2677: Stop of 'ora.crsd' on 'yxsd1' succeeded
  50. CRS-2673: Attempting to stop 'ora.crf' on 'yxsd1'
  51. CRS-2673: Attempting to stop 'ora.ctssd' on 'yxsd1'
  52. CRS-2673: Attempting to stop 'ora.evmd' on 'yxsd1'
  53. CRS-2673: Attempting to stop 'ora.asm' on 'yxsd1'
  54. CRS-2673: Attempting to stop 'ora.mdnsd' on 'yxsd1'
  55. CRS-2677: Stop of 'ora.crf' on 'yxsd1' succeeded
  56. CRS-2677: Stop of 'ora.evmd' on 'yxsd1' succeeded
  57. CRS-2677: Stop of 'ora.mdnsd' on 'yxsd1' succeeded
  58. CRS-2677: Stop of 'ora.asm' on 'yxsd1' succeeded
  59. CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'yxsd1'
  60. CRS-2677: Stop of 'ora.ctssd' on 'yxsd1' succeeded
  61. CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'yxsd1' succeeded
  62. CRS-2673: Attempting to stop 'ora.cssd' on 'yxsd1'
  63. CRS-2677: Stop of 'ora.cssd' on 'yxsd1' succeeded
  64. CRS-2673: Attempting to stop 'ora.gipcd' on 'yxsd1'
  65. CRS-2677: Stop of 'ora.gipcd' on 'yxsd1' succeeded
  66. CRS-2673: Attempting to stop 'ora.gpnpd' on 'yxsd1'
  67. CRS-2677: Stop of 'ora.gpnpd' on 'yxsd1' succeeded
  68. CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'yxsd1' has completed
  69. CRS-4133: Oracle High Availability Services has been stopped.
  70. Successfully unlock /ora/grid/11.2.0/grid
  71. patch /patch/p16083653_112030_Linux-x86-64/16315641  apply successful for home  /ora/grid/11.2.0/grid
  72. patch /patch/p16083653_112030_Linux-x86-64/16056266  apply successful for home  /ora/grid/11.2.0/grid
  73. CRS-4123: Oracle High Availability Services has been started.
  74. Oracle Grid Infrastructure stack start initiated but failed to complete at /patch/p16083653_112030_Linux-x86-64/16315641/files/crs/install/crsconfig_lib.pm line 11627.
复制代码
之后集群服务就起不来了。

没有头绪不知道怎么去修复,rollback也用不了
请高手出出招。

然后我再问一下,打PSU补丁按照readme来做我只在UNIX环境下opatch auto成功过
在linux环境下就没有成过,是不是还是应该自己一步步来打啊?求解惑。

log.zip

9.16 KB, 下载次数: 839

log

2#
发表于 2014-3-24 17:36:53
又试了第二个节点,同样错误。

回复 只看该作者 道具 举报

3#
发表于 2014-4-1 10:19:20
PSU可以参照老大写的这个视频来打:
http://t.askmaclean.com/forum.ph ... TgyfDJ8MjAwNw%3D%3D

回复 只看该作者 道具 举报

4#
发表于 2014-4-1 22:04:29
Why not rolling patch to other nodes together for rac

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-5-17 15:43 , Processed in 0.053478 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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