Operating System - HP-UX
1748024 Members
3863 Online
108757 Solutions
New Discussion юеВ

Re: Oracle ASM holds disks after removing

 
SOLVED
Go to solution
Fred Ruffet
Honored Contributor

Oracle ASM holds disks after removing

Hi all,

I have oracle databases stored in ASM. I have moved some data and dropped a disk from the diskgroup. It doesn't appear in ASM anymore but ASM processes still hold the /dev/rdsk.

On a previous similar operation, I've stopped all instances and restarted ASM. Is there an other way to tell ASM to free devices ?

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
8 REPLIES 8
likid0
Honored Contributor

Re: Oracle ASM holds disks after removing

I had the same problem, some time ago I also has to stop the ASM instance to get them free.

If someone knows a way to remove them without stoping would be great!
Windows?, no thanks
Solution

Re: Oracle ASM holds disks after removing

Fred,

This is the same reason why you can't use ASM in a Serviceguard failover cluster.

Oracle have spent the last 2 years arguuing that this "isn't their problem". See metalink article 402526.1 - although I'd argue that the fact that it happens on nearly every platform would suggest its not an OS problem!

Anyway it looks like they might have finally admitted it as a bug, as there is now a bug ID - 4693355, which will apparently be fixed in the 10.2.0.5 and 11.1.0.7 (although I don't see it mentioned in the patch notes)

Of course 10.2.0.5 isn't available yet and the workaround is (yes you guessed it) - bounce the instance.

You could I guess try using lsof to try and identify which background processes still have the disk open and see if you are in a position to terminate them (or at least make them do some work so they wake up and close their file descriptor)

HTH

Duncan

I am an HPE Employee
Accept or Kudo
Steven E. Protter
Exalted Contributor

Re: Oracle ASM holds disks after removing

Shalom Fred,

Typical oracle quality assurance.

It is there bug, not HP-UX. Their RAC and database server product work fine with SG.

Typical Oracle customer service.

Blame someone else and punt because their fix is not ready.

Escalate with Oracle support, but bouncing the instance, which you can script is the best answer here.


SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Fred Ruffet
Honored Contributor

Re: Oracle ASM holds disks after removing

Thanks Duncan.

That's exactly what I was afraid of. I don't have only one instance based on this ASM. I cannot bounce the ASM this easily.

Anyway the purpose of my actual operations is to remove ASM, so I won't have this problem for long...

Best regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Fred Ruffet
Honored Contributor

Re: Oracle ASM holds disks after removing

I forgot one point : processes that hold the /desv/rdsk device are dbwr and lgwr of ASM instance... so lsof and kill will produce the same as a shutdown abort of ASM.

Fred
--

"Reality is just a point of view." (P. K. D.)
Fred Ruffet
Honored Contributor

Re: Oracle ASM holds disks after removing

close.
--

"Reality is just a point of view." (P. K. D.)
likid0
Honored Contributor

Re: Oracle ASM holds disks after removing

I had a look with lsof Duncan, when i had the problem , but its the asm instance who is using the disks :(

Windows?, no thanks

Re: Oracle ASM holds disks after removing

Fred,

Update... if you are on 10.2.0.4 look at Oracle patches 7225720 and 7330611.

HTH

Duncan

I am an HPE Employee
Accept or Kudo