ORA-15260: permission denied on ASM disk group
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
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 有所不同
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ASM Disk Group TemplateASM
- Oracle ASM spfile in a disk groupOracleASM
- Oracle ASM ACFS disk group rebalanceOracleASM
- Oracle ASM Disk Group AttributesOracleASM
- ASM disk group mount fails with ORA-15036ASMAI
- How to move ASM spfile to a different disk group [ID 1082943.1]ASM
- ASM disk group mount fails with ORA-15036: disk is truncated [ID 1077175.1]ASMAI
- Hexo deploy git permission deniedHexoGit
- 移動ASM的spfile到一個新的disk groupASM
- drop asm disk、撤銷drop asm diskASM
- Angular macOS Err:EACCES: permission deniedAngularMac
- Permission Denied(publickey) 解決
- -bash: ./backup.sql: Permission deniedSQL
- 規劃ASM DISK GROUP、檢視asm 磁碟當前狀態、mount or dismount 磁碟組ASM
- 手工建立ASM Disk Groups、為 ASM Disk Groups 新增 diskASM
- PHP中 mkdir: Permission denied 問題PHP
- adb remount of system failed: Permission deniedREMAI
- nginx部署(13:Permission denied)報錯Nginx
- Asm disk managerASM
- ASM DISK Group載入ORA-15183錯誤一例ASM
- 【Android】Permission denied (missing INTERNET permission?)異常踩坑Android
- 解決“su: cannot open session: Permission denied”Session
- Error: Permission denied @ apply2filesErrorAPP
- PermissionError: [Errno 13] Permission denied 如何解決Error
- Ubuntu git pull 出現Permission denied ErrorUbuntuGitError
- Cannot restore segment prot after reloc:Permission deniedREST
- [ASM] ORA-15032 ORA-15260ASM
- Oracle ASM Disk DirectoryOracleASM
- Oracle ASM Disk PartnerOracleASM
- PermissionError: [Errno 13] Permission denied解決辦法Error
- Android10 建立檔案 Permission deniedAndroid
- Permission denied Command PhaseScriptExecution failed with a nonzero exit codeAI
- 詳解Nginx 13: Permission denied 解決方案Nginx
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- Android Studio: /dev/kvm device permission deniedAndroiddev
- ASM: Device is already labeled for ASM diskASMdev
- Oracle ASM Disk HeaderOracleASMHeader
- 解決centos 刪除資料夾 permission deniedCentOS