向ASM磁盘组添加新的磁盘的时候,报了以下错误:
$ sqlplus '/as sysdba' SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 26 10:45:09 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options SQL> alter diskgroup data add disk '/dev/asm/data01';
alter diskgroup data add disk '/dev/asm/data01'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
解决方法:
使用sysasm身份登陆
# su - grid
$ sqlplus '/as sysasm' SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 26 10:46:39 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options SQL> alter diskgroup data add disk '/dev/asm/data01';