oracle数据库19c补丁发布,19c新环境安装补丁
正常流程
A
[[email protected] ~]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/oracle/30464035
[[email protected] ~]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/oracle/30464035
su - oracle
alter pluggable database all open
cd $ORACLE_HOME/OPatch
./datapatch -verbose
or
B
node1 root, node2 root
/u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/oracle/30464035 -oh /u01/app/19.0.0/grid
/u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/oracle/30464035 -oh /u03/app/oracle/product/19.0.0/db_1
su - oracle
alter pluggable database all open
cd $ORACLE_HOME/OPatch
./datapatch -verbose
=========================完毕!
1.本次测试环境打补丁不顺利!
节点1执行,正常
[[email protected] ~]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/oracle/30464035
节点2执行,异常报错
opatchauto failed with error code 42
--------------------------------------------------------------------------------------------------------
[Apr 2, 2020 3:33:06 PM] [INFO] Following active executables are not used by opatch process :
/u01/app/19.0.0/grid/bin/oracle
/u01/app/19.0.0/grid/bin/tnslsnr
/u01/app/19.0.0/grid/lib/libclntsh.so.19.1
/u01/app/19.0.0/grid/lib/libasmclntsh19.so
Following active executables are used by opatch process :
[Apr 2, 2020 3:33:06 PM] [INFO] Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not used by opatch process :
/u01/app/19.0.0/grid/bin/oracle
/u01/app/19.0.0/grid/bin/tnslsnr
/u01/app/19.0.0/grid/lib/libclntsh.so.19.1
/u01/app/19.0.0/grid/lib/libasmclntsh19.so
Following active executables are used by opatch process :
[Apr 2, 2020 3:33:06 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
==
# lsof | grep /u01/app/19.0.0/grid/bin/oracle
# lsof | grep /u01/app/19.0.0/grid/bin/tnslsnr
# lsof | grep /u01/app/19.0.0/grid/lib/libclntsh.so.19.1
# lsof | grep /u01/app/19.0.0/grid/lib/libasmclntsh19.so
# kill -9 PID
参考解决方法,kill进程无法解决,因为这些进程除非关闭crs!
Grid Infrastructure:OPatch apply (manual step) fails to apply patch because perl process is running (Doc ID 2409442.1)
https://blog.csdn.net/jycjyc/article/details/103083192
关闭crs在打补丁
关闭crs,打补丁无法使用opatchauto!
# /u01/app/19.0.0/grid/bin/crsctl stop crs -f
[[email protected] ~]# /u01/app/19.0.0/grid/bin/crsctl start crs
ManualSteps for Apply/Rollback Patch
See My Oracle Support Document 2246888.1for cases where opatchauto cannotbe used.
补丁回滚!
[[email protected]:/u01/oracle/30464035]$ /u01/app/19.0.0/grid/OPatch/opatch rollback -id 30446054
回滚失败。导致集群节点2 crs无法启动!
在打补丁的过程中,会对Lib等等进行备份修改,如果rollback失败,将导致CRS无法启动。
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐


所有评论(0)