Home » RDBMS Server » Server Administration » ASM add disk issue (Linux 2.6.18-92.1.13.el5)
ASM add disk issue [message #528030] Fri, 21 October 2011 05:28
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi Expert,

I have seen error in alert for ASM:
Errors in file /p01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_rbal_31856.trc:
ORA-29786: SIHA attribute GET failed with error [Attribute 'ASM_DISKSTRING' sts[200] lsts[0]]
Fri Oct 21 06:15:58 2011
NOTE: failed to discover disks from gpnp profile asm diskstring
Errors in file /p01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_rbal_31856.trc:
ORA-29786: SIHA attribute GET failed with error [Attribute 'ASM_DISKSTRING' sts[200] lsts[0]]
Fri Oct 21 06:16:49 2011
NOTE: failed to discover disks from gpnp profile asm diskstring
Errors in file /p01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_rbal_31856.trc:
ORA-29786: SIHA attribute GET failed with error [Attribute 'ASM_DISKSTRING' sts[200] lsts[0]]


when looking to trace file:

KGGPNP_SIHA: resource 'ora.asm' is not available [200]
KGGPNP_SIHA: attribute 'ASM_DISKSTRING' get failed sts[200] lsts[0]
NOTE: failed to discover disks from gpnp profile asm diskstring
ORA-29786: SIHA attribute GET failed with error [Attribute 'ASM_DISKSTRING' sts[200] lsts[0]]


but when checking with all disk are in normal state.
SQL> select GROUP_NUMBER,NAME,STATE from v$asm_disk;

GROUP_NUMBER NAME                           STATE
------------ ------------------------------ --------
           2 T1_ASM01                       NORMAL
           1 T1_ASM02                       NORMAL
           1 T1_ASM03                       NORMAL
           1 T1_ASM04                       NORMAL
           1 T1_ASM05                       NORMAL
           1 T1_ASM06                       NORMAL
           1 T1_ASM07                       NORMAL
           1 T1_ASM08                       NORMAL
           1 T1_ASM09                       NORMAL
           1 T1_ASM10                       NORMAL
           2 T1_ASM11                       NORMAL

11 rows selected.


Please suggest, what to look up for further investigation.

Thanks.
Previous Topic: how to check a partition have been compressed
Next Topic: v$sql and resource hungry query
Goto Forum:
  


Current Time: Fri Nov 29 04:28:06 CST 2024