10. 7. 2009, 12.09
Alert.log:
==========
Fri Jul 10 09:24:19 2009
WARNING: inbound connection timed out (ORA-3136)
Fri Jul 10 09:30:11 2009
Process m000 died, see its trace file
Fri Jul 10 09:30:11 2009
ksvcreate: Process(m000) creation failed
Fri Jul 10 09:31:12 2009
Process m000 died, see its trace file
Trace file:
===========
*** SERVICE NAME:(SYS$BACKGROUND) 2009-07-09 20:35:37.278
*** SESSION ID:(3295.1) 2009-07-09 20:35:37.278
ktsmgtur(): TUR was not tuned for 1644 secs
ktsmg_advance_slot(): MMNL advances slot after 1786 seconds
*** 2009-07-10 09: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 3000
SQL> show parameter session
NAME TYPE VALUE
———————————— ———– ——————————
sessions integer 3305
SQL> select count(*) from v$session;
COUNT(*)
———-
2994
SELECT COUNT(*) FROM v$process;
COUNT(*)
———-
2990
Solution
========
– kill processes which generates the processes ( usually from http)
– restart database
– this error coresponds with ORA-3136
