RedHat 7中,很多命令发生了改变,绑定磁盘不再是start_udev,而是udevadm,具体绑定方式,请看另一篇博文:
1、首先在系统层面查看磁盘绑定情况,如下,
[root@raca1 ~]# ls -l /dev/asm* lrwxrwxrwx 1 root root 4 Apr 24 15:34 /dev/asm-datadisk1 -> sdf2 lrwxrwxrwx 1 root root 4 Apr 24 15:39 /dev/asm-datadisk2 -> sdg2 lrwxrwxrwx 1 root root 4 Apr 24 15:39 /dev/asm-ocrdisk1 -> sdb2 lrwxrwxrwx 1 root root 4 Apr 24 15:17 /dev/asm-ocrdisk2 -> sdc2 lrwxrwxrwx 1 root root 4 Apr 24 15:17 /dev/asm-ocrdisk3 -> sdd2 lrwxrwxrwx 1 root root 4 Apr 24 15:40 /dev/asm-ocrdisk4 -> sde2
2、群集创建完毕,发现在创建ASM磁盘时路径选择错误,应该选择/dev/asm*,结果错选成了/dev/sd*:
SQL> select name,path from v$asm_disk; NAME PATH ---------------------------------------- /dev/sdf2 /dev/sdg2 MGMT_0000 /dev/sde2 VOTE_0002 /dev/sdd2 VOTE_0000 /dev/sdb2 VOTE_0001 /dev/sdc2 6 rows selected. SQL> show parameter string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ asm_diskstring string /dev/sd*
3、修改参数asm_diskstring:
SQL> alter system set asm_diskstring='/dev/asm*' scope=spfile; System altered.
4、生成一个pfile,防止后续数据库无法启动,可用此pfile文件启动数据库
SQL> create pfile='/tmp/pfileraca.ora' from spfile; File created. SQL> quit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [grid@raca2 ~]$ exit logout
5、用root用户进入到GI的HOME/bin目录下,重新启动集群
[root@raca2 ~]# cd /u01/grid/app/12.2.0/bin/ [root@raca2 bin]# ./crsctl stop cluster [root@raca2 bin]# ./crsctl start cluster
6、进入ASM实例查看路径情况,已修改完成
[grid@raca2 ~]$ sqlplus / as sysasm SQL> show parameter string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ asm_diskstring string /dev/asm* SQL> select name,path from v$asm_disk; NAME PATH ------------------------- ------------------------------ /dev/asm-datadisk2 /dev/asm-datadisk1 VOTE_0002 /dev/asm-ocrdisk3 MGMT_0000 /dev/asm-ocrdisk4 VOTE_0001 /dev/asm-ocrdisk2 VOTE_0000 /dev/asm-ocrdisk1 6 rows selected.