6 Replies Latest reply: Apr 1, 2012 1:42 AM by 927737 RSS

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

    774611
      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
          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
            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
              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
                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-Oracle
                  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
                    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