Linux7.4_x86_64 Oracle 12.2.0.1 RAC环境打RU打时候报错处理

最新推荐文章于 2024-09-12 08:16:49 发布

原创最新推荐文章于 2024-09-12 08:16:49 发布 · 751 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #RU #RAC

Oracle 专栏收录该内容

25 篇文章

订阅专栏

在Linux7.4_x86_64的Oracle 12.2.0.1 RAC环境中手动打补丁时遇到错误。通过opatchauto nonrolling方式进行补丁应用，过程中遇到ins_precomp.mk、env_precomp.mk和libpgp.a文件问题。通过检查日志，分别发现这三个文件在不同节点上的状态不一致，通过scp命令同步文件内容后，最终成功完成补丁应用。

Linux7.4_x86_64 Oracle 12.2.0.1 RAC环境打RU打时候报错处理

在使用opatchauto使用nonrolling方式手动打补丁的时候报错

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : lissen-n1->/u01/app/oracle/product/12.2.0.1/dbhome_1 Type[rac]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/oracle/product/12.2.0.1/dbhome_1, host: lissen-n1.
Command failed: /u01/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatchauto apply /u01/RU/30133386/30116802 -oh /u01/app/oracle/product/12.2.0.1/dbhome_1 -target_type rac_database -binary -invPtrLoc /u01/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc -jre /u01/app/oracle/product/12.2.0.1/dbhome_1/OPatch/jre -persistresult /u01/app/oracle/product/12.2.0.1/dbhome_1/opatchautocfg/db/sessioninfo/sessionresult_lissen-n1_rac_2.ser -analyzedresult /u01/app/oracle/product/12.2.0.1/dbhome_1/opatchautocfg/db/sessioninfo/sessionresult_analyze_lissen-n1_rac_2.ser
Command failure output:
==Following patches FAILED in apply:

Patch: /u01/RU/30133386/30116802/30138470
Log: /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-25_19-23-53PM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Re-link fails on target “proc”.
Re-link fails on target “procob”.

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.

[Mar 25, 2021 7:30:29 PM] [INFO] 1) OUI-67200:Make failed to invoke “/usr/bin/make -f ins_precomp.mk proc ORACLE_HOME=/u01
/app/oracle/product/12.2.0.1/dbhome_1 OPATCH_SESSION=napply”…'ins_precomp.mk:1: warning: NUL character seen; rest of line
ignored
ins_precomp.mk:2: warning: NUL character seen; rest of line ignored
ins_precomp.mk:3: warning: NUL character seen; rest of line ignored
ins_precomp.mk:4: warning: NUL character seen; rest of line ignored
ins_precomp.mk:5: warning: NUL character seen; rest of line ignored
ins_precomp.mk:6: warning: NUL character seen; rest of line ignored
ins_precomp.mk:7: warning: NUL character seen; rest of line ignored
ins_precomp.mk:8: warning: NUL character seen; rest of line ignored
ins_precomp.mk:9: warning: NUL character seen; rest of line ignored
ins_precomp.mk:10: warning: NUL character seen; rest of line ignored
ins_precomp.mk:11: warning: NUL character seen; rest of line ignored

回滚下补丁…

/u01/app/oracle/product/12.2.0.1/dbhome_1/.patch_storage/NApply/2021-03-25_20-20-23PM/restore.sh

在节点1 cat /u01/app/oracle/product/12.2.0.1/dbhome_1/precomp/lib/ins_precomp.mk 发现未空，在去节点上2上去cat一下发现有内容，复制该文件到节点1

scp oracle@192.168.59.181:/u01/app/oracle/product/12.2.0.1/dbhome_1/precomp/lib/ins_precomp.mk oracle@192.168.59.180:/u01/app/oracle/product/12.2.0.1/dbhome_1/precomp/lib/ins_precomp.mk

再次执行

/u01/app/oracle/product/12.2.0.1/dbhome_1/.patch_storage/NApply/2021-03-25_20-20-23PM/restore.sh

/u01/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatchauto apply /u01/RU/30133386/30116802 -oh /u01/app/oracle/product/12.2.0.1/dbhome_1 -nonrolling

又发现报错… 这次是文件env_precomp.mk为空，复制过来…

[oracle@lissen-n2 ~]$ scp oracle@192.168.59.181:/u01/app/oracle/product/12.2.0.1/dbhome_1/precomp/lib/env_precomp.mk oracle@192.168.59.180:/u01/app/oracle/product/12.2.0.1/dbhome_1/precomp/lib/env_precomp.mk

再次执行

/u01/app/oracle/product/12.2.0.1/dbhome_1/.patch_storage/NApply/2021-03-25_20-20-23PM/restore.sh

/u01/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatchauto apply /u01/RU/30133386/30116802 -oh /u01/app/oracle/product/12.2.0.1/dbhome_1 -nonrolling

又发现报错… 这次是文件libpgp.a为空，复制过来…

/u01/app/oracle/product/12.2.0.1/dbhome_1/precomp/lib/libpgp.a

继续…

/u01/app/oracle/product/12.2.0.1/dbhome_1/.patch_storage/NApply/2021-03-25_20-20-23PM/restore.sh

[root@lissen-n1 30116802]# /u01/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatchauto apply /u01/RU/30133386/30116802 -oh /u01/app/oracle/product/12.2.0.1/dbhome_1 -nonrolling

OPatchauto session is initiated at Thu Mar 25 20:34:55 2021

System initialization log file is /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2021-03-25_08-35-01PM.log.

Session log file is /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/opatchauto2021-03-25_08-35-07PM.log
The id for this session is V9BV

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

Executing patch validation checks on home /u01/app/oracle/product/12.2.0.1/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/12.2.0.1/dbhome_1

Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0.1/dbhome_1
No step execution required…

Preparing to bring down database service on home /u01/app/oracle/product/12.2.0.1/dbhome_1
No step execution required…

Performing prepatch operation on home /u01/app/oracle/product/12.2.0.1/dbhome_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1

Start applying binary patch on home /u01/app/oracle/product/12.2.0.1/dbhome_1
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1

Performing postpatch operation on home /u01/app/oracle/product/12.2.0.1/dbhome_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1

Preparing home /u01/app/oracle/product/12.2.0.1/dbhome_1 after database service restarted
No step execution required…

Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0.1/dbhome_1
No step execution required…

OPatchAuto successful.

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

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

Host:lissen-n1
RAC Home:/u01/app/oracle/product/12.2.0.1/dbhome_1
Version:12.2.0.1.0
Summary:

==Following patches were SKIPPED:

Patch: /u01/RU/30133386/30116802/30122828
Reason: This patch is not applicable to this specified target type - “rac_database”

Patch: /u01/RU/30133386/30116802/26839277
Reason: This patch is not applicable to this specified target type - “rac_database”

Patch: /u01/RU/30133386/30116802/30093408
Reason: This patch is not applicable to this specified target type - “rac_database”

Patch: /u01/RU/30133386/30116802/30122814
Log: /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-25_20-35-27PM_1.log
Reason: /u01/RU/30133386/30116802/30122814 is not required to be applied to oracle home /u01/app/oracle/product/12.2.0.1/dbhome_1

==Following patches were SUCCESSFULLY applied:

Patch: /u01/RU/30133386/30116802/30138470
Log: /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-25_20-35-38PM_1.log

打补丁成功…