RE: Trying to understand an ASM discrepancy
Date: Thu, 3 Apr 2008 14:25:56 -0700
Yes, asm_diskstring is not set on either node SQL> show parameter asm
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ asm_diskgroups string ASMGRP1, ASMGRP2 asm_diskstring string asm_power_limit integer 1
I did check and all the oracleasm rpm's are present and installed,
although whether or not correctly I don't know. I also looked at the
alert log and on the first node found occurrences of the error...
ORA-15183: ASMLIB initialization error [driver/agent not installed]
ORA-15183: ASMLIB initialization error
[/opt/oracle/extapi/32/asm/orcl/1/libasm.so] ORA-15183: ASMLIB initialization error [driver/agent not installed]
I did find Metalink note 340519.1 which suggests reinstalling the RPM's and rebooting both nodes and see if the problem is resolved.
Unless you, or anyone else, has some other thoughts I will give that a try.
Univ. of California at Davis
IET Campus Data Center
From: Alex Gorbachev [mailto:ag_at_oracloid.com] Sent: Wednesday, April 02, 2008 5:49 PM
To: William Wagman
Subject: Re: Trying to understand an ASM discrepancy
Did I understand you correctly - asm_diskgroup is empty on both nodes? If so, I think on node 1 you have some missing RPM's for ASMLib or something wrong with it so Oracle instance doesn't load ASMLib driver. Compare alert.log on both machines - it should mention loading ASMLib driver there if I recall correctly.
On a slightly different note - consider getting rid of ASMLib - is it worth the pain and adding another layer of complexity?
On 2-Apr-08, at 8:06 PM, William Wagman wrote:
> I am looking at a two node rac cluster running on 32-bit RHEL4, oracle
> 10.2.0.3.0 SE and am puzzled by a discrepancy in the description of
> library and system as listed in the V$ASM_DISK view in the ASM
> The ASM and RDBMS are installed in separate homes. On node 1 I see the
> As I understand it when the library is listed as system it means that
> the asm_diskstring parameter is not set correctly. The puzzling
> thing is
> that in the instance on each node it is set to null. The asm_diskgroup
> parameter is set the same on each node, 'ASMGRP1, ASMGRP2'. I don't
> understand what might have caused these to differ. If anyone can
> I would appreciate it.
> Bill Wagman
> Univ. of California at Davis
> IET Campus Data Center
> (530) 754-6208