向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';