Enterprise oracle adapter (receive adapter) on active-active cluster biztalk server 2006.

Hi Gurus,

 I have an active-active cluster biztalk server 2006 setup.  upon which i have a receive location that make use of Enterprise oracle adapter.

This receive adapter is configure to “Poll SQL Statement” like [select * from table_123 where status_id=’1′]  and “Post Poll SQL statement” like “Update table_123 set status_id=’2′ where status_id=’1′.

My problem is that because the environment is setup as active-active mode,  there will be two instances of orchestration being fired to process the result of this select statement.

I only want one instance to be activated instead of two instances.

Can anyone sugguest some solution to overcome this issue?

I know by setup up the environment to active-passive will solve this, but i’m exploring any other alternative.

Thanks in advance.