Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Oct 25 '11 at 15:38

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

1 Answer 1

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

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

 
discard

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.