##GRID 第二节点打补丁报错 oui-patch.xml (Permission denied)
#<GRID_HOME>/OPatch/opatchauto apply <unzipped location of patch> OPatchauto session is initiated at Tue May 31 02:21:42 2019
System initialization log file is <GRID_HOME>/cfgtoollogs/opatchautodb/systemconfig2019-05-31_02-21-44AM.log.
Session log file is <GRID_HOME>/cfgtoollogs/opatchauto/opatchauto2019-05-31_02-21-44AM.log . . . Patch: <unzipped location of patch> Log: <GRID_HOME>/cfgtoollogs/opatchauto/core/opatch/opatch2019-05-31_02-22-44AM_1.log Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: java.io.IOException: oracle.sysman.oui.patch.PatchException: java.io.FileNotFoundException: <Inventory_location>/ContentsXML/oui-patch.xml (Permission denied)'
After fixing the cause of failure Run opatchauto resume
##发现权限不对，是RAC的一个bug，官方说是 由于二节点未使用oui进程安装的，所以未生成这个文件。 During 19.x Grid Infrastructure (GI) installation, the file 'oui-patch.xml' will be created under the central inventory directory on the OUI node (node where gridSetup.sh was invoked) but not on the remote nodes.
-bash-4.4# hostname;date;ls -ltr $oraInventory/ContentsXML/ <NODE 1> Fri May 31 02:31:36 PDT 2019 total 16 -rw-rw---- 1 grid oinstall 570 May 31 00:40 inventory.xml -rw-rw---- 1 grid oinstall 174 May 31 00:40 oui-patch.xml ---> Owned by grid 正常节点 -rw-rw---- 1 grid oinstall 292 May 31 00:43 libs.xml
-bash-4.4# hostname;date;ls -ltr $oraInventory/ContentsXML/ <NODE 2> Fri May 31 02:30:46 PDT 2019 total 20 -rw-rw---- 1 grid oinstall 570 May 31 00:43 inventory.xml -rw-r--r-- 1 oracle oinstall 174 May 31 02:21 oui-patch.xml ---> Owned by oracle -->这里应该是opatchauto执行时，先安装DB HOME的补丁导致使用Oracle用户生成了oui-patch.xml文件需要修改权限，或者从1节点拷贝 -rw-rw---- 1 grid oinstall 292 May 31 02:21 libs.xml -rw-rw---- 1 grid oinstall 300 May 31 02:21 comps.xml
##官方给的解决方案是从1节点copy oui-patch.xml 文件过来，然后重新使用opatchauto resume开始安装补丁。 在我这里并不好使。
紧接着有如下的问题：
##然后系统报错： [grid@rac02 ~]$ $ORACLE_HOME/OPatch/opatch lspatches Inventory load failed... LsPatchesSession::loadAndPrintInstalledPatch() LsPatchesSession failed: Unable to create patchObject Possible causes are: ORACLE_HOME/inventory/oneoffs/ 32545013 is corrupted. PatchObject constructor: Input file "/u01/app/19.3.0.0/grid/inventory/oneoffs/32545013/etc/config/actions" or "/u01/app/19.3.0.0/grid/inventory/oneoffs/32545013/etc/config/inventory" does not exist.
OPatch failed with error code 2
找32545013补丁找不到。
##我的解决方案
1.从好的节点拷贝这个补丁文件到问题节点 [grid@rac01 ~]$ cd /u01/app/19.3.0.0/grid/inventory/oneoffs/ [grid@rac01 oneoffs]$ ls -l total 0 drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29401763 drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29517242 drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29517247 drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29585399 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:49 32545013 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:50 32576499 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:52 32579761 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:52 32584670 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:53 32585572 [grid@rac01 oneoffs]$ tar -cvf 32545013.tar 32545013 32545013/ 32545013/etc/ 32545013/etc/config/ 32545013/etc/config/inventory.xml 32545013/etc/config/actions.xml 32545013/jlib/ [grid@rac01 oneoffs]$ scp 32545013.tar rac02:$PWD 32545013.tar
[grid@rac01 ~]$ cd /u01/app/19.3.0.0/grid/inventory/oneoffs/ [grid@rac01 oneoffs]$ ls -l total 0 drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29401763 drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29517242 drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29517247 drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29585399 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:49 32545013 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:50 32576499 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:52 32579761 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:52 32584670 drwxr-xr-x 4 grid oinstall 29 Jul 3 09:53 32585572 [grid@rac01 oneoffs]$ tar -cvf 32545013.tar 32545013 32545013/ 32545013/etc/ 32545013/etc/config/ 32545013/etc/config/inventory.xml 32545013/etc/config/actions.xml 32545013/jlib/ [grid@rac01 oneoffs]$ scp 32545013.tar rac02:$PWD 32545013.tar
2.再次执行发现可以 使用opatch命令查询出来
[grid@rac02 oneoffs]$ $ORACLE_HOME/OPatch/opatch lspatches 32545013;Database Release Update : 19.11.0.0.210420 (32545013) 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247) 29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)
3.此时可以 使用opatchauto回滚补丁 root@rac02 oracle]# opatchauto rollback /soft/oracle/32545008 -oh /u01/app/19.3.0.0/grid
OPatchauto session is initiated at Sat Jul 3 12:09:00 2021
System initialization log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-07-03_12-09-05PM.log.
浼..?ュ??.欢?.u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/opatchauto2021-07-03_12-09-11PM.log 姝や?璇.. ID 涓?NK5U
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0.0/grid Patch applicability verified successfully on home /u01/app/19.3.0.0/grid
Executing patch validation checks on home /u01/app/19.3.0.0/grid Patch validation checks successfully completed on home /u01/app/19.3.0.0/grid
Checking shared status of home.....
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/rac02/crsconfig/crs_prepatch_rac02_2021-07-03_12-10-23AM.log CRS service brought down successfully on home /u01/app/19.3.0.0/grid
Start rolling back binary patch on home /u01/app/19.3.0.0/grid
4.回滚完再次 opatchauto 仅给grid应用补丁 解决该问题。因为我发现db已经成功安装补丁了，如果不放心可以将二节点全部回滚，再次重新安装补丁。
##
总结一下：该故障做了2件事情
1.修改 $oraInventory/ContentsXML/oui-patch.xml 文件权限为 grid:oinstall rw-rw-r
2.拷贝 1节点的补丁包到2节点对应目录 /u01/app/19.3.0.0/grid/inventory/oneoffs/
3.回滚2节点已经安装的补丁
4.重新安装补丁。
温馨提示，安装完19c RAC以后就应该手工的使用grid用户从一节点 copy oui-patch.xml到二节点相应目录。
