oracle 11g 为ASM磁盘组添加磁盘时报错ORA-15260和ORA-15032处理一则
今天在一个项目上为oracle数据库ASM磁盘组添加磁盘：
先说一下环境：
两台P750，AIX 6.1，oracle RAC 11.2.0.3
添加磁盘时报如下错：
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
原来是当时使用了sysdba连接，改为使用sysasm连接即可，这是11g在ASM管理上的一个改进。
即：su - grid
sqlplus / as sysasm
alter diskgroup DATA add disk '/dev/rhdisk10';
网上搜到的文章记录一下：http://yumianfeilong.com/html/2011/12/16/557.html
Oracle 11gR2 ASM: Changed permission policy (ORA-15260)
Did you recently see the new error ‘ORA-15260: permission denied on ASM disk group’ in your ASM administration? Maybe you are still connected as SYSDBA, old habit from 10g?
A quick citation from the Oracle Docs:
The SYSOPER privilege permits the following subset of the ALTER DISKGROUP operations: diskgroup_availability, rebalance_diskgroup_clause, check_diskgroup_clause (without the REPAIR option). All other ALTER DISKGROUP clauses require the SYSASM privilege.
Just connect with
sqlplus / as sysasm
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25462274/viewspace-2139714/ ，如需转载，请注明出处，否则将追究法律责任。
