ASM裝載磁碟組時ORA-15063錯誤處理

wisdomone1發表於2010-03-06
一次重啟LINUX後,啟動ASM例項時,發生了這個錯誤:

SQL> startup

ASM instance started

Total System Global Area 130023424 bytes

Fixed Size 2071000 bytes

Variable Size 102786600 bytes

ASM Cache 25165824 bytes

ORA-15032: not all alterations performed

ORA-15063: ASM discovered an insufficient number of disks for diskgroup

"DWDATA"

檢視錯誤資訊:

15063, 00000, "ASM discovered an insufficient number of disks for diskgroup \"%s\""

// *Cause: ASM was unable to find a sufficient number of disks belonging to the

// diskgroup to continue the operation.

// *Action: Check that the disks in the diskgroup are present and functioning,

// that the owner of the ORACLE binary has read/write permission to

// the disks, and that the ASM_DISKSTRING initialization parameter

// has been set correctly. Verify that ASM discovers the appropriate

// disks by querying V$ASM_DISK from the ASM instance.

可以看到這個錯誤是由於ASM例項無法裝載硬碟組的所有磁碟而引起的,有可能是許可權問題。馬上想到是否是由於OS重啟後祼裝置的使用者、許可權是否變更,導致ORACLE使用者沒有許可權訪問祼裝置。將祼裝置的許可權更改完後,果然ASM能夠正常啟動。其實這個問題還是很簡單的,LINUX啟動後預設會把祼裝置的擁有者改為root使用者,只需把/etc/udev/permissions.d/50-udev.permissions 這個檔案中的行“raw/*:root:disk:0660”註釋掉,新增新行“raw/*:oracle:dba:0660”,這樣系統啟動後祼裝置的擁有者就變為ORACLE使用者了,當然如果祼裝置還有其他使用者的話,那麼就需要針對不同的祼裝置進行更改了。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-628799/,如需轉載,請註明出處,否則將追究法律責任。

相關文章