oracle 11g 为ASM磁盘组添加磁盘时报错ORA-15260和ORA-15032处理一则

千家信息网最后更新 2025年02月06日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