SQL> create diskgroup OCR_DG normal redundancy
2 failgroup OCR_DG_001 disk '/dev/asm-diskg'
3 failgroup OCR_DG_002 disk '/dev/asm-diskh'
4 REGULAR failgroup OCR_DG_003 disk '/dev/asm-diski';
create diskgroup OCR_DG normal redundancy
*
ERROR at line 1:
ORA-15260: permission denied on ASM disk group

原因：

SYSDBA privilege不允许进行ASM操作。

解决：

SQL> conn / as sysasm;
Connected.
SQL> r
1 create diskgroup OCR_DG high redundancy
2   failgroup OCR_DG_001 disk '/dev/asm-diskg'
3   failgroup OCR_DG_002 disk '/dev/asm-diskh'
4* REGULAR failgroup OCR_DG_003 disk '/dev/asm-diski'

Diskgroup created.

总结：
    11G SYSDBA privilege不允许进行ASM操作，只能用SYSASM privilege 来操作AMS, 这与10g 有所不同

ITPub博客

ORA-15260: permission denied on ASM disk group

最新文章