一套测试环境,GI是19c,而DB是11.2.0.4,打算针对DB安装最新的PSU时。使用opatch auto方式报错。
[[email protected] software]# /u01/app/oracle/product/11.2.0.4/dbhome_1/OPatch/opatch auto /software/31718723 -oh /u01/app/oracle/product/11.2.0.4/dbhome_1
Executing /u01/app/19.0.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.4/dbhome_1/OPatch/crs/patchDB.pl -patchdir /software -patchn 31718723 -oh /u01/app/oracle/product/11.2.0.4/dbhome_1
This is the main log file: /u01/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatchauto2022-08-15_20-03-28.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatchauto2022-08-15_20-03-28.report.log
Stopping RAC /u01/app/oracle/product/11.2.0.4/dbhome_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0.4/dbhome_1 successfully
patch /software/31718723/29938455/custom/server/29938455 apply successful for home /u01/app/oracle/product/11.2.0.4/dbhome_1
ERROR: patch /software/31718723/31537677 apply failed for home /u01/app/oracle/product/11.2.0.4/dbhome_1
Starting RAC /u01/app/oracle/product/11.2.0.4/dbhome_1 ...
ERROR: Failed to start resources from database home /u01/app/oracle/product/11.2.0.4/dbhome_1
ERROR: ERROR: Refer log file for more details.
opatch auto failed.
[[email protected] software]#
1、查看opatch的日志,有如下报错:
Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0.4/dbhome_1'
You must apply the patch with the install user
Command invocation returned Error... '', Return Code = 1
Execution of PRE script failed, with return value = 1
Do you want to proceed? [y|n]
N (auto-answered by -silent)
User Responded with: N
ApplySession failed in system modification phase... 'Execution of PRE script failed, with return value = 1'
日志中提示,需要将软件的安装用户来应用这个补丁。。。
2、手动安装补丁。手动使用分解后的步骤安装这个PSU,一切顺利。说明就是opatch auto方式存在问题。
3、搜索MOS,找到文章《opatch auto Fails to Apply DBPSU With Error OUI-67133:Execution of PRE script failed and OUI-67124:ApplySession failed in system modification phase (Doc ID 2468874.1)》。
4、为了验证就是这个问题,将已经安装好的PSU rollback掉。根据文章中的workaround,再次使用opatch auto方式安装 DB的PSU,此时不再报错。