Noticed that the following error was popping up in the emagent.trc of a 10.2.04 – Grid Control-agent on a specific node, every 5 seconds. Annoying, unnecessary:
2007-09-18 12:15:14 Thread-134875 ERROR vpxoci: Error on dequeue from SYS.ALERT_QUE: ORA-00604:
error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 30
ORA-25228: timeout or end-of-fetch during message dequeue from SYS.ALERT_QUEM
Metalink gave me doc-id 738638.1 as the cause, and gave me a solution: disable an ‘after event’-trigger. First of all I couldn’t find a trigger (had to search 8 instances..) with the statement they provided. Second of all I couldn’t disable this trigger, as it was an application-trigger, and in use.
The statement they gave was:
select trigger_name,trigger_type,triggering_event from dba_triggers where trigger_type = ‘AFTER EVENT’ and triggering_event = ‘ERROR’;
The following gave me more results:
select trigger_name,trigger_type,triggering_event from dba_triggers where trigger_type = ‘AFTER EVENT’ and triggering_event like ‘%ERROR%’;
So I found the trigger, but could not disable this one. So I updated the trigger with:
if ora_login_user != ‘DBSNMP’ then
Did not need to stop the database, error disappeared right away.