[ASM] ORA-15032 ORA-15260
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;
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 11g 為ASM磁碟組新增磁碟時報錯ORA-15260和ORA-15032處理一則OracleASM
- ORA-15260: permission denied on ASM disk groupASM
- RAC 下使用DBCA 建立ASM出錯(ORA-15032,ORA-15063)ASM
- Oracle 11gR2 (ORA-15260)Oracle
- 基於asm的單例項資料庫啟動時報錯ORA-15032 ORA-15063一例ASM單例資料庫
- asm files,asm directories,asm templatesASM
- 【ASM】如何建立ASM磁碟ASM
- ASM之建立ASM磁碟ASM
- 【ASM學習】ASM 管理ASM
- 【ASM學習】ASM文件ASM
- Unable To Mount Or Drop A Diskgroup, Fails With Ora-15032 And Ora-15063_353423.1AI
- ASM之建立ASM例項及ASM資料庫ASM資料庫
- 【ASM】ASM基礎知識ASM
- ASM之建立ASM例項ASM
- ASM之ASM相關概念ASM
- ASMASM
- 【ORACLE ASM】ASM 支援工具簡介OracleASM
- asm-windows下安裝asmASMWindows
- rman copy asm datafile(rename asm datafile)ASM
- ASM 翻譯系列第八彈:ASM Internal ASM file extent mapASM
- ASM 翻譯系列第十彈:ASM Internal ASM DISK headerASMHeader
- 利用RMAN將非ASM檔案移動到ASM裡 - [ASM]ASM
- ASM 翻譯系列第三十二彈:ASM INTERNAL Find block in ASMASMBloC
- Identify If A Disk/Part Is Still Used By ASM,Used by ASM Or Used by ASM_603210.1IDEASM
- drop asm disk、撤銷drop asm diskASM
- ASM: Device is already labeled for ASM diskASMdev
- 【ASM學習】ASM引數說明ASM
- 【ASM學習】ASM基礎知識ASM
- ASM學習筆記_ASM安裝ASM筆記
- ASM Spfile Is Not Used when ASM Instance StartsASM
- oracle asmOracleASM
- ASM (4)ASM
- ASM (3)ASM
- ASM (2)ASM
- ASM (6)ASM
- ASM (5)ASM
- ASM管理ASM
- oracle ASM中ASM_POWER_LIMIT引數OracleASMMIT