19c 节点2打补丁时遇到 oui-patch.xml 权限不够

1520阅读　0评论2021-04-08　brjl
分类：Oracle


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

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

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

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

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

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

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

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


  26. OPatchAuto 成功。


  29. --------------------------------Summary--------------------------------


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


  35. Host:host2
  36. CRS Home:/u01/app/19c/grid
  37. Version:19.0.0.0.0
  38. Summary:


  41. ==Following patches were SUCCESSFULLY applied:


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


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


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


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



  61. OPatchauto session completed at Thu Apr 8 17:49:40 2021
  62. 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


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


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


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

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

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

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

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

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


  30. 未能执行 [OPatchAutoBinaryAction] 补丁程序操作, 有关详细信息, 请查看日志。故障:
  31. Patch Target : host2->/u01/app/oracle/product/19c/db_1 类型 [rac]
  32. Details: [
  33. ---------------------------Patching Failed---------------------------------
  34. Command execution failed during patching in home: /u01/app/oracle/product/19c/db_1, host: host2.
  35. 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
  36. Command failure output:
  37. ==Following patches FAILED in apply:


  40. Patch: /tmp/31720429/31750108/31771877
  41. Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-51-45下午_1.log
  42. 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 (权限不够)'

  44. After fixing the cause of failure Run opatchauto resume

  46. ]
  47. OPATCHAUTO-68061: 业务流程引擎失败。
  48. OPATCHAUTO-68061: 业务流程引擎失败, 返回代码为 1
  49. OPATCHAUTO-68061: 有关详细资料, 请查看日志。
  50. OPatchAuto 失败。


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


  57.  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却没事。

上一篇：又遇tns-12560，与上次不一样
下一篇：PMON failed to acquire latch, see PMON dump