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

網上搜到的文章記錄一下：

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