DB Carshing almost everyday

[akas_chauhan]

Hi,

These are the errors i'm getting. Oracle Version is 10.2.0.3.0.
Almost everyday i'm getting this error and DB is crashing.
Any idea how to solve this issue, not much relevant info in metalink.

I found following trace in alert log file.

Current log# 3 seq# 14782 mem# 0: /apps/oracledata/oradata/tom/redo03.log

Tue May 13 12:30:14 2008

Process m000 died, see its trace file

Tue May 13 12:30:14 2008

ksvcreate: Process(m000) creation failed

Tue May 13 12:31:15 2008

Process m000 died, see its trace file

Tue May 13 12:31:15 2008

ksvcreate: Process(m000) creation failed

Tue May 13 12:32:10 2008

Process m000 died, see its trace file

Tue May 13 12:32:10 2008

ksvcreate: Process(m000) creation failed

Process m000 died, see its trace file

Tue May 13 12:32:



In trace file



*** 2008-05-13 12:30:14.679

Process m000 is dead (pid=15332, state=3):

Unable to schedule a MMON slave at: Auto Flush Main 1

Attempt to create slave process failed.

Can happen for several reasons:

- No process state objects

- Reached OS set limits

- A shutdown was going on

Check alert log for more details.

[davey23uk]

have you raised an SR with oracle?

[akas_chauhan]

Nope, thought may be getting the naswer soon if somebody faced similar issues here. I've checked process value it's 250 so according to metalink it's not the issue.

[davey23uk]

about time you raised an SR then

[akas_chauhan]

thanks Davey, i'll raise one SR now.

[marist89]

I'd consider double checking my kernel parameters and making sure my sga_max_size is set to a reasonable value.

[rikku]

Hi
Akas do you have solved this problem? If yes what settings have you changed?

[tamilselvan]

May be you need to apply the patch 5010657.

What's your OS release?