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无法启动。