GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Advance Queue: Msg is being enqued in the table but it is not being Dequeued.

edited Feb 3, 2011 4:43AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
Hi,

I am running Oracle Enterprise Server 11.1.0.6 on Solaris 10 sparc. Adhance Queues has been configured & the following steps have been done. Hoewever, the msg is being enqued in the table but it is not being Dequeued. It seems that the notification procedure is not executed.

Steps done:
- create the notification procedure
- register the callback procedure
- enqueue a message
- NOTHING HAPPENS

select * from SYS.REG$; (o/p is below)
REG_ID 7
SUBSCRIPTION_NAME "AUBUATR3"."GWAQ_FCUBS_NOTIF_DATA_Q"
LOCATION_NAME plsql://AUBUATR3.gwpks_notification.pr_notif_callback
USER# 96
USER_CONTEXT 01
CONTEXT_SIZE 0
NAMESPACE 1
PRESENTATION 0
VERSION 0
STATUS 0
CONTEXT_TYPE 0
QOSFLAGS 0
PAYLOAD_CALLBACK

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center