Oracle Database Discussions

Hi everybody,

Im having some problems with the service emctl dbconsole of my database (11.1.0.6.0 on REHL 5). Don't know why it stops usually, and i check emoms.log and see the next error:

2011-06-20 12:02:34,915 [NotificationMgrThread] ERROR em.notification run.1698 - Error checking queue: ORA-25253: listen failed, queue SYSMAN.MGMT_NOTIFY_Q is not enabled for dequeue
ORA-06512: at "SYS.DBMS_AQ", line 675
ORA-06512: at "SYS.DBMS_AQ", line 702
ORA-06512: at "SYSMAN.EMD_NOTIFICATION", line 509
ORA-06512: at line 1

what it mean? how to solve it?

In first time i think the service was down because i have a lot of wait sessions, could it be the problem?:

select sum(seconds_in_wait),event,count(*) from v$session_wait group by event order by 3 desc;

sum(seconds_in_wait) Event count(*)
--------------- ----------------------------------------------------------------------------- ---------------
27256882 SQL*Net message from client 115
195 rdbms ipc message 15
201705 library cache: mutex X 8
0 DIAG idle wait 2
255862 SQL*Net message to client 2
704 Streams AQ: waiting for time management or cleanup tasks 1
8 Streams AQ: qmn coordinator idle wait 1
2136954 VKTM Logical Idle Wait 1
4 Space Manager: slave idle wait 1
8 Streams AQ: qmn slave idle wait 1
2 pmon timer 1
84 smon timer 1
4 Streams AQ: waiting for messages in the queue 1

Thanks in advance

Edited by: Fran on 20-jun-2011 3:11