Hello All,
Env: 10.2.0.3 on Solaris 10
Yesterday, my users were unable connect to the database for around 25 minutes and it happened all of sudden and after few minutes they could establish the connection. (But i could connect from my PC using system)
In the alert.log file i found
Process m000 died, see its trace file
Tue Sep 16 17:00:14 2008
ksvcreate: Process(m000) creation failed
Tue Sep 16 17:05:31 2008
Process q002 died, see its trace file
Tue Sep 16 17:05:31 2008
ksvcreate: Process(q002) creation failed
Tue Sep 16 17:21:29 2008
Process q002 died, see its trace file
Tue Sep 16 17:21:29 2008
ksvcreate: Process(q002) creation failed
I checked the <sid>mmon9671.trc file (below are the last few lines)
.
2008-09-08 18:30:45.603
KEWRAFC: Flush slave failed, AWR Enqueue Timeout
2008-09-16 17:00:14.132
Process m000 is dead (pid=26345, state=3):
Unable to schedule a MMON slave at: Remote Flush Main
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.
Also, once the clients could establish the connection, i checked the total number of sessions and it was around 550+ (only few were active) and was decreasing by time. My init.ora parameter PROCESSES has the value 600.
Is it because that the number sessions has exceeded the total 600 ?
Or, was it because of some other reason ?
TIA,
JJ
Edited by: J..J on Sep 17, 2008 10:50 AM