Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error while enqueueing into queue STRMADMIN.STREAMS_QUEUE

hrishyJan 2 2008 — edited Nov 3 2011

Hi

I have setup a streams environment and also a queue handler with a user defined procedure however when i test the environment i get the following error in dba_apply_error

APPLY_EMP  ORA-26694: error while enqueueing into queue STRMADMIN.STREAMS_QUEUE
           ORA-24033: no recipients for message

APPLY_EMP  ORA-26694: error while enqueueing into queue STRMADMIN.STREAMS_QUEUE
           ORA-24033: no recipients for message

APPLY_EMP  ORA-26694: error while enqueueing into queue STRMADMIN.STREAMS_QUEUE
           ORA-24033: no recipients for message

APPLY_EMP  ORA-26694: error while enqueueing into queue STRMADMIN.STREAMS_QUEUE
           ORA-24033: no recipients for message

I do have a custom deque handler and that is valid.

  1  select object_name,object_type,status
  2  from user_objects
  3* where object_type='PROCEDURE'
SQL> /

OBJECT_NAME          OBJECT_TYPE         STATUS
-------------------- ------------------- -------
EMP_DML_HANDLER      PROCEDURE           VALID

Version of my database is 10.2.0.1.0.

I configured a very simple streams environment by following the instructions at

http://blogs.ittoolbox.com/oracle/guide/archives/oracle-streams-configuration-change-data-capture-13501

Any ideas whats wrong or
How do i go about troubleshooting this environment ?

regards
Hrishy

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2011

Added on Jan 2 2008

#performance-availability, #streams

16 comments

11,470 views