AIX 7.2 下Oracle 11.2.0.4 RAC資料庫root用戶在使用 /u01/app/11.2.0/grid/OPatch/opatch auto /soft/28813878 -ocmrf /soft/ocm.rsp 安裝11.2.0.4.20190115 PSU時，遇到 patch ...
AIX 7.2 下Oracle 11.2.0.4 RAC資料庫root用戶在使用 /u01/app/11.2.0/grid/OPatch/opatch auto /soft/28813878 -ocmrf /soft/ocm.rsp 安裝11.2.0.4.20190115 PSU時，遇到
patch /soft/28813878/28729262 apply failed for home /u01/app/11.2.0/grid
查看日誌顯示：
ApplySession failed in system modification phas
OUI-67133: Execution of PRE script failed,with returen value 1
OPatch failed with error code 73
具體相關日誌：
[Mar 29, 2019 5:23:13 PM] [INFO] Start the Apply preScript at Wed Mar 29 17:23:13 GMT 2019
[Mar 29, 2019 5:23:13 PM] [INFO] Execution of 'sh /soft/28813878/28729262/28204707/custom/scripts/pre -apply 28204707 ':
[Mar 29, 2019 5:23:13 PM] [INFO] Return Code = 1
[Mar 29, 2019 5:23:13 PM] [INFO] Execution of ' Command and arguments of pre/post scripts is restricted to be viewed in log file ':
You must apply the patch with the install user
Return Code = 1
[Mar 29, 2019 5:23:13 PM] [INFO] Command invocation returned Error... '', Return Code = 1
[Mar 29, 2019 5:23:13 PM] [INFO] Finish the Apply preScript at Wed Mar 29 17:23:13 GMT 2019
[Mar 29, 2019 5:23:13 PM] [WARNING] OUI-67133:Execution of PRE script failed, with return value = 1
[Mar 29, 2019 5:23:13 PM] [INFO] Do you want to proceed? [y|n]
[Mar 29, 2019 5:23:13 PM] [INFO] N (auto-answered by -silent)
[Mar 29, 2019 5:23:13 PM] [INFO] User Responded with: N
[Mar 29, 2019 5:23:13 PM] [WARNING] OUI-67124:ApplySession failed in system modification phase... 'Execution of PRE script failed, with return value = 1'
[Mar 29, 2019 5:23:13 PM] [INFO] Restoring "/u01/app/11.2.0/grid" to the state prior to running NApply...
原因： 在使用root用戶進行opatch auto 打補丁的時候，需要su - grid -c ' ...'去進行補丁安裝，故執行pre 的身份仍是root，身份不正確。
可以用如下命令來驗證： 'su <db-user> -c "echo $USER" ' ，例如
[root@rac1 ~]# su grid -c "echo $USER"
root
解決方法：
export USER=grid
/u01/app/11.2.0/grid/OPatch/opatch auto /soft/28813878 -oh /u01/app/11.2.0/grid
export USER=oracle
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /soft/28813878 -oh /u01/app/oracle/product/11.2.0/db_1
