RE: ASM problems

From: Lawie, Duncan <duncan.lawie_at_credit-suisse.com>
Date: Thu, 5 Oct 2006 09:40:04 -0400
Message-ID: <07150B51CE30744CBBB58E696139708DFDDE6D@elon11p32002.csfp.co.uk>

Johan,

have you tried an /etc/init.d/oracleasm scandisks on the second node? This should, at least, allow the disk to be seen from both nodes.

It looks like the select from v$asm_disk is being done in the RDBMS. What do you get if you do the select in your ASM instance? Does it show the second disk? Is it a member of a disk group?

select d.name, d.state, g.name from
v$asm_disk d, v$asm_diskgroup g
where d.group_number = g.group_number

If the second disk isn't a member of a disk group you are OK.

If it is a member of a disk group, try dropping it from that group

alter diskgroup ORADATA1 drop disk WHATEVER;

[ assuming asm_power_limit is non zero ]

HTH,
Duncan.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Johan Eriksson Sent: 05 October 2006 12:33
To: fairlie rego
Cc: oracle-l_at_freelists.org
Subject: Re: ASM problems

No, I ralize now that is was a bit short on information. As I said, I wanted to create a second diskgroup and did what I should first with /etc/init.d/oracleasm createdisk

and after it was marked as a candidate i started dbca to ad it to the asm, but instead of adding a diskgroup I added the disk to the existing group. When I hit ok button it gave me an ora error (ORA-15075 disk(s) are not visible cluster-wide) and I realized it was wrong action I had taken and that I only could se the disk from first node in cluster, I then tried to remove the disk from the group which I so far haven't managed.

unfortunately, still on 10.2.0.1...

/johan

>
> At the moment only one node is working , probably due to this error i made.
>
> from sqlplus i get:
> system_at_msrac1> select name, state from v$asm_disk;
>
> NAME STATE
> ------------------------------ --------
> ORADATA1 NORMAL
>
>
> but when looking in EM I also have a second disk ORADATA2 in state
> FORCING, it shows 100% used but should have no data in it.
>
>
> /johan
> --
> http://www.freelists.org/webpage/oracle-l
>
>

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

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

Received on Thu Oct 05 2006 - 08:40:04 CDT