[ASM] ORA-15032 ORA-15260

tolilong發表於2018-02-19
SQL> conn / as sysdba
Connected.
SQL> select group_number,disk_number,name,path from v$asm_disk where group_number=3;

GROUP_NUMBER DISK_NUMBER NAME                           PATH
------------ ----------- ------------------------------ ------------------------------
           3           0 FRA_0000                       /dev/rdisk/disk27
           3           1 FRA_0001                       /dev/rdisk/disk28

SQL>
SQL> alter diskgroup fra drop disk fra_0001;
alter diskgroup fra drop disk fra_0001
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

使用sysdba登入執行alter diskgroup會提示沒有許可權。
執行alter diskgroup操作,需要使用sysasm登入。

SQL> conn / as sysasm
Connected.
SQL> alter diskgroup fra drop disk fra_0001;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2151109/,如需轉載,請註明出處,否則將追究法律責任。

相關文章