We help IT Professionals succeed at work.
Get Started

oracle streams and banking system !!!!!

RYasin
RYasin asked
on
1,004 Views
Last Modified: 2013-11-11
dear all,,,
 
i am using three oracle database 11g R2 (2 source and 1 destination) , and i am using wireless network, and i 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 disable and then enable the apply process to fix this problem manually. i wish if we can solve this problem automatically without data losing.

Error :: ORA-26851

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

What is the solution?please

---------------------------------------------------------------------------------------
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
Comment
Watch Question
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2020
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE