环境
OS redhat 7.6
database oracle19.4.2
oracle打完补丁后创建磁盘组报错如下
create diskgroup xxxxx;
ORA-15018: Diskgroup can not be created
ORA-15137: cluster in rolling patch
如果下面命令查询2个节点命令不一致的话可以用下面的方法结决,可惜我的2个节点一致这个方法不行
# crsctl query crs softwarepatch <node>
# crsctl stop rollingpatch
CRS-1170: Rejecting rolling patch mode change because the patch has not been applied yet. The software patch level [0] on this node is not the same as the expected patch level [1964077727].
CRS-4000: Command Stop failed, or completed with errors.
问题原因:
是因为打19.4.2的补丁的时候用的不是opatchauto打的,打的时候没有跑root.crs.sh的脚本导致的
解决:
2个节点分别跑root.crs.sh的脚本,问题得到解决
# <GI_HOME>/crs/install/rootcrs.sh -prepatch
# <GI_HOME>/rdbms/install/rootadd_rdbms.sh
If this is an Oracle Restart Home, as the root user execute:
# <GI_HOME>/crs/install/roothas.sh -postpatch