RE: ksvcreate: Process(m000) creation failed

Admin — Thu, 10 Jun 2010 12:52:25 GMT

ksvcreate: Process(m000) creation failed

Alert.log:
==========
Fri Jan 10 05:24:19 2010
WARNING: inbound connection timed out (ORA-3136)
Fri Jan 10 05:30:11 20109
Process m000 died, see its trace file
Fri Jan 10 05:30:11 2010
ksvcreate: Process(m000) creation failed
Fri Jan 10 05:31:12 2010
Process m000 died, see its trace file

Trace file:
===========
*** SERVICE NAME:(SYS$BACKGROUND)
*** SESSION ID:(3295.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.

ksvcreate: Process(m000) creation failed

Admin — Wed, 25 Feb 2009 01:39:50 GMT

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,

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / Non-Coded Errors and Alerts / ksvcreate: Process(m000) creation failed / Latest Posts

RE: ksvcreate: Process(m000) creation failed

ksvcreate: Process(m000) creation failed

ksvcreate: Process(m000) creation failed