Forum Stats

  • 3,782,437 Users
  • 2,254,645 Discussions
  • 7,880,078 Comments

Discussions

Messages are not dequeing from the Queue

3004
3004 Member Posts: 204,171
I am using Oracle Advanced Queueing.
PL/SQL API for enqueue
JMS API for Dequeue Messages asynchronously (register listener and using onMessage())
It is multi consumer queue.
The program used to work fine. Now, it has stopped. Now, we can enqueue as
many messages as we want. The subscriber does not recieve any messages. BUT,
once we disconnect subscriber and connect again, the subscriber gets all the
messages in the queue. You can repeat this N times.

I sent this java program and sql scripts to Oracle support and they ran it successfully in their environment. So it appears to be some weird environment problem.

Question:
Did anybody have problem like this?
Does anybody have any ideas about what to check in Oracle/Java client environment?

We use Java SDK 1.2.2, thin JDBC drive and Oracle 8.1.7

Thanks for reading this message.

Vlad.
null

Comments

  • 3004
    3004 Member Posts: 204,171
    Is your EMON process running. Do you see any trace files ??
  • 3004
    3004 Member Posts: 204,171
    How can I check EMON process? Is it on database server? Where do I check for trace file?

    Thanks for you replay.
    Vlad.
  • 3004
    3004 Member Posts: 204,171
    emon is a non-fatal oracle backgroud process which will be named "*emn*". The trace files, if generated by the emon, can be found in the same location as your alert log file.
  • 3004
    3004 Member Posts: 204,171
    EMON is running:
    oracle 1105 1 0 Apr 28 ? 0:03 ora_emn0_wmdev

    And there are two trace files, but nothing interesting inside (they don't change when I run java client):
    -rw-r--r-- 1 oracle dba 107 May 2 18:01 PLSExtProc_agt_5404.trc
    -rw-r--r-- 1 oracle dba 107 May 2 18:06 PLSExtProc_agt_7021.trc

    PLSExtProc_agt_5404.trc
    ::::::::::::::
    Remote HO Agent received unexpected RPC disconnect
    status 1003: ncrorpi_recv_procid, called from horg.c

    PLSExtProc_agt_7021.trc
    ::::::::::::::
    Remote HO Agent received unexpected RPC disconnect
    status 1003: ncrorpi_recv_procid, called from horg.c
    null
  • 3004
    3004 Member Posts: 204,171
    have you tried the JMS/JDBC-OCI driver? Does this have the same result/
  • 3004
    3004 Member Posts: 204,171
    Hi,
    Are you using a DHCP Client? JMS Message listeners dont work with DHCP Clients (the client must have a static IP address ).

    null
  • 3004
    3004 Member Posts: 204,171
    Thanks you all for your replies!
    Looks like I figured out my problem. Database server has to be able to resolve name of the client machine. So you need to make sure that:
    1. All clients have DNS enties and database server is using DNS
    OR
    2. All clients have entires in /etc/hosts file on database server.

    As for DHCP, Oracle support told me that AQ client has to have static IP (no DHCP), but my windows box uses DHCP and works fine. So I am not sure about this DHCP concern.

    Thanks!
    Vlad.
This discussion has been closed.