ASM Disk problemi

Yeni kurulan bir makinada ilk OS restart  işleminde sonra ASM açılmama problemi olabilir.

asm pmon'u ayakta olabilir ama  açılırken hata almiştir.

dbname oracle@hostname:/oracle/admin/aliates/scripts/logs>ps -ef | grep pmon

  oracle  5383     1  0 10:41:59 ?         0:00 asm_pmon_+ASM


Alerlog hatası

SQL> ALTER DISKGROUP ALL MOUNT 
NOTE: Diskgroups listed in ASM_DISKGROUPS are
         DISKGROUPNAME
NOTE: cache registered group DISKGROUPNAME number=1 incarn=0x74357628
NOTE: cache began mount (first) of group DISKGROUPNAME number=1 incarn=0x74357628
ERROR: no read quorum in group: required 2, found 0 disks
NOTE: cache dismounting (clean) group 1/0x74357628 (DISKGROUPNAME) 
NOTE: messaging CKPT to quiesce pins Unix process pid: 4822, image: oracle@hostname
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 1/0x74357628 (DISKGROUPNAME) 
NOTE: cache ending mount (fail) of group DISKGROUPNAMEnumber=1 incarn=0x74357628
NOTE: cache deleting context for group DISKGROUPNAME1/0x74357628
GMON dismounting group 1 at 2 for pid 17, osid 4822
ERROR: diskgroup DISKGROUPNAME was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DISKGROUPNAME" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DISKGROUPNAME"
ERROR: ALTER DISKGROUP ALL MOUNT
Thu Aug 14 10:34:19 2014
NOTE: No asm libraries found in the system
ASM Health Checker found 1 new failures


ASM diskleri göremediği için mount işleminde hata almiştir.  Disklerin  oracle userina verilmesi gerekmektedir.

Ayrıca asm'in pfile dosyasında disklerin pathleri belirtilmelidir.

 asm_diskstring           = "/dev/rdisk/*"

Diskler ASM'e gösterdikten sonra restart edilir. Olması gereken asm alertlog dosyası


SQL> ALTER DISKGROUP ALL MOUNT
NOTE: Diskgroups listed in ASM_DISKGROUPS are
         DISKGROUPNAME
NOTE: cache registered group DISKGROUPNAME number=1 incarn=0xbfa62ae1
NOTE: cache began mount (first) of group RATED number=1 incarn=0xbfa62ae1
NOTE: Assigning number (1,0) to disk (/dev/rdisk/disk32)
NOTE: Assigning number (1,4) to disk (/dev/rdisk/disk37)
NOTE: Assigning number (1,3) to disk (/dev/rdisk/disk36)
NOTE: Assigning number (1,2) to disk (/dev/rdisk/disk34)
NOTE: Assigning number (1,1) to disk (/dev/rdisk/disk33)
NOTE: GMON heartbeating for grp 1
GMON querying group 1 at 3 for pid 17, osid 5414
NOTE: cache opening disk 0 of grp 1: DISKGROUPNAME path:/dev/rdisk/disk32
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DISKGROUPNAME_0001 path:/dev/rdisk/disk33
NOTE: cache opening disk 2 of grp 1: DISKGROUPNAME_0002 path:/dev/rdisk/disk34
NOTE: cache opening disk 3 of grp 1: DISKGROUPNAME_0003 path:/dev/rdisk/disk36
NOTE: cache opening disk 4 of grp 1: DISKGROUPNAME_0004 path:/dev/rdisk/disk37
NOTE: cache mounting (first) external redundancy group 1/0xBFA62AE1 (DISKGROUPNAME)
NOTE: cache recovered group 1 to fcn 0.9302730
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DISKGROUPNAME )
NOTE: LGWR found thread 1 closed at ABA 2.300
NOTE: LGWR mounted thread 1 for diskgroup 1 (DISKGROUPNAME )
NOTE: LGWR opening thread 1 at fcn 0.9302730 ABA 3.301
NOTE: cache mounting group 1/0xBFA62AE1 (DISKGROUPNAME ) succeeded
NOTE: cache ending mount (success) of group DISKGROUPNAME number=1 incarn=0xbfa62ae1
GMON querying group 1 at 4 for pid 13, osid 5406
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
SUCCESS: diskgroup DISKGROUPNAME was mounted
SUCCESS: ALTER DISKGROUP ALL MOUNT
NOTE: diskgroup resource ora.DISKGROUPNAME .dg is online