ORA-15260: permission denied on ASM disk group

zhouxianwang發表於2014-05-12
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部落格 ” ,連結:http://blog.itpub.net/27036311/viewspace-1159182/,如需轉載,請註明出處,否則將追究法律責任。

相關文章