Oracle11g r2 Version 126.96.36.199.0
Linux RHEL 5.5 64bit
We had Setup and Configured the Oracle Bi-directional Streaming which is working successfully for week and yesterday for some reason we have reboot the
both the Locations Servers in same time and after the reboot Our Oracle streaming processes status is ok on both the end but we shown that
V$STREAMS_CAPTURE view shown the state something like "WAITING FOR A SUBSCRIBER TO BE ADDED".
We had tested and got that our streaming is not more working?
Please guide for resolved the problem?
Any suggestions and help is appreciated.
We had the same problem last month, but in our environment the problem was the network: the firewall dropped some packets and so the capture process could not connect with teh apply process on the other machine.