ksvcreate: Process(m000) creation failed
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



ksvcreate: Process(m000) creation failed Expand / Collapse
Message
Posted 2/25/2009 1:39:50 AM Post #90
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
OK, so we're seeing so many of these in the alert log.


Tue Feb 24 22:10:34 2009
Process m000 died, see its trace file
Tue Feb 24 22:10:34 2009
ksvcreate: Process(m000) creation failed
Tue Feb 24 22:11:35 2009
Process m000 died, see its trace file
Tue Feb 24 22:11:35 2009
ksvcreate: Process(m000) creation failed
Tue Feb 24 22:12:36 2009
Process m000 died, see its trace file
Tue Feb 24 22:12:36 2009
ksvcreate: Process(m000) creation failed
Tue Feb 24 22:13:37 2009
Process m000 died, see its trace file
Tue Feb 24 22:13:37 2009
ksvcreate: Process(m000) creation failed
Tue Feb 24 22:14:38 2009
Process m000 died, see its trace file
Tue Feb 24 22:14:38 2009
ksvcreate: Process(m000) creation failed
Tue Feb 24 22:15:39 2009
Process m000 died, see its trace file
Tue Feb 24 22:15:39 2009
ksvcreate: Process(m000) creation failed
Tue Feb 24 22:16:41 2009
Process m000 died, see its trace file
Tue Feb 24 22:16:41 2009
ksvcreate: Process(m000) creation failed
Tue Feb 24 22:17:42 2009
Process m000 died, see its trace file
Tue Feb 24 22:17:42 2009
ksvcreate: Process(m000) creation failed
Tue Feb 24 22:18:43 2009
Process m000 died, see its trace file
Tue Feb 24 22:18:43 2009
ksvcreate: Process(m000) creation failed
Tue Feb 24 22:46:55 2009
Tue Feb 24 23:00:14 2009
Process m000 died, see its trace file


Not sure what's causing this initially but we eventually figured it out because we couldn't get into the database using sqlplus '/ as sysdba';

It turned out that the max processes of 400 had been reached and no new processes were able to connect to the database.

After verifying that all users were having this issue, we decided to bounce the database and update the processes parameter to 900.

Make sure you have enough memory + your OS parameters are set properly before bumping up any parameters. In our case we had sufficient and all went well.

You may want to open up a Tar with oracle if you have support in case this step didn't work. There maybe a bug you could be hitting.

Good luck and let me know how you guys make out.

Regards,
Posted 6/10/2010 12:52:25 PM Post #200
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

ksvcreate: Process(m000) creation failed

Trace file:
===========
*** SERVICE NAMESYS$BACKGROUND)
*** SESSION ID3295.1)
ktsmgtur(): TUR was not tuned for 1644 secs
ktsmg_advance_slot(): MMNL advances slot after 1786 seconds
*** 2010-01-10 05:30:11.004
Process m000 is dead (pid=32562, 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.

CHECKS:
=======
SQL> show parameter process

NAME                                 TYPE        VALUE
———————————— ———– ——————————
processes                            integer     2000

SQL> show parameter session

NAME                                 TYPE        VALUE
———————————— ———– ——————————
sessions                             integer     2318

SQL> select count(*) from v$session;

COUNT(*)
———-
1994

SELECT COUNT(*) FROM v$process;

COUNT(*)
———-
1990

Solution
========
- kill processes which generates the processes ( usually from http)
- restart database
- this error coresponds with ORA-3136

Hope this helps.

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 2 (2 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:17am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.070. 8 queries. Compression Disabled.