Oracle集群管理ASM-扩容磁盘组报错ora-15137

1 内容描述

今日对19c集群磁盘组进行扩容，

[root@db1 ~]# oracleasm createdisk DATA7 /dev/sdm1
Writing disk header: done
Instantiating disk: done
[root@db1 ~]# oracleasm createdisk DATA8 /dev/sdn1
Writing disk header: done
Instantiating disk: done

使用 alter diskgroup oradata1 add disk '/dev/oracleasm/disks/DATA8' name oradata_00002;

ORA-15137: The ASM cluster is in rolling patch state

匹配文档： [OCI] Scale-up Failed in DBCS With ORA-15032: not all alterations performed, ORA-15137: The ASM cluster is in rolling patch state (Doc ID 2681040.1)为两台计算节点补丁不一致，list of patches在计算节点1缺少一个， patch level值不一致。

查询两边对应的补丁以及补丁号 确实存在问题

使用crsctl命令查看对应的opatch level

crsctl query crs softwarepatch

发现节点1 节点2对应的值是不一样的

[grid@db1 ~]$ crsctl query crs softwarepatch

Oracle Clusterware patch level on node eomsdb1 is [1651835407].

[grid@db2 ~]$ crsctl query crs softwarepatch

Oracle Clusterware patch level on node eomsdb2 is [479021767].

使用opatch lspatchs查看对应的补丁发现节点1的tomcat补丁忘记打了，日了狗。

于是使用prepatch postpatch的方式在对tomcat补丁进行更新，

cd /u01/app/19c/grid/crs/install

./rootcrs.sh -prepatch

su - grid

opatch apply -local -oh $ORACLE_HOME /home/grid/soft/opatch_localtion

cd /u01/app/19c/grid/rdbms/install

./rootadd_rdbms.sh

cd /u01/app/19c/grid/crs/install

./rootcrs.sh -postpatch

更新完补丁之后，会更新整个集群的patch level。

再去添加磁盘成功。