1、环境描述
操作系统：Red Hat Enterprise Linux release 8.2 (Ootpa)
数据库：RAC 19.12
2、升级补丁
2.1 更新GI和Oracle的OPatch工具
根据readme中的要求，更新到19.21需要OPatch版本为12.2.0.1.37 or later
2.2 使用opatchauto工具更新GI和DB软件
[root@db01 35742441]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/35742441/35642822
OPatchauto session is initiated at Tue Dec 19 16:55:37 2023
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-12-19_04-55-40PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-12-19_04-55-55PM.log
The id for this session is Y73T
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Patch applicability verified successfully on home /u01/app/19.0.0/grid
Executing patch validation checks on home /u01/app/19.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0/grid
Executing patch validation checks on home /u01/app/oracle/product/19.0.0/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/dbhome_1
Successfully prepared home /u01/app/oracle/product/19.0.0/dbhome_1 to bring down database service
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/db01/crsconfig/crs_prepatch_apply_inplace_db01_2023-12-19_04-57-10PM.log
CRS service brought down successfully on home /u01/app/19.0.0/grid
Performing prepatch operation on home /u01/app/oracle/product/19.0.0/dbhome_1
Prepatch operation completed successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Start applying binary patch on home /u01/app/oracle/product/19.0.0/dbhome_1
Failed while applying binary patches on home /u01/app/oracle/product/19.0.0/dbhome_1
Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : db01->/u01/app/oracle/product/19.0.0/dbhome_1 Type[rac]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/oracle/product/19.0.0/dbhome_1, host: db01.
Command failed: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatchauto apply /soft/35742441/35642822 -oh /u01/app/oracle/product/19.0.0/dbhome_1 -target_type rac_database -binary -invPtrLoc /u01/app/19.0.0/grid/oraInst.loc -jre /u01/app/19.0.0/grid/OPatch/jre -persistresult /u01/app/oracle/product/19.0.0/dbhome_1/opatchautocfg/db/sessioninfo/sessionresult_db01_rac_2.ser -analyzedresult /u01/app/oracle/product/19.0.0/dbhome_1/opatchautocfg/db/sessioninfo/sessionresult_analyze_db01_rac_2.ser
Command failure output:
==Following patches FAILED in apply:
Patch: /soft/35742441/35642822/35643107
Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_16-59-44PM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException:
Prerequisite check "CheckApplicable" failed.
Patch: /soft/35742441/35642822/35655527
Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_16-59-44PM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException:
Prerequisite check "CheckApplicable" failed.
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 Dec 19 17:00:29 2023
Time taken to complete the session 4 minutes, 49 seconds
opatchauto failed with error code 42
[root@db01 35742441]#
查看日志：对libclntsh.so.19.1文件没有写权限导致
[root@db01 ~]# more /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_16-59-44PM_1.log
[Dec 19, 2023 5:00:24 PM] [INFO] Space Needed : 8741.317MB
[Dec 19, 2023 5:00:26 PM] [INFO] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 35643107
[Dec 19, 2023 5:00:26 PM] [INFO] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 35655527
[Dec 19, 2023 5:00:28 PM] [INFO] Patch 35643107:
Copy Action: Destination File "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so.19.1" is no
t writeable.
'oracle.rdbms.rsf, 19.0.0.0.0': Cannot copy file from 'libclntsh.so.19.1' to '/u01/app/oracle/produ
ct/19.0.0/dbhome_1/lib/libclntsh.so.19.1'
[Dec 19, 2023 5:00:28 PM] [INFO] Prerequisite check "CheckApplicable" failed.
The details are:
Patch 35643107:
Copy Action: Destination File "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so.19.1" is no
t writeable.
'oracle.rdbms.rsf, 19.0.0.0.0': Cannot copy file from 'libclntsh.so.19.1' to '/u01/app/oracle/produ
ct/19.0.0/dbhome_1/lib/libclntsh.so.19.1'
[Dec 19, 2023 5:00:28 PM] [SEVERE] OUI-67073:UtilSession failed:
Prerequisite check "CheckApplicable" failed.
[Dec 19, 2023 5:00:28 PM] [INFO] Finishing UtilSession at Tue Dec 19 17:00:28 CST 2023
在更新到19.12的环境下，该文件的权限：
[oracle@db01 lib]$ ll libclntsh.so.19.1
-r--r--r-- 1 oracle oinstall 81402424 Sep 18 2021 libclntsh.so.19.1
在19.3环境下，该文件的权限：
[oracle@rac01 lib]$ ls -lrth libclntsh.so.19.1*
-rwxr-xr-x. 1 oracle oinstall 77M Nov 19 21:28 libclntsh.so.19.1
赋予正确的权限：
[root@db01 lib]# chmod 755 libclntsh.so.19.1
[root@db01 lib]# ll libclntsh.so.19.1
-rwxr-xr-x 1 oracle oinstall 81402424 Sep 18 2021 libclntsh.so.19.1
重新执行更新补丁操作：
[root@db01 35642822]# opatchauto apply /soft/35742441/35642822
OPatchauto session is initiated at Tue Dec 19 17:36:53 2023
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-12-19_05-36-56PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-12-19_05-37-12PM.log
The id for this session is ZYLM
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Patch applicability verified successfully on home /u01/app/19.0.0/grid
Executing patch validation checks on home /u01/app/19.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0/grid
Executing patch validation checks on home /u01/app/oracle/product/19.0.0/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/dbhome_1
Successfully prepared home /u01/app/oracle/product/19.0.0/dbhome_1 to bring down database service
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/db01/crsconfig/crs_prepatch_apply_inplace_db01_2023-12-19_05-38-26PM.log
CRS service brought down successfully on home /u01/app/19.0.0/grid
Performing prepatch operation on home /u01/app/oracle/product/19.0.0/dbhome_1
Prepatch operation completed successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Start applying binary patch on home /u01/app/oracle/product/19.0.0/dbhome_1
Binary patch applied successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Running rootadd_rdbms.sh on home /u01/app/oracle/product/19.0.0/dbhome_1
Successfully executed rootadd_rdbms.sh on home /u01/app/oracle/product/19.0.0/dbhome_1
Performing postpatch operation on home /u01/app/oracle/product/19.0.0/dbhome_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Start applying binary patch on home /u01/app/19.0.0/grid
Binary patch applied successfully on home /u01/app/19.0.0/grid
Running rootadd_rdbms.sh on home /u01/app/19.0.0/grid
Successfully executed rootadd_rdbms.sh on home /u01/app/19.0.0/grid
Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/db01/crsconfig/crs_postpatch_apply_inplace_db01_2023-12-19_05-46-06PM.log
CRS service started successfully on home /u01/app/19.0.0/grid
Preparing home /u01/app/oracle/product/19.0.0/dbhome_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /u01/app/oracle/product/19.0.0/dbhome_1
No SQL patch operations are required on local node for this home
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:db01
RAC Home:/u01/app/oracle/product/19.0.0/dbhome_1
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /soft/35742441/35642822/35652062
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /soft/35742441/35642822/33575402
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /soft/35742441/35642822/35553096
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /soft/35742441/35642822/35643107
Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_17-39-18PM_1.log
Patch: /soft/35742441/35642822/35655527
Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_17-39-18PM_1.log
Host:db01
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /soft/35742441/35642822/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_17-42-28PM_1.log
Patch: /soft/35742441/35642822/35553096
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_17-42-28PM_1.log
Patch: /soft/35742441/35642822/35643107
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_17-42-28PM_1.log
Patch: /soft/35742441/35642822/35652062
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_17-42-28PM_1.log
Patch: /soft/35742441/35642822/35655527
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-12-19_17-42-28PM_1.log
OPatchauto session completed at Tue Dec 19 17:50:42 2023
Time taken to complete the session 13 minutes, 46 seconds
3、总结
（1）本环境是第一次安装19.3更新到19.12后，过了一段时间后更新到最新的19.21版本。在更新到19.12版本后libclntsh.so.19.1文件权限发生了变化，导致再次更新RU到19.21时执行失败，非19.3版本更新GI RU时，建议提前核对一下libclntsh.so.19.1文件的权限是否发生更改。
（2）更新完成后，startup数据库时报ORA-00800错误，该错误是提升LMHB进程的优先级失败，使用srvctl start instance命令启动可避免产生该报错，或参考MOS文档
2023-12-19T18:29:21.872329+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmhb_1046263.trc (incident=502063):
ORA-00800: soft external error, arguments: [Set Priority Failed], [LMHB], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
2023-12-19T18:29:21.872593+08:00
Error attempting to elevate LMHB's priority: no further priority changes will be attempted for this process
2023-12-19T18:29:22.240564+08:00
