| meraj |
Posted: Sep 18, 2007 03:10:25 AM |
Total Post: 27
Joined: Sep, 2006
|
Hi All,
below is the trace............
*** SERVICE NAME:(SYS$BACKGROUND) 2007-09-18 11:57:48.062
*** SESSION ID:(170.1) 2007-09-18 11:57:48.062
*** 2007-09-18 11:57:48.062
Process EMN0 is dead (pid=10557, state=3):
ksbcr1p: restarting dead process failed
ORA-00444: background process "EMN0" failed while starting
ORA-00020: maximum number of processes () exceeded
this trace i had taken from the alert log..
when i was trying to connect to the database i received the following error
ORA-00020: maximum number of processes (%s) exceeded
and the users were getting
ORA-12516: TNS:listener could not find available handler with matching protocol
Restarting the server did worked for me but i want to know what exactly could have happened...
Thanks in Advance...
|
|
|
 Mohammed Taj |
| Posted: Sep 18, 2007 04:21:42 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
hello,
increase processes parameter ...
step
1. alter system set procesess = value scope=spfile;
2. shutdown immediate;
3. startup
Regards
Mohammed Taj
http://dbataj.blogspot.com
|
|
|
|
|
| meraj |
| Posted: Sep 19, 2007 09:15:56 AM | |
|
Total Post: 27
Joined: Sep, 2006
|
hi Taj,
But can u explain me the exact problem.. what was that about EMNO process... this is the new process for 10g ..isnt?
I have solved the issue but i want to know exactly what happened at that coz just after that there were entries in alert log for RECURSIVE SQL LEVEL2.... so i wanted to know whats the connection between these errors...
please help me...........
meraj...
|
|
|
|
|
| parthokonar |
| Posted: Sep 21, 2007 10:55:45 AM | |
|
Total Post: 27
Joined: Sep, 2007
|
As The Event Monitor process EMNO (EMON) was introduced in Oracle8i, and is associated with the Streams Advanced Queueing (AQ) Notification feature.
It is the process which allows publishers of events, enqueueing processes, to communicate with subscribers to these event, dequeueing processes, asynchronously.
Event publisher to EMON communication happens via the SGA, in particular it utilises the shared_pool, hence it is shared memory communication whereas emon to event
subscriber communication happens via tcp/ip. The former method of communication is significantly faster than the latter.
The Error ORA-00020: maximum number of processes exceeded is usually happens due to database setup For that we check database parameter "processes"
If it’s then less then increase number of processes to higher value. and then start the database. The problem automatically goes
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:10:14 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
