up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

migrated from stackoverflow.com Oct 25 '11 at 15:38

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

1 Answer

up vote 0 down vote

Yes.

Oh, you wanted more detail than that?

See this blog post, complete w/ test case: http://vitspinka.blogspot.com/2008/04/dbmsalert-on-rac.html

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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