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
解决方法:
以root用户执行下面命令安装PSU:
给GI安装PSU:
export USER=grid
/u01/app/11.2.0/grid/OPatch/opatch auto /soft/28813878 -oh /u01/app/11.2.0/grid
给Database安装PSU:
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