really it is big problem !
i have the same problem and until now i could not solve it !
but what is the structure of your stream environment, its type ?!
how much databases are streamed together ?
we need to investigate this new issue in Oracle db r2 that no talk about it before !
We are also facing the same problem, we are using three Oracle Database 11g R2 (2 sources and 1 destination) , and we are using wireless network, and we configure oracle streams successfully , data transfer from source to destination done, but, when network goes down for seconds, the errors appear on propagation process in source database , and data not applying in destination database.
We disabled and then enabled the apply process to fix this problem manually. We wish if there is an automatic solution for this so there is no need for manual intervention.
Error :: ORA-26851
Unable to connect to apply "string" because it has connected to another capture.
We really need a solution for this...
To make things more clear, we working in a company with both Oracle PLSQL and Delphi developers. We are currently developing a financial system for a company with more than one branch.
The Business Logic is implemented in PLSQL and the interface in Delphi. Some of the data needed to be replicated, therefore we decided to use Oracle Streams.
We are currently using Oracle Database 11g R2, we have implemented the streams successfully and everything is just fine.
However, our customer has connected his branches using WiMAX network, therefore we felt little worry from the disconnection that could happen in the network. So, we decided to have a test using our own machines at the development environment. Once we disconnect the machines from the network, the above problem starts to appear.
We are kindly asking the following:
How much Oracle Streams is reliable for Financial Systems that needs replications? Systems could be (Banking, Insurance,... etc)
How much Oracle Streams is suitable for Wireless networks that face disconnection everyday if not every hour.
If Oracle Streams is reliable for Financial Systems as well as Wireless Networks, how could we solve the mentioned problem?
If Oracle Streams is not reliable, what other solution Oracle offers for such circumstances??
We are experiencing the same problem. We have a hub-and-spoke environment with bidirectional replication (1 hub, 2 spokes. the hub has separate capture/propagate/apply for each spoke.). Hub and spokes are connected over a WAN that may encounter disconnects from time to time. If any of the spokes is disconnected from the hub and then reconnected a few minutes after the disconnect, the propagation-process at the spoke shows the ORA-26851. We would expect streams to fully recover automatically, but we always had to manually restart the processes to fix this issue.
Has anyone a solution or even an explanation for this behaviour? We absolutely do not understand to what "other" capture process the apply-process at the hub could connect, because the spoke only has one capture process.
This sounds like it may be bug 9115822. The fix for this bug will be included in the 22.214.171.124 patchset.
Contact Oracle Support to request a patch for 126.96.36.199 for your platform, if it is not already available.