This discussion is archived
6 Replies Latest reply: Mar 31, 2012 11:42 PM by 927737 RSS

ORA-26851:Unable to connect to apply "string" because it has connected to

774611 Newbie
Currently Being Moderated
Oracle Error :: ORA-26851

Unable to connect to apply "string" because it has connected to another capture.


What is the solution?
  • 1. Re: ORA-26851:Unable to connect to apply "string" because it has connected to
    761900 Newbie
    Currently Being Moderated
    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 !
  • 2. Re: ORA-26851:Unable to connect to apply "string" because it has connected to
    EmadKehail Newbie
    Currently Being Moderated
    Hello all,

    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...
  • 3. Re: ORA-26851:Unable to connect to apply "string" because it has connected to
    761900 Newbie
    Currently Being Moderated
    Dear all,

    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??

    Thanks
  • 4. Re: ORA-26851:Unable to connect to apply "string" because it has connected to
    786447 Newbie
    Currently Being Moderated
    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.
  • 5. Re: ORA-26851:Unable to connect to apply "string" because it has connected to
    pmcelroy Newbie
    Currently Being Moderated
    This sounds like it may be bug 9115822. The fix for this bug will be included in the 11.2.0.2 patchset.
    Contact Oracle Support to request a patch for 11.2.0.1 for your platform, if it is not already available.
  • 6. Re: ORA-26851:Unable to connect to apply "string" because it has connected to
    927737 Newbie
    Currently Being Moderated
    try to add "SQLNET.EXPIRE_TIME=n " to SQLNET.ORA
    SQLNET.EXPIRE_TIME=n Where 'n' is the number of minutes to let connection idle befor shutting them out

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points