I have two oracle databases. I wanted to dynamically point to another DB if one of the server goes down through coldfusion code. Does anyone know or same situation. Any help pointing to solution is highly appericiated.
ok, this is a tricky situation because you are getting into clustring.
The questions I would have for you first are:
1) Are they mirrored? by this I mean do they have all the data (exactly) the same in both servers? 2) What method are you using to mirror them if the answer is yes? 3) Depending on what you are using to mirror them, most solution then also handle clusting (or load balancing them) in which case it should NOT be done at the CF level, but at the network level.