RE: Trying to understand an ASM discrepancy
- From: "William Wagman" <wjwagman@xxxxxxxxxxx>
- To: "Alex Gorbachev" <ag@xxxxxxxxxxxx>
- Date: Thu, 3 Apr 2008 14:25:56 -0700
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@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: Alex Gorbachev [mailto:ag@xxxxxxxxxxxx]
Sent: Wednesday, April 02, 2008 5:49 PM
To: William Wagman
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx
> (530) 754-6208
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
