Ora-24010: Queue SYS.ALERT_QUE Does Not Exist In Emagent.Trc (Doc ID 367732.1)

Last updated on FEBRUARY 19, 2013

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.1 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on Feb-19-2013

Symptoms

The <AGENT_ORACLE_HOME>/sysman/log/emagent.trc file fills with errors like below:


SQL = "/* OracleOEM */ DECLARE subscriber sys.aq$_agent;
BEGIN"...
LOGIN =
dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTO =TCP)(HOST=<hostname>)(PORT
=1521))(CONNECT_DATA=(SID=<sid>)))
2006-04-21 10:11:46 Thread-130 ERROR recvlets.aq: Error creating subscriber
hirogen_ins_s_3872_testdb01 on <service_name>: ORA-24010: QUEUE
SYS.ALERT_QUE does not exist
ORA-06512: at line 1
2006-04-21 10:11:46 Thread-130 ERROR recvlets.aq: unable to create subscription
on oracle_database <service_name>
2006-04-21 10:12:01 Thread-130 WARN vpxoci: OCI Error -- ErrorCode(24010):
ORA-24010: QUEUE SYS.ALERT_QUE does not exist
ORA-06512: at line 1

SQL = "/* OracleOEM */ DECLARE subscriber sys.aq$_agent;
BEGIN"...
LOGIN =
dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTO =TCP)(HOST=<hostname>)(POR
=1521))(CONNECT_DATA=(SID=<sid>)))
2006-04-21 10:12:01 Thread-130 ERROR recvlets.aq: Error creating subscriber
hirogen_ins_s_3872_testdb01 on <service_name>: ORA-24010: QUEUE
SYS.ALERT_QUE does not exist
ORA-06512: at line 1
2006-04-21 10:12:02 Thread-130 ERROR recvlets.aq: unable to create subscription
on oracle_database <service_name>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms