Shulou(Shulou.com)06/01 Report--

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

Performing alter diskgroup using sysdba login prompts you that you do not have permissions.

To perform the alter diskgroup operation, you need to log in using sysasm.

SQL > conn / as sysasm

Connected.

SQL > alter diskgroup fra drop disk fra_0001

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.