暂无图片
暂无图片
3
暂无图片
暂无图片
1
暂无图片
首页 / (2)麒麟Linux6.5+Oracle 12c rac psu 190716->220118验证测试

(2)麒麟Linux6.5+Oracle 12c rac psu 190716->220118验证测试

原创 jieguo 2022-09-21
3769

麒麟Linux6.5+Oracle 12c rac psu 190716->220118验证测试
接上篇【一次失败的割接经历：麒麟linux6.5+oracle 12c rac打PSU补丁】
image.png
image.png

两节点/etc/profile增加环境变量：

export PATH=/u01/app/12.2.0/grid/OPatch:/u01/app/12.2.0/grid/bin:$PATH;


复制

两节点替换opatch

cd /home/oracle/soft/2022/
rm -rf /u01/app/oracle/product/12.2.0/db_1/OPatch
cp -rp OPatch /u01/app/oracle/product/12.2.0/db_1/
chown -R oracle:oinstall /u01/app/oracle/product/12.2.0/db_1/OPatch
rm -rf /u01/app/12.2.0/grid/OPatch
cp -rf OPatch /u01/app/12.2.0/grid/
chown -R grid:oinstall /u01/app/12.2.0/grid/OPatch
export PATH=$PATH:/u01/app/12.2.0/grid/OPatch
chmod -R 777 33559966/
opatch version

复制

image.png

两节点检查补丁冲突：

grid
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/soft/2022/33559966/33583921/33587128
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/soft/2022/33559966/33583921/33678030
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/soft/2022/33559966/33583921/33116894
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/soft/2022/33559966/33583921/26839277
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/soft/2022/33559966/33583921/33610989

oracle
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/soft/2022/33559966/33583921/33587128

复制

image.png
image.png

集群状态检查：

image.png

节点1开始打补丁

[root@rac1 2022]# pwd
/home/oracle/soft/2022
[root@rac1 2022]# opatchauto apply /home/oracle/soft/2022/33559966/33583921 -analyze

复制

image.png
image.png
检查分析没问题，正式打：

[root@rac1 2022]# opatchauto apply /home/oracle/soft/2022/33559966/33583921

OPatchauto session is initiated at Wed Sep 21 12:13:25 2022

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-09-21_12-13-27PM.log.

会话日志文件是/u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2022-09-21_12-13-53PM.log
此会话的 ID 为 NIX7

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


Executing patch validation checks on home /u01/app/12.2.0/grid
Patch validation checks successfully completed on home /u01/app/12.2.0/grid


Executing patch validation checks on home /u01/app/oracle/product/12.2.0/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/12.2.0/db_1


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


Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/12.2.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/rac1/crsconfig/crspatch_rac1_2022-09-21_12-15-00AM.log
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
Prepatch 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

