麒麟linux6.5 oracle 12c rac psu 190716->220118验证测试
接上篇【一次失败的割接经历：麒麟linux6.5 oracle 12c rac打psu补丁】
两节点/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
两节点检查补丁冲突：
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
集群状态检查：
节点1开始打补丁
[root@rac1 2022]# pwd
/home/oracle/soft/2022
[root@rac1 2022]# opatchauto apply /home/oracle/soft/2022/33559966/33583921 -analyze
检查分析没问题，正式打：
[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/米乐app官网下载 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
[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相关文件被进程占用：
通过以下命令删除进程：
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
此时节点2的scan ip失效，但实例2和vip2是正常的
节点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]#
此时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
如下图所示两节点补丁级别不同
节点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
此时查看两节点补丁完全相同了：
集群服务也恢复正常：
220118补丁版本截图：
后续更新数据字典和ojvm的补丁根据readme操作即可顺利完成。
总结问题：
1.生产割接无小事，认真做好每一次测试，不要想当然
2.做好必要的备份工作，有备无患
3.遇事需冷静谨慎，后续不明朗，没有把握的情况下，该回退回退，保证业务按时恢复最重要
4.利用好虚机测试环境，可以高效的完成很多测试任务，国产操作系统和国外主流软件兼容性方面需多做验证。
最后修改时间：2022-09-22 10:50:20
【米乐app官网下载的版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。