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 有所不同
--转自