Last updated on AUGUST 26, 2013
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 25-Aug-2013***
In a 10.2.0.X production database the following error is reported querying the AQ$ tables:
Current SQL statement for this session:
SELECT NVL(COUNT(MSG_STATE),0) FROM STRMADMIN.AQ$ICON_QUEUE_TABLE WHERE consumer_name is null AND
MSG_STATE='READY' and queue = 'ICON_QUEUE' and address IN (select '"'||destination_queue_owner
||'"' ||'.'||'"' ||destination_queue_name||'"@'||destination_dblink from dba_propagation)
Also this error can be returned:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms