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

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

20

积分

0

好友

5

主题
1#
发表于 2013-12-17 17:23:26 | 查看: 6317| 回复: 4
本帖最后由 fiozhang 于 2013-12-17 17:27 编辑

Database11.2.0.3 Patch13
WINDOWS 2008 R2

之前已经在3节点rac上升级了此patch,但是在升级grid过程中并没有对crs进行patch(rootcrs.pl -patch)
现在发现一个bug 需要执行rootcrs.pl -patch进行修复。

请问现在我能不能单独再运行rootcrs.pl -patch给crs打补丁?

文档说明如下
  1. 3.3.3Patch Installation Instructions for RAC
  2. Follow these steps:

  3. Please note that this patch is RAC rolling upgradable for GRID, and RDBMS homes.

  4. Stop the Oracle services only in the home where the patch is being applied.

  5. The order of patching in RAC install is GRID_HOME, then RDBMS_HOME

  6. 1.Before Patching GRID_HOME, stop OCR related resources, Oracle HASD Services (OHASD) Services and all Oracle Services:

  7. > srvctl stop service -d <database name> -s <configured workload management service> -i <instancename>
  8. > srvctl stop instance -d <dbname> -i <instance name> -o abort
  9. > crsctl stop crs
  10. To verify all resources have been moved to the other nodes, run the following command from another node with GRID running:
  11. > crsctl status resource -t
  12. Then use the Computer Management Services GUI or the net stop command to stop ALL Oracle services running on that node:

  13. ◦net stop OracleService<SID>

  14. ◦net stop Oracle<CRShome>TNSListenerLISTENER_<nodename>

  15. ◦net stop Oracle<CRShome>TNSListenerLISTENER_SCANn

  16. ◦net stop OracleDBConsole<SID>

  17. ◦net stop OracleASMService<ASMSID>

  18. ◦net stop "Oracle <SID> VSS Writer Service"

  19. ◦net stop OracleREMExecService

  20. ◦net stop OracleOHService

  21. ◦net stop "Oracle Object Service"

  22. ◦net stop OracleClusterVolumeService

  23. ◦net stop ocfs (required only for OCFS installation)

  24. ◦net stop orafenceservice

  25. ◦Note: An explicit 'srvctl start listener -n <nodename>' should be issued after patching

  26. 2.Before Patching RDBMS_HOME, the GRID and ASM services can be running.
  27. Stop OCR related resources and Oracle Services on the current node as listed below:

  28. > srvctl stop service -d <database name> -s <configured workload management service> -i <instancename>
  29. > srvctl stop instance -d <dbname> -i <instance name> -o abort
  30. ◦net stop OracleService<SID>

  31. ◦net stop Oracle<SID>VSSWriterService

  32. ◦net stop OracleDBConsole<SID>

  33. 3.Set the ORACLE_HOME environment variable properly

  34. 4.Go to the directory where you downloaded the patch:

  35. > cd 14828076
  36. 5.Ensure that the directory containing the OPatch script appears in your PATH setting. Patch this node using the command listed below.

  37. > %ORACLE_HOME%\perl\bin\perl -I%ORACLE_HOME%\perl\lib -I%ORACLE_HOME%\crs\install %ORACLE_HOME%\crs\install\rootcrs.pl -unlock
  38. > opatch apply
  39. opatch will attempt to apply the patch on all the nodes in the cluster sequentially. However will prompt for user input to start patching other nodes. At this time ensure that the Oracle services on target node are stopped before proceeding to patch. Once the opatch session completes patching this node, start the services and proceed applying patch to the next node.

  40. NOTE: When patching GRID_HOME on a node.
  41. Once the opatch session completes patching GRID_HOME on a node, run the following before proceeding to patch GRID_HOME on the next node.
  42. %ORACLE_HOME%\bin\acfsroot install
  43. %ORACLE_HOME%\perl\bin\perl -I%ORACLE_HOME%\perl\lib -I%ORACLE_HOME%\crs\install %ORACLE_HOME%\crs\install\rootcrs.pl -patch


复制代码
2#
发表于 2013-12-17 17:25:27
原帖子只有陈述句 没有疑问句

回复 只看该作者 道具 举报

3#
发表于 2013-12-17 17:31:42
问题已经更新了,主要就是对次序上的疑问,原来要求的顺序是:
节点1 grid opatch打补丁,然后节点1 rootcrs.pl -patch,完了以后再打下一个节点。
现在我所有节点grid opatch都打完了,再返回来想打crs补丁,不知道可不可行

回复 只看该作者 道具 举报

4#
发表于 2013-12-17 19:43:09
理论上我觉得没问题, 需要实际测试

回复 只看该作者 道具 举报

5#
发表于 2013-12-18 16:25:22
昨晚上顺利打完补丁,看来这个最后打没问题

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-12-21 09:46 , Processed in 0.052834 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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