19.3 GI打补丁到19.8节点2失败处理

2020年9月23日 1322点热度 0人点赞 0条评论

■■node2打补丁报错

[root@zzjk02:0 /u01/soft]$ opatchauto apply /u01/soft/patch/31305339

OPatchauto session is initiated at Tue Sep 22 19:04:51 2020

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-09-22_07-04-53PM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2020-09-22_07-05-43PM.log
The id for this session is 4RP6

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1

Patch applicability verified successfully on home /u01/app/12.2.0/grid

Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1

Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db_1
Successfully prepared home /u01/app/oracle/product/12.2.0/db_1 to bring down database service

Bringing down CRS service on home /u01/app/12.2.0/grid
CRS service brought down successfully on home /u01/app/12.2.0/grid

Performing prepatch operation on home /u01/app/oracle/product/12.2.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1

Start applying binary patch on home /u01/app/oracle/product/12.2.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1

Performing postpatch operation on home /u01/app/oracle/product/12.2.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1

Start applying binary patch on home /u01/app/12.2.0/grid
Failed while applying binary patches on home /u01/app/12.2.0/grid

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : zzjk02->/u01/app/12.2.0/grid Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/12.2.0/grid, host: zzjk02.
Command failed: /u01/app/12.2.0/grid/OPatch/opatchauto apply /u01/soft/patch/31305339 -oh /u01/app/12.2.0/grid -target_type cluster -binary -invPtrLoc /u01/app/12.2.0/grid/oraInst.loc -jre /u01/app/12.2.0/grid/OPatch/jre -persistresult /u01/app/12.2.0/grid/opatchautocfg/db/sessioninfo/sessionresult_zzjk02_crs_1.ser -analyzedresult /u01/app/12.2.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_zzjk02_crs_1.ser
Command failure output:
==Following patches FAILED in apply:

Patch: /u01/soft/patch/31305339/31281355
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-09-22_19-14-09PM_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: /u01/app/oraInventory/ContentsXML/oui-patch.xml (Permission denied)'

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

OPatchauto session completed at Tue Sep 22 19:19:28 2020
Time taken to complete the session 14 minutes, 37 seconds

opatchauto failed with error code 42

■■
可见node2的GI补丁失败,此时由于打补丁失败,node2无法启动crs
[root@zzjk02:0 /u01/soft]$ crsctl start crs
CRS-6706: Oracle Clusterware Release patch level ('4172947236') does not match Software patch level ('724960844'). Oracle Clusterware cannot be started.
CRS-4000: Command Start failed, or completed with errors.

需要清理补丁状态,再启动即可
./clscfg -localpatch
./crsctl start crs

■■单独给node2打GI补丁报错

[root@zzjk02:0 /u01/app/12.2.0/grid/bin]$ export PATH=$PATH:/u01/app/12.2.0/grid/OPatch
[root@zzjk02:0 /u01/app/12.2.0/grid/bin]$ opatchauto apply /u01/soft/patch/31305339 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Wed Sep 23 11:00:44 2020

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-09-23_11-00-50AM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2020-09-23_11-01-18AM.log
The id for this session is 8INF

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid
Patch applicability verification failed on home /u01/app/12.2.0/grid

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : zzjk02->/u01/app/12.2.0/grid Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/12.2.0/grid, host: zzjk02.
Command failed: /u01/app/12.2.0/grid/OPatch/opatchauto apply /u01/soft/patch/31305339 -oh /u01/app/12.2.0/grid -target_type cluster -binary -invPtrLoc /u01/app/12.2.0/grid/oraInst.loc -jre /u01/app/12.2.0/grid/OPatch/jre -persistresult /u01/app/12.2.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_zzjk02_crs_1.ser -analyze -online -prepare_home
Command failure output:
==Following patches FAILED in analysis for apply:

Patch: /u01/soft/patch/31305339/31305087
Log:
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
ORACLE_HOME/inventory/oneoffs/29401763 is corrupted. PatchObject constructor: Input file "/u01/app/12.2.0/grid/inventory/oneoffs/29401763/etc/config/actions" or "/u01/app/12.2.0/grid/inventory/oneoffs/29401763/etc/config/inventory" does not exist.

Patch: /u01/soft/patch/31305339/31304218
Log:
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
ORACLE_HOME/inventory/oneoffs/29401763 is corrupted. PatchObject constructor: Input file "/u01/app/12.2.0/grid/inventory/oneoffs/29401763/etc/config/actions" or "/u01/app/12.2.0/grid/inventory/oneoffs/29401763/etc/config/inventory" does not exist.

Patch: /u01/soft/patch/31305339/31335188
Log:
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
ORACLE_HOME/inventory/oneoffs/29401763 is corrupted. PatchObject constructor: Input file "/u01/app/12.2.0/grid/inventory/oneoffs/29401763/etc/config/actions" or "/u01/app/12.2.0/grid/inventory/oneoffs/29401763/etc/config/inventory" does not exist.

Patch: /u01/soft/patch/31305339/31281355
Log:
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
ORACLE_HOME/inventory/oneoffs/29401763 is corrupted. PatchObject constructor: Input file "/u01/app/12.2.0/grid/inventory/oneoffs/29401763/etc/config/actions" or "/u01/app/12.2.0/grid/inventory/oneoffs/29401763/etc/config/inventory" does not exist.

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

OPatchauto session completed at Wed Sep 23 11:01:37 2020
Time taken to complete the session 0 minute, 54 seconds

opatchauto failed with error code 42

发现此时目录ORACLE_HOME/inventory/oneoffs下没有所需的补丁目录!
从node1拷贝过来,保留原属性,采用cp -rp的方式拷贝,因此还需要事先配置nfs服务。其他scp、tar的方式均失败,只能配置nfs采用cp -rp方式完美保留原目录属性、属主、权限。
拷贝来后,再次apply还有失败,提示一个文件属性不对,比照node1修改即可,如下修改:
[root@zzjk02:0 /u01/app/12.2.0/grid/inventory/ContentsXML]$ ll /u01/app/oraInventory/ContentsXML/oui-patch.xml
-rw-r--r-- 1 oracle oinstall 174 Sep 22 19:14 /u01/app/oraInventory/ContentsXML/oui-patch.xml
[root@zzjk02:0 /u01/app/12.2.0/grid/inventory/ContentsXML]$ chmod 660 /u01/app/oraInventory/ContentsXML/oui-patch.xml
[root@zzjk02:0 /u01/app/12.2.0/grid/inventory/ContentsXML]$ chown grid.oinstall /u01/app/oraInventory/ContentsXML/oui-patch.xml

■■最终结果

■node1
[grid@zzjk01:0 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
31335188;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31335188)
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31304218;ACFS RELEASE UPDATE 19.8.0.0.0 (31304218)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)

OPatch succeeded.

[oracle@zzjk01:0 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)

OPatch succeeded.

■node2
[grid@zzjk02:0 /u01/app/12.2.0/grid/OPatch]$ ./opatch lspatches
31335188;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31335188)
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31304218;ACFS RELEASE UPDATE 19.8.0.0.0 (31304218)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)

OPatch succeeded.

[oracle@zzjk02:0 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)

OPatch succeeded.

liking

这个人很懒,什么都没留下

文章评论