Hmmmm after posting my question and making a cup of tea I see failover EVENTUALLY happened. This means there is a timeout of horrendous proportions.....somewhere
I have similar issues. Fail over is OK except when the primary data base host is down. Do you know how to fix this ? We tried several things but it never switches to the back up data base, instead we have a time out.
Thank you very much for your help.