Database Software

Hi,

Today i got a ticket to look in, with errorORA-15032: not all alterations performed :
SQL> select state, mode_status, mount_status from v$asm_disk where name='NB01_DATA';

no rows selected
======================================================
SQL> select name,state,header_status,path from v$asm_disk;

NAME STATE HEADER_STATU
------------------------------ -------- ------------
PATH
--------------------------------------------------------------------------------
NORMAL UNKNOWN
/dev/rasm_01

NORMAL UNKNOWN
/dev/rasm_02

NORMAL UNKNOWN
/dev/rasm_03


NAME STATE HEADER_STATU
------------------------------ -------- ------------
PATH
--------------------------------------------------------------------------------
NORMAL UNKNOWN
/dev/rasm_04

NORMAL UNKNOWN
/dev/rasm_05

NORMAL UNKNOWN
/dev/rasm_06
===================================================================
SQL> show parameter asm_disk;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string NB01_DATA, NB01_FLASH, PNB01_D
ATA, PNB01_FLASH
asm_diskstring string /dev/rasm_*

==================================================================================


SQL> alter diskgroup all mount;
alter diskgroup all mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "PNB01_FLASH" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"PNB01_FLASH"
ORA-15017: diskgroup "PNB01_DATA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"PNB01_DATA"
ORA-15017: diskgroup "NB01_FLASH" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"NB01_FLASH"
ORA-15017: diskgroup "NB01_DATA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"NB01_DATA"
ORA-15080: synchronous I/O operation to a disk failed
ORA-15080: synchronous I/O operation to a disk failed
ORA-15080: synchronous I/O operation to a disk failed
ORA-15080: synchronous I/O operation to a disk failed
=====================================================================




is it possible from DBA end to handle this issue, or do we need to discuss this issues with OS team.

Thanks

Firdous

Edited by: user11914238 on Mar 17, 2013 3:35 AM