Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3673130
  • 博文数量: 715
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 7745
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(715)

文章存档

2023年(75)

2022年(134)

2021年(238)

2020年(115)

2019年(11)

2018年(9)

2017年(9)

2016年(17)

2015年(7)

2014年(4)

2013年(1)

2012年(11)

2011年(27)

2010年(35)

2009年(11)

2008年(11)

分类: Oracle

2021-04-08 18:55:05


Linux7.7上 安装oracle rac 19.3,在节点2打数据库19.9补丁时遇到错误。

对gi打补丁
[root@host2 31720429]#  opatchauto apply /tmp/31720429/31750108

  1. OPatchauto session is initiated at Thu Apr 8 17:31:37 2021

  2. System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2021-04-08_05-31-41PM.log.

  3. 会话日志文件是/u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2021-04-08_05-32-12PM.log
  4. 此会话的 ID 为 WXLV

  5. Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid
  6. Patch applicability verified successfully on home /u01/app/19c/grid

  7. Executing patch validation checks on home /u01/app/19c/grid
  8. Patch validation checks successfully completed on home /u01/app/19c/grid

  9. Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19c/grid
  10. Prepatch operation log file location: /u01/app/grid/crsdata/host2/crsconfig/crs_prepatch_apply_inplace_host2_2021-04-08_05-32-54PM.log
  11. CRS service brought down successfully on home /u01/app/19c/grid

  12. Start applying binary patch on home /u01/app/19c/grid
  13. Binary patch applied successfully on home /u01/app/19c/grid

  14. Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid
  15. Postpatch operation log file location: /u01/app/grid/crsdata/host2/crsconfig/crs_postpatch_apply_inplace_host2_2021-04-08_05-44-32PM.log
  16. CRS service started successfully on home /u01/app/19c/grid


  17. OPatchAuto 成功。


  18. --------------------------------Summary--------------------------------


  19. Patching is completed successfully. Please find the summary as follows:


  20. Host:host2
  21. CRS Home:/u01/app/19c/grid
  22. Version:19.0.0.0.0
  23. Summary:


  24. ==Following patches were SUCCESSFULLY applied:


  25. Patch: /tmp/31720429/31750108/31771877
  26. Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-35-39下午_1.log


  27. Patch: /tmp/31720429/31750108/31772784
  28. Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-35-39下午_1.log


  29. Patch: /tmp/31720429/31750108/31773437
  30. Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-35-39下午_1.log


  31. Patch: /tmp/31720429/31750108/31780966
  32. Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-35-39下午_1.log



  33. OPatchauto session completed at Thu Apr 8 17:49:40 2021
  34. Time taken to complete the session 18 minutes, 4 seconds

按README.HTML中说明执行opatchauto应该对grid和db都打上补丁呀,但是检查db没有打上,于是单独对db_home打补丁
[root@host2 31720429]# /u01/app/oracle/product/19c/db_1/OPatch/opatchauto apply /tmp/31720429/31750108 -oh /u01/app/oracle/product/19c/db_1


  1. OPatchauto session is initiated at Thu Apr 8 17:50:39 2021


  2. System initialization log file is /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2021-04-08_05-50-46PM.log.


  3. 会话日志文件是/u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2021-04-08_05-51-05PM.log
  4. 此会话的 ID 为 PVR4


  5. Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/db_1
  6. Patch applicability verified successfully on home /u01/app/oracle/product/19c/db_1

  7. Executing patch validation checks on home /u01/app/oracle/product/19c/db_1
  8. Patch validation checks successfully completed on home /u01/app/oracle/product/19c/db_1

  9. Verifying SQL patch applicability on home /u01/app/oracle/product/19c/db_1
  10. No step execution required.........

  11. Preparing to bring down database service on home /u01/app/oracle/product/19c/db_1
  12. No step execution required.........

  13. Performing prepatch operation on home /u01/app/oracle/product/19c/db_1
  14. Perpatch operation completed successfully on home /u01/app/oracle/product/19c/db_1

  15. Start applying binary patch on home /u01/app/oracle/product/19c/db_1
  16. Failed while applying binary patches on home /u01/app/oracle/product/19c/db_1


  17. 未能执行 [OPatchAutoBinaryAction] 补丁程序操作, 有关详细信息, 请查看日志。故障:
  18. Patch Target : host2->/u01/app/oracle/product/19c/db_1 类型 [rac]
  19. Details: [
  20. ---------------------------Patching Failed---------------------------------
  21. Command execution failed during patching in home: /u01/app/oracle/product/19c/db_1, host: host2.
  22. Command failed: /u01/app/oracle/product/19c/db_1/OPatch/opatchauto apply /tmp/31720429/31750108 -oh /u01/app/oracle/product/19c/db_1 -target_type rac_database -binary -invPtrLoc /u01/app/oracle/product/19c/db_1/oraInst.loc -jre /u01/app/oracle/product/19c/db_1/OPatch/jre -persistresult /u01/app/oracle/product/19c/db_1/opatchautocfg/db/sessioninfo/sessionresult_host2_rac_2.ser -analyzedresult /u01/app/oracle/product/19c/db_1/opatchautocfg/db/sessioninfo/sessionresult_analyze_host2_rac_2.ser
  23. Command failure output:
  24. ==Following patches FAILED in apply:


  25. Patch: /tmp/31720429/31750108/31771877
  26. Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-51-45下午_1.log
  27. Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession 在系统修改阶段失败... 'ApplySession::apply failed: java.io.IOException: oracle.sysman.oui.patch.PatchException: java.io.FileNotFoundException: /u01/app/oraInventory/ContentsXML/oui-patch.xml (权限不够)'

  28. After fixing the cause of failure Run opatchauto resume

  29. ]
  30. OPATCHAUTO-68061: 业务流程引擎失败。
  31. OPATCHAUTO-68061: 业务流程引擎失败, 返回代码为 1
  32. OPATCHAUTO-68061: 有关详细资料, 请查看日志。
  33. OPatchAuto 失败。


  34. OPatchauto session completed at Thu Apr 8 17:55:39 2021
  35. Time taken to complete the session 5 minutes, 0 second


  36.  opatchauto failed with error code 42

提示中oui-patch.xml (权限不够),具体检查一下权限与节点1不一样,这是bug导致的失败。

解决方法是:
1、复制节点1上的文件
 host1 $ cd $ORACLE_HOME/inventory/oneoffs
 host1 $ scp -r * host2:$PWD

2、修改权限
 host2 # chmod 660 /u01/app/oraInventory/ContentsXML/oui-patch.xml

3、重新执行打补丁命令

这是在打节点2的db补丁时遇到的问题,节点1却没事。

阅读(1401) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~