个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2021-04-08 18:55:05
linux7.7上 安装oracle rac 19.3，在节点2打数据库19.9补丁时遇到错误。
对gi打补丁
[root@host2 31720429]# opatchauto apply /tmp/31720429/31750108
-
opatchauto session is initiated at thu apr 8 17:31:37 2021
-
-
system initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2021-04-08_05-31-41pm.log.
-
-
会话日志文件是/u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2021-04-08_05-32-12pm.log
-
此会话的 id 为 wxlv
-
-
executing opatch prereq operations to verify patch applicability on home /u01/app/19c/grid
-
patch applicability verified successfully on home /u01/app/19c/grid
-
-
executing patch validation checks on home /u01/app/19c/grid
-
patch validation checks successfully completed on home /u01/app/19c/grid
-
-
performing prepatch operations on crs - bringing down crs service on home /u01/app/19c/grid
-
prepatch operation log file location: /u01/app/grid/crsdata/host2/crsconfig/crs_prepatch_apply_inplace_host2_2021-04-08_05-32-54pm.log
-
crs service brought down successfully on home /u01/app/19c/grid
-
-
start applying binary patch on home /u01/app/19c/grid
-
binary patch applied successfully on home /u01/app/19c/grid
-
-
performing postpatch operations on crs - starting crs service on home /u01/app/19c/grid
-
postpatch operation log file location: /u01/app/grid/crsdata/host2/crsconfig/crs_postpatch_apply_inplace_host2_2021-04-08_05-44-32pm.log
-
crs service started successfully on home /u01/app/19c/grid
-
-
-
opatchauto 成功。
-
-
-
--------------------------------summary--------------------------------
-
-
-
patching is completed successfully. please find the summary as follows:
-
-
-
host:host2
-
crs home:/u01/app/19c/grid
-
version:19.0.0.0.0
-
summary:
-
-
-
==following patches were successfully applied:
-
-
-
patch: /tmp/31720429/31750108/31771877
-
log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-35-39下午_1.log
-
-
-
patch: /tmp/31720429/31750108/31772784
-
log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-35-39下午_1.log
-
-
-
patch: /tmp/31720429/31750108/31773437
-
log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-35-39下午_1.log
-
-
-
patch: /tmp/31720429/31750108/31780966
-
log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-35-39下午_1.log
-
-
-
-
opatchauto session completed at thu apr 8 17:49:40 2021
- time taken to complete the session 18 minutes, 4 seconds
按readme.html中说明执行opatchauto应该对grid和db都打上补丁呀，但是检查db没有打上，于是单独对db_home打补丁
[root@host2 31720429]# /u01/app/oracle/product/19c/db_1/opatch/opatchauto apply /tmp/31720429/31750108 -oh /u01/app/oracle/product/19c/db_1
-
opatchauto session is initiated at thu apr 8 17:50:39 2021
-
-
-
system initialization log file is /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2021-04-08_05-50-46pm.log.
-
-
-
会话日志文件是/u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2021-04-08_05-51-05pm.log
-
此会话的 id 为 pvr4
-
-
-
executing opatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/db_1
-
patch applicability verified successfully on home /u01/app/oracle/product/19c/db_1
-
-
executing patch validation checks on home /u01/app/oracle/product/19c/db_1
-
patch validation checks successfully completed on home /u01/app/oracle/product/19c/db_1
-
-
verifying sql patch applicability on home /u01/app/oracle/product/19c/db_1
-
no step execution required.........
-
-
preparing to bring down database service on home /u01/app/oracle/product/19c/db_1
-
no step execution required.........
-
-
performing prepatch operation on home /u01/app/oracle/product/19c/db_1
-
perpatch operation completed successfully on home /u01/app/oracle/product/19c/db_1
-
-
start applying binary patch on home /u01/app/oracle/product/19c/db_1
-
failed while applying binary patches on home /u01/app/oracle/product/19c/db_1
-
-
-
未能执行 [opatchautobinaryaction] 补丁程序操作, 有关详细信息, 请查看日志。故障:
-
patch target : host2->/u01/app/oracle/product/19c/db_1 类型 [rac]
-
details: [
-
---------------------------patching failed---------------------------------
-
command execution failed during patching in home: /u01/app/oracle/product/19c/db_1, host: host2.
-
command failed: /u01/app/oracle/product/19c/db_1/opatch/opatchauto apply /tmp/31720429/31750108 -oh /u01/app/oracle/product/19c/db_1 -target_type rac_database -binary -invptrloc /u01/app/oracle/product/19c/db_1/orainst.loc -jre /u01/app/oracle/product/19c/db_1/opatch/jre -persistresult /u01/app/oracle/product/19c/db_1/opatchautocfg/db/sessioninfo/sessionresult_host2_rac_2.ser -analyzedresult /u01/app/oracle/product/19c/db_1/opatchautocfg/db/sessioninfo/sessionresult_analyze_host2_rac_2.ser
-
command failure output:
-
==following patches failed in apply:
-
-
-
patch: /tmp/31720429/31750108/31771877
-
log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-08_17-51-45下午_1.log
-
reason: failed during patching: oracle.opatch.opatchsdk.opatchexception: applysession 在系统修改阶段失败... 'applysession::apply failed: java.io.ioexception: oracle.sysman.oui.patch.patchexception: java.io.filenotfoundexception: /u01/app/orainventory/contentsxml/oui-patch.xml (权限不够)'
-
-
after fixing the cause of failure run opatchauto resume
-
-
]
-
opatchauto-68061: 业务流程引擎失败。
-
opatchauto-68061: 业务流程引擎失败, 返回代码为 1
-
opatchauto-68061: 有关详细资料, 请查看日志。
-
opatchauto 失败。
-
-
-
opatchauto session completed at thu apr 8 17:55:39 2021
-
time taken to complete the session 5 minutes, 0 second
-
-
- opatchauto failed with error code 42
提示中oui-patch.xml (权限不够)，具体检查一下权限与节点1不一样，这是bug导致的失败。
解决方法是：
1、复制节点1上的文件
host1 $ cd $oracle_home/inventory/oneoffs
host1 $ scp -r * host2:$pwd
2、修改权限
host2 # chmod 660 /u01/app/orainventory/contentsxml/oui-patch.xml
3、重新执行打补丁命令
这是在打节点2的db补丁时遇到的问题，节点1却没事。
给主人留下些什么吧！~~