ASM Is Unable To Detect SCSI Disks On Windows. [ID 880061.1]

		修改时间 10-SEP-2009 类型 PROBLEM 状态 PUBLISHED

In this Document
Symptoms
Changes
Cause
Solution
References

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2
Microsoft Windows
Microsoft Windows XP (64-bit Itanium)
Microsoft Windows Server 2003 (64-bit Itanium)
Microsoft Windows XP (64-bit AMD64 and Intel EM64T)
Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)
Microsoft Windows (64-bit) on Intel Itanium
Microsoft Windows Vista (32-bit)
Microsoft Windows Server 2003 R2 (64-bit AMD64 and Intel EM64T)
Microsoft Windows Server 2003 R2 (32-bit)
Microsoft Windows Vista x64 (64-bit)
Microsoft Windows Server 2008 (32-bit)
Microsoft Windows Server 2008 (64-bit Itanium)
Microsoft Windows Server 2008 x64 (AMD64/EM64T)
Generic Windows

Symptoms

1) After OS restore, ASM instance cannot detect SCSI disks previously configured:

SQL> ALTER DISKGROUP ALL MOUNT 
* 
ERROR at line 1: 
ORA-15032: not all alterations performed 
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"

2) asmtoolg or asmtool are able to see the disk(s):

C:>asmtool -list 
NTFS DeviceHarddisk0Partition1 20481M 
FAT32 DeviceHarddisk0Partition2 4094M 
NTFS DeviceHarddisk0Partition3 30725M 
NTFS DeviceHarddisk0Partition4 30718M 
ORCLDISKDATA0 DeviceHarddisk3Partition1 1027

3) Also, the dd for windows command is able to read on the disk (confirmed I/O access):

C:> dd if=?DeviceHarddisk3Partition1 of=C:tmp.dmp bs=4096 count=1 
1+0 records in 
1+0 records out

4) But v$asm_disk view cannot discover the disk(s):

SQL> select path from v$asm_disks; 

no rows selected

Or

SQL> Alter system asm_diskstring = '.ORCLDISKDATA0’; 

SQL> select path from v$asm_disks; 


no rows selected

5) Kfed also confirmed a valid ASM disk header:

+ASM:oracle>kfed read tmp.dmp 
kfbh.endian: 1 ; 0x000: 0x01 
kfbh.hard: 130 ; 0x001: 0x82 
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD 
kfbh.datfmt: 1 ; 0x003: 0x01 
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0 
kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0 
kfbh.check: 1906290351 ; 0x00c: 0x719faeaf 
kfbh.fcn.base: 0 ; 0x010: 0x00000000 
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 
kfbh.spare1: 0 ; 0x018: 0x00000000 
kfbh.spare2: 0 ; 0x01c: 0x00000000 
kfdhdb.driver.provstr: ORCLDISKDATA0 ; 0x000: length=13 kfdhdb.driver.reserved[0]: 1096040772 ; 0x008: 0x41544144 
kfdhdb.driver.reserved[1]: 48 ; 0x00c: 0x00000030 
kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000 
kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000 
kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000 
kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000 
kfdhdb.compat: 168820736 ; 0x020: 0x0a100000 
kfdhdb.dsknum: 0 ; 0x024: 0x0000 
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL 
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER 
kfdhdb.dskname: DATA_0000 ; 0x028: length=9 
kfdhdb.grpname: DATA ; 0x048: length=4 
kfdhdb.fgname: DATA_0000 ; 0x068: length=9 
kfdhdb.capname: ; 0x088: length=0 
kfdhdb.crestmp.hi: 32888073 ; 0x0a8: HOUR=0x9 DAYS=0x8 MNTH=0x5 
YEAR=0x7d7 
kfdhdb.crestmp.lo: 1131875328 ; 0x0ac: USEC=0x0 MSEC=0x1c3 SECS=0x37 
MINS=0x10 
kfdhdb.mntstmp.hi: 32922857 ; 0x0b0: HOUR=0x9 DAYS=0x7 MNTH=0x7 
YEAR=0x7d9 
kfdhdb.mntstmp.lo: 3848871936 ; 0x0b4: USEC=0x0 MSEC=0x248 SECS=0x16 
MINS=0x39

6) Also validated the automount feature is OK:

C:> diskpart 

DISKPART> automount enable

7) Shutdown and startup the ASM instance but the problem persists:

C:> srvctl stop asm -n nodename 
C:> srvctl start asm -n nodename

Changes

OS was restored from backup.

Cause

1) “Logical Disk Manager Administrative Service” was disabled.

2) +ASM1 service depends on the “Logical Disk Manager Administrative Service” (dmadmin) to discover the SCSI disks.

3) That service configures hard disk drives and volumes. The service only runs for configuration processes and then stops.

Solution

1) “Logical Disk Manager Administrative Service” needs to be enabled and running as follow:

1.1) Start and enabled the “Logical Disk Manager Administrative Service” (dmadmin) thru the Windows Services gui.

1.2) Restarted the +ASM1 service thru the Windows Services gui.

1.3) After enable it, the ASM '.ORCLDISKDATA0’ disk(s) was successfully discovered & DATA diskgroup was mounted.

1.4) Also, you can create a dependency between the ASM instance and the “Logical Disk Manager Administrative Service” (dmadmin) to make the changes persistent after the reboot as follow:

C:> creatDep /s dmadmin /d OracleASMService+ASM1

References

显示相关信息 相关的

产品

Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

关键字

START INSTANCE; WINDOWS SERVICE; ASM; SRVCTL; V$ASM_DISK; ASMTOOL; ASMTOOLG; V$ASM_DISK

错误

ORA-15063; ORA-15032