Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can anyone confirm whether the oracle DBMS_ALERT package works correctly in a RAC envirnoment.

That is, if I have a DBMS_ALERT.WAITONE() on all instances, then I do a DBMS_ALERT.SIGNAL(), will all nodes be signalled?

share|improve this question

migrated from Oct 25 '11 at 15:38

This question came from our site for professional and enthusiast programmers.


Oh, you wanted more detail than that?

See this blog post, complete w/ test case:

share|improve this answer
Thanks for the quick reply. – ftkalcevic Oct 24 '11 at 21:20
Thanks for the quick reply. I've seen that post, but I've also seen many other posts, including a paragraph from "Pro Oracle Database 10g RAC on Linux" that say it doesn't. In fact, every time I see someone say it doesn't work, they are referencing that book. We are in the process of setting up a RAC test environment on linux VMs but this is progressing slowly. The only thing I can say confidently is that I can't find anything in oracle's documentation that says it doesn't work. – ftkalcevic Oct 24 '11 at 21:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.