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。
再去添加磁盘成功。