Re: Fall-back not working?
Posted by: Uri Bernstein
Date: December 09, 2004 04:01AM

This turns out to be a major problem for me, so I wonder if I could get some help here.

My "secondary" database is on a geographically remote site. So for connections in the "failed-over" state, there is a significant degradation in performance. The problem is that if the "primary" DB fails even for a short time, the performance problem lasts indefinitely (because the connections keep going to the secondary). Furthermore, I have no means to know that this had happened, so I can't even fix the situation manually by restarting the servers.

I have two questions:

- You mentioned that the fix is not difficult. Can you give me a pointer to what needs to be fixed? I tried several things (like setting needsPing to true in setFailedOverState()), but to no avail.

- Assuming the driver itself is not fixed, is there any way for me to reliably determine that a connection failed over, so I can restart the system (assuming the primary DB is back up)? Can I somehow make the driver write something to a log when a connection is failed-over? Or can I somehow query the driver after the fact and ask whether any connections are in the failed-over state?

Any help would be much appreciated.

Options: ReplyQuote

Written By
December 02, 2004 12:05PM
December 02, 2004 03:23PM
December 02, 2004 03:29PM
Re: Fall-back not working?
December 09, 2004 04:01AM
January 17, 2005 06:14AM
January 17, 2005 09:01AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.