RE: Trying to understand an ASM discrepancy

Alex,

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.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

-----Original Message-----
From: Alex Gorbachev [mailto:ag_at_oracloid.com] Sent: Wednesday, April 02, 2008 5:49 PM
To: William Wagman
Cc: oracle-l_at_freelists.org
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:

> Greetings,
>
> 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
> the
> library and system as listed in the V$ASM_DISK view in the ASM
> instance.
> The ASM and RDBMS are installed in separate homes. On node 1 I see the
> following...
>
> .....
>
> 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
> assist
> I would appreciate it.
>
> Thanks.
>
> Bill Wagman
> Univ. of California at Davis
> IET Campus Data Center
> wjwagman_at_ucdavis.edu
> (530) 754-6208
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l