未能执行 [OPatchAutoBinaryAction] 补丁程序操作, 有关详细信息, 请查看日志。故障:
Patch Target : rac1->/u01/app/12.2.0/grid 类型 [crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/12.2.0/grid, host: rac1.
Command failed:  /u01/app/12.2.0/grid/OPatch/opatchauto  apply /home/oracle/soft/2022/33559966/33583921 -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_rac1_crs_1.ser -analyzedresult /u01/app/12.2.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_rac1_crs_1.ser
Command failure output: 
==Following patches FAILED in apply:

Patch: /home/oracle/soft/2022/33559966/33583921/33116894
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-19-11下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: 执行脚本 INIT 失败, 返回值 = 1

Patch: /home/oracle/soft/2022/33559966/33583921/33587128
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-19-11下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: 执行脚本 INIT 失败, 返回值 = 1

Patch: /home/oracle/soft/2022/33559966/33583921/33610989
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-19-11下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: 执行脚本 INIT 失败, 返回值 = 1

Patch: /home/oracle/soft/2022/33559966/33583921/33678030
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-19-11下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: 执行脚本 INIT 失败, 返回值 = 1 

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: 业务流程引擎失败。
OPATCHAUTO-68061: 业务流程引擎失败, 返回代码为 1
OPATCHAUTO-68061: 有关详细资料, 请查看日志。
OPatchAuto 失败。

OPatchauto session completed at Wed Sep 21 12:19:20 2022
Time taken to complete the session 5 minutes, 55 seconds

 opatchauto failed with error code 42
[root@rac1 2022]# 
[root@rac1 2022]# more /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-19-11下午_1.log
[2022-9-21 12:19:13] [INFO]         ENTERING METHOD: NApply(patches,options)
[2022-9-21 12:19:13] [INFO]         Checking if the Oracle Home /u01/app/12.2.0/grid is good for OPatch to work.
[2022-9-21 12:19:13] [INFO]         Option unsupported:false and isCASEnabled :false
[2022-9-21 12:19:13] [INFO]         OPatch invoked as follows: 'napply -phBaseFile /u01/app/12.2.0/grid/cfgtoollogs/opatch
auto/core/opatch/SDKWork.txt -local '
[2022-9-21 12:19:13] [INFO]         Oracle 主目录       : /u01/app/12.2.0/grid
                                    主产品清单: /u01/app/oraInventory
                                       从           : /u01/app/12.2.0/grid/oraInst.loc
                                    OPatch 版本    : 12.2.0.1.32
                                    OUI 版本       : 12.2.0.1.4
                                    OUI 位置      : /u01/app/12.2.0/grid/oui
                                    日志文件位置 : /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-2
1_12-19-11下午_1.log
[2022-9-21 12:19:13] [INFO]         Patch history file: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch_his
tory.txt
[2022-9-21 12:19:15] [INFO]         [OPSR-TIME] Loading raw inventory
[2022-9-21 12:19:15] [INFO]         [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 63 (MB)
[2022-9-21 12:19:15] [INFO]         [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 63 (MB)
[2022-9-21 12:19:15] [INFO]         [OPSR-TIME] Raw inventory loaded successfully
[2022-9-21 12:19:16] [INFO]         NApply::no CAS enabled, OPatch runs with legacy process.
[2022-9-21 12:19:16] [INFO]         Verifying environment and performing prerequisite checks...
[2022-9-21 12:19:16] [INFO]         [OPSR-TIME] Running prerequisite checks
[2022-9-21 12:19:16] [INFO]         opatch-external.jar is in /u01/app/12.2.0/grid/OPatch/jlib/opatch-external.jar
[2022-9-21 12:19:16] [INFO]         [OPSR-TIME] Loading cooked inventory
[2022-9-21 12:19:16] [INFO]         [OPSR-MEMORY] : Loading cooked one offs. Heap memory used 160 (MB)
[2022-9-21 12:19:17] [INFO]         [OPSR-MEMORY] : Loaded cooked oneoffs. Heap memory used : 257 (MB)
[2022-9-21 12:19:17] [INFO]         [OPSR-TIME] Cooked inventory loaded successfully
[2022-9-21 12:19:18] [INFO]         Checking if Oracle Home has components required by patches...
[2022-9-21 12:19:18] [INFO]         CheckMissingComps: Cached file does not exist or is invalid, re-build prereq result.
[2022-9-21 12:19:18] [INFO]         Checking conflict among patches...
[2022-9-21 12:19:18] [INFO]         Running prereq checkConflictAmongPatchesWithDetail
[2022-9-21 12:19:18] [INFO]         Following patches can be applied:  33116894 33587128 33610989 33678030
[2022-9-21 12:19:18] [INFO]         Following patches are not required:
[2022-9-21 12:19:18] [INFO]         Following patches are auto rollbackable:
[2022-9-21 12:19:18] [INFO]         Finished checking prereq checkConflictAmongPatchesWithDetail
[2022-9-21 12:19:18] [INFO]         Conflict checking amongst patches PASSED
[2022-9-21 12:19:18] [INFO]         Checking conflicts against Oracle Home...
[2022-9-21 12:19:18] [INFO]         Running prereq checkConflictAgainstOHWithDetail
[2022-9-21 12:19:19] [INFO]         Following patches can be applied:  33116894 33587128 33610989 33678030
[2022-9-21 12:19:19] [INFO]         Following patches are not required:
[2022-9-21 12:19:19] [INFO]         Following patches are auto rollbackable:
[2022-9-21 12:19:19] [INFO]         Finished checking prereq checkConflictAgainstOHWithDetail
[2022-9-21 12:19:19] [INFO]         OCM validation is skipped for SDK mode.
[2022-9-21 12:19:19] [INFO]         Execution of 'sh /home/oracle/soft/2022/33559966/33583921/33587128/custom/scripts/init
 -apply 33587128 ':
[2022-9-21 12:19:19] [INFO]         Return Code = 1
[2022-9-21 12:19:19] [INFO]         执行 ' Command and arguments of init script is restricted to be viewed in log file ':
                                    
                                    返回代码 = 1
[2022-9-21 12:19:19] [INFO]         命令调用返回错误... 'chmod: 更改"/u01/app/12.2.0/grid/jdk" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/.manifest" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/README.html" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include/jawt.h" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include/jvmti.h" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include/jdwpTransport.h" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include/linux" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include/linux/jawt_md.h" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include/linux/jni_md.h" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include/jvmticmlr.h" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include/classfile_constants.h" 的权限: 不允许的操
作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/include/jni.h" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/javafx-src.zip" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/THIRDPARTYLICENSEREADME.txt" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/LICENSE" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/README" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/THIRDPARTYLICENSEREADME.txt" 的权限: 不允许的
操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/LICENSE" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/Welcome.html" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/java" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/rmiregistry" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/tnameserv" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/orbd" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/keytool" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/pack200" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/jcontrol" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/policytool" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/jjs" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/unpack200" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/servertool" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/javaws" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/bin/rmid" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/jfr" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/jfr/default.jfc" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/jfr/profile.jfc" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/fontconfig.bfc" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/meta-index" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/fontconfig.SuSE.10.bfc" 的权限: 不允许的
操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/resources.jar" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/jce.jar" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/hijrah-config-umalqura.properties" 的权限
: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/locale" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/locale/es" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/locale/es/LC_MESSAGES" 的权限: 不允许的操
作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/locale/es/LC_MESSAGES/sunw_java_plugin.mo
" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/locale/zh" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/locale/zh/LC_MESSAGES" 的权限: 不允许的操
作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/jre/lib/locale/zh/LC_MESSAGES/sunw_java_plugin.mo
" 的权限: 不允许的操作

此处省略几千行。。。。。。
此处省略几千行。。。。。。

                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derbyLocale_pt_BR.jar" 的权限: 不允许的操

                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derbyLocale_ru.jar" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derbyclient.jar" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derbyrun.jar" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derbyLocale_pl.jar" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derbyLocale_de_DE.jar" 的权限: 不允许的操

                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derby.jar" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derbyLocale_fr.jar" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derbyLocale_zh_CN.jar" 的权限: 不允许的操

                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/db/lib/derbyLocale_hu.jar" 的权限: 不允许的操作
                                    chmod: 更改"/u01/app/12.2.0/grid/jdk/COPYRIGHT" 的权限: 不允许的操作
                                    ', 返回代码 = 1
[2022-9-21 12:19:19] [WARNING]      OUI-67133:执行脚本 INIT 失败, 返回值 = 1
[2022-9-21 12:19:19] [INFO]         是否继续? [y|n]
[2022-9-21 12:19:19] [INFO]         N (auto-answered by -silent)
[2022-9-21 12:19:19] [INFO]         User Responded with: N
[2022-9-21 12:19:19] [SEVERE]       OUI-67073:UtilSession 失败: 执行脚本 INIT 失败, 返回值 = 1
[2022-9-21 12:19:19] [INFO]         --------------------------------------------------------------------------------
[2022-9-21 12:19:19] [INFO]         The following warnings have occurred during OPatch execution:
[2022-9-21 12:19:19] [INFO]         1) OUI-67133:执行脚本 INIT 失败, 返回值 = 1
[2022-9-21 12:19:19] [INFO]         --------------------------------------------------------------------------------
[2022-9-21 12:19:19] [INFO]         Finishing UtilSession at Wed Sep 21 12:19:19 CST 2022
[2022-9-21 12:19:19] [INFO]         Log file location: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-
09-21_12-19-11下午_1.log

复制

1）核查报错都是/u01/app/12.2.0/grid/jdk目前权限的提示。

执行赋权操作：

chown -R grid:oinstall /u01/app/12.2.0/grid/jdk
继续执行opatchauto resume
[root@rac1 2022]# opatchauto resume

OPatchauto session is initiated at Wed Sep 21 12:24:23 2022
会话日志文件是/u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2022-09-21_12-24-23PM.log
恢复 ID 为 NIX7 的现有会话

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

未能执行 [OPatchAutoBinaryAction] 补丁程序操作, 有关详细信息, 请查看日志。故障:
Patch Target : rac1->/u01/app/12.2.0/grid 类型 [crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/12.2.0/grid, host: rac1.
Command failed:  /u01/app/12.2.0/grid/OPatch/opatchauto  apply /home/oracle/soft/2022/33559966/33583921 -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_rac1_crs_1.ser -analyzedresult /u01/app/12.2.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_rac1_crs_1.ser
Command failure output: 
==Following patches FAILED in apply:

Patch: /home/oracle/soft/2022/33559966/33583921/33116894
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-24-40下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: 
Prerequisite check "CheckApplicable" failed.

Patch: /home/oracle/soft/2022/33559966/33583921/33587128
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-24-40下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: 
Prerequisite check "CheckApplicable" failed.

Patch: /home/oracle/soft/2022/33559966/33583921/33610989
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-24-40下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: 
Prerequisite check "CheckApplicable" failed.

Patch: /home/oracle/soft/2022/33559966/33583921/33678030
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-24-40下午_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: 业务流程引擎失败。
OPATCHAUTO-68061: 业务流程引擎失败, 返回代码为 1
OPATCHAUTO-68061: 有关详细资料, 请查看日志。
OPatchAuto 失败。

OPatchauto session completed at Wed Sep 21 12:24:55 2022
Time taken to complete the session 0 minute, 33 seconds

 opatchauto failed with error code 42
[root@rac1 2022]# more /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-24-40下午_1.log
[2022-9-21 12:24:42] [INFO]         ENTERING METHOD: NApply(patches,options)
[2022-9-21 12:24:42] [INFO]         Checking if the Oracle Home /u01/app/12.2.0/grid is good for OPatch to work.
[2022-9-21 12:24:42] [INFO]         Option unsupported:false and isCASEnabled :false
[2022-9-21 12:24:42] [INFO]         OPatch invoked as follows: 'napply -phBaseFile /u01/app/12.2.0/grid/cfgtoollogs/opatch
auto/core/opatch/SDKWork.txt -local '
[2022-9-21 12:24:42] [INFO]         Oracle 主目录       : /u01/app/12.2.0/grid
                                    主产品清单: /u01/app/oraInventory
                                       从           : /u01/app/12.2.0/grid/oraInst.loc
                                    OPatch 版本    : 12.2.0.1.32
                                    OUI 版本       : 12.2.0.1.4
                                    OUI 位置      : /u01/app/12.2.0/grid/oui
                                    日志文件位置 : /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-2
1_12-24-40下午_1.log
[2022-9-21 12:24:42] [INFO]         Patch history file: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch_his
tory.txt
[2022-9-21 12:24:44] [INFO]         [OPSR-TIME] Loading raw inventory
[2022-9-21 12:24:44] [INFO]         [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 75 (MB)
[2022-9-21 12:24:44] [INFO]         [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 75 (MB)
[2022-9-21 12:24:44] [INFO]         [OPSR-TIME] Raw inventory loaded successfully
[2022-9-21 12:24:44] [INFO]         NApply::no CAS enabled, OPatch runs with legacy process.
[2022-9-21 12:24:44] [INFO]         Verifying environment and performing prerequisite checks...
[2022-9-21 12:24:44] [INFO]         [OPSR-TIME] Running prerequisite checks
[2022-9-21 12:24:44] [INFO]         opatch-external.jar is in /u01/app/12.2.0/grid/OPatch/jlib/opatch-external.jar
[2022-9-21 12:24:44] [INFO]         [OPSR-TIME] Loading cooked inventory
[2022-9-21 12:24:45] [INFO]         [OPSR-MEMORY] : Loading cooked one offs. Heap memory used 137 (MB)
[2022-9-21 12:24:45] [INFO]         [OPSR-MEMORY] : Loaded cooked oneoffs. Heap memory used : 234 (MB)
[2022-9-21 12:24:45] [INFO]         [OPSR-TIME] Cooked inventory loaded successfully
[2022-9-21 12:24:46] [INFO]         Checking if Oracle Home has components required by patches...
[2022-9-21 12:24:46] [INFO]         CheckMissingComps: Cached file does not exist or is invalid, re-build prereq result.
[2022-9-21 12:24:46] [INFO]         Checking conflict among patches...
[2022-9-21 12:24:46] [INFO]         Running prereq checkConflictAmongPatchesWithDetail
[2022-9-21 12:24:46] [INFO]         Following patches can be applied:  33116894 33587128 33610989 33678030
[2022-9-21 12:24:46] [INFO]         Following patches are not required:
[2022-9-21 12:24:46] [INFO]         Following patches are auto rollbackable:
[2022-9-21 12:24:46] [INFO]         Finished checking prereq checkConflictAmongPatchesWithDetail
[2022-9-21 12:24:46] [INFO]         Conflict checking amongst patches PASSED
[2022-9-21 12:24:46] [INFO]         Checking conflicts against Oracle Home...
[2022-9-21 12:24:46] [INFO]         Running prereq checkConflictAgainstOHWithDetail
[2022-9-21 12:24:47] [INFO]         Following patches can be applied:  33116894 33587128 33610989 33678030
[2022-9-21 12:24:47] [INFO]         Following patches are not required:
[2022-9-21 12:24:47] [INFO]         Following patches are auto rollbackable:
[2022-9-21 12:24:47] [INFO]         Finished checking prereq checkConflictAgainstOHWithDetail
[2022-9-21 12:24:47] [INFO]         OCM validation is skipped for SDK mode.
[2022-9-21 12:24:47] [INFO]         Execution of 'sh /home/oracle/soft/2022/33559966/33583921/33587128/custom/scripts/init
 -apply 33587128 ':
[2022-9-21 12:24:47] [INFO]         Return Code = 0
[2022-9-21 12:24:47] [INFO]         执行 ' Command and arguments of init script is restricted to be viewed in log file ':
                                    
                                    返回代码 = 0
[2022-9-21 12:24:48] [INFO]         Running prerequisite checks...
[2022-9-21 12:24:48] [INFO]         Space Needed : 12170.331MB
[2022-9-21 12:24:48] [INFO]         Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 33116894
[2022-9-21 12:24:48] [INFO]         Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 33587128
[2022-9-21 12:24:48] [INFO]         Prereq checkPatchApplicableOnCurrentPlatform Passed on patch :33610989
[2022-9-21 12:24:48] [INFO]         Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 33678030
[2022-9-21 12:24:49] [INFO]         Patch 33116894:
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsccm" is not writeable.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsccm' 复制到 '/u01/app/12.2.0/grid/bin/acfs
ccm'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsdriverstate" is not writea
ble.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsdriverstate' 复制到 '/u01/app/12.2.0/grid/
bin/acfsdriverstate'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfshanfs" is not writeable.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfshanfs' 复制到 '/u01/app/12.2.0/grid/bin/ac
fshanfs'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsload" is not writeable.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsload' 复制到 '/u01/app/12.2.0/grid/bin/acf
sload'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsregistrymount" is not writ
eable.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsregistrymount' 复制到 '/u01/app/12.2.0/gri
d/bin/acfsregistrymount'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsrepl_apply" is not writeab
le.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsrepl_apply' 复制到 '/u01/app/12.2.0/grid/b
in/acfsrepl_apply'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsrepl_apply.bin" is not wri
teable.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsrepl_apply.bin' 复制到 '/u01/app/12.2.0/gr
id/bin/acfsrepl_apply.bin'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsrepl_dupd" is not writeabl
e.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsrepl_dupd' 复制到 '/u01/app/12.2.0/grid/bi
n/acfsrepl_dupd'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsrepl_dupd.bin" is not writ
eable.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsrepl_dupd.bin' 复制到 '/u01/app/12.2.0/gri
d/bin/acfsrepl_dupd.bin'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsrepl_initializer" is not w
riteable.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsrepl_initializer' 复制到 '/u01/app/12.2.0/
grid/bin/acfsrepl_initializer'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsrepl_monitor" is not write
able.
                                    'oracle.usm, 12.2.0.1.0': 无法将文件从 'acfsrepl_monitor' 复制到 '/u01/app/12.2.0/grid
/bin/acfsrepl_monitor'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/bin/acfsrepl_preapply" is not writ
eable.
此处省略几千行。。。。。。
此处省略几千行。。。。。。
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 'jwcctl_common.pm' 复制到 '/u01/app/12.2.0/grid/lib/jwcctl_common.pm'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/jwcctl_lib.pm" is not writeable.
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 'jwcctl_lib.pm' 复制到 '/u01/app/12.2.0/grid/lib/jwcctl_lib.pm'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libCurveFit.so" is not writeable.
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 'libCurveFit.so' 复制到 '/u01/app/12.2.0/grid/lib/libCurveFit.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libNeticaJ.so" is not writeable.
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 'libNeticaJ.so' 复制到 '/u01/app/12.2.0/grid/lib/libNeticaJ.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libcha12.so" is not writeable.
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 'libcha12.so' 复制到 '/u01/app/12.2.0/grid/lib/libcha12.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libcrf12.so" is not writeable.
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 'libcrf12.so' 复制到 '/u01/app/12.2.0/grid/lib/libcrf12.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libcrf_mdb12.so" is not writeable.
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 'libcrf_mdb12.so' 复制到 '/u01/app/12.2.0/grid/lib/libcrf_mdb12.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libeonsserver.so" is not writeable.
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 'libeonsserver.so' 复制到 '/u01/app/12.2.0/grid/lib/libeonsserver.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libjagent12.so" is not writeable.
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 'libjagent12.so' 复制到 '/u01/app/12.2.0/grid/lib/libjagent12.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/s_jwcctl_lib.pm" is not writeable.
                                    'oracle.has.crs, 12.2.0.1.0': 无法将文件从 's_jwcctl_lib.pm' 复制到 '/u01/app/12.2.0/grid/lib/s_jwcctl_lib.pm'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/jlib/srvm.jar" is not writeable.
                                    'oracle.has.common.cvu, 12.2.0.1.0': 无法将文件从 'srvm.jar' 复制到 '/u01/app/12.2.0/grid/jlib/srvm.jar'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libhasgen12.so" is not writeable.
                                    'oracle.has.common.cvu, 12.2.0.1.0': 无法将文件从 'libhasgen12.so' 复制到 '/u01/app/12.2.0/grid/lib/libhasgen12.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libocr12.so" is not writeable.
                                    'oracle.has.common.cvu, 12.2.0.1.0': 无法将文件从 'libocr12.so' 复制到 '/u01/app/12.2.0/grid/lib/libocr12.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libocrb12.so" is not writeable.
                                    'oracle.has.common.cvu, 12.2.0.1.0': 无法将文件从 'libocrb12.so' 复制到 '/u01/app/12.2.0/grid/lib/libocrb12.so'
                                    Copy Action: Destination File "/u01/app/12.2.0/grid/lib/libocrutl12.so" is not writeable.
                                    'oracle.has.common.cvu, 12.2.0.1.0': 无法将文件从 'libocrutl12.so' 复制到 '/u01/app/12.2.0/grid/lib/libocrutl12.so'
[2022-9-21 12:24:54] [SEVERE]       OUI-67073:UtilSession 失败: 
                                    Prerequisite check "CheckApplicable" failed.
[2022-9-21 12:24:54] [INFO]         Finishing UtilSession at Wed Sep 21 12:24:54 CST 2022
[2022-9-21 12:24:54] [INFO]         Log file location: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-24-40下午_1.log

复制

2）检查报错同样还是报一些目录文件的权限问题

获取上述错误日志，然后通过grep Destination opatch2022-09-21_12-24-40下午_1.log > err.txt然后排序，去重，补全脚本等方式，得到如下脚本，并继续root执行

mkdir -p /u01/app/12.2.0/grid/usm/install/Novell/SLES12/x86_64/SP4/4.12.14-94.41/default/bin
mkdir -p /u01/app/12.2.0/grid/jdk/jre/legal/jdk
mkdir -p /u01/app/12.2.0/grid/jdk/jre/legal/javafx
mkdir -p /u01/app/12.2.0/grid/jdk/jre/lib/security/policy/limited
mkdir -p /u01/app/12.2.0/grid/jdk/jre/lib/security/policy/unlimited
mkdir -p /u01/app/12.2.0/grid/jdk/legal/jdk
mkdir -p /u01/app/12.2.0/grid/jdk/legal/javafx

chown -R grid:oinstall /u01/app/12.2.0/grid/usm/install/Novell/SLES12/x86_64/SP4/4.12.14-94.41/default/bin
chown -R grid:oinstall /u01/app/12.2.0/grid/jdk
chown -R grid:oinstall /u01/app/12.2.0/grid/bin
chown -R grid:oinstall /u01/app/12.2.0/grid/lib
chown -R grid:oinstall /u01/app/12.2.0/grid/crs/install
chown -R grid:oinstall /u01/app/12.2.0/grid/jlib
chown -R grid:oinstall /u01/app/12.2.0/grid/srvm/jlib
chown -R grid:oinstall /u01/app/12.2.0/grid/suptools/tfa
opatchauto resume

复制

image.png
image.png

[root@rac1 2022]# opatchauto resume

OPatchauto session is initiated at Wed Sep 21 12:34:13 2022
会话日志文件是/u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2022-09-21_12-34-13PM.log
恢复 ID 为 NIX7 的现有会话

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

未能执行 [OPatchAutoBinaryAction] 补丁程序操作, 有关详细信息, 请查看日志。故障:
Patch Target : rac1->/u01/app/12.2.0/grid 类型 [crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/12.2.0/grid, host: rac1.
Command failed:  /u01/app/12.2.0/grid/OPatch/opatchauto  apply /home/oracle/soft/2022/33559966/33583921 -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_rac1_crs_1.ser -analyzedresult /u01/app/12.2.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_rac1_crs_1.ser
Command failure output: 
==Following patches FAILED in apply:

Patch: /home/oracle/soft/2022/33559966/33583921/33116894
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-34-30下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Patch: /home/oracle/soft/2022/33559966/33583921/33587128
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-34-30下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Patch: /home/oracle/soft/2022/33559966/33583921/33610989
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-34-30下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Patch: /home/oracle/soft/2022/33559966/33583921/33678030
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-34-30下午_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Prerequisite check "CheckActiveFilesAndExecutables" failed. 

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: 业务流程引擎失败。
OPATCHAUTO-68061: 业务流程引擎失败, 返回代码为 1
OPATCHAUTO-68061: 有关详细资料, 请查看日志。
OPatchAuto 失败。

OPatchauto session completed at Wed Sep 21 12:34:48 2022
Time taken to complete the session 0 minute, 36 seconds

 opatchauto failed with error code 42
[root@rac1 2022]# more /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-34-30下午_1.log
[2022-9-21 12:34:32] [INFO]         ENTERING METHOD: NApply(patches,options)
[2022-9-21 12:34:32] [INFO]         Checking if the Oracle Home /u01/app/12.2.0/grid is good for OPatch to work.
[2022-9-21 12:34:32] [INFO]         Option unsupported:false and isCASEnabled :false
[2022-9-21 12:34:32] [INFO]         OPatch invoked as follows: 'napply -phBaseFile /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/SDKWork.txt -loc
al '
[2022-9-21 12:34:32] [INFO]         Oracle 主目录       : /u01/app/12.2.0/grid
                                    主产品清单: /u01/app/oraInventory
                                       从           : /u01/app/12.2.0/grid/oraInst.loc
                                    OPatch 版本    : 12.2.0.1.32
                                    OUI 版本       : 12.2.0.1.4
                                    OUI 位置      : /u01/app/12.2.0/grid/oui
                                    日志文件位置 : /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-34-30下午_1.log
[2022-9-21 12:34:32] [INFO]         Patch history file: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch_history.txt
[2022-9-21 12:34:34] [INFO]         [OPSR-TIME] Loading raw inventory
[2022-9-21 12:34:34] [INFO]         [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 80 (MB)
[2022-9-21 12:34:34] [INFO]         [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 80 (MB)
[2022-9-21 12:34:34] [INFO]         [OPSR-TIME] Raw inventory loaded successfully
[2022-9-21 12:34:34] [INFO]         NApply::no CAS enabled, OPatch runs with legacy process.
[2022-9-21 12:34:34] [INFO]         Verifying environment and performing prerequisite checks...
[2022-9-21 12:34:34] [INFO]         [OPSR-TIME] Running prerequisite checks
[2022-9-21 12:34:34] [INFO]         opatch-external.jar is in /u01/app/12.2.0/grid/OPatch/jlib/opatch-external.jar
[2022-9-21 12:34:34] [INFO]         [OPSR-TIME] Loading cooked inventory
[2022-9-21 12:34:35] [INFO]         [OPSR-MEMORY] : Loading cooked one offs. Heap memory used 142 (MB)
[2022-9-21 12:34:35] [INFO]         [OPSR-MEMORY] : Loaded cooked oneoffs. Heap memory used : 241 (MB)
[2022-9-21 12:34:35] [INFO]         [OPSR-TIME] Cooked inventory loaded successfully
[2022-9-21 12:34:36] [INFO]         Checking if Oracle Home has components required by patches...
[2022-9-21 12:34:36] [INFO]         CheckMissingComps: Cached file does not exist or is invalid, re-build prereq result.
[2022-9-21 12:34:36] [INFO]         Checking conflict among patches...
[2022-9-21 12:34:36] [INFO]         Running prereq checkConflictAmongPatchesWithDetail
[2022-9-21 12:34:36] [INFO]         Following patches can be applied:  33116894 33587128 33610989 33678030
[2022-9-21 12:34:36] [INFO]         Following patches are not required:
[2022-9-21 12:34:36] [INFO]         Following patches are auto rollbackable:
[2022-9-21 12:34:36] [INFO]         Finished checking prereq checkConflictAmongPatchesWithDetail
[2022-9-21 12:34:36] [INFO]         Conflict checking amongst patches PASSED
[2022-9-21 12:34:36] [INFO]         Checking conflicts against Oracle Home...
[2022-9-21 12:34:36] [INFO]         Running prereq checkConflictAgainstOHWithDetail
[2022-9-21 12:34:37] [INFO]         Following patches can be applied:  33116894 33587128 33610989 33678030
[2022-9-21 12:34:37] [INFO]         Following patches are not required:
[2022-9-21 12:34:37] [INFO]         Following patches are auto rollbackable:
[2022-9-21 12:34:37] [INFO]         Finished checking prereq checkConflictAgainstOHWithDetail
[2022-9-21 12:34:37] [INFO]         OCM validation is skipped for SDK mode.
[2022-9-21 12:34:37] [INFO]         Execution of 'sh /home/oracle/soft/2022/33559966/33583921/33587128/custom/scripts/init -apply 33587128 ':
[2022-9-21 12:34:37] [INFO]         Return Code = 0
[2022-9-21 12:34:37] [INFO]         执行 ' Command and arguments of init script is restricted to be viewed in log file ':
                                    
                                    返回代码 = 0
[2022-9-21 12:34:38] [INFO]         Running prerequisite checks...
[2022-9-21 12:34:38] [INFO]         Space Needed : 12170.331MB
[2022-9-21 12:34:38] [INFO]         Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 33116894
[2022-9-21 12:34:38] [INFO]         Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 33587128
[2022-9-21 12:34:38] [INFO]         Prereq checkPatchApplicableOnCurrentPlatform Passed on patch :33610989
[2022-9-21 12:34:38] [INFO]         Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 33678030
[2022-9-21 12:34:44] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/oracle at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/oracle at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Files in use by a process: /u01/app/12.2.0/grid/bin/oracle PID( 2807  3433  3486  3708  3710  3712  3714  3718  3722  3
726  3730  3732  3734  3736  3738  3740  3742  3746  3748  3750  3752  3754  3756  3758  3760  3762  3764  3766  3768  3770  3772  3778  3849  3875  3877  
3904  4127  4133  5570  5572  5585  5727  5731  5735  5739  5743  5746  5751  5753  5755  5757  5759  5761  5763  5765  5767  5769  5771  5773  5775  5778 
 5780  5782  5784  5786  5788  5790  5792  5794  5797  5799  5801  5817  6786  6788  6849  6851  6856  7146  7957  8740  8755  8764  8780  8785  9064  9069
  9357  9411 11009 11870 11872 14528 31035 31568 )
[2022-9-21 12:34:44] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/sqlldr at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/sqlldr at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/rman at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/rman at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/wrap at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/wrap at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/plshprof at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/plshprof at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/amdu at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/amdu at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/kfed at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/kfed at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:44] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/kfod at Wed Sep 21 12:34:44 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/kfod at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/renamedg at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/renamedg at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/dbfs_client at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/dbfs_client at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/wrc at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/wrc at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/orion at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/orion at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/dgmgrl at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/dgmgrl at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/setasmgid at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/setasmgid at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/extjob at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/extjob at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/extjobo at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/extjobo at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/orapwd at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/orapwd at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:45] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/kgmgr at Wed Sep 21 12:34:45 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/kgmgr at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/dbv at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/dbv at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/ldapsearch at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/ldapsearch at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/nid at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/nid at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/trcldr at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/trcldr at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/expdp at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/expdp at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/impdp at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/impdp at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/dg4pwd at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/bin/dg4pwd at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/lib/libagtsh.so.1.0 at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/lib/libagtsh.so.1.0 at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/lib/libclntsh.so.12.1 at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/lib/libclntsh.so.12.1 at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Files in use by a process: /u01/app/12.2.0/grid/lib/libclntsh.so.12.1 PID( 2344  2370  2372  2405  2457  2807  3344  34
33  3708  3710  3712  3714  3718  3722  3726  3730  3732  3734  3736  3738  3740  3742  3746  3748  3750  3752  3754  3756  3758  3760  3762  3764  3766  3
768  3770  3772  3778  3849  3875  3877  3904  3999  4127  4133  4155  4157  4160  4206  4219  4455  4463  4636  5570  5572  5585  5727  5731  5735  5739  
5743  5746  5751  5753  5755  5757  5759  5761  5763  5765  5767  5769  5771  5773  5775  5778  5780  5782  5784  5786  5788  5790  5792  5794  5797  5799 
 5801  5817  6786  6788  6849  6851  6856  7146  7957  8740  8755  8764  8780  8785  9064  9069  9180 11009 11870 11872 14528 31035 31568 )
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/lib/libasmclntsh12.so at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/lib/libasmclntsh12.so at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:46] [INFO]         Files in use by a process: /u01/app/12.2.0/grid/lib/libasmclntsh12.so PID( 2344  2370  2372  2405  2457  2807  3344  34
33  3708  3710  3712  3714  3718  3722  3726  3730  3732  3734  3736  3738  3740  3742  3746  3748  3750  3752  3754  3756  3758  3760  3762  3764  3766  3
768  3770  3772  3778  3849  3875  3877  3904  3999  4127  4133  4155  4157  4160  4206  4455  4463  4636  5570  5572  5585  5727  5731  5735  5739  5743  
5746  5751  5753  5755  5757  5759  5761  5763  5765  5767  5769  5771  5773  5775  5778  5780  5782  5784  5786  5788  5790  5792  5794  5797  5799  5801 
 5817  6786  6788  6849  6851  6856  7146  7957  8740  8755  8764  8780  8785  9064  9069  9180 11009 11870 11872 14528 31035 31568 )
[2022-9-21 12:34:46] [INFO]         Start fuser command /sbin/fuser /u01/app/12.2.0/grid/lib/libsqlplus.so at Wed Sep 21 12:34:46 CST 2022
[2022-9-21 12:34:47] [INFO]         Finish fuser command /sbin/fuser /u01/app/12.2.0/grid/lib/libsqlplus.so at Wed Sep 21 12:34:47 CST 2022
[2022-9-21 12:34:47] [INFO]         Following active files/executables/libs are used by ORACLE_HOME :/u01/app/12.2.0/grid
                                    /u01/app/12.2.0/grid/bin/oracle
                                    /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
                                    /u01/app/12.2.0/grid/lib/libasmclntsh12.so
[2022-9-21 12:34:47] [INFO]         Prerequisite check "CheckActiveFilesAndExecutables" failed.
                                    The details are:
                                    
                                    
                                    Following active files/executables/libs are used by ORACLE_HOME :/u01/app/12.2.0/grid
                                    /u01/app/12.2.0/grid/bin/oracle
                                    /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
                                    /u01/app/12.2.0/grid/lib/libasmclntsh12.so
[2022-9-21 12:34:47] [SEVERE]       OUI-67073:UtilSession 失败: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[2022-9-21 12:34:47] [INFO]         Finishing UtilSession at Wed Sep 21 12:34:47 CST 2022
[2022-9-21 12:34:47] [INFO]         Log file location: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_12-34-30下午_1.log
[root@rac1 2022]# 

复制

3）检查报错，很明显提示oracle相关文件被进程占用：

image.png
通过以下命令删除进程：

fuser -ck /u01/app/12.2.0/grid/bin/oracle
fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so

操作记录如下，直至没有进程残留：
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
/u01/app/12.2.0/grid/lib/libclntsh.so.12.1: 16451e
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
/u01/app/12.2.0/grid/lib/libasmclntsh12.so: 16460ce 16531ce 16551ce 16553ce 16569ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
/u01/app/12.2.0/grid/bin/oracle: 16595ce 16667ce 16687ce 16689ce 16705ce 16772ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
/u01/app/12.2.0/grid/lib/libasmclntsh12.so: 16798ce 16848ce 16870ce 16876ce 16888ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
/u01/app/12.2.0/grid/bin/oracle: 16914ce 16964ce 16986ce 16994ce 17005ce 17067ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
/u01/app/12.2.0/grid/lib/libasmclntsh12.so: 17090ce 17161ce 17181ce 17183ce 17200ce
[root@rac1 2022]# 
[root@rac1 2022]# 
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
/u01/app/12.2.0/grid/bin/oracle: 17225ce 17297ce 17315ce 17325ce 17337ce 17400ce 17421 17435e
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
/u01/app/12.2.0/grid/lib/libasmclntsh12.so: 17462ce 17533ce 17553ce 17556ce 17573ce
[root@rac1 2022]# 
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
/u01/app/12.2.0/grid/bin/oracle: 17597ce 17670ce 17687ce 17696ce 17710ce 17772ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
/u01/app/12.2.0/grid/lib/libclntsh.so.12.1: 17798e
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
/u01/app/12.2.0/grid/lib/libasmclntsh12.so: 17822ce 17872ce 17893ce 17898ce 17911ce
[root@rac1 2022]# 
[root@rac1 2022]# 
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
/u01/app/12.2.0/grid/bin/oracle: 17955ce 18005ce 18027ce 18030ce 18045ce 18108ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
/u01/app/12.2.0/grid/lib/libasmclntsh12.so: 18131ce 18203e
[root@rac1 2022]# 
[root@rac1 2022]# 
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
/u01/app/12.2.0/grid/bin/oracle: 18223ce 18295ce 18314ce 18321ce 18333ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
/u01/app/12.2.0/grid/lib/libclntsh.so.12.1: 18359ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
/u01/app/12.2.0/grid/lib/libasmclntsh12.so: 18411e
[root@rac1 2022]# 
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
/u01/app/12.2.0/grid/bin/oracle: 18420ce 18492ce 18512ce 18517ce 18530ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so/u01/app/12.2.0/grid/lib/libclntsh.so.12.1: 18556e
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
/u01/app/12.2.0/grid/lib/libasmclntsh12.so: 18580ce
[root@rac1 2022]# 
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
/u01/app/12.2.0/grid/bin/oracle: 18639ce 18689ce 18711ce 18717ce 18729ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so/u01/app/12.2.0/grid/lib/libclntsh.so.12.1: 18755e
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
/u01/app/12.2.0/grid/lib/libasmclntsh12.so: 18779ce
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
[root@rac1 2022]# 
[root@rac1 2022]# 
[root@rac1 2022]# 
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/bin/oracle
fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libclntsh.so.12.1
fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
[root@rac1 2022]# fuser -ck /u01/app/12.2.0/grid/lib/libasmclntsh12.so
[root@rac1 2022]# 
[root@rac1 2022]# ps -ef|grep d.bin
root     20369  3385  0 12:39 pts/0    00:00:00 grep d.bin

复制

image.png
此时节点2的scan ip失效，但实例2和vip2是正常的
image.png
节点1会话窗口中继续opatchauto resume

[root@rac1 2022]# opatchauto resume

OPatchauto session is initiated at Wed Sep 21 12:40:32 2022
会话日志文件是/u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2022-09-21_12-40-34PM.log
恢复 ID 为 NIX7 的现有会话

Start applying binary patch on home /u01/app/12.2.0/grid
Binary patch applied successfully on home /u01/app/12.2.0/grid

Checking shared status of home.....

Performing postpatch operations on CRS - starting CRS service on home /u01/app/12.2.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/rac1/crsconfig/crspatch_rac1_2022-09-21_12-46-23AM.log
Failed to start CRS service on home /u01/app/12.2.0/grid

未能执行 [GIStartupAction] 补丁程序操作, 有关详细信息, 请查看日志。故障:
Patch Target : rac1->/u01/app/12.2.0/grid 类型 [crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/12.2.0/grid, host: rac1.
Command failed:  /u01/app/12.2.0/grid/perl/bin/perl -I/u01/app/12.2.0/grid/perl/lib -I/u01/app/12.2.0/grid/opatchautocfg/db/dbtmp/bootstrap_rac1/patchwork/crs/install /u01/app/12.2.0/grid/opatchautocfg/db/dbtmp/bootstrap_rac1/patchwork/crs/install/rootcrs.pl -postpatch
Command failure output: 
Using configuration parameter file: /u01/app/12.2.0/grid/opatchautocfg/db/dbtmp/bootstrap_rac1/patchwork/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/rac1/crsconfig/crspatch_rac1_2022-09-21_12-46-23AM.log
2022/09/21 12:46:34 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2022/09/21 12:48:19 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2022/09/21 12:48:23 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.conf'
CRS-4123: 正在启动 Oracle 高可用性服务管理的资源
CRS-2672: 尝试启动 'ora.mdnsd' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.evmd' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.mdnsd' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.evmd' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.gpnpd' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.gpnpd' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.gipcd' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.gipcd' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.cssdmonitor' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.cssdmonitor' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.cssd' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.diskmon' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.diskmon' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.cssd' (在 'rac1' 上)
CRS-2679: 尝试清除 'ora.cluster_interconnect.haip' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.ctssd' (在 'rac1' 上)
CRS-2681: 成功清除 'ora.cluster_interconnect.haip' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.cluster_interconnect.haip' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.cluster_interconnect.haip' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.ctssd' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.asm' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.asm' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.storage' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.storage' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.crf' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.crf' (在 'rac1' 上)
CRS-2672: 尝试启动 'ora.crsd' (在 'rac1' 上)
CRS-2676: 成功启动 'ora.crsd' (在 'rac1' 上)
Cluster Ready Service aborted due to Oracle Cluster Registry error [PROC-53: 配置的补丁程序级别, 发行版补丁程序级别和另一个活动集群节点上的补丁程序级别不完全相同。]. Details at (:CRSD00111:) in /u01/app/grid/diag/crs/rac1/crs/trace/crsd.trc.
CRS-2883: 在集群件堆栈启动期间, 资源 'ora.crsd' 失败。
CRS-4406: Oracle 高可用性服务同步启动失败。
CRS-4000: 命令 Start 失败, 或已完成但出现错误。
2022/09/21 12:49:11 CLSRSC-117: Failed to start Oracle Clusterware stack 

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: 业务流程引擎失败。
OPATCHAUTO-68061: 业务流程引擎失败, 返回代码为 1
OPATCHAUTO-68061: 有关详细资料, 请查看日志。
OPatchAuto 失败。

OPatchauto session completed at Wed Sep 21 12:49:13 2022
Time taken to complete the session 8 minutes, 42 seconds

 opatchauto failed with error code 42

复制

4）检查报错信息，提示最后启动集群服务失败，原因是[PROC-53: 配置的补丁程序级别, 发行版补丁程序级别和另一个活动集群节点上的补丁程序级别不完全相同。]

[root@rac1 2022]# 

复制

image.png
image.png
此时crsd和evmd进程无法启动

[root@rac1 2022]# crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [12.2.0.1.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [3975995681].
[root@rac1 2022]# kfod op=patches
---------------
List of Patches
===============
26839277
33116894
33587128
33610989
33678030
[root@rac1 2022]# kfod op=patchlvl
-------------------
Current Patch level
===================
3975995681

查看节点2状态：
[root@rac2 2022]# crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [12.2.0.1.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [3975995681].
[root@rac2 2022]# kfod op=patches
---------------
List of Patches
===============
26839277
28566910
29757449
29770040
29770090
[root@rac2 2022]# kfod op=patchlvl
-------------------
Current Patch level
===================
927320293

复制

如下图所示两节点补丁级别不同
image.png
节点1的集群就此保持失败状态。

此时不管节点1，继续做节点2打补丁：

同样先分析一下，没问题。

[root@rac2 2022]# cd /home/oracle/soft/2022
[root@rac2 2022]# opatchauto apply /home/oracle/soft/2022/33559966/33583921 -analyze

OPatchauto session is initiated at Wed Sep 21 13:00:15 2022

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-09-21_01-00-17PM.log.

会话日志文件是/u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2022-09-21_01-00-53PM.log
此会话的 ID 为 1CSC

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/12.2.0/grid

Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Executing patch validation checks on home /u01/app/12.2.0/grid
Patch validation checks successfully completed on home /u01/app/12.2.0/grid


Executing patch validation checks on home /u01/app/oracle/product/12.2.0/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/12.2.0/db_1


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

OPatchAuto 成功。

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

Analysis for applying patches has completed successfully:

Host:rac2
CRS Home:/u01/app/12.2.0/grid
Version:12.2.0.1.0


==Following patches were SKIPPED:

Patch: /home/oracle/soft/2022/33559966/33583921/26839277
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-01-12下午_1.log
Reason: /home/oracle/soft/2022/33559966/33583921/26839277 is not required to be applied to oracle home /u01/app/12.2.0/grid


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /home/oracle/soft/2022/33559966/33583921/33678030
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-01-12下午_1.log

Patch: /home/oracle/soft/2022/33559966/33583921/33116894
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-01-12下午_1.log

Patch: /home/oracle/soft/2022/33559966/33583921/33610989
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-01-12下午_1.log

Patch: /home/oracle/soft/2022/33559966/33583921/33587128
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-01-12下午_1.log


Host:rac2
RAC Home:/u01/app/oracle/product/12.2.0/db_1
Version:12.2.0.1.0


==Following patches were SKIPPED:

Patch: /home/oracle/soft/2022/33559966/33583921/33116894
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/soft/2022/33559966/33583921/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/soft/2022/33559966/33583921/33610989
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /home/oracle/soft/2022/33559966/33583921/33678030
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-01-12下午_1.log

Patch: /home/oracle/soft/2022/33559966/33583921/33587128
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-01-12下午_1.log



OPatchauto session completed at Wed Sep 21 13:01:45 2022
Time taken to complete the session 1 minute, 30 seconds
[root@rac2 2022]# 

复制

节点2正式打补丁：

[root@rac2 2022]# opatchauto apply /home/oracle/soft/2022/33559966/33583921

OPatchauto session is initiated at Wed Sep 21 13:03:41 2022

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-09-21_01-03-43PM.log.

会话日志文件是/u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2022-09-21_01-04-11PM.log
此会话的 ID 为 BDX5

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/12.2.0/grid

Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Executing patch validation checks on home /u01/app/12.2.0/grid
Patch validation checks successfully completed on home /u01/app/12.2.0/grid


Executing patch validation checks on home /u01/app/oracle/product/12.2.0/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/12.2.0/db_1


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


Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/12.2.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/rac2/crsconfig/crspatch_rac2_2022-09-21_01-05-01PM.log
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
Prepatch 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
Binary patch applied successfully on home /u01/app/12.2.0/grid


Performing postpatch operations on CRS - starting CRS service on home /u01/app/12.2.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/rac2/crsconfig/crspatch_rac2_2022-09-21_01-13-59PM.log
CRS service started successfully on home /u01/app/12.2.0/grid


Preparing home /u01/app/oracle/product/12.2.0/db_1 after database service restarted
No step execution required.........
 

Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/db_1
"[/bin/sh -c 'cd /u01/app/oracle/product/12.2.0/db_1;ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1 ORACLE_SID=cisdb2 /u01/app/oracle/product/12.2.0/db_1/OPatch/datapatch -verbose']" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be applied by manually retrying the same command.

SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1

OPatchAuto 成功。

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

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

Host:rac2
RAC Home:/u01/app/oracle/product/12.2.0/db_1
Version:12.2.0.1.0
Summary:

==Following patches were SKIPPED:

Patch: /home/oracle/soft/2022/33559966/33583921/33116894
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/soft/2022/33559966/33583921/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/soft/2022/33559966/33583921/33610989
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/soft/2022/33559966/33583921/33587128
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-06-09下午_1.log

Patch: /home/oracle/soft/2022/33559966/33583921/33678030
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-06-09下午_1.log


Host:rac2
CRS Home:/u01/app/12.2.0/grid
Version:12.2.0.1.0
Summary:

==Following patches were SKIPPED:

Patch: /home/oracle/soft/2022/33559966/33583921/26839277
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-04-30下午_1.log
Reason: /home/oracle/soft/2022/33559966/33583921/26839277 is not required to be applied to oracle home /u01/app/12.2.0/grid


==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/soft/2022/33559966/33583921/33116894
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-09-06下午_1.log

Patch: /home/oracle/soft/2022/33559966/33583921/33587128
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-09-06下午_1.log

Patch: /home/oracle/soft/2022/33559966/33583921/33610989
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-09-06下午_1.log

Patch: /home/oracle/soft/2022/33559966/33583921/33678030
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-09-21_13-09-06下午_1.log



OPatchauto session completed at Wed Sep 21 13:27:36 2022
Time taken to complete the session 23 minutes, 55 seconds

复制

节点2没有任何报错，很顺利的打上了补丁,此时发现节点1的服务也正常了。

[root@rac2 2022]# crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [12.2.0.1.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [3975995681].
[root@rac2 2022]# kfod op=patches
---------------
List of Patches
===============
26839277
33116894
33587128
33610989
33678030
[root@rac2 2022]# kfod op=patchlvl
-------------------
Current Patch level
===================
3975995681

复制

此时查看两节点补丁完全相同了：
image.png
集群服务也恢复正常：
image.png
image.png
220118补丁版本截图：
image.png
后续更新数据字典和ojvm的补丁根据readme操作即可顺利完成。

总结问题：

1.生产割接无小事，认真做好每一次测试，不要想当然
2.做好必要的备份工作，有备无患
3.遇事需冷静谨慎，后续不明朗，没有把握的情况下，该回退回退，保证业务按时恢复最重要
4.利用好虚机测试环境，可以高效的完成很多测试任务，国产操作系统和国外主流软件兼容性方面需多做验证。

墨力计划oracle rac故障处理
最后修改时间：2022-09-22 10:50:20
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
1人已赞赏
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论

tnan1986
暂无图片
9月前
评论
暂无图片 0
一波三折啊，惊心动魄！！！
9月前
暂无图片 点赞
评论

相关阅读

记一次ORA600内部错误故障分析与修复实录
Digital Observer
279次阅读
2025-03-05 09:33:15
记一次oracle rac 一个节点load averge高导致的问题
Digital Observer
228次阅读
2025-03-13 10:13:43
REMOTE_LISTENER引发的血案
Digital Observer
161次阅读
2025-03-17 09:27:37
Oracle-RAC修改IP信息
胡振兴
96次阅读
2025-03-17 08:36:45
Oracle 19c for OEL8.9 4节点RAC安装部署（静默方式）
zwtian
19次阅读
2025-03-28 16:13:14
Oracle RAC
恩恩霸
16次阅读
2025-03-28 21:54:28
jieguo
关注
297
文章
87
粉丝
327K+
浏览量
暂无图片
获得了588次点赞
暂无图片
内容获得280次评论
暂无图片
获得了353次收藏
热门文章
oracle19c rac grid安装报错的快速处理libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile
2023-03-15 12698浏览
奇怪的ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
2021-11-26 8301浏览
oracle19c rac+asm-->oracle 19c single+fs的adg搭建(实战于生产)
2021-11-11 5739浏览
(1)一次失败的割接经历：麒麟linux6.5+oracle 12c rac打PSU补丁
2022-09-21 5640浏览
gpu p2p多卡训练运行不正常问题
2023-03-09 5251浏览
最新文章
Exadata 核心优势技术全景
5天前 23浏览
Kafka3.8.0+Centos7.9的安装参考
2024-09-20 267浏览
查看oracle长时间运行任务的进度
2024-09-10 100浏览
系统重启后两节点mgr自动恢复的脚本
2024-07-23 57浏览
git@github.com: Permission denied (publickey).
2024-07-10 70浏览
目录
  • 两节点替换opatch
  • 两节点检查补丁冲突：
  • 集群状态检查：
  • 节点1开始打补丁
    • 1）核查报错都是/u01/app/12.2.0/grid/jdk目前权限的提示。
    • 2）检查报错同样还是报一些目录文件的权限问题
    • 3）检查报错，很明显提示oracle相关文件被进程占用：
    • 4）检查报错信息，提示最后启动集群服务失败，原因是[PROC-53: 配置的补丁程序级别, 发行版补丁程序级别和另一个活动集群节点上的补丁程序级别不完全相同。]
  • 此时不管节点1，继续做节点2打补丁：
  • 节点2正式打补丁：
  • 节点2没有任何报错，很顺利的打上了补丁,此时发现节点1的服务也正常了。
  • 总结问题：