19c GI打补丁到19.9节点2失败处理

2020年11月28日 980点热度 0人点赞 0条评论

[root@wydb02:1 ~]$ export PATH=$PATH:/u01/app/12.2.0/grid/OPatch
[root@wydb02:1 ~]$ opatchauto apply /u01/soft/patch/31750108

OPatchauto session is initiated at Sat Nov 28 13:21:58 2020

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-11-28_01-22-00PM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2020-11-28_01-22-21PM.log
The id for this session is XXMT

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

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid
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 : wydb02->/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: wydb02.
Command failed: /u01/app/12.2.0/grid/OPatch/opatchauto apply /u01/soft/patch/31750108 -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_wydb02_crs_1.ser -analyzedresult /u01/app/12.2.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_wydb02_crs_1.ser
Command failure output:
==Following patches FAILED in apply:

Patch: /u01/soft/patch/31750108/31771877
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-11-28_13-32-19PM_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 Sat Nov 28 13:38:12 2020
Time taken to complete the session 16 minutes, 14 seconds

opatchauto failed with error code 42

比照节点1修改这个文件/u01/app/oraInventory/ContentsXML/oui-patch.xml的属性:
chmod 660 /u01/app/oraInventory/ContentsXML/oui-patch.xml
chown grid.oinstall /u01/app/oraInventory/ContentsXML/oui-patch.xml

再次apply
如前面博客所言,缺目录317
[root@wydb02:5 /u01/app/12.2.0/grid/inventory/oneoffs]$ ll
total 32
drwxr-x--- 4 grid oinstall 4096 Nov 3 10:47 29401763
drwxr-x--- 4 grid oinstall 4096 Nov 3 10:47 29517242
drwxr-x--- 4 grid oinstall 4096 Nov 3 10:47 29517247
drwxr-x--- 4 grid oinstall 4096 Nov 3 10:47 29585399
drwxr-xr-x 4 grid oinstall 4096 Nov 3 15:37 31281355
drwxr-xr-x 4 grid oinstall 4096 Nov 3 15:38 31304218
drwxr-xr-x 4 grid oinstall 4096 Nov 3 15:39 31305087
drwxr-xr-x 4 grid oinstall 4096 Nov 3 15:40 31335188
[root@wydb02:6 /mnt/nfs/grid/inventory/oneoffs]$ cp -rp 317
/u01/app/12.2.0/grid/inventory/oneoffs
[root@wydb02:5 /u01/app/12.2.0/grid/inventory/oneoffs]$ ll
total 48
drwxr-x--- 4 grid oinstall 4096 Nov 3 10:47 29401763
drwxr-x--- 4 grid oinstall 4096 Nov 3 10:47 29517242
drwxr-x--- 4 grid oinstall 4096 Nov 3 10:47 29517247
drwxr-x--- 4 grid oinstall 4096 Nov 3 10:47 29585399
drwxr-xr-x 4 grid oinstall 4096 Nov 3 15:37 31281355
drwxr-xr-x 4 grid oinstall 4096 Nov 3 15:38 31304218
drwxr-xr-x 4 grid oinstall 4096 Nov 3 15:39 31305087
drwxr-xr-x 4 grid oinstall 4096 Nov 3 15:40 31335188
drwxr-xr-x 4 grid oinstall 4096 Nov 28 10:53 31771877
drwxr-xr-x 4 grid oinstall 4096 Nov 28 11:48 31772784
drwxr-xr-x 4 grid oinstall 4096 Nov 28 11:49 31773437
drwxr-xr-x 4 grid oinstall 4096 Nov 28 11:51 31780966

再次apply成功,如下:

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:wydb02
RAC Home:/u01/app/oracle/product/12.2.0/db_1
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /u01/soft/patch/31750108/31773437
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /u01/soft/patch/31750108/31780966
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /u01/soft/patch/31750108/31772784
Reason: This patch is already been applied, so not going to apply again.

Patch: /u01/soft/patch/31750108/31771877
Reason: This patch is already been applied, so not going to apply again.

Host:wydb02
CRS Home:/u01/app/12.2.0/grid
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /u01/soft/patch/31750108/31771877
Reason: This patch is already been applied, so not going to apply again.

==Following patches were SUCCESSFULLY applied:

Patch: /u01/soft/patch/31750108/31772784
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-11-28_14-07-25PM_1.log

Patch: /u01/soft/patch/31750108/31773437
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-11-28_14-07-25PM_1.log

Patch: /u01/soft/patch/31750108/31780966
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-11-28_14-07-25PM_1.log

OPatchauto session completed at Sat Nov 28 14:17:18 2020
Time taken to complete the session 12 minutes, 54 seconds

最后检查一下:
[root@wydb02:6 /mnt/nfs/grid/inventory/oneoffs]$ su - grid
Last login: Sat Nov 28 14:20:10 CST 2020
[grid@wydb02:6 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
31780966;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31780966)
31773437;ACFS RELEASE UPDATE 19.9.0.0.0 (31773437)
31772784;OCW RELEASE UPDATE 19.9.0.0.0 (31772784)
31771877;Database Release Update : 19.9.0.0.201020 (31771877)

OPatch succeeded.
[grid@wydb02:6 ~]$ exit
logout
[root@wydb02:6 /mnt/nfs/grid/inventory/oneoffs]$ su - oracle
Last login: Sat Nov 28 14:17:53 CST 2020
[oracle@wydb02:6 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
31772784;OCW RELEASE UPDATE 19.9.0.0.0 (31772784)
31771877;Database Release Update : 19.9.0.0.201020 (31771877)

OPatch succeeded.

与节点一完全一致。

liking

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

文章评论