topic Re: Oracle 10g & ASM question in Operating System - Linux

Oracle 10g & ASM question

Jorge Cocomess — Wed, 06 Sep 2006 20:15:33 GMT

Greetings,

I hope this is the right spot to post a question about Oracle 10g and ASM. I apologize in advance.

Does anyone here seen or heard of an ASM restarting itself? So far, this is the only time I've seen our ASM restarting itself for no apparent reason.

Any ideas where I can look for help on this forum or some logs at the OS level?

Thank you in advance.
Jorge

Re: Oracle 10g & ASM question

Steven E. Protter — Thu, 07 Sep 2006 15:57:13 GMT

Shalom Jorge,

ASM will restart itself if clustered and there has been a failure, which the cluster monitor script detects and corrects.

Otherwise it should just stay stopped.

Either way you should check the alert and other relavent logs for problems. Also check and see if cron did it.

SEP

Re: Oracle 10g & ASM question

Eric Singer — Fri, 08 Sep 2006 08:34:01 GMT

We've had a few unexplained ASM restarts in our 4 node Oracle 10G r1 RAC Cluster. This only occurred with one node and not all 4. We opened a TAR with Oracle and they think its bug id 4477387. They reference a work around in bug id 4462367 that required these steps

1) make a backup copy of init.crsd script
2) please add 'ulimit -n unlimited' to init.crsd immediately after 'ulimit -c unlimited'

Hope this is helpful,

Eric

Re: Oracle 10g & ASM question

Eric Singer — Fri, 08 Sep 2006 10:10:41 GMT

I must have made the Oracle gods angry with that last post; we just experienced another ASM restart on one node at our site. It's been a few weeks since this has last happened.

Obviously the above workaround was not a fix.

Eric

Re: Oracle 10g & ASM question

Jorge Cocomess — Fri, 08 Sep 2006 10:56:57 GMT

Oh, NO!! Sorry! Eric - Can you verify this bug id or if you have a link to this work around, I'd love to see it and try it myself. If I find something else out, I will return the favor.

Thanks for your help.

Jorge.

Re: Oracle 10g & ASM question

Eric Singer — Fri, 08 Sep 2006 14:52:20 GMT

You can bring up the bug report on metalink.oracle.com

Our DBA updated our TAR with Oracle and we'll see what their response is to this last ASM restart.

Re: Oracle 10g & ASM question

Jorge Cocomess — Sun, 10 Sep 2006 14:53:20 GMT

What if this is a stand alone DB server with ASM? This server was not installed Oracle clustered, only ASM.

Any other ideas?

Thanks,
Jorge

Re: Oracle 10g & ASM question

Jorge Cocomess — Tue, 19 Sep 2006 10:05:11 GMT

Eric -- Would you please post the outcome of this ASM bug.

Thanks,
Jorge

Re: Oracle 10g & ASM question

Eric Singer — Wed, 20 Sep 2006 12:21:46 GMT

Hi Jorge,

We currently do not have a solution. This past weekend we were plagued by ASM restarts and we're currently looking at upgrade to 10.1.0.4 to see if Oracle has fixed that bug with in that version. So far it seems to occur when CPU utilization is high on the server.

Sorry I don't have any better news for you,

Eric